Fresh outlook to Auditing and Monitoring of User Activity using Traces

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]

Against the "sp_" Stored Procedure Naming Convention

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]

Script to generate DEFAULT Constraint definitions

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]

Automatically Back Up the Transaction Log when 75 Percent Full

Once your databases are live and your production SQL Server instance is functioning to it’s best, a user might decide to transfer large amounts of data into a database using SSIS, BCP, or some other custom application.  When such data transfers occur SQL Server logs activity in the transaction log. ... [Read More]