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,262 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)
8,428 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,317 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,169 reads
Blogs
Creating an Empty Repo in GitHub–#SQLNewBlogger
By Steve Jones
I saw someone struggling with getting started with a Visual Studio project and Azure...
Product Review: DataVeil
By Brian Kelley
If you’re looking at data masking tools, I recently was able to review the...
The Last Price Bump for the Data Community Summit
By Steve Jones
This week the cost of the PASS Data Community Summit jumps up to full...
Forums
Cherrykitten autumn sale up to 25% off y2k earrings
As autumn arrives, it's time for girls to embrace the latest fashion trends to...
How to Setup Backups and Restore planning in SQL Server Availability Groups?
I need some help regarding How to Setup Backups and Restore planning in SQL...
Partition Large Tables needed
Hello Gurus, I have a requirement and need to implement the solution quickly. SQL...
Ask SSC