Category: Tech and Learning

SQL Math: Whole Numbers, Real Numbers

Post author By Jen McCown
Post date March 28, 2011
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
3 Comments on 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 fellow SQL practitioner, so off […]

Maaaaaagic Tables!!!

Post author By Jen McCown
Post date March 24, 2011
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, TSQL
19 Comments on 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. Oh, yes there are! This is my favorite question. […]

24 Hours of PASS Spring 2011 Code Sins

Post author By Jen McCown
Post date March 15, 2011
Categories In 24HOP, 24HOP, Beginner, Intermediate, sql server, SQLPASS, sqlserverpedia-syndication, SSC, Tips, TSQL
5 Comments on 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 a few days yet. The 24HOP recorded sessions […]