SQL Server Power Search - Get More Relevant Results

SQL Server Articles and Tips

Welcome to SQL Server Pro. I am a DBA, consultant and database developer with years of experience, and this site enables me to pass some of my experience and knowledge on to you.

 

As I come across interesting topics or problems in my everyday work, or just think of something interesting to write about, it is added to these pages. The spread of topics is fairly random, but I have grouped all articles by category so they are easy to find.

The categories are listed in the navigation bar on the right. There is also a search page tuned and optimized for SQL searches, enabling you to search this site and others for the information you are looking for.

I hope you enjoy browsing this site, and gain something from it. If you have any suggestions for content, please contact me.

Here are some of my recent articles:

sp_help_revlogin Alternative

A PowerShell alternative to sp_help_revlogin...

Data Warehouse Performance Part 1 - I/O

The first of a series of articles on data warehouse performance. This article focuses on I/O...

SQL Server 2008 Deprecated Features

What are they? And how to tell if you are still using them...

EVA Partition Alignment

Partition alignment is a well documented best practice, but does it have any benefit on an HP EVA?

DBCC CHECKDB - Use and Abuse

How to use it and what to do when it finds corruption...

SQL WHERE Clause Optimization

SQL WHERE clause optimization is important to get maximum performance from a query. If an index exists on a column you obviously want the query to use it...

Autoshrink - Don't Do It!

The autoshrink database option is OK in a development environment, but avoid it like the plague on your production servers...

 
Not found what you're looking for?
Use this search box. It is tuned for SQL Server searches. Try it and see!






All my articles can be found under one of the following categories:

Recent Articles

My most recent articles are listed here. There is also an RSS feed for these articles...

Database Administration

Effective database administration is often made out to be a dark art, yet it's really more about discipline and best practice...

Performance Tips

Performance tips and articles to assist you with troubleshooting performance problems...

Scripts

Why reinvent the wheel? Scripts that I have written and use regularly are detailed here...

Error Reference

When you get an error, look here for a troubleshooting guide...

Learn SQL

Learn SQL from a collection of free tutorials covering the most useful SQL commands...

Reviews

Reviews of books, software and tools that help to make a DBA's life a little bit easier...

Miscellany

Articles and posts that don't naturally fall under any of the categories above...

SQL Server FAQ

This is the newest part of the site and allows visitors to ask and answer questions related to SQL Server...