Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: December 2006

Midlands PASS Chapter Meeting for January

Our next meeting will be on Thursday, January 4, 2007, at 6:30 PM. It'll be at the Training Concepts facility once again. With respect to swag, I have a couple of the new Microsoft Press SQL Server books (Microsoft sent them to all official PASS chapters, and there are enough to spread over…

Read more

0 comments, 1,018 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 December 2006

Setting Goals for the New Year and Beyond

I've never been a big fan of "New Year's Resolutions" for the same reason most other folks are against them: they don't typically work. Why don't they work? Usually because people saw they vow to do certain things and that's where they stop: "I will lose 25 pounds," "I will…

Read more

0 comments, 1,024 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 December 2006

Phone books and Indexes

On Wednesday I gave a presentation to the St. Louis Visual Basic.Net user group.  I really enjoy speaking to this group, they never look like they are falling asleep and we always have a lively discussion.  I spoke about indexes, using estimated query plans to troubleshoot queries and the procedure… Read more

0 comments, 853 reads

Posted in Advice from Aunt Kathi on 22 December 2006


We recently received a script for a modified stored proc from a vendor.  My colleague ran the script on the test database, but the application owner wasn't ready to test the new functionality.  My colleague knew she had to revert back to the old proc and scripted out the proc… Read more

0 comments, 1,386 reads

Posted in Advice from Aunt Kathi on 15 December 2006

The Moto Q and Being Proactive

I am a big fan of automating whatever I can and being proactive.  The more proactive you can be, the less fires to put out and the less stress you have.  I was reading the 7 Habits book at one time which suggests that you can carry around a little… Read more

0 comments, 951 reads

Posted in Advice from Aunt Kathi on 14 December 2006

How to handle an invalid default database

My general recommendation for SQL Server service accounts and accounts that have sysadmin fixed server role membership is to default those logins to the master database. After all, master will always be present. If master isn't present, you don't have a working SQL Server. But every once in a while…

Read more

1 comments, 1,197 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 11 December 2006

Midlands PASS Chapter is official

A group of us met on Thursday, December 7th, 2006, and voted to approve the bylaws and a motion to become an official Professional Association of SQL Server (PASS) chapter. On Friday morning I faxed off the letter of understanding to PASS HQ, so we're all set. Officer elections will…

Read more

Jason Haley recently began posting his interesting finds again

Jason Haley used to post his Interesting Finds about every day, if not multiple times a day. The interesting finds were a collection of blog posts and other links he had come across from his various RSS feeds which is put together for others who were interested in the same…

Read more

Windows 2000 Resource Kit Tools Available

If you're like me and rely a lot on the resource kit tools, you may have found that it's relatively easy to find the Windows Server 2003 Resource Kit tools in searches on the Microsoft site. However, if you still have Windows 2000 computers (including Windows 2000 Active Directory domain…

Read more

0 comments, 1,066 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 9 December 2006

SysInternals Tools Updated

Several SysInternals Tools have been updated. One of the big updates was to the PSTools Suite - now you can pass the EULA acceptance in a command line format. When the tools first appeared on the Microsoft TechNet site, there was a GUI-based EULA that popped up when the tool…

Read more

Log Buffer #22: A Carnival of the Vanities for DBAs

Welcome to the 22nd edition of Log Buffer, a weekly compendium of postings and news from database-related blogs across the Internet.

Starting things off with a bang is Peter Zaitsev and his MySQL Performance Blog where he records his observations on a  recent set of benchmarks for both MySQL… Read more

0 comments, 1,056 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 8 December 2006

Inserting missing rows

I can think of three ways to insert just the missing rows from one table or query into another table. 

The first way is so ugly that I hate to even bring it up, yet I know that there are developers and (gasp) DBAs using this very technique.  Basically, you create… Read more

0 comments, 1,044 reads

Posted in Advice from Aunt Kathi on 6 December 2006

Extreme Work

"The Productivity Pro" Laura Stack posted in her blog today about jobs where long hours are the norm:

  'Extreme' jobs on the rise: poor time management skills and workaholism to blame

She cites the example of a person who says she has a "passion" for her business and that's…

Read more

Guidance on Microsoft Certified Architect Submissions

For those considering the Microsoft Certified Architect program, some guidance on what to submit as documentation has been posted to the MCA blog:

  The submitted documentation

It's an interesting read... even if you're not actively pursuing the certification because it gives some insight into what is expected…

Read more

Bad weather and Power Outage

After years of mild weather in the St. Louis area, this is the second time we have been hit hard in a year.  In July, two storms in one week left hundreds of thousands of homes without power in 95 degree plus temperatures (F) .  On Thursday afternoon this week, an… Read more

0 comments, 853 reads

Posted in Advice from Aunt Kathi on 2 December 2006

Professional Association of SQL Server - Midlands Chapter First Meeting

If you are in South Carolina or a nearby location (Charlotte, Augusta, etc.) and are interested in participating in an official Professional Association of SQL Server chapter, our first meeting is scheduled for December 7th, 2006 at 6:30 PM. We will meet at the Training Concepts facility.

 Here are directions…

Read more

TechEd 2007 tracks announced

The Microsoft TechEd tracks have been released early here:

Sneak Peak at the 2007 Tracks

For those who are interested in attending TechEd this coming year, it will be held in Orlando, Florida again. Microsoft had previously planned on holding it in New Orleans but apparently, in Microsoft's opinion, there…

Read more

Excellent post on encryption

Laurentiu Cristofor has an excellent blog post, Who needs encryption?, which presents some point blank facts about encryption and the correlations you can draw from those facts. This post isn't a SQL Server or even a database specific post. It's about encryption in general.

I love his Fact #1:…

Read more

0 comments, 1,049 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 1 December 2006