Explore Azure SQL Cost Optimization strategies for optimizing Azure SQL components and significantly reducing cloud expenditure

Delayed Durability in SQL Server improves performance while allowing for some data loss. Learn what happens during shutdown...

Are you facing slow database performance and frequent lock chains caused by the high concurrency of DML statements on a central table in...

Written by: Eric Rouach, Madeira Data Solutions - May 2023 Create External Table As Select or "CETAS" has finally become available on...

I have seen a lot of graphs lately where colors are used to convey a message of comparing groups. Here are some examples: Both graphs...

Use Azure Databricks to read data from Oracle Netsuite cloud ERP.

Where you told to not use Big A** Numbers in your dashboard? Well, sometimes you should.

As someone who works with databases and often collaborates with software development teams, I've noticed a rise in the popularity of...

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.