In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine's system databases. Tim Chapman discusses these system databases. A fundamental skill for DBAs is to have ...

Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...

In SQL Server 2005, Microsoft introduced the Upgrade Advisor. This was a great idea to be able to analyze your current SQL Server in a safe environment and start the planning process of an important ...

Early discussions on SQL Server 2008 seemed to suggest that it would really only be a point release, quite unlike what occurred with SQL Server 2005. Anyone looking at the new and upgraded features in ...

Yesterday, Microsoft released a patch for a flaw in SQL Server 2005 SP2 that affected both existing and new maintenance plans and Integration Services packages. Although not every SQL Server 2005 ...

CPU issues have long been the bane of database and system administrators. I have worked on enterprise databases since the mid-1980s and seen three significant eras for CPU architecture and ...

A conference being held in Denver this week by the Professional Association for SQL Server user group will provide a forum for the biggest public unveiling to date of Microsoft Corp.’s SQL Server 2008 ...