With the General Data Protection Regulation (GDPR) becoming a focus point for many organisations, data owners are investing in ways to better protect their customers' data. Microsoft has invested heavily in a range of new security capabilities in SQL Server 2016 such as Row-Level Security, Dynamic..
Matt Robertshaw
Recent Posts
Clustering SQL Server 2008 R2 on Windows Server 2012 R2
I recently had to install a SQL Server 2008 R2 failover cluster on Windows Server 2012 R2. Some of you may be wondering if this is actually supported. A quick look at the hardware and software requirements for SQL Server 2008 R2 indicates that it is indeed supported.
Converging tables with PowerShell and TableDiff
If you've ever had to troubleshoot non-convergence with SQL Server Replication and not been able to initialize from a snapshot or backup, you could be left with the complex task of manually synchronising individual tables. Non-convergence is a term used to describe the differences in rows between..