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

A conference being held in Denver this week by the Professional Association for SQL Server user group will provide a forum for the biggest public unveiling to date of Microsoft Corp.’s SQL Server 2008 ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Knowing exactly what in-memory OLTP tables are used for will help you make the most of one of SQL Server's newest features. While in-memory online transaction processing (OLTP) tables may sound like a ...

Determine a Windows Server build date with these one-liners Your email has been sent With Windows Server systems, it can be difficult to determine when a system was built. Here's how you can determine ...

In the age of big data, efficiently managing relational databases, particularly SQL Server, may be the single most important issue facing a growing number of CIOs and data center managers. Throughout ...

Microsoft will end security support for SQL Server 2005 in April 2016, and higher education IT leaders must prepare to upgrade. Phil Goldstein is a former web editor of the CDW family of tech ...