So you may have noticed that MidnightDBA looks a bit different. Quite a bit prettier, and a little big uglier. This week we pushed our upgrade…tah-dah!! The site is still a little rough, and we'll be putting in big work this weekend. BUT, the new site features some pretty exciting stuff:
-
For us, a much easier video deployment process. It has a (drumroll-please)…..SQL back end!
-
For you, the ability to move columns around, and sort the lists of videos by any column. So if you want to see the longest videos in, say, the Dev section, just click on the "Length" heading! Sweeeet….
-
Video preview images (thumbnails). This is especially amusing on the DBAs@Midnight page
-
Author bios and pix
And we have a full list of other improvements we want to make. First things first though, gotta work out the formatting and other bugs.
And I have a couple of new articles on SQL Server Pedia: First, a thorough introduction to Joins: "In a SELECT statement we know that the first (select) phrase tells us what columns we’ll be receiving, FROM tells us what table they live in, WHERE limits the set of rows we get back, and so on. So what about JOINs? It turns out, JOINs are all about the math, baby. Stay with me here, this won’t hurt."
And now, a little TSQL script I like to call Compare Column Definitions Between Two Tables: "This week I went looking around for a quick bit of code to compare two similar tables – I had to find the mismatched datatypes and NULL settings – and I didn't find anything I liked. So I wrote this!"
Happy days, all!
-Jen McCown, http://www.MidnightDBA.com