×

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

Imposter Syndrome-Welcome to My World!

January 14, 2020

I thank Jon Shaulis (blog|twitter) for hosting T-SQL Tuesday #122. The topic for this month is Imposter Syndrome. 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 this program. If you are […]

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

UDFs CPU and Elapsed Time

December 23, 2019

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


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!
https://octopus.com/blog/devops-reading-list

#sqlhelp
#AzureSupport
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.

https://docs.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview?tabs=single-database#configure-backup-storage-redundancy-by-using-the-azure-portal

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!
@NewStarsOfData
https://dbanuggets.com/2020/11/21/take-that-first-step-in-faith-rest-will-pave-its-path-to-your-speaking-journey/

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

#sqlpass

Load More...