As SQL Server 2016 approaches end of support in July 2026, a look back at its groundbreaking innovations reveals how it reshaped Microsoft's data platform and why it's time to move forward. As I've ...

Microsoft has made SQL Server 2025 generally available. The latest version of the database focuses on built-in AI functionality and developer improvements. In addition, the release offers improved ...

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work. Today, at Ignite, Microsoft announced the general availability of SQL ...

Community driven content discussing all aspects of software development from DevOps to design patterns. Fill in the blank for the Contoso cloud scenario. A(n) [?] helps organizations get the most ...

The increasing adoption of AI technologies is presenting new challenges for our customers’ data estate and applications. Most organizations expect to deploy AI workloads across a hybrid mix of cloud, ...

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

Data warehousing and analytic workloads often need to scan large amounts of data, and can greatly benefit from columnstore indexes. In contrast, rowstore (B+-tree) indexes are most effective for ...

A columnstore index is a technology for storing, retrieving and managing data by using a columnar data format, called a columnstore. More information you can find ...