Click here to monitor SSC
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: 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

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

"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

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,096 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