×

SQL Server

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

How to Use Managed Identity with Azure Function App?

January 27, 2020

With the announcement of Powershell support in Azure Functions, it has become easier for data professionals to use functions to manage cloud resources such as Azure SQL Database, Managed Instances. A common challenge when using functions is how to manage the credentials in function code for authenticating databases. Keeping the credentials secure is an important […]

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

Shortcut to Show and Hide Azure Data Studio Results Pane

January 6, 2020

On December 29th I saw a tweet with #sqlhelp hashtag from Derik Hammer (Blog|Twitter). I know CTRL+R works for the same when using SQL Server Management Studio (SSMS). That hotkey did not work in Azure Data Studio (ADS). Knowing how brilliant technologists Derik is, I realized that a standard google search will not work. I […]

Did My UDF Inlined?

December 30, 2019

With the release of SQL Server 2019, CTP 2.1 new features were added to Intelligent Query Processing (QP) feature family. One of those features was Scalar UDF Inlining. You can read about the announcement by Karthik Ramachandra from Microsoft in this blog post. Karthik explained why UDFs are a problem when inlining is not done. Another […]


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 will be speaking at @PASSCloudVC in 3 hours.
10 am PST
1 pm EST
17:00 UTC

Azure SQL Database - Where is my SQL ... Agent?
Registration: https://cloud.pass.org/
#sqlpass #MVPBuzz

#SQLFriday is free Microsoft Data Platform training, delivered by top speakers from the Data Platform community every ... Friday lunch (12:00 CEST), to your computer. Join meetup group at https://meetup.com/Sql-Friday and check out the full schedule at https://sqlfriday.net/schedule

Call for Speakers has reopened! In light of #PASSsummit 2020 becoming a virtual event, we want to give you another ... chance to share your #data knowledge with the #sqlpass community, from anywhere in the world!

Apply Today: http://ow.ly/iuiX50zVWQ0

Load More...