×

SSMS

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 […]

T-SQL Tuesday #123: SSMS tips to make your day easier

February 11, 2020

I thank Jes Pomfret (blog|twitter) for hosting T-SQL Tuesday #123. The topic for this month is Life hacks to make your day easier. I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some of the #TSQL Tuesday’s and participated in a few. Thank you, Steve Jones (blog|twitter), for coordinating […]

UnmatchedIndexes – Bug in SSMS

January 21, 2020

Filtered Index in SQL Server and Parameterized Query does not work well with each other. This incompatibility is a well-known issue among Data Professionals. If you do a Google search for ‘SQL Server unmatched index‘ you find many articles written by well-known bloggers in the SQL Server community. I am quoting a summary of the […]



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

Did you know? We have a #SQLServer builds site with nearly 1000 builds: indexed, searchable and powered by a regularly ...updated JSON file that is included in dbatools! http://dbatools.io/builds

I've started a little thing to provide a list of mental health resources for people. Started by having many ...conversations with folks. It's in on GitHub so people can help me add to it. It's in its baby stages. https://buff.ly/3Ar09Vw #mentalhealth #sqlfamily

My kids had their first day of school today.

As school starts up again, tell your kids about Ruby Bridges—the first... Black child at all-white public elementary school in South.

Ms. Bridges is only 67

67.

Azure SQL Database - Business Continuity During Disaster🤯with #MVP @SqlWorldWide🌍

Sept 1st @ 1pm BST!📅

You ...can RSVP below!👇 Please note that our user group is fully virtual - that means anyone and everyone can join us!😍

https://www.meetup.com/microsoftdataplatformbirmingham/events/287780538/

Load More...