S–3–X Talk Week: Love, HR, and Sexy Shoes

We’re conducting S–3–X Talk Week here at the MidnightDBA #Awesomesauce blog. In the tradition of the first S-3-X week blog,...

Forgotten T-SQL Cheat Sheet

You’ve seen the blog, you’ve downloaded the code…you even watched the 24HOP session recording…now own the Forgotten T-SQL Cheat Sheet!
Yessir,...

S–3–X Talk Week: This Totally Won’t be Awkward

We’re conducting S–E–X Talk Week here at the MidnightDBA #Awesomesauce blog, in honor of everyone’s favorite subject. In deference to the...

New Hotness: sys.objects and sys.schemas

Last month we talked about the old and busted syscomments- and the new hotness that is sys.sql_modules – for pulling code out of...

How MUCH More Do You Make?

Yesterday, my SQLServerCentral.com editorial Why are we still talking about Women in Tech? was published, and we had a fine...

Today I Blog About Certifications (Instead of Studying)

I'm not in it for the money...exclusively...
I was talking to the older kids about homework yesterday, and I mentioned that...

Tip: OVER and PARTITION BY

Here’s a quick summary of OVER and PARTITION BY (new in SQL 2005), for the uninitiated or forgetful…

OVER
OVER allows you...

Dear Users…Sincerely, Your IT Guys

Dear Users,
We, the tech people, understand that you just want technology to work so you can get your jobs done. ...

How to Prove a Fact (Again)

Sean’s latest rant – about a vendor with a dangerously small amount of SQL knowledge – has spurred me to talk about...

Journal: SQL Saturday #52

Friday
6am – up to catch an 8:30 flight. My daughter Lisette is going with me on this trip.
9:30am local time, we...