From Chaos to Clarity: Transform Your Data with Power Query in Power BI
Master Power Query transformations in Power BI, clean and transform data like a pro, and unlock meaningful insights. Get started today!
top of page
Search
Guy Glantser
- 21 hours ago
- 2 min
Azure SQL Cost Optimization
Explore Azure SQL Cost Optimization strategies for optimizing Azure SQL components and significantly reducing cloud expenditure
Guy Glantser
- 4 days ago
- 3 min
Delayed Durability During Shutdown
Delayed Durability in SQL Server improves performance while allowing for some data loss. Learn what happens during shutdown...
Eitan Blumin
- May 15
- 1 min
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...
Eric Rouach
- May 3
- 2 min
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...
Rita Fainshtein
- May 3
- 2 min
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...
Chen Hirsh
- Apr 29
- 2 min
Read Netsuite data with Azure Databricks
Use Azure Databricks to read data from Oracle Netsuite cloud ERP.
Uri Bahat
- Apr 27
- 2 min
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.
Eitan Blumin
- Apr 23
- 2 min
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...
Eitan Blumin
- Apr 3
- 2 min
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...
bottom of page