Arun Sirpal

Azure SQL Database – Maxdop Updated

About 1.5 years I wrote about MAXDOP setting within Azure SQL DB, more specifically the fact that the default setting being 0. (https://blobeater.blog/2018/09/12/maxdop-and-azure-sql-db/) Now, you should be aware that...

2020-08-10

12 reads

Azure SQL Training

I thought being an Azure Data/Database blogger I would share some amazing content from Microsoft, an Azure SQL Fundamentals learning path. Following this training you will “Learn how to...

2020-08-05

27 reads

Azure SQL Database SLA

Can you improve on the baseline (service level agreement) SLA of 99.99 % for Azure SQL Database? How can you get 99.995% as shown below, from official Microsoft documentation?...

2020-08-04

10 reads

SQL Server Stretch DB to Azure

Since SQL Server 2016 we could leverage Microsoft Azure to dynamically move “cold” portions of data away from on-premises storage for longer retention time periods. Whilst in theory being...

2020-07-27

18 reads

Azure Data Engineer Associate

You can read about all the new role based qualifications from Microsoft here – https://www.microsoft.com/en-us/learning/certification-overview.aspx Today I want to talk about the Azure Data Engineer one from my experience...

2020-07-06

23 reads

Blogs

What goes around comes around : T-SQL Tuesday #129

By

I almost died. I’m sure a lot of you already know this but just...

My T-SQL Tuesday #129 Time Capsule

By

This month the T-SQL Tuesday invitation comes from Tamara Clark. I strong-armed Tamara last...

Azure Database Administrator

By

Recently I found out that I passed the BETA exam for Azure Database Administrator...

Read the latest Blogs

Forums

Change dbowner

By ramyours2003

Can we change the dbowner to system databses ? if yes how can we...

Send me an email if this job run longer than 30 minutes

By krypto69

Hi I have a job that I need to be notified/emailed if it runs...

Time out expired on the application side

By zouzou

Hi   I have an application that is timing out i run the query...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The D in ACID

See possible answers