Data Protection in the news

Today data protection makes it into the news. The UK Government will be talking about the new legislation preparing for the changes in the data protection legislation General Data Protection Regulation (GDPR) that comes into force in May 2018. The GDPR regulation will remove the "pre-populated" consent boxes and those complicated sentences with [...] Read more

"GDPR - Making it real" Meeting June 2017

On Monday 12 June I attended a joint event hosted by DAMA-UK and BCS Data Management Specialist Group on the implementation of the General Data Protection Regulation (GDPR) . The GDPR is a new law that will replace the Data Protection Act 1998 (DPA). Presentations throughout the day were made by the Information Commissioner's Office (ICO), [...] Read more

SQL Server alert to monitor disk space.

In SQL Server you can set up alerts that access the Windows Management Instrumentation (WMI) directly. I was looking at an unrelated Powershell task when I stumbled across an example of using the WMI query WQL on Microsoft's Dev Centre pages that shows the use of __InstanceModificationEvent system class on the Win32_LogicalDisk object. FreeSpace [...] Read more

Powershell and SQL Server Agent anomaly.

Powershell is a great tool for DBAs based on Microsoft platforms and it is getting even more useful now that it can be used to directly manage cloud services in Azure. Today I encountered a very strange situation when using a Powershell job step with SQL Server Agent on SQL2012. Below is a very simple Powershell script that I use to manually [...] Read more

Numerical data and histograms.

In this post I am focusing on presenting continuous or discrete numerical data using a histogram. Visualising your underlying data using a histogram is probably the easiest way to understand the behaviour of a given data value. Histograms are very basic and aren't very impressive in today's world of dazzling infographics, but generating histograms [...] Read more

< 1 2 3 4 5 6 7 >