Pop Rivett and the Expanding Log

When your database transaction log is out of control, there is only one man who can tame it.

How do you convert a floating-point value from...

Monitoring Changes to your Database Schema

With the introduction of SQL Server 2005, Microsoft now allows you to write Data Definition Language (DDL) triggers to perform actions when events occur on your server. In this article, Greg Larsen discusses (examples included) some of the things that DDL triggers can be use for.

SQL Server ships with a built in system...

What does the STATS_DATE() function do?

Distributed Partitioned Views / Federated Databases: Lessons Learned

This article contains information about the things we have learned while working with Federated Databases. Before beginning it is necessary to define the terms being used. Included in this article is one solution in production that is using federated servers and Distributed Partitioned Views.

Deploying Reports

Longtime SQL Server expert Raj Vasant takes a look at various ways in which you can deploy reports for Reporting Services 2005.

If you run a backup to your local...

How can you get the number of columns...

Upgrading a Database SQL 2000 to SQL 2005

Performing an upgrade to the next version of SQL Server is something more and more of us will be doing as the support for SQL Server 2000 wanes. New author Sachin Samuel brings us an overview of the process and options that you have for performing an upgrade.