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 ...

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 ...

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 ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Vivek Yadav, an engineering manager from ...

In this Microsoft SQL Server and JDBC tutorial, you'll learn how to connect to a Microsoft SQL Server in Java using JDBC. The steps are relatively straightforward: Each database is different, so ...

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 ...