"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

Data integration: rsync with a networked drive

I have been asked about this on several occasions so I thought it was worthy of a blog post. Scenario The scenario is an automated recording device connected to a remote Linux machine. The data are written to files in a known directory on the Linux filesystem. The Linux machine is connected to a local network that also has a large networked drive [...] Read more

< 1 2 3 4 5 6 7 >