And the winners are….. (iPads for Christmas contest)
Congratulations to the following winners of our iPads for Christmas contest. It was a hard choice, but I ended up...
2010-12-20
1,303 reads
SQL Server Storage Internals Part 3 - Architecture of Heaps
In this article I have explained below topics
1. key points on HEAP tables.
2. What happens when a table is created.
3. How to list...
2010-12-19
5,596 reads
SQL Server 2005 Service Pack 4 RTM
Service Pack 4
Just in time for Christmas, SQL Server 2005 Service Pack 4 has RTM’d. If you are using SQL...
2010-12-18
843 reads
SQL Saturday 62 – Tampa FL – January 15th 2011
On January 15th, 2011, SQL Saturday is once again coming to Tampa Florida. This is going to be a tremendous...
2010-12-18
1,196 reads
Pragmatic Works Seeking Employment Candidates
If you’re anything like me, you enjoy constantly striving to new levels of knowledge. This new level of knowledge brings...
2010-12-18
428 reads
SQL Server 2005 SP4 Released
Steve Jones mentioned recently that SP4 for SQL Server 2005 is on its way because Microsoft closed his connect item....
2010-12-18
523 reads
Just in time for Christmas – SQL Server 2005 SP4
Just in time for Christmas, Microsoft releases SQL Server 2005 SP4.
Many were wondering if they would meet their intended...
2010-12-18
1,755 reads
Let it Snow, Let it Snow, Let it Snow!
I don’t usually post on my blog on the weekend, but this weekend, the weekend before a Christmas is a...
2010-12-18
488 reads
Grant permission to the profile
The Profiler is a powerful tool available to the dba, but it can also be very useful for system developers....
2010-12-18
781 reads
Social Leadership And The SQL Community
2010 is rapidly coming to a close and in retrospect this has been a fantastic year of growth for the...
2010-12-17
1,191 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers