Pairing your on-prem SQL Server with a cloud-based instance for high availability has its challenges, but they can be overcome. Here’s how. The geographic distribution of cloud data centers makes it ...

In-Depth Build Your Own 'Skunk Works' Business Intelligence Project with SQL Using SQL Server, you can build a BI platform without getting your organization's top brass involved. By Andrew Peterson ...

Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements. The statements use a SQL string varchar data type, then you execute the ...

Build 2022 marks the long-awaited public preview of Microsoft's next-generation database engine. Here are the top seven new SQL Server 2022 features to look out for. When Microsoft introduced SQL ...

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

If you're in the process of planning an enterprise-wide data warehouse, proper planning is a prerequisite. But what if you're just getting started and you've got a tight, almost non-existent budget?

[Click on image for larger view.] SQL Server Reporting Services (SSRS) has evolved since it first came out as an add-on to SQL Server 2000. Detractors will say it's not as good as (fill in some ...