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

Unlike DB2, Oracle9i, and Sybase ASE, SQL Server relies on Windows for clustering. The Enterprise Manager has a graphical interface and plenty of wizards for common tasks; it also lets you manage many ...

For much of its existence Boise, Idaho-based ProClarity has built its analytic technology stack almost entirely on top of Microsoft’s SQL Server 2000 database. That changed late last month when ...

PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...

SQL Server Reporting Services includes the SQL Server Report Designer, whose wizards give you a streamlined solution for setting up, designing, polishing, and publishing reports. Authoring a report ...

SQL has dominated data querying for decades. Newer query languages offer more elegance, simplicity, and flexibility for modern use cases. For the last three decades, databases and Structured Query ...