SQL Archives - Page 2 of 2 - Jonathan Crozier

SQL Server Database Mail setup simplified

Having the facility to send emails directly from your database engine is a hugely useful feature and this is exactly what the Database Mail functionality in SQL Server provides. With Database Mail, you can send email alerts when specific database events occur, or send query results and reports to users automatically on a scheduled basis….

Find out how many IDs are left for your SQL Server database tables

InSQL

If you are administering a very large SQL Server database that uses integer IDs, you may have cause to be concerned about how many identity values you have left for your tables. This is a particular concern for heavy transactional tables where new rows are constantly being inserted and there are other reasons why identity…

Connecting to SQL Server from PowerShell

InScripting SQL

PowerShell is an awesome scripting language with many powerful features. This includes integration with SQL Server; a fantastic database engine that is both reliable and battle-tested. If you need to automate repetitive and/or time-consuming DBA processes, connecting PowerShell to your SQL Server instance can be a massive help. In this article, we are going to…

SQL query things you keep forgetting

InSQL

When working with SQL databases, you may find there are things you need to do which although seemingly basic on the surface, are easy to forget due to nuances in query syntax and the required ordering of statements. For these situations, it is useful to have a working example to refer to which reminds you…

How to create and fire a SQL Server Trigger

InSQL

When implemented correctly, SQL Server Triggers are a powerful mechanism for adding useful functionality to a database without the need to change any application code. In this article, I look at what a SQL Server Trigger is, a template for defining a new Trigger and possible use cases. A few facts You may already be…

How to parse the name parts from a full name using SQL

InSQL

Sometimes I come across situations where I need to extract the individual parts of a full name from a database record that relates to a person e.g. a customer or an employee. This may be part of general application logic or perhaps something that needs to be carried out during a database migration. For example,…

Don’t be a victim… Log your SQL Server deadlocks

InSQL

Quite often there are situations in which you are aware that deadlocks are happening in your SQL Server database, but you are lacking the information required to fix them. What you need under these circumstances is an automated way of tracking the locks and logging them. In this article, I demonstrate a simple way to…

Query to find column names in a SQL Server database

InSQL

Whenever I’m considering making database schema changes, I often find the need to search the database I’m working with for columns with a particular name. It can be especially valuable to do this when dealing with a large model consisting of many tables and columns. In this situation, I’m typically seeking to establish whether a…

Category: SQL

SQL Server Database Mail setup simplified

Find out how many IDs are left for your SQL Server database tables

Connecting to SQL Server from PowerShell

SQL query things you keep forgetting

How to create and fire a SQL Server Trigger

How to parse the name parts from a full name using SQL

Don’t be a victim… Log your SQL Server deadlocks

Query to find column names in a SQL Server database

How to catch and parse a SQL Server Duplicate Key Exception

How to publish a .NET application as a standalone executable file

Encrypt directories and file names within a zip archive using 7-Zip