×

Speaking at SQLSaturday Cleveland

January 23, 2020

PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. SQLSaturday Cleaveland will be held on Feb 01, 2020, at Strosacker Hall – Baldwin Wallace University, 115 Tressel Street, Berea, Cleveland, Ohio, […]

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


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

Q: If I hold an *exclusive lock* on a row, can another transaction running at (the default) *locking read committed* ... isolation level read it?

A: Yes!

SQL Server can skip shared locks if there is no risk of reading uncommitted data without them:

https://www.sql.kiwi/2010/11/read-committed-shared-locks-and-rollbacks.html

facebook copied my entire app, then renamed it IG Threads. pro tip: don’t present your hard work at their developer ... conferences https://twitter.com/dhof/status/1288233909931642880

dom hofmann@dhof

facebook has copied a lot of my work

Next Virtual Boston Azure (@bostonazure + @NorthBTownAzure) meetup will be on Tuesday 8/11. Learn very useful @Azure ... tips and tricks from the one and only @mbcrump. As always, don’t forget to RSVP here: https://www.meetup.com/bostonazure/events/272237070/ #AzureTipsAndTricks #Azure

Not an acceptable distance for a weekend run.
Blame kids activity.
Have to go out for another run or cycling.
... #selfcare
#sqlrun

Learn about "The Good, The Bad, and The Ugly" with TempDB next week (📅 Aug 12) with @SQLGoddess: ... https://bit.ly/2D08fJJ #AzureSQL

Load More...