Azure SQL Cost Optimization
Explore Azure SQL Cost Optimization strategies for optimizing Azure SQL components and significantly reducing cloud expenditure
top of page
Guy Glantser
May 20, 20233 min read
Delayed Durability During Shutdown
Delayed Durability in SQL Server improves performance while allowing for some data loss. Learn what happens during shutdown...
4
Eitan Blumin
May 15, 20231 min read
The Asynchronous Ledger Trick for Lightning-Fast SQL Server OLTP
Are you facing slow database performance and frequent lock chains caused by the high concurrency of DML statements on a central table in...
3
Eric Rouach
May 3, 20232 min read
CETAS in SQL Server 2022
Written by: Eric Rouach, Madeira Data Solutions - May 2023 Create External Table As Select or "CETAS" has finally become available on...
2
Rita Fainshtein
May 3, 20232 min read
My attention-span-challenging graph
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...
2
Chen Hirsh
Apr 29, 20232 min read
Read Netsuite data with Azure Databricks
Use Azure Databricks to read data from Oracle Netsuite cloud ERP.
1
Uri Bahat
Apr 27, 20232 min read
Don't be afraid of the Big Number Monster
Where you told to not use Big A** Numbers in your dashboard? Well, sometimes you should.
0
Eitan Blumin
Apr 23, 20232 min read
Should your DB and App projects be in the same Source Control Repository?
As someone who works with databases and often collaborates with software development teams, I've noticed a rise in the popularity of...
1
Eitan Blumin
Apr 3, 20232 min read
Resolved: Database Stuck in Single-User Mode
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...
0
Chen Hirsh
Mar 28, 20232 min read
SQL server vs Databricks SQL syntax
Converting SQL server stored procedures to Databricks notebooks, be aware of syntax differences.
5
bottom of page