The T-SQL ROW_NUMBER() Function

If you learn one new T-SQL (i.e., Microsoft SQL Server) concept today it should be ROW_NUMBER().  Introduced in SQL 2005,...

Index Scripting with Powershell

I’ve been actively seeking out opportunities to do more stuff with Powershell of late.
I had wanted to script out only...

Webinar Q&A: Getting Started With Analysis Services

I recently presented a free webinar for Pragmatic Works Free Training on the T’s about Getting Started With Analysis Services....

Reblog: March 14 to March 20

Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...

More On Alas Snapshot

Hopefully you had a chance to answer the Alas Poor Snapshot, I Knew Him Well question of the day than...

The power of the baseline

There is one thing we all have in common, and a lot of us probably don’t even realize it, baselines!

While...

PASS DBA Virtual Chapter Talk

I almost forgot to tell you about the Database Administration Virtual Chapter meeting next week, March 26th, 2014. I’ll be...

Friday Followup For March 21, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

The power of the baseline

There is one thing we all have in common, and a lot of us probably don’t even realize it, baselines!
...

Disheartening Apples

Question:  How many Oracle DBAs can you fit in Madison Square Garden?
Answer:  None, their egos won’t fit through the door.
No,...