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

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

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

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

SQLite has an incredibly small footprint. The database itself, its DLLs and the complimentary diff and analyzer tools are less than 15 MB in size. It's perfect for small mobile devices, advanced ...

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

As covered by my ZDNet colleague Mary Jo Foley, Microsoft has announced that it is bringing its core, flagship relational database, SQL Server, to the Linux operating system. I also work for Datameer, ...

Follow this step-by-step guide to install PostgreSQL, load data, connect to a database, and execute SQL queries including table joins PostgreSQL is an open-source, object-relational (also called ...

Virtual Server 2005 R2 is an enterprise level application designed by Microsoft to support the simultaneous running of multiple virtual machines on a high performance, scalable, secure and reliable ...

Data is a valuable commodity that sits at the heart of our IT systems, whether on-premise or in the public cloud. The need to retain our data on persistent storage media, however, has been around ...