Step-By-Step: Learn the basics of using DTS in Microsoft SQL Server Your email has been sent Learn how Data Transformation Services (DTS) can help you import, export, and/or transform data from ...

So, my client and their subcontractor(s) have found themselves in a bit of a pickle, as no one bothered to spec or price a DB for a software implementation, so now I've been handed the bag. The client ...

Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types. Datetimes and intervals are ...

Microsoft announced today that SQL Server 2008 R2 is released to manufacturing just 20 months after SQL Server 2008, the platform on which it is built. SQL Server 2008 R2 (codenamed Kilimanjaro) ...

A free tool from Microsoft can make backing up data in Windows Server 2008 R2 efficient and almost hassle-free. Here's how to use it effectively. Back in the day, Microsoft's free backup tool was the ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

Whether you call it Windows Server 2008 R2 or Windows Server 7, there's no doubt that this is a major Server product release for Microsoft. I'm not sure why Microsoft decided to deviate from the ...

Back in the day, Microsoft's free backup tool was the now venerable NTBackup. However, that utility has gone to the great recycle bin in the sky. Windows Server 2008 offers a new set of backup tools, ...