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,110 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,462 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,269 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,074 reads
Blogs
Information Measurement with SQL Server, Part 4.9: The Bregman Divergence
By Steve Bolton …………Before closing out this long-delayed segment on stochastic information distances, I...
Let’s Talk About The Cloud
I’m launching a new initiative called the Community Circle Cloud Conversation Club (c5 for...
Daily Coping 29 May 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Daily Coping 29 May 2020
Today’s tip is today link your decisions and choices to your purpose in life....
Week Ending Thursday, can some one tweek my code?
What I have missed from this code? I'm trying to show the DateTimeRaised field...
The Matchbox Database
Comments posted to this topic are about the item The Matchbox Database, which is...
Ask SSC