Site sponsored by:

Home

Articles

Forums

Tips

FAQ's

Blogs

Software

Books

About Us

RSS Feeds

Article Topics

All Articles

Peformance Tuning

Audit

Business Intelligence

Clustering

Reporting Services

Developer

General DBA

ASP.NET / ADO.NET

SQL Server 2008 - Worth the Wait

SQL Server’s first significant upgrade in three years features a number of envelope-pushing enhancements and improvements. Which will have the greatest impact on SQL administration and development? More...

Latest FAQ's

SSIS Lookups are Case Sensitive

Convert Number to Words in SSRS

After installing SP2 on SQL Server 2005 x64, when trying to ...

Remote Name Could not be Resolved in SQL Server Reporting Services ...

SQL Server General DBA Articles

Usage of SQL Server Database Snapshots
Database Snapshots are a new feature in SQL Server 2005 which many DBA's are not aware of. In this article Dinesh Asanka provides an overview of this feature.

Creating Custom Reports for SSMS
The new custom report feature of SQL Server 2005 SP2 allows you to incorporate Reporting Services report definitions (.rdl) files into SQL Server Management Studio (SSMS).

Importing Poorly Formatted Text Files using SSIS
Importing text files is a common task for DBA's and Developers, but what happens when the text file is not properly formatted?

Data Cleansing with SSIS
SSIS introduces several new tools including Fuzzy Logic to aid data cleaning.

Isolation Levels in SQL Server 2005
Isolation levels are used to prioritize the acccess to a resource. SQL Server 2005 extends upon the support for isolation levels in 2000 with several new features including an additional level.

SSIS Package Configuration in SQL Server 2005
SQL Server 2005 allows DBAs to set configurations for SSIS packages outside the package to facilitate a smooth transition between different environments.

A Look at Microsoft SQL Server Upgrade Advisor
Microsoft SQL Server Upgrade Advisor tool helps the user with the process of upgrading SQL Server 2000 (or 7.0) instances to SQL Server 2005. It analyzes the configuration of installed SQL Server 2000 (or 7.0) components and generates reports. The reports give an idea of the issues that will hinder the upgrade process.

Server System Architecture, 2007 (Preliminary)
The original article in this series was published in 2002 and covered Pentium III and Pentium III Xeon systems. It is now time for an update to the Core 2 and Opteron based systems of 2007 and a look ahead to 2008. By Joe Chang.

DDL Replication in SQL Server 2000 and 2005
You may have wondered how to add, drop, or alter (type or size) a column of a table that is an article of a publication. I have seen this question in many forums and discussion boards. Obviously, dropping the replication, making the necessary changes, and then recreating the replication is not efficient. By Dinesh Asanka.

Keeping Your SQL Server Databases Defragmented with Diskeeper
Physical file fragmentation can hinder SQL Server's performance. Learn how Diskeeper can help resolve this problem.

Security Enhancements in SQL Server 2005: Schema
This article will discuss the key features of authorization in SQL Server 2005. Among the several authorization features, schema is the most valuable and confusing special feature.

How To Configure SQL Mail to Work With GroupWise
Learn how to configure GroupWise to work with SQL Server Mail.

Centralized SQL Server 2000 Monitoring
Learn two different ways to help centrally manage your SQL Servers

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 dealing with them; instead, it offers solutions for the most commonly used backup jobs.

E-Mail Functionality in SQL Server 2005
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 to introduce Database Mail and highlight the advantages of using it over legacy SQL Mail.

Peer-to-Peer Transactional Replication in SQL Server 2005
As you may be aware, SQL Server 2000 provides three types of replication: Snapshot replication, transactional replication, and merge replication. SQL Server 2005 includes a new replication method: Peer-to-peer transactional replication.

SQL Server Books Online: A Primer for New Users
This article is for new users of SQL Server … I'm a big fan of SQL Server Books Online (BOL). It has helped me a lot and I have saved a fair amount of time that I would have spent searching through books or on the Web for answers.

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.

Select Based on List of Random Values — Dynamic SQL or CSV Parsing UDF?
How do you pass random-list based criteria to a stored procedure and how do you achieve a good execution plan without a recompilation each time the query is executed?

Dealing with the Dodgy GO Command
The GO command 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.

Scripts for Space Monitoring Report
Scripts to complement the 'Monitor Your Database Servers with DTS, Part 3: Space Monitoring of SQL Servers' article.

Monitor Your Database Servers with DTS, Part 3: Space Monitoring of SQL Servers
In this final article on how to monitor a large number of servers from a centralized location using Data Transformation Services (DTS), I explain how to monitor space utilization of databases on all the servers.

Generate Log Files with a Trigger
The following article will show you how to log DML changes to specific tables in your database, using triggers.

SQL 2000 to SQL 2005: Where Have All the Old Features Gone?
Although Management Studio has some very nice long-awaited features, some of the good old stuff just isn't there.

Scripts for Errorlog Monitoring of SQL Servers
Scripts to complement the 'Monitor Your Database Servers with DTS, Part 2: Errorlog Monitoring of SQL Servers' article.

Monitor Your Database Servers with DTS, Part 2: Errorlog Monitoring of SQL Servers
In the second of three articles on how to monitor a large number of servers from a centralized location using Data Transformation Services (DTS), I explain how to monitor SQL Server errorlogs.

Scripts for Backup SLA Report
Scripts to complement the 'Monitor Your Database Servers with DTS, Part 1: Backup SLA Report' article.

Monitor Your Database Servers with DTS, Part 1: Backup SLA Report
In the first of three articles on how to monitor a large number of servers from a centralized location using Data Transformation Services (DTS), I explain the setup of a report that ensures that backups are happening as per the backup policy.

SQL PASS Community Summit vs. SQL Server Connections Conference
Don't know which SQL Server conference to attend, get one person's opinion here.

Implementing the SQL Server Multiple Publishers and Central Subscriber Replication Topology
Learn how to configure replication for multiple publishers with a central subscriber.

SQL Server Replication Across Domains and the Internet
Learn how to configure replication to work across domains or the Internet.

SQL Server 2005: The Replication GUI
The replication GUI screen has changed substantially in SQL Server 2005.

Replicating Stored Procedure Execution
Learn how to replicate stored procedure execution to reduce replication overhead and boost performance.

Kerberos Protocol Transition and Constrained Delegation
Learn how to implement Kerberos protocol transition and constrained delegation in SQL Server and IIS.

Learn About SQL Server Disaster Recovery from Vas Srinivasan of Sonasoft.com
Learn about the importance of disaster recovery in this interview with an industry expert.

An Interview with Simon Galbraith, Marketing Director of Red Gate Software, on Major Trends in the SQL Server Market
One person's perspective on what's happening in the SQL Server tools marketplace.

SQL Server 2000: View Basics
Learn the basics of Views in SQL Server 2000.

Taking a Proactive Approach with SQL Server Agent
Learn some of the basics of using SQL Server Agent.

How to Find a SQL Server Database Object
Learn how to write a stored procedure to make it easy for you to locate objects anywhere on a SQL Server.

Pros & Cons of Using SELECT, Views, and Stored Procedures in SQL Server
Learn how SQL Server treats SELECTs, views, and stored procedures

Keep Your SQL Servers Synchronized with SQL Compare and SQL Data Compare
Do you need to keep SQL Server database in synch? If so, find out if SQL Compare and SQL Data Compare are for you.

Can Amazon Serve Customers and Protect Privacy at the Same Time? (What Data Should DBAs Keep and Discard)
As a DBA, you need to consider the kind of data you collect, and whether or not is should be kept or discarded.

Migrating from Oracle to SQL Server
Migrating from Oracle to SQL Server is not a problem, if you know how.

Sample SQL Server Disaster Recover Plans
Learn how other companies put together their SQL Server disaster recovery plans.

SQL Server Stored Procedures for Beginners
Learn the basics of writing SQL Server stored procedures.

A Script to Find SQL Server Stored Procedure Dependencies
If you want to script stored procedures in the correct order, then this script may help you out.

SQL Server Upgrade Recommendations and Best Practices Part 2: SQL Server 6.5 to 2000 Critical Upgrade Decisions and Redundant Upgrade Architecture
Part two of this article series focuses on the the technical components faced by DBAs and Developers during the upgrade process.

Making the Move from Sybase to SQL Server
If you are planning a move from Sybase to SQL Server, you had better check this article out.

How to Connect to SQL Server from Visual FoxPro
If you use Visual FoxPro to connect to SQL Server, then you will want to read this article.

How to Identify and Delete Duplicate SQL Server Records
Deleting duplicate SQL Server records is not as easy as you might expect. Learn how to identify and delete duplicate records in this article.

Create Your Own SQL Server Job Management System
If you don't have the ability to easily manage the jobs on your SQL Server, then you may want to consider writing your own SQL Server job management system, like the one described in this article.

SQL Server Startup Parameters
Learn how to take advantage of SQL Server startup options.

Track SP Changes by Automatically Saving Your SQL Server SP Text
Track SP Changes by Automatically Saving Your SQL Server SP Text

SQL Server Upgrade Recommendations and Best Practices Part 1: Upgrade Overview and Project Planning
First in a series of new articles on how to best upgrade SQL Server

SQL Server 2000 Undocumented Stored Procedures
Still more from author Alexander Chigrik on the secret world of undocumented SQL Server 2000 stored procedures.

Using Stored Procedures to Manage SQL Server Security
Stored Procedures are not only good for performance, they are also good for security.

Learn About SQL Server Disaster Recovery from Greg Robidoux of Edgewood Solutions
Learn About SQL Server Disaster Recovery from Greg Robidoux of Edgewood Solutions

Introduction to Data Mining with SQL Server
Learn the basics of data mining using SQL Server.

Troubleshooting SQL Server Full-Text Search Problems
Learn how to troubleshoot common full-text search problems.

Use This SP to Generate a SQL Server Job Report
Use this SP to create a report listing all of your SQL Server 7.0 and 2000 jobs.

Server System Architecture, 2002
Learn about the various chipsets, and their pros and cons, available for your SQL Server.

A Comparison of SQL Server 7.0 with SQL Server 2000
Are you still using SQL Server 7.0 and considering upgrading to SQL Server 2000? If so, this article may help.

Interview with Tim Hayes, dbPAL Developer and CEO of IT-Map
Learn about the "big picture" of SQL Server-based software development from an industry veteran.

SQL Server 7.0 and 2000 Trace Flags
Learn about documented and undocumented SQL Server 7.0 and 2000 trace flags.

How 11GB of SQL Server Data Mysteriously Disappeared, and How I Ended Up Better Off than Before
What would you do if your SQL Server database mysteriously lost 11GB of data? Find out what happened to me. By Brad M. McGehee.

Inside SQL Server Maintenance Plans
Learn what happens under the covers when you use the Maintenance Wizard to create maintenance plans.

Manage Multiple SQL Server Installations and Databases with OSQL
Learn how to use OSQL to automate SQL Server management.

Some Useful Undocumented SQL Server 2000 Trace Flags
You can never know too much about SQL Server trace flags. In this article, find out about those that are undocumented in SQL Server 2000.

Auditing Your SQL Server Environment, Part II (Reviewing Role Memberships)
In this second article of a series, learn how to audit SQL Server role memberships

Interview with Carl Speshock, Author of the Microsoft SQL Server 2000 Database Administrator's Guidebook
Find out more about the author of the Microsoft SQL Server 2000 Database Administrator's Guidebook, and what he thinks about SQL Server.

Understanding SQL Server's DBCC SHOWCONTIG
Find out how to use the DBCC SHOWCONTIG command to boost the performance of your databases.

Some Useful Undocumented SQL Server 7.0 Trace Flags
Learn about these undocumented SQL Server 7.0 trace flags.

Some Useful Undocumented SQL Server 7.0 and 2000 DBCC Commands
Author Alexander Chigrik is at it again, showing you more undocumented commands, this time DBCC commands for SQL Server 7.0 and 2000.

How to Script User and Role Object Permissions in SQL Server
Use these scripts to help you move object permissions from one database to another.

Auditing Your SQL Server Environment Part I
Learn how to audit login security in your SQL Servers.

The Self-Taught DBA
Are you thinking of becoming a master DBA? If so, find out how you can.

Overview of the SQL Server Security Model and Security Best Practices
Learn about the SQL Server security model and SQL Server security best practices.

SQL Server 7.0 Undocumented Stored Procedures
More from author Alexander Chigrik as he helps us discover the secret world of undocumented SQL Server 7.0 stored procedures.

SQL Server Replication from 6.5 to 2000
Find out how to replicate data from a SQL Server 6.5 database to a SQL Server 2000 database. Includes some related performance tips.

Data Page Structures in SQL Server 6.5
Learn about the underlying architecture of SQL Server 6.5 data storage.

How to Troubleshoot SQL Server 7.0 Installation Issues
Find out how to troubleshoot failed SQL Server 7.0 installations.

Creating Logins for Databases Restored to a Replacement SQL Server
Find out how you can easily move SQL Server logins from one server to another.

How Updates are Performed in SQL Server 6.5
If you are still using SQL Server 6.5, this article on how SQL Server internally handles updates might make for some interesting reading.

Start Preparing Today for the SQL Server 2000 Enterprise Certification Exam
This article provides tips on how to prepare to take the SQL Server 2000 Enterprise certification test.

Compare SQL Server Databases with sp_CompareDB
Use this powerful, free, stored procedure to compare database structures and data.

SQL Server 6.5 Useful Undocumented Stored Procedures
Author Alexander Chigrik helps us discover the secret world of undocumented SQL Server 6.5 stored procedures.

Useful Undocumented SQL Server Extended Stored Procedures
SQL Server offers many features that are not documented in the Books Online. Here are some of the undocumented extended stored procedures found in SQL Server 7.0 and 2000.

Undocumented SQL Server 7.0 System Tables
Learn the inner workings of these undocumented SQL Server 7.0 system tables.

Some Useful Undocumented SQL Server 6.5 DBCC Commands
If you are still supporting SQL Server 6.5, then this article on undocumented SQL Server 6.5 DBCC commands may prove very useful.