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:
Physical CPU Count
How to get the physical CPU count for a server using PowerShell...PowerShell Backup Check
A PowerShell script to enumerate multiple servers and report databases with overdue backups...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!