September 2007 - Posts

• Computer Science 301

  Last night I delivered my PASS presentation to an Advanced Database Management class at my local college. Before I started the presentation I explained some concepts that were important in the presentation but outside the scope of it. Things a SQL Server Read More... Posted Tuesday, September 25, 2007 8:52 AM by AllenMWhite | 5 Comments

• PASS Conference (Friday)

  Friday started with the keynote where the new PASS Board Members and officers were announced, and congratulations and best of luck to them all. Over the 5 years I've attended the PASS conference I've gotten to know most of them, and I respect all of them Read More... Posted Sunday, September 23, 2007 11:51 AM by AllenMWhite | 0 Comments

• PASS Conference (Thursday)

  Thursday started off with a session on integrating ERWin and Visual Studio Team System for Database Professionals. I've been looking forward to using these two tools together so I was glad to see a session like this. Unfortunately, the session was supposed Read More... Posted Friday, September 21, 2007 8:26 AM by AllenMWhite | 2 Comments

• PASS Conference (Wednesday)

  The first day at PASS is always exciting. Starting with the keynote address by Ted Kummert and ending with the vendor exposition, it's great to see people again that you only get to see once or twice a year. Kummert's address mentioned the data explosion, Read More... Posted Thursday, September 20, 2007 8:53 AM by AllenMWhite | 0 Comments

• PASS Pre Conference (Tuesday)

  Tuesday's pre-conference session (for me) was Gert Drapers' Data Dude (Visual Studio Team System for Database Professionals). I've seen a number of Gert's presentations in one hour format, and this was a chance to see the product in depth. I wasn't disappointed Read More... Posted Wednesday, September 19, 2007 9:26 AM by AllenMWhite | 1 Comments

• PASS Pre Conference (Monday)

  On Monday I attended Itzik Ben-Gan's pre-conference session on Transact-SQL. I've attended a couple of his sessions in the past, and was looking forward to a full day session with him. I wasn't disappointed. His code to concatenate strings using FOR XML Read More... Posted Tuesday, September 18, 2007 8:36 AM by AllenMWhite | 0 Comments

• Using SMO to Manage SQL Server

  One week from today I'll be delivering my presentation on SMO at the 2007 PASS Community Summit . Here's the abstract of my session: Enterprise Database Administration often requires a DBA to perform the same task on multiple servers. SMO (Server Management Read More... Posted Wednesday, September 12, 2007 2:17 PM by AllenMWhite | 0 Comments

• Checklists

  One of the first things a pilot is taught is to use checklists. Everything from preflight to tie down after your return is covered in aviation checklists. Did you check the thickness of the brake pads? Did you actually look in the fuel tanks to see how Read More... Posted Tuesday, September 04, 2007 10:13 AM by AllenMWhite | 3 Comments Filed under: Database Administration