SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

K. Brian Kelley - Databases, Infrastructure, and Security

IT Security, MySQL, Perl, SQL Server, and Windows technologies.

Archives: January 2006

Teaching 3rd Graders binary numbers?!?

This is just neat. I saw the link in a post on Tess Ferrandez's blog. She's an escalation engineer with Microsoft based on her profile. I initially signed up for her blog because of how she covers debugging. In any case, the Socratic method was used to teach 3rd…

Read more

0 comments, 1,483 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 27 January 2006

Forums for Atadore's PromptSQL

Atadore has opened up forums for support and feature requests of its PromptSQL tool. You can find them on the PromptSQL site here:

There is useful information such as Known Restrictions and what's Fixed in Next Release.

Read more

0 comments, 1,318 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 26 January 2006

The Greatest Trick

In reading Gianpaolo Carraro's blog I came across this entry: The architect greatest trick?!

In it he's talking about having seen the movie The Usual Suspects where Kevin Spacey's character make a comment about the devil's greatest trick is making people believe he didn't exist. Then Mr. Carraro carries this…

Read more

0 comments, 1,515 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 26 January 2006

PromptSQL Review

I had the opportunity recently to take a look at PromptSQL and offer a review on it. That review hit SSC.com's front page today. If you're interested in an inexpensive IntelliSense tool for Query Analyzer, Visual Studio, or SQL Server Management Studio, take a look at the review to get…

Read more

0 comments, 1,406 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 18 January 2006

Awesome Interview on Windows Vista Kernel Architecture

This actually premiered on Channel 9 right before Christmas. It is an interview with Rob Short, a Microsoft VP in charge of the team working on Vista's kernel architecture. With him are Darryl Havens, Richard Ward, and Rich Neves, all architects who work under him. The interview is quite candid…

Read more

Guidance on .WMF patch from Mike Nash, Microsoft Corporate VP

There is a new posting from Mike Nash on the Microsoft Security Response Center blog:


Relevant quote:

So the thing that I know you are all wondering is what should I do?  So here is my advice.  If you are a consumer or a small business, you…

Read more

Microsoft .WMF Security Patch Releasing Today (out-of-cycle)

Microsoft has announced they will release a security hotfix at 2 PM PST for the WMF design flaw. More details here:

Microsoft Security Bulletin Advance Notification

The number of exploits taking advantage of this design flaw are continuing to grow. Consider testing this patch immediately on non-production systems.

Read more

Simple Script to Report Tables Sizes in a SQL2K Database

Last week we had an issue with a database growing unexpectedly. The database in question supported an infrastructure type 3rd party application and the administrators over said application were scratching their head as to why it could have grown. I threw together a quick script using sp_spaceused to figure out…

Read more

Sample Chapter from Professional SQL Server 2005 Integration Services

Brian Knight posted a sample chapter for Professional SQL Server 2005 Integration Services to his blog a few days ago. Last night I had a chance to go through it and work through the examples. I found them to be clear and closely model some of the types of file…

Read more

Philosophy on Soldiering

This is taken from the book About Face:The Odyssey of an American Warrior. The author is Col. David "Hack" Hackworth, one of the most decorated soldiers in the history of the United States. He served in post-WWII Europe in Trieste, spent two tours in Korea during the Korean War,…

Read more