Sensitivity Rank in Data Classification

May 27, 2020

Data Discovery & Classification is supported for SQL Server 2012 and later, and can be used with SQL Server Management Studio (SSMS) 17.5 or later. Starting SSMS 18.5, a new feature called ‘sensitivity rank’ was added in Data Classification. I will show details about the sensitivity rank in this blog post. I want to thank David Trigano, Program […]

SSMS – Notebook as a destination for Generate Scripts wizard

May 18, 2020

SQL Server Management Studio (SSMS) was released on April 7th, 2020. You can download this latest version from this link. 18.5 is an update to 18.4 with these new items and bug fixes. One of the features added in this release is to select ‘Azure Data Studio‘ Notebook as a destination for Generate Scripts wizard. […]

SSMS Memory Grant Info

May 11, 2020

Over some time, SQL Server Management Studio has expanded memory grant information. Memory grant provides memory grant estimate as well as actual runtime memory grant information. In this blog post, I will explain each element of ‘Memory Grant Info’, so we can get a better understanding of what those numbers mean? I am using this […]

AZ-900 How Did I Prepare?

March 19, 2020

On March 16th, I posted (Twitter|LinkedIn) about achieving my first ever Azure Certification. AZ-900 Azure Fundamentals. I understand it is basics, and that is why it is called fundamentals. I had a few people asked me how I prepared as they want to do the same. Here are a few resources I used to prepare: […]

Ring Buffer Monitoring CPU – What do those values mean?

February 24, 2020

Here is a sample output of XML from sys.dm_os_ring_buffers where WHERE ring_buffer_type = N’RING_BUFFER_SCHEDULER_MONITOR’. What do those XML elements mean? In order to monitor CPU usages, you need to understand what each element means so you can use the values. I will explain each one in this blog post. ProcessUtilization Indicates the amount of CPU SQL […]

profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

I'm expecting a lot of my followers to follow this diagram and end up at Database Reliability Engineering.

So I suppose... I owe @BrentO a thank you for effectively writing that part of this blog post for me!

Anyone know how to get to these section in portal. I know how to configure this using PowerShell ... .
I am not seeing this while creating new database.


Are you a Data Professional?
Do you have a Dream to become a Public Speaker but struggle with self-doubt?
Then this ... article is for you!

#sqlsatmontreal organizers thank you for work and opportunity.
Flawless execution.
Thanks to all speakers, sponsors, ... volunteers and attendees.


Load More...