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

When building an IT environment for a large casino and hotel that weaves together traditional mainframe applications with forward-looking Web-based software, rolling the dice on critical database ...

I'm doing some web development contract work this summer, and my scenario/task is this. The environment is broken up into Production / Staging / Testing / Local Dev All environments are running MS SQL ...

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

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

One reoccurring SQL Server question that I see: Why is my TempDB database so large and what can I go to reduce the size of TempDB? The answer requires some basic understanding of the internals of how ...

Although the SQL Procedure Pass-Through Facility has always passed joins to the DBMS, it is now possible to pass joins to the DBMS without using Pass-Through. Beginning in Version 7, the LIBNAME ...

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