The task is to be able to copy a databases from production (and the source will always be production) down to staging or testing. Finally, all of these tasks need to be scriptable as SQL statements.

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

Idera, a provider of Microsoft SQL Server management and administration tools, announced SQL virtual database 1.3, the latest release for this solution that enables backup files to look and act just ...

In addition, he announced the availability of the Best Practices Analyzer (BPA) for SQL Server 2000, a tool designed to help database administrators (DBAs) develop better, more maintainable SQL Server ...

When Microsoft launches its 64-bit version of SQL Server at the end of April, the database will cost the same as the 32-bit version, perform better, and be part of the company's bid to oust Oracle and ...

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

Microsoft Corp. today is introducing updates across its database portfolio as part of general availability announcements for Azure DocumentDB and SQL Server 2025.