SQL Server Diaries

I was recently involved in the implementation of an SQL Server environment that would host the database for a Microsoft Service Center Configuration Manager (SCCM) deployment.  My expertiese was required to prepare the SQL Server instance and make reccomendations for performance, sizing, and of course security, which I did.  The... [Read More]

I recently wrote about auditing SQL Server instances using Traces, and after reviewing the solution with a “fresh” mindset I saw features that were missed during the research which led to a previous article.  Today’s post shows how to limit the auditing to UPDATE, INSERT and DELETE events (see note/insert... [Read More]

In previous posts I described techniques how to extract TRIGGER and DEFAULT constraint definitions using T-SQL scripting.  Today I will explain how I used database system objects to generate CREATE INDEX statements for my database. [Read More]

It has been in the SQL Server Books Online since the 2000 version was published, and a considerable number of articles have been written against the use of the “sp_” stored procedure naming convention. What I cannot understand is why newly written stored procedures are being pushed for deployment using... [Read More]

A few posts ago I published a Script to generate Trigger definitions. This week’s topic covers another automation script to generate scripts, this time related to DEFAULT Constraints.  Simplistically put, whenever a DEFAULT constraint is definied on a table column, if the column is set to disallow NULL values and... [Read More]