Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works. Database ...

Database performance is rarely a single "fix it and forget it" task. SQL Server workloads shift over time. A sluggish ...

IDERA has released SQL Query Store Optimizer, a new tool in its portfolio of database monitoring tools to help database administrators (DBAs) manage and troubleshoot SQL Query Stores. The free tool ...

Azure SQL Query Store now captures read-only queries, expanding performance visibility beyond transactional workloads DBAs can analyze execution plans and runtime statistics for primary and read-only ...

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

SQL Server 2012 includes a lot of new and exciting features. One feature that has caught the imagination of many in the user community is the high-performance feature called Columnstore Indexes.

Microsoft fills in the gaps on its Big Data offering with previews of its Azure Data Lake and Language Services, which includes the brand-new U-SQL language for crunching the incoming explosion of ...

There has always been the debate as to whether to store binary large object (BLOB) data such as images, documents, audio and video inside the database or outside on the file system. The problem with ...