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.

2009-06-26

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.

2008-09-19

3,269 reads

Blogs

SSIS Logging – Linking sysssislog with custom log

By

I was working on an ETL solution, which was expected to run for hours....

Azure Arc

By

Azure arc is another great stuff coming with Microsoft Azure, as we were expecting...

Built-in Duotone Image Filter, Editor Navigation via Persistent List View, and Other Block Editor Improvements

By

The next batch of exciting updates to the block editor is live on WordPress.com....

Read the latest Blogs

Forums

AOAG with FCI Step by Step

By Super Cat

It's been a very long while since I have set this all up. I...

how to get GPNSignature that first part on it start by portion key ?

By ahmed_elbarbary.2010

I work on sql server 2012 I face issue i can't get GPNSignature that...

Multiple .ndf file in single disk

By IT researcher

I have moved some of my database to SQL server 2017 (RTM) - Standard...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers