SQL Server 2014

SQL Server 2012 and 2014 Hit with Security Vulnerabilities

Microsoft has released patches today to sew up some holes in its SQL Server product – specifically for the 2012 and 2014 versions. Security Update for SQL Server 2014 Service Pack 2 CU (KB3194718)  Security Update for SQL Server 2012 SP2 CU (KB3194725) Security Update for SQL Server 2012 Service Pack 3 GDR (KB 3194721) Looking for an awesome, no-nonsense technical conference for IT Pros, Devs, and DevOps? IT/Dev Connections kicks off in San Francisco in 2017!

T-SQL Tuesday #66: Monitoring

Topic today is monitoring. Catherine Wilhelmsen (b|t) is hosting this month’s T-SQL Tuesday blog party. The party was started by Adam Machanic (b|t) in December of 2009. I’ve been looking a lot of SQL Server installations over the past year. … Continue reading →

Migrating databases between SQL Server instances

If you ever have a need to migrate SQL Server databases between servers; particularly a backup/restore scenario, you need to be aware that the database security login ids are not automatically migrated. Here are some notes on this task. Once … Continue reading →

ConfigMgr 2012 R2 support for SQL Server 2014

ConfigMgr 2012 R2 does support SQL Server 2014, but only if it had been installed with SQL Server 2012, then upgraded to SQL Server 2014. The interesting part arises, what if you have to perform a restore of ConfigMgr 2012 … Continue reading →