• Home
  • About
  • Blog
  • Speaking
  • Contact

Author: SQL Stijn

Home Articles Posted by SQL Stijn
29 posts, 0 comments

Building a Modern Lakehouse Data Warehouse with Azure Synapse Analytics: Moving your Database to the lake

14 June 2022SQL StijnNo Commentsadls, adls gen 2, Azure Data Factory, data lake, lakehouse, parameterized pipeline, parquet, pipeline, Synapse, synapse integrate

Hi and welcome to the first post on the Building a Modern Lakehouse Data Warehouse series. As you can see in the video [here] we will be building a modern data warehouse using Azure Synapse Analytics with a Lake House strategy. Today we will be focusing on moving your data from your database to the…

Azure Synapse Dedicated SQL Pools: Workload Management

15 December 2021SQL StijnNo CommentsAzure Synapse, Azure Synapse Analytics, Configuration, Dedicated SQL Pools, SQL Pools, Synapse, Tuning, Workload, Workload Classifier, Workload Group, Workload Management

Today I would like to explain a bit more on Workload Management in Dedicated SQL Pools. Workload management is one of the tools you can use to ensure a smooth-running workload by leveraging different groups with classifiers. This is one of the features that is sometimes overlooked by customers and is one of the key…

 3,062 total views

Azure Synapse Analytics – Serverless SQL Pools: Data Elimination

9 March 2021SQL StijnNo CommentsAzure Synapse Analytics, Azure Synapse SQL Pools, Serverless SQL Pools

Welcome to the third post of the blog series I am writing on Azure Synapse Analytics. As you know Azure Synapse Analytics went GA December of 2020, and in the following blogposts I would like to walk you through the out-of-the-box capabilities you have to report easily on a vast dataset. Azure Synapse Analytics  series…

 4,902 total views

Importing DLL into SSIS Integration Runtime

3 February 2021SQL StijnNo CommentsAzure Data Factory, SSIS, SSIS Integration Runtime

I came across an issue this week when loading a DLL to the SSIS integration runtime. Loading MSI packages is quite straightforward however, loading a single DLL proved to be quite a challenge. According to the documentation https://docs.microsoft.com/en-us/azure/data-factory/how-to-configure-azure-ssis-ir-custom-setup you should provide a blob container in which you put a CMD task called main.cmd, in this…

Azure Synapse Analytics – Serverless SQL Pools: Partitioning

12 January 2021SQL StijnNo CommentsAzure Synapse Analytics, Partitioning, Power BI, Serverless SQL Pools

Welcome to the second post of the blog series I am writing on Azure Synapse Analytics. As you know Azure Synapse Analytics went GA December of 2020, and in the following blogposts I would like to walk you through the out-of-the-box capabilities you have to report easily on a vast dataset. Azure Synapse Analytics series…

 5,846 total views

Azure Synapse Analytics – Serverless SQL Pools

4 January 2021SQL StijnNo CommentsAzure Synapse Analytics, Power BI, Serverless SQL Pools

Welcome to the first of the blog series I am writing on Azure Synapse Analytics. As you know Azure Synapse Analytics went GA end of 2020, and in the following blogposts I would like to walk you through the out-of-the-box capabilities you have to report easily on a vast dataset. Azure Synapse Analytics Series: Azure…

 5,498 total views

Azure Synapse SQL Pools: Loading Staging Tables

16 December 2020SQL StijnNo CommentsAzure Data Factory, Azure SQL Datawarehouse, Azure Synapse Analytics, Azure Synapse SQL Pools, DISTRIBUTION, SQL, Staging Tables

Introduction Today I will be showing you the do’s and don’ts when loading data into staging tables in Azure Synapse SQL Pools. This process should go as fast as possible and I would like to use this post to highlight all the things you can do to decrease the time spent on loading to stage….

 7,169 total views

SQL Saturday #536 Gothenburg

16 August 2016SQL StijnNo Comments

I am happy to inform you that I will be speaking on SQL Saturday #536 in Gothenburg! On Saturday I will be explaining the do’s and dont’s on operational/real-time analytics. A whole hour of fun concerning columnstore indexes & how to combine OLTP & OLAP! All information concerning the SQL Saturday can be found on…

Natively Stored Procs & In memory Tables: NextGen loading!

19 July 2016SQL StijnNo Comments

Today I was creating a dummy database and wanted to fill this with a certain amount of data. Since I was going to use this database for demo purposes, I created them with foreign keys & Primary keys, and some indexes. (For my next blog on real-time analytics) But during the creation of this database…

Index maintenance on a VLDB: How to tame the beast!

5 July 2016SQL StijnNo CommentsCOLUMNSTATISTICS, Index Maintenance, INDEX REBUILD, SQL SERVER, VLDB

When working with large data volumes, doing normal day to day maintenance becomes a more difficult issue, in a previous post (https://swyssql.wordpress.com/2015/08/06/dbcc-how-to-check-the-uncheckable-dbcc-on-vldb/) I talked about how to handle DBCC CheckDB on a multi-terabyte database. Today I will tackle another issue I came across while dealing with multi-terabyte databases, Index Maintenance. Like most of you my…

Posts navigation

1 2 3 >

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}