Did you say Data Masking?
Author: Eric Rouach, Madeira Data Solutions Date: August 2022 If you are using SQL Server and need a lightweight encryption solution at...
Search
Guy Glantser
- Aug 1
- 2 min
Track SQL Errors
Here is a script to create an event session that captures SQL errors with all the information you need...
Guy Glantser
- Jul 27
- 3 min
Should You Split Queries?
The SplitQuery feature in EF is a terrible feature in most cases. Developers should avoid using it.
Guy Glantser
- Jul 21
- 5 min
A Useful Script to Delete Data from Multiple Tables
Sometimes you need to delete data from multiple tables with foreign keys. Here is a useful script that can save you a lot of time...
Guy Glantser
- Jul 10
- 2 min
Use Filtered Statistics to Improve Performance on Very Large Tables
Let’s say you have a very large table on SQL Server 2012 Standard Edition. Most of the time you get poor performance. What can you do?
Guy Glantser
- Jul 10
- 5 min
The Performance Tuning Magic Show @ DPS2022
I'm excited about delivering a pre-con session in Data Platform Virtual Summit 2022 - The Performance Tuning Magic Show
Guy Glantser
- Jul 9
- 1 min
Can I Pause and Resume an Index Rebuild Operation?
One of the cool features introduced in SQL Server 2017 is the option to pause and resume an online index rebuild operation...
Eric Rouach
- Jul 2
- 2 min
Extract, Transform...and, send an e-mail!
Author: Eric Rouach, DBA at Madeira Data Solutions Date: July 2022 If you need to extract data from a SQL Server/Azure SQL database,...
Guy Glantser
- Jun 25
- 2 min
How to Identify and Fix Tempdb Contention
Here is all you need to know about the two types of contention in tempdb...
Guy Glantser
- Jun 19
- 4 min
Do You Have a Proper Backup Strategy?
Research shows that we are more likely to lose our database in the coming year - don't let that happen to you!