Category: Beginner

Overview: SQL Server (SQL Saturday #63)

Here are all the things related to the most awesome Overview: SQL Server session I gave at SQL Saturday #63 April 2, 2011.  This session was live streamed on http://www.bit.ly/DBAShow. That recording (without screen shots) is here. As always, feel free to write with questions and comments! Links:  SQL Server Developer Edition, free to students. DreamSpark.com  SQL Server […]

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!!!

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. […]