SQL Server General DBA

E-Mail Functionality in SQL Server 2005

Sending an e-mail has become very important in any system for purposes such as sending notifications. SQL Server database has an integrated mailing system. With the arrival of SQL Server 2005, users now have the new functionality of Database Mail, which is different from SQL Server 2000 SQL Mail. The purpose of this article is […]

Peer-to-Peer Transactional Replication in SQL Server 2005

Replication is an important technology that can be used in SQL Server. With replication, a DBA can synchronize data between two or more databases. This vital function is primarily used when a DBA needs to share server loads to improve database server performance. Replication can also help to provide high availability to TCP/IP services. As […]

SQL Server Books Online: A Primer for New Users

What’s New and How to Get the Most Out of It This article is for new users of SQL Server. I have been using SQL Server since 1997. In that time, I have seen the many changes that have occurred since the initial release of SQL Server version 4.2. Each new release is a thrill […]

Interview with SQL Server Master Trainer Scott Whigham, Owner of LearnSQLServer.com

Scott Whigham is a SQL Server consultant and trainer. Recently, he started a new website called LearnSQLServer.Com. I recently met Scott at a training event and was impressed with his teaching ability, so I decided to interview him. Give us a brief introduction to your website, LearnSQLServer.com. LearnSqlServer.com is a place where people can go […]

Select Based on List of Random Values — Dynamic SQL or CSV Parsing UDF?

Two frequently asked related questions in Microsoft SQL Server discussion groups are: How to pass an array to a stored procedure? How to select data based on a list of values? Examples: User wants to search for jobs based on a list of desired locations. User marks e-mails in an inbox for deletion. SQL data […]

Dealing with the Dodgy GO Command

The GO command plays a very important role in Microsoft SQL Server. It signals the end of a batch of SQL statements and executes them as a whole. Seems simple enough. But using GO can be disastrous if you don’t understand its usage in a certain scenario. One of the places where I found the […]

Scripts for Space Monitoring Report

The SQL to enter in the “Execute SQL Task” if not exists(select * from master..sysdatabases where name=’dbamaint’) create database dbamaint go alter database dbamaint set RECOVERY SIMPLE go use dbamaint go if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_filespacestats]’) and OBJECTPROPERTY(id, N’IsProcedure’) = 1) drop procedure [dbo].[sp_filespacestats] GO SET QUOTED_IDENTIFIER ON GO SET […]

Monitor Your Database Servers with DTS, Part 3: Space Monitoring of SQL Servers

In the previous two articles in this series on monitoring a large number of servers from a centralized location using Data Transformation Services (DTS) (see Part 1 and Part 2), I explained how to set up a report to ensure that backups are happening as per the backup policy and how to monitor SQL Server […]

Generate Log Files with a Trigger

As a DBA you try to supply data in a format that is familiar to the audience you’re presenting it to. Many times, you’ll present data in MS Excel to the accounting department, or an HTML report to a standard user. Your system and security administrators are no different; they are used to reading logs […]

SQL 2000 to SQL 2005: Where Have All the Old Features Gone?

As more DBAs across the planet begin using SQL 2005 Tools, but still manage SQL 2000 servers with them, I suspect there will be lots of muffled moaning as to where all the good old features have gone. Although Management Studio has some very nice long-awaited features, some of the good old stuff just isn’t […]