SQL Server General DBA

Security Enhancements in SQL Server 2005: Schema

Security has become more and more important in today’s business environment. From the database point of view, DBAs and system administrators need an improved security model. SQL Server 2005 provides an improved security feature. It is claimed that SQL Server 2005 is secure by default. In SQL Server 2005, the security model is divided into […]

How To Configure SQL Mail to Work With GroupWise

Introduction This document walks through how to configure SQL Mail for Microsoft SQL Server to work with Novell GroupWise. For the purpose of this document I will refer to the user account as sqluser and the password as sqlpassword. Requirements You should have both Microsoft SQL Server and GroupWise installed. Configuration There are four main […]

Centralized SQL Server 2000 Monitoring

This article provides how-to information and code for two different monitoring systems you can set up centrally to manage reporting of SQL Server 2000 maintenance and disk utilization. The first is a scheme I have used in my role as a DBA, which has helped simplify and speed up one of the more mundane tasks […]

Creating Backup Jobs in SQL Server 2005

The SQL Server 2005 Maintenance Plan feature has been significantly modified in comparison with SQL 2000: now it utilizes new Integration Services. Also, creating database and transaction log backups is not as clear as it was in SQL 2000. This article does not describe all available SQL Server 2005 backup features or provide some tricks […]

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 […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |