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
SQLStudies
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,350 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,573 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
Physical Join Operators by Ami Levin
For those who don’t know the three physical join operators are Hash Match, Loop Join and Nested Loops. Understanding these...
2013-11-06
672 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
Adding a column to a table with a default (NULL vs NOT NULL)
There are lots of ways to learn new things, or be reminded of old things. One of my favorites is...
2013-11-05 (first published: 2013-10-30)
5,167 reads
Change in SQL 2012 SSMS grid output behavior
It’s one of those things that always aggravated me but not really enough to complain about. When you run a...
2013-10-28
692 reads
Blogs
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers