×

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

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

Vermont SQL Server User Group

January 15, 2020

View Event: New features in SQL Server Management Studio, Performance Troubleshooting Title: New features in SQL Server Management Studio — Performance Troubleshooting made easier! Description: SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools, which enabled rapid enhancement to the Execution Plan. Do you know […]

Global diversity CFP day Boston/Cambridge, USA

January 17, 2020

View Event: https://www.globaldiversitycfpday.com/events/204 Reason for being involved in the workshop: I remember how I got started with lightning talk a few years ago, and now I want to use my experience in helping new speakers.


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...