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...Read about the rich lifestyle.