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

Archives: November 2005

Updated my professional site

Slowly reworking my professional site at but as of right now it's more of a brochure site than anything else. I want to try and make it more useful than in its previous incarnation.

Read more


I wrote an editorial on the 64-bit decision by Exchange to not release their next version in 32 bit. Only 64. Some friends and I had a discussion at lunch today, with most of them thinking this was more a marketing decision than a technical one, but I'm not sure.

Read more

0 comments, 977 reads

Posted in The Voice of the DBA on 29 November 2005

Update on MSSQL::OlleDB - Name Change

SQL Server MVP Erland Sommarskog has announced a name change to MSSQL::OlleDB. It's now known as Win32::SQLServer. This is to bring it in line with the other Win32 modules that are used in Perl.

Read more

New Version of Apex SQL Edit released

Looked over at the Apex SQL site and noticed they released a new version of ApexSQL Edit last weekend. I went out and grabbed the latest version but didn't even note the release version. Silly me. In any case, the annoucement is here:

Apex SQL Edit 2.20 Released - Major…

Read more

Writing an article - don't be afraid to get started!

Writing at article for SQL Server Central tends to be a very rewarding experience. Every chance I get, I encourage others to try their hand at putting forth something. Not only does it serve as a resume builder, but it gives back something to the community, helps develop knowledge in…

Read more

PromptSQL - Intellisense for SQL Server

Visual Studio has spoiled me. I love the Intellisense feature that has continued to evolve with each new edition of Microsoft's IDE. Intellisense not only reduces the time it takes me to develop solutions, but it's kind of like a built-in checker with respect to referencing objects and variables. Put those… Read more

0 comments, 1,012 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 25 November 2005

"Predicate Evaluation Order"

In writing an article for SQL Server Standard's January issue, I received a tech edit comment from Adam Machanic about a weakness in the typical row-level security implementation for SQL Server that I wasn't aware of. Doing a little research (especially using Adam's citations as MVPs Steve Kass and Sharon…

Read more

0 comments, 1,002 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 25 November 2005

New version of ADO.NET provider for MySQL is available

The following announcement came out this morning on the Annouce mailing list for MySQL:

"MySQL Connector/Net 1.0.7, a new version of the fully-managed, ADO.Net provider for the MySQL database system has been released.  This release is the latest production release of the 1.0 series and is suitable for use with…

Read more

0 comments, 1,112 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 21 November 2005

Google Base

There has been some talk on Google Base on the Full Disclosure security list. I've also seen on another blog about Google Base being a threat to small businesses that do web hosting and the like (if you read the Google Base FAQ, you'll see why).

Here's the FAQ about…

Read more

Brief from David Litchfield about Administrator Logins to a Database Server

David Litchfield has put out a brief (as he says it, "It's called a brief because there's enough meat to make it interesting but not enough to make it a paper ;) ) on why no one should log onto a database server (or any server hosting network based services…

Read more

MySQL 5.0 Released

Catching back up on things. MySQL 5.0 went "RTM" at the end of October. Haven't had a lot of chances to play with the new features (been tinkering in SQL Server 2005 land), but there are a lot of new additions.

You can download it here:

Read more

New Perl Module for SQL Server released

For those who use Perl and access SQL Server, MVP Erland Sommarskog has announced a new module which uses OLE DB to access SQL Server. Called MSSQL::OlleDB, you can find it here:

This requires ActiveState Perl 5.8.3 (most current release is 5.8.7).

Read more

0 comments, 1,012 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 19 November 2005

I love wireless!!!

I took part of today off to attend the Denver Woodworking show north of Denver. I left early because, well, I was excited and wanted to get down here and allow for any traffic issues while driving through Denver. It's also my son's birthday, so I need to be back…

Read more

0 comments, 902 reads

Posted in The Voice of the DBA on 18 November 2005

Named Instances and SS2K

I saw Alex's post on installing a named instance of SS2K5 and having issues with SS2K. I wanted to note that Dale Corey and I are working on a SQL Server Management Studio book and I needed to check some things using the RTM code. I need my desktop to…

Read more

0 comments, 914 reads

Posted in The Voice of the DBA on 18 November 2005

Apologies and Testing

First, apologies to the Database Daily readers. I'll include one in next week's issue as well, but the links didn't work and it's my fault.

The reason it happened is quite simple. I made a change and didn't test it. But the back story is a touch more complicated and…

Read more

0 comments, 1,331 reads

Posted in The Voice of the DBA on 15 November 2005

Get MAXimum functionality

SQL 2005 provides a the new max specifier to be used with varbinary, varchar and nvarchar data types. You can use these in place of image, text and ntext data types respectively.

There are many things you can't do with text that will work with varchar or nvarchar:

declare @bigString… Read more

0 comments, 835 reads

Posted in Advice from Aunt Kathi on 12 November 2005


If you haven't seen it, I started a poll in the editorial today. Check it out and give you answer: Ten Most Influential People in the 20th Century.

Read more

0 comments, 1,043 reads

Posted in The Voice of the DBA on 11 November 2005

Day Zero

Today's the day!!!

SQL Server is being released as I type this and I'm online listening to the keynote from Steve Ballmer.

I'm not thrilled with him as a speaker, I'd much prefer Bill Gates, Paul Flessner,  or Bill Baker, but Steve's the voice of the company, so it makes…

Read more

0 comments, 966 reads

Posted in The Voice of the DBA on 7 November 2005

Boycott Sony

In general I have been a Sony fan for most of my life, starting with the Walkmans they brought out in the eighties.

But no more. Not sure if I'll skip their movies, but I am done buying Sony products for now after the rootkit incidents. There are two entries…

Read more

0 comments, 937 reads

Posted in The Voice of the DBA on 4 November 2005

Looking For Technical Editors

If anyone is interested, we are looking for people that are interested in doing some technical editing for our magazine, the SQL Server Standard.

We're offering $25 and a free one year subscription or $50 for each article and we have them in a variety of areas. If anyone is…

Read more

0 comments, 943 reads

Posted in The Voice of the DBA on 2 November 2005