In this ultimate guide, learn how to fix high VLF counts and shrink transaction logs in SQL Server to improve performance. Discover best...

Master Power Query transformations in Power BI, clean and transform data like a pro, and unlock meaningful insights. Get started today!

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