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 […]
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. […]
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 […]
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 […]
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 […]
Got stack dumps? Check out the latest version of the SQLCallstackResolver from @arvisam ! ... https://github.com/arvindshmicrosoft/SQLCallStackResolver/releases/tag/2.0.1
Looking forward to moderate this session by @SQLGoddess .
We have 142 data professionals signed up. We can accommodate ... few more.
Looking forward to hosting @SQLGoddess tomorrow night, talking about "TempDB: The Good, the Bad, and the Ugly". There's still time to sign up: https://www.meetup.com/NESQLUG/events/271358709/
"See" you there!
What an honor and privilege to be speaking at @ROCSqlUG
Thursday, August 13, 2020
19:00 - 21:00 EDT
The Magnificent ... Seven - Intelligent Query Processing in SQL Server
Registration details:
https://rochesterpass.pass.org/
#sqlpass #sqlserver #sqlserver2019
#mvpbuzz
@timweigel @SqlWorldWide @sqlpass The game changer that I found for SQL Saturday Iowa 2020 was to fully embrace the ... online event and stop thinking of it as an "in person" event presented online. We found innovative ways around many of the online event challenges.
The great staff we have didn't hurt either!
@timweigel @SqlWorldWide @sqlpass In person is great for a rock solid paywall.
In person events allow me to see people ... who I love to talk to but who live in places I rarely get to visit... @SQLInTheWild, @rob_farley, and @jesus_gilv jump right to mind, among a full on hoard of European friends.
