Finding active DTS packages
DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS...
2013-12-09 (first published: 2013-11-27)
3,181 reads
Kenneth Fisher
Undocumented functionality in FORMATMESSAGE
I was reading a rather interesting post on stackexchange “Why is % a forbidden char in a THROW message?” (which is...
2013-12-09
1,496 reads
Insert into a table using only default values
A while back I talked about the DEFAULT keyword and using it to tell SQL to use the default value...
2013-12-04
1,049 reads
Why do DBAs like to say “It Depends” so much?
Well the short answer is that they just don’t have enough information to give a definitive answer. You will notice...
2013-12-02
649 reads
Finding the metadata for a query
You know I occasionally find it interesting how I learn new things. I was running through a practice test for...
2013-11-25
2,365 reads
A pattern to do beginning of period calculations.
Beginning of period calculations are common things. Rolling month reports, queries to pull everything from last month etc require beginning...
2013-11-20
757 reads
Connection options in SSMS
When connecting to a SQL Server instance in SSMS there are a fair number of options. Most DBAs I know...
2013-11-18
1,577 reads
Who’s on call
Every morning we have a daily meeting and my manager asks who’s on call. And every morning some form of...
2013-11-13
594 reads
A better way to find missing indexes
I recently attended SQL Saturday #255 and specifically the performance tuning pre-con put on by Grant Fritchey. It was a...
2013-11-11
943 reads
sp_SrvPermissions & sp_DBPermissions V3.0
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...
2013-11-11 (first published: 2013-11-04)
1,853 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Cross-DB Ownership Chaining problem
We want to setup a gateway db to host stored procedures which use tables...
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers