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,313 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,897 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,339 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,229 reads
Blogs
Azure Cloud Chronicles with Microsoft MVPs YouTube Channel
By Brian Kelley
In my YouTube subscriptions feed, a new video for the Azure Cloud Chronicles with...
T-SQL Tuesday #188: Growing the Community
By Steve Jones
This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has...
Unveiling the Legacy: POSTGRES to Modern Open-Source Powerhouse
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Forums
Each database having its own disk?
Good morning, Once again, I find myself Sr. DBA for a company. As I...
the value of the effectiveusername xml for analysis property is not valid
I'm experiencing odd behaviour when using Analysis Services as a data source in Excel...
the value of the effectiveusername xml for analysis property is not valid
I'm experiencing odd behaviour when using Analysis Services as a data source in Excel...
Question of the Day
Independence Day
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers