Several consolidation options are available for managers and DBAs who are looking to cut costs. Learn about some of these strategies and when to use them along with details on the benefits of SQL Server consolidation with Windows 2008.
Continue Reading

This short guide features resources for those looking to learn more about SQL Server consolidation, with details on when (and when not) to consolidate, strategies, best practices and more.
Continue Reading

In a database management system (DBMS), a tablespace is
a logical group of data files in a database. A typical database contains at least one tablespace, and usually two or more. In a database, a tablespace plays a role similar to that of a folder...
Continue Reading

Determining your goals is the first step to selecting a disaster recovery technology. Here's how to weigh the pros and cons of the myriad options depending on your business requirements.
Continue Reading

If your SQL Server tempdb database is full, the data files could be the cause. Find out how to use the SQL Server process ID number, along with T-SQL queries, to find the source of any unexpected growth in data files.
Continue Reading

The BULK INSERT statement enables the bulk-loading of data files into SQL Server databases. Get instructions on how to use it, along with details on the FIELDTERMINATOR and CHECK_CONSTRAINTS options.
Continue Reading

In this chapter excerpt from "SQL Server 2008 Integration Services Unleashed", learn what's included with SSIS and how developers and database administrators can use these utilities to improve performance and accessibility.
Continue Reading