Data Warehousing

Introduction to Fast Track Data Warehouse Architectures

  • Article

This paper provides an overview and guide to SQL Server® Fast Track Data Warehouse, a new set of reference architectures created for scale-up (SMP) SQL Server based data warehouse solutions. It includes a summary of the resources available in the reference configuration, the distinguishing features of the approach, and the steps necessary to take full advantage of the new architectures.


4,002 reads

Data Warehouse Capacity Planning as Capacity Enforcement

  • Article

Capacity planning is a problem for a data warehouse because it sets contrasting functional requirements against each other. On one hand, data warehouse customers consume data warehouse capacity as they query the data in the data warehouse business intelligence (BI) reporting. Meanwhile, applications consume data warehouse capacity as they load data into a data warehouse through the extract, transform and load (ETL) process.


3,269 reads


Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes – Another Method


Yesterday in this post I described a method to correct permissions when upgrading a...

Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers


Welcome back to my Power Platform Quick Tips series! In this second episode we...

Simple-Talk Article…Understanding Azure Storage Options


Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...

Read the latest Blogs


Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Using subquery count to subtract from main query count

By DaveBriCam

I'm trying to find the correct way of using a subquery count to subtract...

AG vs Failover Clustering Instance

By RonMexico

Suppose an environment has a two node, active-passive cluster and users connect using the...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers