Today we had an interesting use case where a customer reported that one of the databases they just restored from a backup got stuck in " Single-User " mode in one of their environments. To resolve it, I first tried running the following command: ALTER DATABASE MyDB SET MULTI_USER WITH ROLLBACK IMMEDIATE; In response, I got deadlocked with the dreaded error 1205: Transaction (Process ID) was deadlocked on lock resources with another process and has been chosen as the deadlock

Converting SQL server stored procedures to Databricks notebooks, be aware of syntax differences.

If someone asked you which graph would be best for visualizing the customer types for each account manager based on the table in the...

Which is the right ETL tool for you on Azure cloud? Azure data factory or Azure Databricks?

Today I had the honor to present my session in SQLBits 2023. I promised to make all the session materials available for download...

This article was published by Aaron Bertrand a few years ago, talking about system-named constraints in SQL Server. The article mostly...

On Azure data factory with GIT, sometimes old versions are left on live mode, here is how to delete them.

A few days ago, I had a conversation with a colleague about Data Visualization. I explained that in data visualization, it is the...

Use Azure data factory to sort files to time hierarchy partitions.