At the company I’m working at the moment they had a problem with the maintenance of a few monsters of databases(VLDB). They had about 2-4 TB of data and more than 90000 tables. Building a good maintenance solution for such databases is not an easy thing to do. For most of my clients I use…
Today I came across an issue I was having with my CMS. On my CMS server I have a database which has a few tables with some detail about my server state (Memory/Diskspace/…). I wrote a few stored procs to gather this data with openrowset in combination with the serverlist that I get from the…
There comes a time in every SQL Server dba’s life when he will have to consolidate a MS Access database to a SQL server, it is inevitable and destiny decided that it was my time today.An overly used Access database which had almost grown beyond its capacity was the one who decided my fate today,…
I’ve been working on a big migration project for several months now, and I would like to share my experiences with you to make your migration go as smooth as possible. One of the most common words you will hear while doing a migration is downtime.When you ask your business people if there can be…
Today we will be exploring a new functionality in SQL SERVER 2014 Enterprise edition. This new feature is called the Clustered Columnstore index. In SQL 2012 we already got a “preview” with the NON-clustered columnstore index. But the concept has drastically changed with the new Clustered columnstore index. In this post I will be talking…
It all started about a month ago, I got my first big assignment as a junior. The assignment was quite simple, design and implement a datawarehouse from scratch from a production system of an enterprise. Although the description of my assignment was quite simple, putting this assignment into practice proved to be a lot of…
In this video post I will show you how fast you can load data into your PDW with Dwloader & SSIS. This is a demo about my previous posts on DWloader, but also contains the demo for SSIS.
In previous posts I talked about DWLOADER and the distribution & replication theory, today I’m going to explain how you can combine this knowledge to achieve the ultimate PDW load speed with DWLoader. There are 3 things that determine your load speed File size Destination Table Design Structure of the file I will start…
Today I want to talk a bit more about Distribution and Replication and how it is used in a PDW. I’m going to start by answering two questions. What is Distribution? Because MS PDW is a MPP system (http://swyssql.wordpress.com/2013/12/13/basic-introduction-to-ms-pdw/), it uses different nodes to ensure fast querying! With the Distribution theory we take our large…
Today I will enlighten you about the incredible fast load times which you will get with a Microsoft Parallel Data Warehouse! The first thing you have to do when you work with a MSPDW is load your data into the PDW. This initial load will be the most “time consuming” so with this post I…
