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
3 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,437 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,801 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,473 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
707 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
819 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
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...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers