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 […]
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 […]
Microsoft SQL Server Management Studio (SSMS) version 17.5 added new showplan attributes UdfCpuTime and UdfElapsedTime to QueryTimeStats. These two attributes will measure the time and CPU spent on user-defined functions within a query execution hence helping to discover the impact of UDF execution within full query execution. This feature was first added in SQL Server […]
HA/DR Open Q&A Extravaganza is on December 10th, 2019, at 1 PM EST. This event is one of the most extensive lineups of SQL Server HA/DR experts in history, and any question goes! ! Organized by High Availability and Disaster Recovery PASS virtual group. I am honored, humbled, and super excited to be part of this panel. […]
SSMS XEvent Profiler was made available on SQL Server Management Studio (SSMS) v17.3 or later. Make sure you are using the latest version. You can find the latest version of SSMS here. What is the XEvent Profiler? The XEvent Profiler is a SQL Server Management Studio (SSMS) feature that displays a live viewer window of extended […]
