The Inteview is Done
I completed my interview for the PASS board election today. I don’t want to talk about what was in the...
2010-08-06
409 reads
Free SQL Server Training for the Week of August 9, 2010
Monday
SQL Lunch - SSIS Design Patterns 1a: Introduction to SSIS Design Patterns - Andy Leonard
Tuesday
PASS Application Development Virtual Chapter - Where the bl**dy...
2010-08-06
1,224 reads
eReaders - Kindle v Nook v iPad
A friend of my wife’s posted a note asking what people thought of the various devices and which one would...
2010-08-06
1,202 reads
Simple Script to Determine Who To Kill (SPIDs)
I'm mostly working now supporting the building of SSIS packages for ETL. And on one particular project we've been making heavy...
2010-08-06
758 reads
Tiny Homes
Over the course of my life I’ve lived in a few different places; small home, apartment, pup tent, large tent,...
2010-08-06
543 reads
Hands Off System Databases
I saw a post earlier this week from Buck Woody called Don’t Mess with the System Databases and I agree....
2010-08-06
362 reads
SQL Server Locking & Blocking At DevLink 2010
Wow! Thanks to everyone who came to my SQL Server Locking & Blocking session at devLINK this morning! I’m completely humbled...
2010-08-05
379 reads
Midlands PASS Meeting - August 10
Topic: Creating a SQL Server Utility Environment
Can SQL Server be offered as a service (SQLaaS)? Can SQL Server be treated like...
2010-08-05
778 reads
Middle of the Pack
I noticed the scores for the first part of the PASS nomination process were posted recently. These were the aggregate...
2010-08-05
422 reads
SQL Saturday # 28 in Baton Rouge, Saturday Aug 14th, looks to be one of the best events of the year.
If you are looking for a rewarding way to spend next Saturday, August 14th 2010, do yourself a favour and...
2010-08-05
713 reads
Blogs
The New Unified Copilot in Fabric and Project Osmos: From AI Assistance to Agentic Data Engineering
By James Serra
(This post starts a three-part series on how AI is changing the way we...
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Forums
Managed Instance vs Azure Database - is this a good option?
We're currently in Azure, however as we had a very tight migration timeline when...
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers