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

2008-02-29

7,417 reads

Blogs

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

By

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

Azure chaos STUDIO

By

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

Announcing a New Book on SQL from 3Cloud Authors

By

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

Read the latest Blogs

Forums

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