Create an Azure Synapse Analytics SQL Pool

by Erwin | Jun 17, 2020 | Azure, Azure Synapse Analytics

Azure SQL DataWarehouse

Adding a new SQL Pool

There are 2 options to create a SQL Pool. Go to your Synapse Workspace in de Azure Portal and add a new SQL Pool.

Create SQL Pool

Or go to the Management Tab in your Azure Synapse Workspace and add a new Pool.

Creating a new SQL Pool

SQL Pool Name (SQL pool name should not be greater than 15 characters) and select the correct Performance Level. Be careful in selecting the Performance Level. DW 1000c will cost you € 12,73 per hour excluding storage. My advice is to start small and scale up when necessary. More about DWc units can be found here.

If you want to use Data from an existing pool, select Backup or Restore Point. Otherwise select none

Use existing data-Backup

Use existing data-Restore Point

Use existing data-None

Review Azure Synapse SQL Pool

Review your settings and your SQL Pool will be created.

Remarks

Be aware that if you already have another Azure SQL DW running, you cannot select or add it to your Azure Synapse Workspace.
Adding an SQL pool is only possible via the Azure Synapse Workspace(Azure Portal or Studio).

If you install it as a standalone component through the Azure portal, the SQL Pool cannot be added to the Azure Synapse Workspace.

And if you don't use your SQL pool please PAUSE it. It will save you a lot of money.

DataMinds 2018

by Erwin | Oct 20, 2018 | Events

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

Speaking(Virtual) at SQL Saturday #963 Denmark

SQL Saturday 963 Denmark PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. My...

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

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 Virtual session DataWeekender 4.2

DataWeekender 4.2 This Saturday I've joined the Van and Spoke at DataWeekender Azure 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...

Data Saturday #1 Pordenone(Video)

Recording of my session during Data Saturday #1 Pordenone Azure Purview Microsoft's answer to Data Governance and Data Lineage

October=Speaking Month

$variable({"type":"content","value":{"name":"post_title","settings":{"before":"","after":""}}})$ DataSaturday Holland and DataMinds in Belgium Like last year I have been selected again this year for both events to speak. Cool to be able to speak at 3 different events...

My virtual session at Data Toboggan

Data Toboggan This Saturday I've joined the Data Toboggan to talk about Azure Synapse Analytics. Azure Synapse Analytics Today I've been talking on how to deal with all the different roles in Azure Synapse Analytics during Data Toboggan. An event 100% focussed...

SQLBITS 2022

SQL BITS 2022 What a great time I had Wednesday 9th of March the time had finally come, at 1830 my plane would leave for London City. After all the preparations over the past few weeks, the time was there. After arriving in London City and checking in at the hotel, I...

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

SQLBits 2020(Video)

All sessions of SQLBits 2020 have been made available to everyone and can now be viewed via their Youtube channel. To make it easier to find a recording of your choice, a number of playlists have been created: Developer SQLBits 2020 - Developer sessions High...

My First Blog Post SQLSatHolland 790

by Erwin | Oct 15, 2018 | Events, SQL Saturday

Azure SQL DataWarehouse

by Erwin | Oct 15, 2018

Yeah, my first blog is LIVE

After a good talk with Reza Rad from RADACAD during SQLSatHolland, I decided to start my first blog!
Knowledge sharing is very important, it gives me a lot of energy. But it also gives others people in the community energies to pick up new activities. That is the main reason to start this blog.

Now back to SQLSatHolland, which was held on October 13th in Utrecht. This free event is very well attended and with 550 attendees it is one of the largest SQLSaturday’s in the world. Not everyone who registered did show up, but that was mainly due to the extremely hot weather in the Netherlands, 28 degrees in October.

International top speakers
This year there were again international Top speakers to Utrecht, compliments for the organizers André, Peter and Joost and many others. Organizing such a big event is already a challenge, but finding international speakers is not easy either.

Azure Data Factory V2
This year my session was about Migrating to Azure SQL DataWarehouse with Azure Data Factory V2, this was the first time I presented this session, so extra exciting for me. You can find the session details here

Enthusiastic audience
The session went very well and the room was crowded. You can be very exited about your session, but it is always the question whether others like your session as well.

I got some nice compliments after the session and that is one of the reasons you end up doing it

It was a great day, spoke to a lot of people, see you next year.

Feel free to leave a comment

Azure SQL DataWarehouse

Adding a new SQL Pool

Creating a new SQL Pool

Use existing data-Backup

Use existing data-Restore Point

Use existing data-None

Remarks

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

Migrate to Azure SQL DataWareHouse

Great Feedback

Organisation

Azure SQL DataWarehouse

Yeah, my first blog is LIVE

After a good talk with Reza Rad from RADACAD during SQLSatHolland, I decided to start my first blog!Knowledge sharing is very important, it gives me a lot of energy. But it also gives others people in the community energies to pick up new activities. That is the main reason to start this blog.

Feel free to leave a comment

Categories

Because the organization of SQLSatHolland and DataMinds worked well together, top speakers where
present again.

After a good talk with Reza Rad from RADACAD during SQLSatHolland, I decided to start my first blog!
Knowledge sharing is very important, it gives me a lot of energy. But it also gives others people in the community energies to pick up new activities. That is the main reason to start this blog.