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,177 reads
Andy Jones
Auto Generate Your Database Documentation
Script provided to create missing extended properties allowing you to auto generate your database documentation.
2017-11-17 (first published: 2016-02-25)
7,723 reads
Initial Installation of the Production Database
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,283 reads
Loading a Series of Flat Files
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,078 reads
Blogs
Everyone Run a SQL Saturday in 2021
By Steve Jones
With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....
Modern Data Warehouse & Reverse ETL
By James-Serra
An extension to the Modern Data Warehouse (MDW) that I have heard a bit...
Daily Coping 12 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
performance tuning
Hi everyone, Any good suggestion to tune below query: --CREATE NONCLUSTERED INDEX nonclust_code...
Understanding the Internals of a Data Page
Comments posted to this topic are about the item Understanding the Internals of a...
Preventing Trigger Execution
Comments posted to this topic are about the item Preventing Trigger Execution
Ask SSC