SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: March 2011

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 you a handy chart! Also available in PDF format!

For your convenience, here are the associated links:


DBAs@Midnight webshow


DBA Rant

SQL Awesomesauce

SQL Marklar


ITBookworm.com Read more

0 comments, 599 reads

Posted in SQL Awesomesauce on 28 March 2011

SQL Math: Whole Numbers, Real Numbers

It’s been a long time since grade school math, and for some the details have become kinda fuzzy. I’m no [insert name of famous math genius here], but I’ve been able to explain some basic things over the years.  A common SQL Math Misunderstanding came up again recently with a… Read more

0 comments, 1,852 reads

Posted in SQL Awesomesauce on 28 March 2011

An Analogy is like a Tree….

For years, I’ve been trying to express how everything ties into everything else. A big part of understanding any given thing is relating that thing to other things like it. So, a big part of learning is analogy.

This is been on my mind lately because I’ve been listening to… Read more

0 comments, 479 reads

Posted in SQL Awesomesauce on 25 March 2011

Maaaaaagic Tables!!!

I had an interview earlier this week. An interview for a SQL developer position. It went fine. But. Question number X in the initial tech screen was, and I quote:

“What are magic tables?”

……I’m sorry, what?

No, really. ”What are magic tables?”

Uhm. There’s no such thing. Read more

29 comments, 2,356 reads

Posted in SQL Awesomesauce on 24 March 2011

Not Cool Enough for Firefox

I’m pretty consistently behind the curve on most things. It took three years for me to get into The Office and American Idol.  Serenity was already made and on DVD before I was introduced to Firefly. And it’s taken me until now – 2011 – to notice The Cure (I… Read more

4 comments, 865 reads

Posted in SQL Awesomesauce on 22 March 2011

Filmed: DBAs@Midnight Episode 2.30

Friday night (as per usual) we filmed a new episode of our 2 1/2 year old webshow, DBAs@Midnight in front of a live internet audience. This was episode 2.30 (meaning season 2, episode 30).  Par for the course, I say the wrong episode number in the episode AND in the… Read more

0 comments, 832 reads

Posted in SQL Awesomesauce on 19 March 2011

Women in Technology SQL Lunch!

Attend SQL Lunch...the power of my sweater compels you...

This week on Friday, March 17 we’re having a free panel talk, presented by SQL Lunch/SQL University

SQLChicken says:

If you enjoyed reading all of the fantastic posts from WIT week you’ll love this event. The session is…

Read more

0 comments, 652 reads

Posted in SQL Awesomesauce on 17 March 2011

24 Hours of PASS Spring 2011 Code Sins

Here is all the things related to the most awesome Code Sins session I gave at 24 Hours of PASS Spring 2011.  Thanks to the 750+ of you that attended, and the many who commented!!  I will be updating this blog post with links and answers to questions for… Read more

0 comments, 656 reads

Posted in SQL Awesomesauce on 15 March 2011

SQL University – Teach Your Children Well

“If you had a daughter, would you really encourage her to get into IT?” … “Yes, if she loved it.”
- My Name Is Jes, and I’m a WIT, Jes Borland

“Let the kids (your kids, any kid) know there are more career options than teacher, doctor, lawyer, fireman,…

Read more

0 comments, 962 reads

Posted in SQL Awesomesauce on 10 March 2011

T-SQL Tuesday #016: Aggregates and Windowing Functions and Ranking! Yum!

Let’s get this out of the way right now: I am SO going to take advantage of this T-SQL Tuesday on aggregates to talk about OVER() and PARTITION BY. Aggregates and OVER go together like french fries and catsup…sure, you can have them apart, but together they’re just magical.


Read more

0 comments, 874 reads

Posted in SQL Awesomesauce on 8 March 2011

Women in Technology PPT Template

Well hey-howdy-hey (as we don’t say in Texas), it’s Women’s History Month!  And by all accounts, it’s going to be a busy one in SQL-land!  Among other things, I’ll be joining in the WIT SQL Lunch next week* as a panelist. In the course of discussing this with my… Read more

0 comments, 958 reads

Posted in SQL Awesomesauce on 4 March 2011

I Give Up: What IS an MVP?

I’m so glad you asked!

Here’s how it works: Microsoft makes products.  (The one I talk about the most is SQL Server.) People use the products to fill business needs. These solutions can be complicated, so we all share information to get better at using the product.  Everybody wins: Microsoft… Read more

0 comments, 485 reads

Posted in SQL Awesomesauce on 2 March 2011