SQL Server Monitoring Week – SQL Monitor

Today I begin a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary job is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help the customer with their various SQL Server performance issues, I often see my customers struggle with the monitoring their SQL Server’s health. One of the primary discussion at the end of consultation which we do is what tool is the best for their environment and how it can prevent them to walk into another trouble. Today we will talk about SQL Monitor (SM) in brief.

Read More

Data Privacy – Are Your Database Processes Fully Compliant?

This year has been filled with data privacy and protection concerns. From the introduction of the General Data Protection Regulation (GDPR) and the exposure of data breaches at Cambridge Analytica, Facebook and Under Armour, to new legislation springing up in the US, including New York’s Stop Hacks and Improve Electronic Data Security Act (SHIELD) and the California Consumer Privacy Act (CCPA). Stories about the value of data – and the risks associated with it – are everywhere. As data professionals, the pressure is there to achieve a balance between compliance and the need to deliver faster than ever.

Read More