Defensive Db Programming Chapter 07
We are here again after another …um long lapse in time … and ready for another episode in this series. Today...
2010-11-03
740 reads
Blog Posts
How To Participate In The PASS Summit When You Can't Be There
Bummed that you can't go to the PASS Summit in Seattle this year? Turn that frown upside down because there...
2010-11-03
688 reads
Kilt Day
A week from now will be Kilt Day at the PASS Summit. It’s probably way too late to order a...
2010-11-03
669 reads
MERGE Statement Corrected, or, How to Eat Crow in Public
Better pull out the excuse-o-meter
I have no excuse, none whatsoever.
In my T-SQL Brush-Up presentation to the North Texas SQL Server...
2010-11-03
842 reads
More PASS Summit Tips For First Timers
Yesterday I posted my tips for PASS Summit First Timers, and of course as soon as I did I remembered...
2010-11-03
1,786 reads
My PASS Summit Schedule
Several bloggers have posted what their plans are for the PASS Summit and I’m following suit for 2 reasons:
So people...
2010-11-03
665 reads
PARTITION BY clause works incorrectly when in nested select over large volumes of data
I have been witnessing a very strange behaviour of ROW_NUMBER() PARTITION BY clause in complex join and nested select or...
2010-11-03
2,756 reads
PASS Update #45 (Agenda for SQLSaturday Roundtable)
If you’re attending the 2010 Summit and are interested in helping improve SQLSaturday, I hope you’ll register and attend our...
2010-11-03
341 reads
PASS Update #46 (What Should PASS Be?)
I’ve been wanting to write this for a while, and I haven’t because I felt that I just didn’t quite...
2010-11-03
408 reads
Powershell and Policy Based Management
If you haven’t looked at Policy Based Management (PBM), and you manage multiple instances, you ought to really look at...
2010-11-03
972 reads
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Secure Communications
Comments posted to this topic are about the item Secure Communications
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers