top of page


High Allocated Unused Space: The Hidden SQL Server Problem You Need to Fix
In my daily work, I use a few monitoring and alerting systems. One of the conditions triggers an alert for highly allocated unused space....

Vitaly Bruk
Dec 26, 20245 min read


SQL Server Database Mail High CPU
Today, I investigated an interesting issue. One of my clients called me and complained about high CPU on his server. Server with 0 load...

Vitaly Bruk
Dec 10, 20244 min read


Resumable Incremental Database Integrity Checks
Discover how to optimize database integrity checks with a special TSQL script, reduce downtime, and improve performance in large databases.
Eitan Blumin
Nov 26, 20241 min read


The Databricks Debugger
Writing flawless code on the first try is a dream, but debugging is a reality for most developers. In this post, I dive into the new Databri

Chen Hirsh
Nov 17, 20241 min read


Resolving and Preventing Deadlocks in SQL Server
In this blog post, we'll discuss how to troubleshoot and prevent deadlocks in SQL Server.
Eitan Blumin
Nov 16, 20247 min read


אופטימיזציה של תהליכי ETL: כיצד לשפר את הביצועים והמהירות
במציאות הדינמית של היום, בה ארגונים מתמודדים עם כמויות עצומות של נתונים, תהליכי ETL נחשבים לכלים חיוניים לניהול הנתונים. עם זאת, כאשר...

Madeira Team
Nov 7, 20242 min read


הטעויות הנפוצות ביישום שירותי BI ואיך להימנע מהן
שירותי BI (בינה עסקית) הם כלי עוצמתי שמאפשר לארגונים להפיק תובנות מנתוני החברה ולקבל החלטות עסקיות מושכלות. עם זאת, בתהליך יישום BI, ניתן...

Madeira Team
Nov 7, 20242 min read


How to enable system tables on Databricks
System tables on Databricks can help us monitor and manage our Data Warehouse.

Chen Hirsh
Nov 4, 20241 min read


Microsoft SQL Server on Amazon Web Services Cloud
Today one of my customers asked me to help him with SQL Server installation using his AWS cloud account. So, it's a great opportunity to...

Vitaly Bruk
Oct 30, 20242 min read


Clean Data with Spark
Cleaning data is a very common task for data professionals. The data we read from source systems are sometimes corrupt, duplicated, or...

Chen Hirsh
Oct 16, 20241 min read
bottom of page
