Zen and the Art of SQL Server Maintenance

Partitioned Tables and Indexes

Here is a good article on SQL Server 2005 Partitioned Tables and Indexes. Read More...

Virtual PC 2007 Console System Tray Problem Options.xml doesn't exist

I have a common Virtual PC 2007 problem with dual monitors for my SQL VMs... when I most need to use my Virtual PC software, often the console goes insane when using a dual monitor, and though I can limp along by using Virtual PC from the system tray, Read More...

Terminal Services Configuration Settings for SQL Server Virtual Machine

Though this article is a bit outdated, it is helpful in setting up the Terminal Services settings for a SQL Server VM: http://www.microsoft.com/technet/prodtechnol/win2kts/maintain/optimize/secw2kts.mspx Read More...

SharePoint and SSRS (Reporting Services) IIS Port Conflict

I have been having trouble installing SharePoint on the same Server as SQL 2005 due to port 80 conflicts. If you search on "SharePoint" in SQL BOL (Books On Line) there are some good links to configure both on the same machine. Here is some initial reasearch Read More...

Determine SQL Server Version

Here is a nice way to determine SQL Server Version Information aside from @@version: SELECT SERVERPROPERTY ( 'productversion' ), SERVERPROPERTY ( 'productlevel' ), SERVERPROPERTY ( 'edition' ) Read More...

AdventureWorks Sample Databases for SQL 2005

Here are the AdventureWorks Samples for SQL 2005 and 2008 . Here is a good pointer to the AdventureWorks Sample Databases overview for SQL 2005. I also found that there is a SqlRun_Tools.msi file under the setup disk ..\Tools\Setup that willl help with Read More...

Determine Space Used By a SQL Server Database with sp_SpaceUsed

Here is a nice link about how to determine space consumed by a SQL Server database for each table by Nigel Rivett: and some other useful scripts : Read More...