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...

MySQL 5.0 Release Candidate Released

The release candidate for MySQL 5.0 is out. This little database is really growing up.

http://www.mysql.com/news-and-events/news/article_959.html

Head back up above water

I've spent the last few weeks writing SOX documentation, more SOX
documentation, and even more SOX documentation. A lot the documentation
doesn't...

SQL PASS Chapter in South Carolina

If you are interested in helping to organize or be a part of an
official Professional Association of SQL Server chapter...

Triggers in SQL Server 7.0 and 2000 - What's New

This is the second of a two part series on how triggers work in the two latest versions of MS SQL Server. The first part dealt with what is common between the two versions. This article will detail what's been added to SQL Server 2000.

Securing SQL Backups

SQL Server does many things very well, but securing itself is not one of them. While securing your server requires some effort, there is an area that many people forget. Securing your backups! Brian Kelley, our resident security expert, brings some advice and ideas for ensuring your data will not be stolen.

Triggers in SQL Server 7.0 and 2000 - The Common Ground

This is a two part series on how triggers work in the two latest versions of MS SQL Server. Because there are some pretty significant additions in trigger functionality from 7.0 to 2000, we'll first need to look at what the two versions have in common. The second part to this series will look at the differences between the two MS SQL Server versions.

Which of the following commands will successfully create...

Getting the Most out of SQL Server 2000's Query Analyzer, Part I

So you open up the tool a hundred times a day. In this article by Brian Kelley, he shows you how to get the most out of some of the known and unknown features.

Stored Procedures and Caching

One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.