Trigger Happy
This article looks at using triggers to audit and to prevent the performing of unintended actions.
2018-10-12 (first published: 2016-03-28)
4,265 reads
This article looks at using triggers to audit and to prevent the performing of unintended actions.
2018-10-12 (first published: 2016-03-28)
4,265 reads
Script provided to create missing extended properties allowing you to auto generate your database documentation.
2017-11-17 (first published: 2016-02-25)
8,486 reads
Your software has passed all testing phase(s) and it is time to install your database into production. Andy Jones will outline below how he accomplished this task. This article is concerned with an evolving system and how to migrate it to production.
2003-02-04
6,319 reads
Andy Jones recently faced a requirement to load several flat files on a nightly basis. In this article, Andy Jones shows you how he accomplished this and shows plenty of code!
2002-10-31
11,176 reads
I know I can use extended events (xevents) in Azure SQL DB when in...
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
I'm working with someone whose client says "Yes, we have a data warehouse. But...
Hi Folks, I have been tasked with reviewing all the activity on a...