SQL Server Diaries

According to the Selecting an Account for the SQL Server Agent Service, the SQL Server Agent service account should be able to authenticate with the instance and also be a memeber of the sysadmin fixed server role. [Read More]

When creating an SQL Server Agent job with one or more steps, each step can be configured to write the query output to a log file.  If the job failes, such a log can assist a DBA identify the cause of the failure.  That is, if the log is still... [Read More]

Accurate documentation is paramount for any system. Unfotunately, when developing a database we sometimes tend to overlook this particular document. [Read More]

When migrating databases from SQL Server 7 or 2000 to SQL Server 2005/2008 the steps can be summarised as follows: [Read More]

Stored procedures and functions allow for the implementation of groups of data manipulation language (DML) statements as database objects.  Besides each code block having the relevant comments to facilitate other parties’ understanding of the same code blocks (amongst other reasons), a good coding practice is that some information about the object... [Read More]