Latest from the COEO blog

Tuesday, April 26, 2016
no comments

Being a futurist, I like new features and SQL Server 2016 and Azure SQL Database have one that’s really caught my eye! ALTER DATABASE SCOPED CONFIGURATION This command lets you set what used to be server level configuration settings on a per-database level.  It  also lets you set different values for the primary and secondary… Read more »

Thursday, April 21, 2016
no comments

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. With that, here are three things you… Read more »

Sunday, April 17, 2016
no comments

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 two tables.  I recently came about this problem… Read more »


Find Us

710 Wharfedale Road,
Winnersh, Wokingham,
Berkshire, RG41 5TP,
United Kingdom