My First Blog Post SQLSatHolland 790

My First Blog Post SQLSatHolland 790

« All Events

This event has passed.
PASS Data Community SUMMIT

November 8, 2021 @ 8:00 am - November 12, 2021 @ 5:00 pm CET Free

« Dataweekender #4.2
Data Saturday #16 Slovenia (Virtual) »

Related

Add to calendar

Google Calendar

iCalendar

Outlook 365

Outlook Live

Details

Start:

November 8, 2021 @ 8:00 am
CET

End:

November 12, 2021 @ 5:00 pm
CET

Cost:
Free

Event Category: Redgate

Website:
https://passdatacommunitysummit.com/

Venue

Virtual

« Dataweekender #4.2
Data Saturday #16 Slovenia (Virtual) »

Read More
DataMinds 2018

DataMinds 2018

PASS Data Community SUMMIT

by ErwinAug 24, 2021

An event in the Footbal Arena from Gent!

Two days after SQLSatholland it was time for DataMinds Connects, which was held in beautiful Belgian Ghent. The location for this event was in the stadium of KAA Gent.
Because the organization of SQLSatHolland and DataMinds worked well together, top speakers where present again.

Great event for Speakers
Nice detail, the speaker room was in the Presidential SkyBox with a very nice view in the Stadium.
And every speaker had his own football shirt.During this event I talked about Migrating your On Premise database to Azure SQL Data Warehouse
 
 
Migrate to Azure SQL DataWareHouse
Have you ever tried to migrate your DataWareHouse (DataVault) solution to a Azure SQL DataWareHouse? Azure SQL DW is a MPP system and requires a lot of changes to your current solution.What are the best practices for Migrate your solution? Why should you migrate to a Azure SQL DW? I did, and would like to share my experience. During the session I spoke about Distribution keys, Replicated Tables, identity Colums, CTAS, scaling, pausing, monitoring and much more.
Great Feedback
The session was well attended and the feedback was very good afterwards. I’m enjoying every time again to share my knowledge with the Community. Speaking at events always gives me a lot of energy.
Organisation
Compliments to the organizers Benni, Stijn and Frederik

Feel free to leave a comment

0 Comments

Submit a Comment Cancel replyYour email address will not be published. Required fields are marked *Comment * Name *
Email *
Website
Please enter an answer in digits:4 × two = Notify me of new posts by email.Submit Comment

Δ
This site uses Akismet to reduce spam. Learn how your comment data is processed.

Data Saturday Stockholm

Data Saturday Stockholm Bra så alla tillbaka personligen This means great so everyone back in person. Last weekend I had the honor to speak at Data Saturday in Stockholm. About one of my favourite topics Azure Synapse Analytics. It was nice to see everyone in person...

My first Virtual session in 2022 for Dataminds

DataMindsThis Tuesday I've joined the DataMinds user Group to talk about Azure Purview.  Azure Purview It was the first session of the year for both me and DataMinds. Some great questions during the session, thank you for that. You can find my slides below on...

Speaking at SQLBits in London (postponed to September 2020)

SQLBits 2020SQLBits is the largest Microsoft Data Platform conference in Europe taking place between 29nd September and 3rd October2020 at the Excel London.Proud to be speaking I am very proud and happy that one of my sessions was selected for SQLBits. It's not the...

Datagrillen: Data, Bratwurst und Beer

Data, Bratwurst and BeerAn event that started 5 years ago as a small event, that has grown into an event with 200 participants, 50+ sessions, 5 tracks, 2 days and a BBQ in a small place in Germany, called Lingen. William Durkin and Ben Weissman are the main...

Techoroma NL 2019

Azure Key Vault, Azure Dev Ops and Azure Data Factory how do these Azure Services work perfectly together! Some impressions during Techorama NL 2019.    Feel free to leave a comment

My Virtual Session Cloud Lunch and Learn Marathon

Cloud Lunch and Learn Marathon 2021This Thursday May 13th 2021 I've been speaking during Cloud Lunch and Learn Marathon 2021. It was the first Cloud Lunch and Learn Marathon conference, more then 1200 registered attendees, 24hours Live and pre recorded sessions....

SQL BITS 2022 Session recordings

Recordings SQL Bits 2022 All sessions of SQLBits 2022 have been made available to everyone and can now be viewed via their Youtube channel. Microsoft asked me to present me this session during SQL Bits in the Cloud Scale Analytics solution area. Session Title: Lake...

DataSaturday NL 2019

Recording of my session on DataSaturdayNL 2019 Can we store our Connectionstrings or BlobStorageKeys or other Secretvalues somewhere else then in Azure Data Factory(ADF)? Yes you can! You can store these valuable secrets in Azure Key Vault(AKV). But how can we achieve...

SQL SERVER KONFERENZ 2020

SQL SERVER KONFERENZ 2020Date: 4-5 March Location: KongressCenter Darmstadt   Speaking Dinner The speaker dinner on Tuesday evening was held in Restaurant Sitte. And yes what do you eat when you are in Germany a delicious Schnitzel with baked potatoes. It was a...

My Virtual session DataWeekender 4.2

DataWeekender 4.2This Saturday I've joined the Van and Spoke at DataWeekenderAzure Purview I presented a session on Azure Purview Microsoft's answer to Data Governance and Data Lineage You can find my slides below on Slideshare: Data weekender4.2 azure purview erwin...

Related

Read More
Service Health Alerts in Azure

Service Health Alerts in Azure

PASS Data Community SUMMIT

by ErwinAug 24, 2021

Maintenance and Service Healths in Azure

I get often questions, is there no maintenance in Azure. Like every data center, the Azure data center also needs maintenance. You can even be notified when a specific service, in a specific data center, has scheduled maintenance so that you will not be surprised.
 

Do you want know how to setup up these Service Health Alerts? Please click on the link below.
Service Healths in Azure

Feel free to leave a comment

0 Comments

Submit a Comment Cancel replyYour email address will not be published. Required fields are marked *Comment * Name *
Email *
Website
Please enter an answer in digits:3 × three = Notify me of new posts by email.Submit Comment

Δ
This site uses Akismet to reduce spam. Learn how your comment data is processed.

Rerun Pipeline activities in Azure Data Factory

Rerun Pipeline activities in ADF! As of today you can rerun or partially, yes you’re reading it correct partially, rerun you Azure Data Factory pipeline.Where you previously had to run the entire Pipeline again, you can now run a part of the Pipeline. This can save a...

Calculate the Last Day of the Month using SQL

Calculate the Last DayToday I needed to calculate the last day of the previous month for a Customer.Ever heard from the function EOMONTH? Searching on the web I came across a function I never heard from before EOMONTH, this function can be used as of SQL Server 2012....

Azure Purview Public Preview Starts billing

Billing for Azure Purview(Public Preview)As of January 20th 2021 0:00 UTC Azure Purview will starts billing.Preview From January 20 ,2021 Azure Purview will start billing. During the Public Preview, you will only be billed if you exceed the 4 capacity units for Azure...

Updated competency exams and certifications Data Platform and Data Analytics for 2020

Retiring and new exams and certifications as of June 30 2020 A lot of Exams and certifications for Data Platform and Data Analytics are retiring on June 30 2020. All retired Exams and certifications will remain eligible for competency attainment and renewal until June...

Parameterize Linked Services in ADF

Parameterize Linked Services For my Azure Data Factory solution I wanted to Parameterize properties in my Linked Services. Not all properties are Parameterized by default through the UI. But there's another way to achieve this.    Linked Service Open your existing...

Azure Synapse Analytics

Azure Synapse Analytics  Insights for all Azure Synapse provides a breathtaking view of your data across data warehouses and big data analytics systems. Bringing these two worlds together into a single service is challenging as it requires unifying similar...

Data Factory Pricing

Data Factory pricingAre you also having problems to understand the Pricing Model for Azure Data Factory? After some research on the internet I came across an article which I wanted to share with you. ADFV2 Pricing ExamplesFeel free to leave a comment

Azure Synapse Analytics Code Repository has arrived

Azure Synapse Analytics Code repository‎I just opened my Azure Synapse Analytics Workspace and got a great surprise, the option Git Configuration is available as of today‎.    After a long wait, today the Git Configuration option became available in Azure Synapse...

Calculate Workingdays including Holidays with T-SQL

Calculate Workingdays between 2 Date columnsRecently I have been getting some questions from my customers, can I calculate the number of workdays between 2 dates? Of course my answer was, yes you can. But I do want certain closing dates and holidays of our company not...

Control my Nest Thermostat on my Domoticz Server running on a Synology DiskStation

Control your Nest Thermostat  in DomoticzNormally I always write Azure related, but today I'm writing about something different, on how I can control my Nest Thermostat on my Domoticz Server (Home automation). A while ago I have upgraded my  Nest Thermostat to login...

Related

Read More

Service Healths in Azure

PASS Data Community SUMMIT

PASS Data Community SUMMIT

by ErwinAug 24, 2021

Creating Service Health Alerts in Azure

Azure Portal
In the Azure Portal go to Monitor – Service Health – Health alerts

If you have created alerts before you will see them over here. Assuming you haven’t created an Alert before, we will start to create an Alert.

1 Define Alert Condition:

Select the correction Subscription
Select the Azure Services where you want to get an Alert for
Select the Azure Region
And for this Alert Condition we will select only the Service issue as the Event Type.

2 Define Alert Details

Define Alert Rule name CustomerName – Service Issue Alert
Define Description
Select the Resource Group where you want to save this Alert. I’ve created a seperate Resource Group where I store everything which is related to Monitoring of my Azure Environment.

3 Define Action Group
The last step of the alert Creation is to setup how we want to notify people. I the example below I will care take about the  Action Group Type Email/SMS/Push/Voice

 
 
 
 
 
 

 
 
Fill in your email address
 
 
 
 
 
Fill in your email address and make your sure you install the Micrsosoft Azure app on your phone to receive push messages.
 
 
 
 

 
 
 
 
You also have the possibility to define multiple Action Groups.
Next time I will write how to change your Action Group to add or remove Members.
Thanks so much for reading through this article today, and I hope you all take some time to try it out. It’s will make your life easier.

Latest Posts
Connecting Event Hubs in Microsoft Fabric
Introduction to Real-Time Analytics in Microsoft Fabric
Custom comments in Azure Synapse Analytics
Updated Microsoft Purview Pricing and Applications
SQLBits session: Microsoft Purview Data Policy App

Feel free to leave a comment

0 Comments

Submit a Comment Cancel replyYour email address will not be published. Required fields are marked *Comment * Name *
Email *
Website
Please enter an answer in digits:20 − fourteen = Notify me of new posts by email.Submit Comment

Δ
This site uses Akismet to reduce spam. Learn how your comment data is processed.

How to create a Azure Synapse Analytics Workspace

Creating your Azure Synapse Analytics Workspace In the article below I would like to take you through,  how you can configure an Azure Synapse Workspace and not the already existing Azure Synapse Analytics SQL Pool(formerly Azure SQL DW): In de Azure Portal search for...

Scale your SQL Pool dynamically in Azure Synapse

Scale your Dedicated SQL Pool in Azure Synapse Analytics In my previous article, I explained how you can Pause and Resume your Dedicated SQL Pool with a Pipeline in Azure Synapse Analytics. In this article I will explain how to scale up and down a SQL Pool via a...

Azure Synapse Pause and Resume SQL Pool

Pause or Resume your Dedicated SQL Pool in Azure Synapse Analytics Azure Synapse Analytics went GA in beginning of December 2020, with Azure Synapse we can now also create a Dedicated SQL Pool(formerly Azure SQL DW). Please read this document to learn what a Dedicated...

Blog Serie: Provision users and groups from AAD to Azure Databricks

This blog post series contains topics on how to Provision users and groups from Azure Active Directory to Azure Databricks using the Enterprise Application(SCIM). This is a summary of the all the blogs I posted the last couple of days. I am very happy with all the feedback and tips I have received about this blog series.

Related

Scale SQL Database dynamically with Metadata

Scale SQL Database Dynamically with Metadata Use this template to scale up and down an Azure SQL Database in Azure Synapse Analytics or in Azure Data Factory. This article describes a solution template how you can Scale up or down a SQL Database within Azure Synapse...

Migrate Azure Storage to Azure Data Lake Gen2

Migrate Azure Storage to Storage Account with Azure Data Lake Gen2 capabilities Does it sometimes happen that you come across a Storage Account where the Hierarchical namespace is not enabled or that you still have a Storage Account V1? In the tutorial below I...

Data Sharing Lineage in Microsoft Purview

In my previous blog, I wrote how you can share data within your organization or across organizations. Now it's time to have a look how the lineage will look like. In this article I will explain the Microsoft Purview Data Sharing Lineage and not the Lineage for Azure...

Provision users and groups from AAD to Azure Databricks (part 5)

In the previous blog, you assigned Users and Groups to an Azure Databricks Workspace. In this blog, you will learn how to assign Service Principals to an Azure Databricks Workspace and define the correct entitlements.

Related

Provision users and groups from AAD to Azure Databricks (part 2)

Assign and Provision users and groups in the Enterprise Application In the previous blog you learned how to configure the Enterprise Application. In this blog, you will learn how to assign and Provision Users and Groups. Once the Users and groups are assigned to the...

Create Virtual Machines with Azure DevTest Lab

A while ago I had to give a training. Normally I would roll out a number of virtual machines in Azure. Until someone brought my attention to an Azure Service, Azure DevTest Labs. With this Azure service you can easily create a basic image and use this image to roll...

Related

Read More
LEAP 2018

LEAP 2018

PASS Data Community SUMMIT

by ErwinAug 24, 2021

Lead Enterprise Architect Program

From the 4th of December until the 6th of December I’ve joined the LEAP (Lead Enterprise Architect Program) 2018 Data/AI from Microsoft NL.
Three  days on the Microsoft Campus in Redmond joining business and technical sessions from a diversity of speakers and Program Managers.
 

Amsterdam Seattle
After a long flight of 11 hours from Amsterdam to Seattle, we arrived around 13:00 on Sunday December 2nd. Since we have also gone back 9 hours, it is important to stay awake for as long as possible. So that we have less trouble with our Jetlag the following days(hopefully).
Jetlag
Fortunately we have one day of rest before Leap starts on Tuesday. The Monday we spend in Seattle. Starting the day with a nice breakfast at Pike Place.
After breakfast we went for a long walk trough downtown Seattle. In the afternoon we did a Locks tour by boat. A wonderful activity to get through your jetlag with a great view from Seattle. In the evening we end up in the Pike Brewery where we have met more Leap participants.
Finally it is Tuesday, Start of LEAP
After I have seen almost every hour on the clock during the night, I woke up early. The bus was leaving the hotel at 7:15 to the Microsoft Campus in Redmond where we were expected in the EBC (Executive Briefing Center) for breakfast.
Business – Technical
In the morning we have tracks with the whole group, in the afternoon we split up in Business and Technical tracks. The first day is dedicated to various sessions about Azure, DevOps and Digital Transformation for Partners. In the afternoon I have followed the technical sessions where we talked about DevOps, DataBricks and DataLake. Super cool to see how open all Program Managers are. All sessions are dedicated to questions that we have and which were all answered well. We ended the day with a group dinner.
Day 2
Day 2 is kicked off by Rohan Kunar, CVP Azure Data, followed by a session on AI and Serverless Architecture. In the afternoon we talked this time about IOT and Machine Learning. We closed the evening with dinner in a Brazilian Restaurant, the atmosphere was great and some participants will remember this evening for the time being.
What happened in Seattle stays in Seattle!
3 Wonderful days are coming to an end
The last day we started with a White Board session of the Distinguished Architect of Microsoft, a beautiful session in which many topics about the use and the future of data.We closed the morning with a Technical session about the Power Platform.
Seattle by Night
After a few hours of rest, yes the jet lag still works, we finalized the day in Seattle with some other participants with a drink at the Taphouse Grill, if you are in Seattle, a must to visit, they have more than 150 beers on tap. For dinner we end up in the CheeseCake Factory.
I had 3 top days, thanks for the organization and the super nice program. Personally, I got a lot of energy out of these days and good to see that we are on the right track as Axians.
See you next time.

Feel free to leave a comment

0 Comments

Submit a Comment Cancel replyYour email address will not be published. Required fields are marked *Comment * Name *
Email *
Website
Please enter an answer in digits:four × 5 = Notify me of new posts by email.Submit Comment

Δ
This site uses Akismet to reduce spam. Learn how your comment data is processed.

Azure Purview MSIgnite Spring 2021 Announcements

Azure Purview Ignite 2021 AnnoucementPricing This week the Azure Purview announced that they will extend the Azure Purview offer to provision 4 Capacity Units of the Data Map for free till May 31, 2021! Charging will start on June 1, 2021. Great news for customer who...

Azure Purview Public Preview Starts billing

Billing for Azure Purview(Public Preview)As of January 20th 2021 0:00 UTC Azure Purview will starts billing.Preview From January 20 ,2021 Azure Purview will start billing. During the Public Preview, you will only be billed if you exceed the 4 capacity units for Azure...

Goodbye 2020 Hello 2021

Goodbye 2020 Started to work for InSpark Last year was certainly an eventful year. Started with a new job at InSpark and after 10 weeks we all know what happened, the first intelligent lockdown. The Netherlands was partially locked, but our office was immediately...

My Sessions at DataSaturdayNL 2019

DataSaturday NL 2019Date: 5 th October Location: Pathé Leidsche Rijn Data Saturday Holland is the new name for SQL Saturday Holland. A new start a new location and wow what a top location, Pathé Leidsche Rijn. A cinema with 7 screens and ranging from 180 to 668 seats....

Proud to be an ADF Hackathon winner!

Azure Data Factory HackathonAround the clock During the event 'Around the clock Azure SQL and Azure Data Factory' event on Feb 3, 2021, they kicked-off the Azure Data Factory (ADF) Hackathon. Recording of this event can be found here.Winner I submitted a ADF Pipeline...

10 Days of Azure Synapse Analytics

10 Days of Azure Synapse AnalyticsFor the next 10 days, every day a different topic is explained about Azure Synapse Analytics. The shortest and easiest way to see how Azure Synapse Analytics can help you, to make decisions within your data landscape.Day 1...

A new year with a new job

Changing jobsAfter almost 11 years and 4 months I have decided to leave Axians and to start a new adventure in the new year. On January 2, 2020 I will start my day as Lead Data and AI at InsparkThe past years have flown by. I started at Eniac BI, which was...

How to use concurrency in Azure Synapse pipelines?

How to prevent concurrent pipeline execution?Concurrency This week I had a discussion with a colleague about how we can now make sure that a Pipeline does not start when it's already started. He then indicated, have you ever thought of the concurrency option?  I've...

LEAP 2018

Lead Enterprise Architect ProgramFrom the 4th of December until the 6th of December I've joined the LEAP (Lead Enterprise Architect Program) 2018 Data/AI from Microsoft NL. Three  days on the Microsoft Campus in Redmond joining business and technical sessions from a...

Restore a accidentally deleted Azure SQL Database

Help I deleted my Logical Server​OOPS Have you ever experienced that you accidentally deleted your Logical Server in Azure?  Because, for example, you made your Pipeline wrong. Surely. And of course you didn't have a backup in your storage either.Well I must confess...

Related

Read More

Upcoming Events

Featured Featured

SQLKonferenz

View Calendar

Categories