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,158 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,633 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,280 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,077 reads
Blogs
The End of PASS
By Andy Warren
I think our profession was the better for having a professional association, even if...
Platforms for Events
By Andy Warren
in my last post I wrote about thinking of the tools as being a...
Getting Started with Robotic Process Automation (RPA) Using the Power Automate Desktop
By Devin-Knight
There are a lot of hot phrases you’ve likely heard thrown around during various...
Forums
"Home PC" SQL instance
This may be a bit non-typical, but I am currently running SQL 2019 Developer...
Interview question about CPU
Hello SSC friends, I am a SQL Developer who is learning how to be...
Ask SSC