James Greaves

  • Interests: Motorcycles, SQL Server

SQLServerCentral Article

Monitoring and Recording DDL changes on SQL 2005 (NARC)

Auditing activities on your database servers becomes more important all the time. But ensuring that schema changes do not occur without your knowledge may be more important for a stable system. James Greaves brings us a great technique using DDL triggers for doing this.

4.52 (21)

You rated this post out of 5. Change rating


7,417 reads


Parameter Sensitive Plan Optimization in SQL Server 2022. What is it and is it any good?


Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...

Azure chaos STUDIO


Chaos engineering is fun but especially important when building solutions in the cloud. It...

Announcing a New Book on SQL from 3Cloud Authors


I am proud to announce the launch of a new book, centered around the...

Read the latest Blogs


Azure DW default schema in a query / proc equal to "Search_Path" in AWS

By digdave7

I know you can't do this in MSSQL, but hoping DW has progressed more....

Call SQL Agent job using different account to one executing powershell

By Dave D

Hi Folks trying the below but having zero luck and was wondering if anybody...

Encrypt Varchar(max) column in SQL Server

By SatishAyyar

I have a varchar(max) column which has sensitive data and want to encrypt it....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers