K. Brian Kelley - Databases, Infrastructure, and Security - November 2005 - Blogs

Updated my professional site

Slowly reworking my professional site at http://www.truthsolutions.com/ 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.

0 comments, 397 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 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.

0 comments, 414 reads

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

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…

0 comments, 419 reads

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

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…

0 comments, 435 reads

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

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, 420 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…

0 comments, 419 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…

0 comments, 483 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…

0 comments, 459 reads

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

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…

0 comments, 403 reads

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

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:

http://dev.mysql.com/downloads/mysql/5.0.html

0 comments, 417 reads

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

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:

http://www.sommarskog.se/mssqlperl/

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

0 comments, 450 reads

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

Get Your Own Blog

Contact the author

All Blogs

Feeds

Archives for this blog