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:
More…
0 comments, 160 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, 718 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, 127 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, 659 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, 273 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, 191 reads
Posted in SQL Awesomesauce on 19 March 2011
Women in Technology SQL Lunch!
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…
0 comments, 164 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, 215 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,…
0 comments, 175 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.
Note
0 comments, 184 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, 354 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, 90 reads
Posted in SQL Awesomesauce on 2 March 2011



Subscribe to this blog