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,...

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...

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...

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...

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...

Breaking Into SQL Showbiz

You can tell by my face, I'm an expert
Matthew Velic (blog, Twitter) just asked this question on Twitter:
And really that’s...

SELECT: If ON preceeds JOIN, then how….

I got some excellent questions from my 24HOP session yesterday, and when presenting the same session at NTSSUG last night. ...