My First Blog Post SQLSatHolland 790

My First Blog Post SQLSatHolland 790

« All Events

This event has passed.
DataMinds Connect 2019

October 7, 2019 - October 8, 2019 €325 – €375

« Data Saturday
Microsoft Ignite »

Related

Add to calendar

Google Calendar

iCalendar

Outlook 365

Outlook Live

Details

Start:

October 7, 2019

End:

October 8, 2019

Cost:
€325 – €375

Website:
http://dataminds.be/connect

Venue

Congres- en Erfgoedcentrum Lamot

Van Beethovenstraat 8-10

Mechelen,

B – 2800

Belgium

+ Google Map

View Venue Website

Organizer

DataMinds Connect

View Organizer Website

« Data Saturday
Microsoft Ignite »

Read More
DataMinds 2018

DataMinds 2018

DataMinds Connect 2019

by ErwinMar 2, 2019

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:8 + 18 = Notify me of new posts by email.Submit Comment

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

Watch the MS Ignite sessions on-demand

MS Ignite SessionsMS Ignite 2020 was this year a virtual event. Most of the sessions were live in the evenings and the other sessions were available at different times in different time zones. Compliments to the MS Ignite team for organizing such a great event Most of...

DataGrillen 2022

DataGrillen 2022 Microsoft Purview When we say: Data, bratwurst and beer, we are of course talking about DataGrillen. After more than 2 years of absence, it was time again in recent days, with speakers from all over the world with almost 50 sessions, good weather and...

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...

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...

Scottisch Summit 2021(Video)

Recording of my session during Scottisch Summit 2021 Is there a way that we can build our Azure DataFactory all with parameters based on MetaData?Feel free to leave a comment

October=Speaking Month

DataSaturday Holland and DataMinds in BelgiumLike last year I have been selected again this year for both events to speak. Cool to be able to speak at 3 different events within 7 days, but also to see many known people and to met new people.Data Saturday Data Saturday...

The new and refreshing Azure Data Factory home page

The Data Factory home page has been redesigned for a modern and more accessible (WCAG 2.1) experience. The new design is more fluid with better contrast and reflow capabilities.  Thank you to the complete product team for this great experience The new and refreshing...

Speaking at Techorama NL

Techorama = Deep Knowledge IT ConferenceTechorama is a yearly international technology conference which takes place at Pathé Ede, Netherlands from September 30th until October 2nd. This will be the second year the event will be in held in the Netherlands. Last year...

SQLBits session: Microsoft Purview Data Policy App

SQLBits 2023 Thanks everyone for visiting my session during SQLBits. It's great to see such a full room and that so many people have started using Microsoft Purview.  SLIDES The slides can be downloaded via the link below, so that you can view them again at...

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....

Related

Read More
Service Health Alerts in Azure

Service Health Alerts in Azure

DataMinds Connect 2019

by ErwinMar 2, 2019

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:2 + thirteen = Notify me of new posts by email.Submit Comment

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

Are you using Azure DevOps?

Azure DevOpsMore and more users are starting with Azure DevOps. Azure DevOps can be used for up to 5 users free of charge and is therefore a great start to start a project.    Build and Release I will not describe what Azure DevOps can do, because that is too much to...

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...

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...

New Microsoft Azure Certifications

Microsoft Certification by Solution Area Handy overview of the new Microsoft Azure Certifications. More details can be found here Feel free to leave a comment

How to check your SQL Server Quota in Azure?

Azure Subscription Usages for SQL Server  Last week we reached our Logical server Quota in Azure. By default you're only allowed to add 20 Logical Servers, but we wanted to have some more for testing purposes.Microsoft Support You can submit a support ticket trough...

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...

ADF: Get Metadata Activity stopped working

Meta Data ActivityToday my pipelines in Azure Data Factory (ADF) suddenly stopped working. The output structure was not found. Quit strange while these pipelines have been running for weeks.    Invalid Template After debugging my Pipeline I found out the...

Custom comments in Azure Synapse Analytics

Add custom comments to your Azure DevOps and Github commitsFinally ​Finally and secretly hidden, we can now add a Comment to our commits in Azure Synapse Analytics and Azure Data Factory to Azure Dev Ops. How do you activate this custom comment option in your existing...

Azure Data Factory: Save a pipeline as a Template

Saving a PipelineAnother great improvement in Azure Data Factory. Saving you template!How can you save your template? First of all you need to connect your Azure Data Factory to  a GIT integration. Both Azure DevOps GIT and GitHub are supported. Please follow this...

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

Service Healths in Azure

DataMinds Connect 2019

DataMinds Connect 2019

by ErwinMar 2, 2019

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 − seven = Notify me of new posts by email.Submit Comment

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

Azure Synapse Analytics Power BI Integration

Creating a Linked Service for Power BI Open your Synapse Studio and select the Management Hub. Add a new Linked Service If you haven't connect to Power BI before, you will see the screen above. If you want to add another Power BI Linked Service(Workspace). Search for...

Azure Data Factory Let’s get started

Creating an Azure Data Factory Instance, let's get started Many blogs nowadays are about which functionalities we can use within Azure Data Factory. But how do we create an Azure Data Factory instance in Azure for the first time and what should you take into account? ...

Introduction to Real-Time Analytics in Microsoft Fabric

Introduction to Real-Time Analytics in Microsoft Fabric Real-Time Analytics is one of the data and analytical workloads/experiences available in Microsoft Fabric, the new platform currently in Public Preview at Microsoft. With Real-Time Analytics, companies and...

Azure Data Factory updates June

Azure Data Factory updates There have been quite a few updates in Azure Data Factory and Azure Synapse Analytics in the last few days.Below is a summary of these updates:   Time-To-Live (TTL) on Integration Runtime with managed virtual network enabled The new TTL...

Data Sharing in Microsoft Purview

In today's world, data is the key to success for businesses. The more data a business has, the better it can make decisions and stay ahead of its competitors. However, data is not always easy to come by, and many businesses struggle with finding and accessing the data...

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...

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

Creating a metastore in your Azure Databricks account In the previous blog you learned how to sync and assign users and groups to the Enterprise Application. In this blog, you will learn how to create a metastore and assign it to Azure Databricks workspaces to. This...

Azure Purview announcements and new functionalities

This week the Azure Purview Product team added some new functionalities, new connectors(these connectors where added during my holiday), Azure Synapse Data Lineage, a better Power BI integration and the introduction of Elastics Data Map. Slowly we are on our way to a...

SSMS 18.xx: Creating your Azure Data Factory SSIS IR directly in SSMS

Creating your Azure Data Factory(ADF) SSIS IR in SSMS Since  version 18.0 we could see our Integration Catalog on Azure Instances directly. Yesterday I wrote an article how to Schedule your SSIS Packages in ADF, during writing that article I found out that you can...

Azure Data Factory: Generate Pipeline from the new Template Gallery

Last week I mentioned that we could save a Pipeline to GIT. But today I found out that you can also create a Pipeline from a predefined Solution Template.Template Gallery These template will make it easier to start with Azure Data Factory and it will reduce...

Related

Read More
LEAP 2018

LEAP 2018

DataMinds Connect 2019

by ErwinMar 2, 2019

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:2 × 4 = Notify me of new posts by email.Submit Comment

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

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...

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....

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....

New Microsoft Azure Certifications

Microsoft Certification by Solution Area Handy overview of the new Microsoft Azure Certifications. More details can be found here Feel 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...

Azure Purview March Updates

Azure Purview updatesAnnouncements Last week during SQLBITS, quite a few new updates were announced. I would like to include you in these announcements.March updates Support for SAP Business Warehouse (Preview) Blogpost:...

Enable Pattern Rules in Azure Purview

How can I enable Pattern Rules?​Pattern Rules Last night I was preparing for a demo with Azure Purview. As always, I walk through all the activity hubs to see if there are any new options. This time I noticed that the Pattern Rules option was greyed out. Resource Set...

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...

How to check your SQL Server Quota in Azure?

Azure Subscription Usages for SQL Server  Last week we reached our Logical server Quota in Azure. By default you're only allowed to add 20 Logical Servers, but we wanted to have some more for testing purposes.Microsoft Support You can submit a support ticket trough...

Azure Data Factory: Save a pipeline as a Template

Saving a PipelineAnother great improvement in Azure Data Factory. Saving you template!How can you save your template? First of all you need to connect your Azure Data Factory to  a GIT integration. Both Azure DevOps GIT and GitHub are supported. Please follow this...

Related

Read More

Upcoming Events

Featured Featured

SQLKonferenz

View Calendar

Categories