• Home
  • About
  • Blog
  • Speaking
  • Contact

Category: Geen categorie

Home Archive by Category "Geen categorie"

DBCC: How to check the uncheckable (DBCC on VLDB)

6 August 2015SQL StijnNo Comments

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…

Openrowset across the CMS: The Proxy Way of Life

20 March 2015SQL StijnNo CommentsCMS, MICROSOFT, Openrowset, Proxy, SQL SERVER, TSQL

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…

The inevitable: Migrating ACCESS 2007 to SQL Server 2014

18 March 2015SQL StijnNo CommentsAccess database, SQL SERVER

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,…

How I migrate SQL SERVER to a new Server

9 December 2014SQL StijnNo Comments

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…

Clustered Columnstore Index TupleMove Magic

6 November 2014SQL StijnNo CommentsCCI, Clustered Columnstore Index, SQL 2014, SQL SERVER, Tuple Mover

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…

Creating my first Datawarehouse from scratch: The Analysis!

10 July 2014SQL StijnNo Comments

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…

Loading Data with Dwloader & SSIS for MS PDW

24 February 2014SQL StijnNo CommentsDWLOADER, MICROSOFT, PDW, SQL, SQL SERVER

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.

How to achieve Ultimate PDW load speed (DWLOADER PART 2)

24 January 2014SQL StijnNo CommentsDWLOADER, MICROSOFT, PDW, SQL

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…

PDW Distribution & Replication

21 January 2014SQL StijnNo CommentsDISTRIBUTION, DISTRIBUTION KEY, DWH, MICROSOFT, PDW, SQL SERVER, table design

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…

Load your data into your PDW (part 1 the DWLOADER)

7 January 2014SQL StijnNo CommentsDWLOADER, MICROSOFT, PDW, SQL

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…

Posts navigation

1 2 >

Recent Posts

  • Building a Modern Lakehouse Data Warehouse with Azure Synapse Analytics: Moving your Database to the lake
  • Azure Synapse Dedicated SQL Pools: Workload Management
  • Synapse Spark – Playing with Data Frames with Python
  • Synapse Spark – Reading CSV files from Azure Data Lake Storage Gen 2 with Synapse Spark using Python
  • Azure Synapse Analytics – Serverless SQL Pools: Data Elimination

Recent Comments

    Archives

    • June 2022
    • December 2021
    • May 2021
    • April 2021
    • March 2021
    • February 2021
    • January 2021
    • December 2020
    • August 2016
    • July 2016
    • March 2016
    • February 2016
    • December 2015
    • October 2015
    • August 2015
    • March 2015
    • December 2014
    • November 2014
    • July 2014
    • February 2014
    • January 2014
    • December 2013

    Categories

    • Azure Synapse Analytics
    • Building a Modern Lakehouse Data Warehouse
    • Geen categorie
    • MS PDW
    • SQL 2016
    • SQL Maintenance
    • SQL Server Migration
    • SQL Server Misconfiguration Chronicles
    • SQL2014
    • Troubleshooting

    Contact Stijn now


    © SQL Stijn 2017 - Privacy Policy - Cookie Policy
    Manage Cookie Consent
    To provide the best experiences, we use technologies like cookies to store and/or access device information.
    Functional Always active
    The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
    Preferences
    The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
    Statistics
    The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
    Marketing
    The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
    Manage options Manage services Manage vendors Read more about these purposes
    View preferences
    {title} {title} {title}