Subscribe to latest posts
Archives: December 2006
Midlands PASS Chapter Meeting for January
0 comments, 425 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 December 2006
Setting Goals for the New Year and Beyond
0 comments, 431 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, 393 reads
Posted in Advice from Aunt Kathi on 22 December 2006
SET QUOTED_IDENTIFIER
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, 413 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, 394 reads
Posted in Advice from Aunt Kathi on 14 December 2006
How to handle an invalid default database
0 comments, 458 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 11 December 2006
Midlands PASS Chapter is official
0 comments, 422 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 11 December 2006
Jason Haley recently began posting his interesting finds again
0 comments, 393 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 9 December 2006
Windows 2000 Resource Kit Tools Available
0 comments, 434 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 9 December 2006
SysInternals Tools Updated
0 comments, 402 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 9 December 2006
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, 465 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, 439 reads
Posted in Advice from Aunt Kathi on 6 December 2006
Extreme Work
'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…
1 comments, 418 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 5 December 2006
Guidance on Microsoft Certified Architect Submissions
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…
0 comments, 396 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 5 December 2006
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, 392 reads
Posted in Advice from Aunt Kathi on 2 December 2006
Professional Association of SQL Server - Midlands Chapter First Meeting
Here are directions…
0 comments, 446 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 1 December 2006
TechEd 2007 tracks announced
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…
0 comments, 388 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 1 December 2006
Excellent post on encryption
I love his Fact #1:…
0 comments, 493 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 1 December 2006