Data Warehouse

External Article

Modern Data Warehouse Design Pattern – Part I

  • Article

The modern data warehouse design helps in building a hub for all types of data to initiate integrated and transformative solutions. To achieve these goals and to support modern designs, Microsoft has introduced a set of fully managed, cloud-based services that not only support modern data warehouse design patterns but also provide the advantages of inbuilt scalability, high availability, good performance, and flexibility.

2018-09-04

3,797 reads

External Article

Using the DbFit Framework for Data Warehouse Regression Testing

  • Article

It is ironic that the users of database application need to rely on the very technologists that created the system to then devise and run their acceptance tests. Surely someone has devised a test system for databases that is simple enough for ordinary tech-savvy people to use and for them to create the tests? Yes they have. Fitnesse DbFit is a mature product that can, and does, test SQL Server databases, and Nat Sundar explains how to set it up and do it.

2017-05-18

3,142 reads

Blogs

Daily Coping 21 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using dbachecks for CIS Security Checks

By

Well back at the end of 2019 I finished writing most of the checks...

How to tell if Change Data Capture (CDC) is working as expected

By

I’m not sure how many of you use Change Data Capture (CDC) on your...

Read the latest Blogs

Forums

SSRS reports

By AryaanHaigh

Hi, I need to delete multiple SSRS reports from report portal. Is there any...

Get over 500,000 records into a table

By rmahon

Hello Everyone, hope everyone is well and staying safe! I have an issue that...

Some questions about AWS/Any cloud service

By sirikonta

So basically, I want to host a Minecraft server at very little or no...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers