Midnight Snacks

Midnight Snacks are short tutorials, only a minute or two. Topics range from Windows and IE, to T-SQL and SSMS.

TSQLEqualsNullMistake by Jennifer McCown at 9/3/2009
1:11 minutes long

Here's a quick look at one common (NULL related) coding mistake. Remember that NULL means "unknown".

SSMS Experience Enhancements by Jennifer McCown at 9/3/2009
1:21 minutes long

Line numbers, SQL management studio keyboard shortcuts (we add sp_helptext as CTRL-F1), CTRL-R toggles the result window, CTRL-F for find, CTRL-H for replace.

Code Sins: Formatting by Jennifer McCown at 8/21/2009
1:26 minutes long

I declare Code Sin #1: poorly formatted code. Look, the video's uner 90 seconds long...watch it. Your successors, your coworkers -- your CHILDREN, will thank you.

TSQL: Select Statement Evaluation Order by Jennifer McCown at 8/20/2009
2:05 minutes long

How does SQL see a SELECT statement? Which part gets evaluated first? Why should I care? Find out here, find out fast! 1 - From 2 - Where 3 - Group by 4 - Having 5 - Select 6 - Order by

Katmai Backward Schemas by Jennifer McCown at 8/20/2009
1:00 minutes long

In Katmai, there are several schemas that are names of database roles. Jen answers that age old question: What's up with that?

TSQLInsert by Jennifer McCown at 8/19/2009
1:43 minutes long

Quick talk on different kinds of insert statements: * insert into (existing tables), new feature in 08 - multi row insert! * insert default values (empty row) * insert into ... select * insert into ... exec * select into ...

IE8 Colored Tabs by Sean McCown at 8/17/2009
1:36 minutes long

IE8 groups parent and child pages together by giving them the same tag color.

Cool Websites 1 by Jennifer McCown at 8/17/2009
0:55 minutes long

Here are a few of our favorite entertainment (okay, time waster) websites.

Cool Websites 2 by Jennifer McCown at 8/17/2009
1:03 minutes long

Here are five of Jen's favorite YouTube videos.

SSMS Code Folding by Sean McCown at 8/17/2009
1:37 minutes long

SSMS finally gets code folding, a wicked cool feature that Visual Studio has had forever.

SSMS Dynamic Help by Sean McCown at 8/17/2009
1:20 minutes long

Here I show you how cool Dynamic Help is in SSMS.

SSMS Integrated Help by Sean McCown at 8/17/2009
1:03 minutes long

Integrated Help Viewer lets you view SQL help right in SSMS, instead of a new window.

SSMS Line Numbers by Sean McCown at 8/17/2009
0:41 minutes long

Learn how to turn on line numbers in SMS.

SSMS Search Hidden Text by Sean McCown at 8/17/2009
1:04 minutes long

CTRL-F gives you the option to search hidden (folded) text! Wheee!

SSMS Split Panes by Sean McCown at 8/17/2009
0:53 minutes long

Be one of the COOL DBAs...split your panes, man!

Windows 7 Control Panel Search by Sean McCown at 8/17/2009
1:09 minutes long

Windows 7 gives you a smart and intuitive control panel search.

Windows 7 Magnifier by Sean McCown at 8/17/2009
1:25 minutes long

Win 7 has a convenient magnifier that you can dock, use in lens view, or use in full screen.

Windows 7 Shake by Sean McCown at 8/17/2009
1:13 minutes long

Windows let you clear the desktop with a shake of a window.

Windows 7 Sticky Notes by Sean McCown at 8/17/2009
1:21 minutes long

Sticky notes: Just like a post-it on your website. Now with subliminal (midnighdba) suggestions!

Windows 7 Transparent Windows by Sean McCown at 8/17/2009
1:45 minutes long

Here's another great navigation feature in Win 7. Hey guys, let's play "spot the late-night speling"!

Windows Shortcuts 1 by Jennifer McCown at 8/17/2009
1:19 minutes long

Universal Windows keyboard shortcuts. CTRL-A CTRL-C CTRL-V CTRL-Home SHIFT-Down CTRL-SHIFT-End CTRL-SHIFT-Home CTRL-Z CTRL-S

Windows Shortcuts 2 by Jennifer McCown at 8/17/2009
1:28 minutes long

More fun with keyboard shortcuts. Alt-TAB Alt-SHIFT-TAB Alt-F4 Alt-SHIFT Alt-SHIFT-N Alt-SHIFT-X Alt-SHIFT-R WINDOWS-L WINDOWS-R WINDOWS- [#]

Windows Shortcuts 3 by Jennifer McCown at 8/17/2009
1:16 minutes long

Classic text menu shortcuts (Notepad, IE, Office, etc) Alt-F Alt-F-N Alt-F-O Alt-F-S or CTRL-S Alt-F-A Alt-F-P or CTRL-P Alt-E-U or CTRL-Z F3 or CTRL-F

IE8 Browse Button by Sean McCown at 8/16/2009
Need minutes long


DirtyTricks2: Get List From Command Line by Jennifer McCown at 1/1/0001
minutes long


Ignoring Parameters by Jennifer McCown at 1/1/0001
minutes long