Tip: OVER and PARTITION BY

I like to repost this blog about once a  year, because you really really need to know about windowing functions....

Blogging for Beginners

Last week at the PASS Summit, I had several conversations with several different aspiring bloggers, and found myself saying the...

Find Duplicate (and covered) Indexes

A while back, I wrote a simple little query that lets you Get Index Included Column Info (because sp_help and sp_helpindex only...

Lose #5 Before #sqlpass

Win Valuable Prizes!

Impress Your Friends!
This week we’re starting up a health and weight loss competition that I hereby dub #PASSGameOn,...

Interview with a #SQLPASS Candidate – @NTSSUG’s Sri Sridharan!

Last week, Sri Sridharan (Twitter, blog) and I sat down on the Internet to talk about his run for the...

PASS Summit: What’s all the hype?

Last week I received this comment/question from one of my fabulous First Timers:
I have a good natured question coming from...

PASS First Timers Guide and Schedule – 2012 edition

Hi there ho there everybody! It’s less than five (FIVE!) three (THREE!)one (ONE!!) week until the 2012 PASS Summit in Seattle,...

Register for Sean’s Dallas precon!

On October 13, Dallas will hold our second ever Special Bi Edition of SQLSaturday Dallas - #SQLSat163 for you Twitter folk...

Stressed? Need training? Take a #SQLCruise!

I can’t tell you how many times I’ve sat in a training room, in the middle of a week long...

Our weekly webshow starts Friday! #DBAsAtMidnight

Let’s pretend we’ve never met. Depending on who you are, maybe we haven’t. It’s beside the point, really.
So hi, I’m...