How to check your SQL Server Quota in Azure?

Loading view.

There were no results found for this view. Jump to the next upcoming events.

There were no results found for this view. Jump to the next upcoming events.

Events Search and Views Navigation

Search

Enter Keyword. Search for Events by Keyword.

Find Events

Event Views Navigation

Month

List

Month

Day

This Month

2024-04-28

April 2024

Select date.

Calendar of Events

M

Mon

T

Tue

W

Wed

T

Thu

F

Fri

S

Sat

S

Sun

0 events,

1

0 events,

1

0 events,

2

0 events,

2

0 events,

3

0 events,

3

0 events,

4

0 events,

4

0 events,

5

0 events,

5

0 events,

6

0 events,

6

0 events,

7

0 events,

7

0 events,

8

0 events,

8

0 events,

9

0 events,

9

0 events,

10

0 events,

10

0 events,

11

0 events,

11

0 events,

12

0 events,

12

0 events,

13

0 events,

13

0 events,

14

0 events,

14

0 events,

15

0 events,

15

0 events,

16

0 events,

16

0 events,

17

0 events,

17

0 events,

18

0 events,

18

0 events,

19

0 events,

19

0 events,

20

0 events,

20

0 events,

21

0 events,

21

0 events,

22

0 events,

22

0 events,

23

0 events,

23

0 events,

24

0 events,

24

0 events,

25

0 events,

25

0 events,

26

0 events,

26

0 events,

27

0 events,

27

0 events,

28

0 events,

28

0 events,

29

0 events,

29

0 events,

30

0 events,

30

0 events,

1

0 events,

1

0 events,

2

0 events,

2

0 events,

3

0 events,

3

0 events,

4

0 events,

4

0 events,

5

0 events,

5

There were no results found for this view. Jump to the next upcoming events.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

There are no events on this day.

Mar

This Month

May

Subscribe to calendar

Google Calendar

iCalendar

Outlook 365

Outlook Live

Export .ics file

Export Outlook .ics file

Read More

New Microsoft Azure Certifications

Experts Live Netherlands

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

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

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

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

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

Azure Data Factory: New functionalities and features

New functionalities and featuresLast week, a number of great new functionalities and features were added within Azure Data Factory. I would like to take you in some details in the blog below:Customer key With this new functionality you can add extra security to your...

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

Goodbye 2021, Hello 2022

Goodbye 2021Recap First of all, I would like to wish everyone a very beautiful and healthy 2022. We are now 3 days on the road into the new year and it is always good to look back at what happened last year. It's certainly been an eventful year, topped off with my MVP...

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

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

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

Read More

Azure SQL Data Warehouse: How to setup Reserved Capacity

Experts Live Netherlands

Purchase your Azure SQL Datawarehouse Reservation
 
Since a few weeks you can buy Reserved Capacity for an Azure SQL Datawarehouse (SQLDW). This Reservation can save you up to 65% on the normal Pay as You go rates with a 3 year pre-commit. A pre-commit of 1 year will be discounted up to 35%.
These savings will only effect the compute power. You will charged separately for the storage with the normal Pay as You go rates.
To purchase a reservation,  you need to sign-in to the Azure Portal first and then search for reservations.

After you have clicked on Purchase Now, you will need to choose the Azure SQLDW option.

Select the Region, be aware that if you want to run Several SQLDW’s (Dev/Test/Prod) and you want to make use of the benefits of the reserved capacity that these SQLDW’s must all be created in the Region in which the reservation is made.
When you’re running a Enterprise Subscription and you have more then 1 Subscription you can change the Scope to  “Shared”. With this option selected you can use the Reserved Capacity across all subscription within the same EA Enrollment.

Select 1 or 3 year Term.

Choose a quantity. The reserved capacity is calculated by 100 cDWU(Data Warehouse units). Choose the quantity you want to reserved. In case you select 5 cDWU, you will have 500 cDWU of reserved capacity every hour.

 

The last step is to Purchase your Reservation.

Reserved Capacity nice to know’s
Storage and Network are charged separately, for these Azure Services the Reserved Capacity Discount will not be applied.
The Reserved Capacity Discount is applied on running Azure SQLDW Instances on a hourly basis.
If you don’t have a Azure SQLDW Instance deployed for an hour, then the reserved capacity is wasted for that hour. It doesn’t carry over. Unless you have more then 1 Azure SQLDW Instance running, the reservation is automatically applied to other matching instances in that hour.
Some Examples:
1 – Running 1 Azure SQLDW Instance:
You have purchased 5 units of 100 cDWU.
On the moment you scale to 1000 cDWU, you will be charged with a Pay as You go rates for 700 cDWU.
2 – Running 2 Azure SQLDW Instances:
You have purchased 15 units of 100 cDWU.
1 Azure SQLDW Instance is running 500 cDWU and the other one 1000 cDWU.
No extra cost will be applied.
3 – Running 2 Azure SQLDW Instances:
You have purchased 15 units of 100 cDWU.
1 Azure SQLDW Instance is running 500 cDWU from 9 am to 5 pm  and the other one 1500 cDWU the whole day.
You will be charged for a Pay as You go rates for 500 cDWU from 9 am to 5 pm.

Thank you for reading this article and hopefully it will make things clear to you.
Within a few days I will publish a new article in which I describe how much you could possibly save if you still want to scale up or down during certain periods of the day. If there are any questions left about this article, don’t hesitate to ask them to me.
UPDATE 6th May
Reserved Capacity versus Pas as You go
Azure SQL Data Warehouse: How to setup Reserved Capacity

Latest Posts
Microsoft Purview Data Governance Public Preview Rolllout
How to use mssparkutils.notebook.runMultiple in Notebooks in Microsoft Fabric?
Video: Learn Live Use Data Factory pipelines in Microsoft Fabric
How to use the PySpark executor in Notebooks in Microsoft Fabric?
High Concurrency Notebook Activity in Microsoft Fabric

Feel free to leave a comment

Read More

Azure SQL Data Warehouse: Reserved Capacity versus Pay as You go

Experts Live Netherlands

How do I use my Reserved Capacity correctly?
Update 11-11-2020: This also applies to Azure Synapse SQL Pools.
In my previous article you were introduced, how to create a Reserved Capacity for an Azure SQL Datawarehouse (SQLDW). Now it’s time to take a look at how this Reserved Capacity differs from an already working environment with an Azure SQLDW Pay as You go model where we already scale up and down during certain time periods.
 
In the example below I’m running an Azure SQLDW with the following capacity during the day.
 
Weekdays:

12:00 AM
4:00 AM
100   cDWU

5:00 AM
7:00 AM
3000 cDWU

8:00 AM
6:00 PM
1500 cDWU

7:00 PM
12:00 AM
100   cDWU

Weekenddays:

12:00 AM
4:00 AM
100   cDWU

5:00 AM
7:00 AM
3000 cDWU

8:00 AM
6:00 PM
500   cDWU

7:00 PM
12:00 AM
100   cDWU

We have separated the weekdays from the weekend days. The SQLDW is used less heavily during the weekend than during the week.
In our calculation we assume that we will purchase a Reserved Capacity of 3 years with 15 units of 100 cDWU. On the left site you will see the Pay as You go model and on the right site the Reserved Capacity.
The amount of Storage will be 8 TB.
As you can see in the example below.

Conclusions:
In the example we see that we have to pay extra if we exceed our Reserved Capacity. These extras are billed with the normal Pay as You go rate.

If we use the Reserved Capacity, we have 1500 cDWU available throughout the day so we don’t longer need to turn it off or scale it down during weekends or outside office hours. Otherwise the Reserved Capacity is wasted for that hour, it doesn’t carry over.
So we actually get more capacity and we pay less for it, sounds great or not!  More details can be found here.

In this example, we save nearly 2,750 euros a month, which is almost 33,000 euros a year and 100,000 euros during the 3-year Reserved Capacity period. And that is a considerable amount that you can use to develop new solutions.

 

Reserved Capacity
Years
Discount
Month
Year 
Total Period

Reserved Capacity
Year
Discount
month
year
Total Period

1500 cDWU
3
65
2742
32914
98739,648

1500 cDWU
1
35
-2319,41
-27832,9
-27832,896

1000 cDWU
3
65
2261,952
27143,42
81430,272

1000 cDWU
1
35
-1112,83
-13354
-13353,984

In this situation we achieve the largest saving with 1500 cDWU with a Reservation of 3 years. When purchasing 10 units of 100 cDWU, we still save but slightly less. When purchasing Reserved Capacity for 1 year, a Pay as You go model will be cheaper.

 
Calculation Sheet
Since every situation is different, you will have to play with these quantities/units yourself. I have added the Excel form so that you can download it, on which I have based this article. With this form you can fill in your own situation as well as possible. And finally you can take your own conclusions for your customer or environment.

In the sheet only change the Green Marked cells. Prices are in Euro’s.

SQLDWH_-_pay-as-you-go_vs_reservedcapcity

This form has been created together with my colleague Maurice Veltman and we have used it for a solid calculation for 1 of our customers.

If you have any questions or comments about this article or the form,  just let me know.

 

Latest Posts
Microsoft Purview Data Governance Public Preview Rolllout
How to use mssparkutils.notebook.runMultiple in Notebooks in Microsoft Fabric?
Video: Learn Live Use Data Factory pipelines in Microsoft Fabric
How to use the PySpark executor in Notebooks in Microsoft Fabric?
High Concurrency Notebook Activity in Microsoft Fabric

Feel free to leave a comment

Read More

SSMS 18.1: Schedule your SSIS Packages in Azure Data Factory

Experts Live Netherlands

Schedule your SSIS Packages with SSMS in Azure Data Factory(ADF)
This week SQL Server Management Studio version 18.1 was released, which can be downloaded from here.
In version 18.1 the Database diagrams are back and from now on we can also schedule SSIS Packages in ADF via SSMS.
 
Select the package you want to schedule in your Integration Services Catalog,

 
Create the schedule you want to create and click on OK.
 Your schedule will be created in Azure Data Factory.

 
 
 
 
Azure Data Factory
In Azure Data Factory a pipeline and trigger are created automatically

 
Azure Dev Ops
Scheduling your SISS packages is not working fine when you have Azure Dev Ops Enabled. Pipeline and Trigger are published to the Data Factory instead of Azure DevOps GIT as you can see below.
My advice will be to build your schedule/trigger directly in Azure Data Factory when you ‘re using Azure Dev Ops.

 
In case you have any questions left, do not hesitate to ask them. I’m more then happy to answer them.

Latest Posts
Microsoft Purview Data Governance Public Preview Rolllout
How to use mssparkutils.notebook.runMultiple in Notebooks in Microsoft Fabric?
Video: Learn Live Use Data Factory pipelines in Microsoft Fabric
How to use the PySpark executor in Notebooks in Microsoft Fabric?
High Concurrency Notebook Activity in Microsoft Fabric

Feel free to leave a comment

Read More

Upcoming Events