SQL Confessions
I had a brainstorm of an idea for a group of articles on my blog a couple of weeks ago and am finally getting around to putting it together....
2010-12-13
4 reads
Blog Posts
SQL Server 2005 SP4
Last year I submitted a Connect item for SQL Server 2005 SP4. Quite a few people supported this item and...
2010-12-13
1,438 reads
SQL Server Storage Internals Part 1 - Basics
While learning query tuning topics, I got a chance to understand anatomy of data page and different types and levels...
2010-12-13
6,803 reads
SSIS Denali Source and Destination Assistants
In several previous posts I have described some of the usability changes that will come with the next release of...
2010-12-13
1,474 reads
SSIS Job Execution
While working on a process to refresh the QA environment (data purge, reload data and reapply changes made over time...
2010-12-13
708 reads
SSIS Job Execution
While working on a process to refresh the QA environment (data purge, reload data and reapply changes made over time as parts of release cycles), I ran into self-imposed...
2010-12-13
2 reads
Upgrading to SQL Server 2008 - a comprehensive checklist.
There are many considerations and much preparation to do, when a company decides that it is ready to upgrade their...
2010-12-13
13,776 reads
URL Based Images using SSRS
For header images, I typically embed an image into the report. However, there may be times when you need to...
2010-12-13
820 reads
Wait Stats resources
Today I was out and about looking for past roundups on TSQLTuesday. While doing that, I came across a post...
2010-12-13
705 reads
Wait Stats resources
Today I was out and about looking for past roundups on TSQLTuesday. While doing that, I came across a post from Paul Randal (Blog | Twitter) about wait stats. The...
2010-12-13
6 reads
Blogs
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers