Would You Like To Play A Game?
Do you have a favorite line from a holiday movie? Can you change it around slightly to make it SQL...
2010-12-20
801 reads
Blog Posts
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,617 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
795 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,764 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
491 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
431 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,199 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
846 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
524 reads
Free SQL Server Training for the Week of December 20, 2010
Monday
PASS Data Warehousing/BI Virual Chapter - SSIS + CDC = SCD - Patrick LeBlanc
Tuesday
Pragmatic Works - Introduction to Performance Tuning Analysis Services 2008 - Chris Webb
Thursday
Pragmatic...
2010-12-17
845 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers