The Recursive CTE
(Yet another boring org chart example – except this one has multiple roots)
One of my apps has a hierarchial org chart...
2011-05-18
1,707 reads
PASS Summit Session Votes
I blogged a week ago about the sessions that I submitted for the PASS Summit this year. At the point...
2011-05-18
1,081 reads
How To Make Your Laptop 100x Faster
Simon Sabin had his own take on increasing laptop speed. He had some good ideas, but he inspired me to...
2011-05-18
2,337 reads
How To: Use the Same Data Flow Column Twice As a Parameter in SSIS
Every once in a while, you'll have a slightly more complex UPDATE statement in an OLE DB Command or Destination. You'll use an UPDATE statement or a destination table that needsto use...
2011-05-18
12 reads
How To: Use the Same Data Flow Column Twice As a Parameter in SSIS
Every once in a while, you'll have a slightly more complex UPDATE statement in an OLE DB Command or Destination. You'll use an UPDATE statement or a destination table that needsto use...
2011-05-18
18 reads
How To: Use the Same Data Flow Column Twice As a Parameter in SSIS
Every once in a while, you'll have a slightly more complex UPDATE statement in an OLE DB Command or Destination. ...
2011-05-18
1,380 reads
Where to put the logic? SQL? Code?
A discussion of where logic should go and why SQL might be the best place.
SQL is a powerful language and...
2011-05-18
844 reads
Not. Quite. There. This Time I Failed the Lab
Since I’ve been blogging about my progress through the SQL Server MCM certification, it makes sense to follow-up with my...
2011-05-17
681 reads
SQL Server 2008 SP1 CU14 and SQL Server 2008 SP2 CU4 Released
Microsoft has released two new Cumulative Updates for SQL Server 2008 SP1 and SQL Server 2008 SP2. The first one...
2011-05-17
1,528 reads
Presenting at Denver SQL Server User’s Group on May 19
I will be giving the main presentation at this month’s meeting of the Denver SQL Server User’s Group on May...
2011-05-17
600 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
does anyone used https://github.com/ktaranov/sqlserver-kit
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers