Learn T-SQL in 5 Minutes
I will be giving a five minute Lightning Talk at SQLRally in May that aims to do the impossible: Teach...
2011-04-29
2,196 reads
SQL Awesomesauce
Drop the Noise
I’m reading Tim Ferriss’ “The Four Hour Work Week” (FHWW) right now, and it’s got me thinking about (among other...
2011-04-28
1,461 reads
Fail-Win Balance
It’s a busy week for me, and a slow one technically. But I know that you, Constant Reader, thirst for...
2011-04-20
521 reads
PASS Women in Technology
The Professional Association for SQL Server (PASS) Women in Technology group first caught my attention at the PASS Summit in 2009...
2011-04-12
1,000 reads
For Your Friday Enrichment: Get Alifeatoll
I have made something for your pleasure and entertainment, and placed it on the MidnightDBA YouTube Channel. Please to enjoy...
2011-04-08
513 reads
Me Me Me, Event Event Event
Dear Readers,
Today’s blog shall be entirely stream-of-consciousness, which is to say, I don’t know exactly what I’m going to talk...
2011-04-07
810 reads
Meme Monday
Meme Monday story:
They’d never heard of indexes. Man, I was SUCH a rockstar!
-Jen McCown, MidnightDBA.com/Jen
2011-04-04
594 reads
Varying Results with Subquery, ORDER BY, MAXDOP
In the speaker rooms of SQL events everywhere, there is wondrous blog material to be had, free for the picking...
2011-04-04
1,181 reads
SQL Saturday 63 Dallas: EPICITY
SQL Saturday 63 Dallas. Will. Be. Epic.
Here are my proofs:
The Schedule. Note the gelato breaks. It is impossible to get...
2011-04-01
508 reads
MidnightDBA: We do a lot
We do a lot of things. It’s difficult to explain all the things we do to people. So I made...
2011-03-28
610 reads
Blogs
Performance tuning KubeVirt for SQL Server
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Forums
Change Tracking – Troubleshooting
I have change tracking configured in several databases, in QA and production environments, and...
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers