SQL Server 2012

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 →

T-SQL Tuesday #62 – Healthy SQL

 SQL Health Checks Healthy SQL is an important topic… I’ve gotten involved in a number of SQL health checks and would like to share some of the key methodology, metrics investigated and tools/utilities used. There are at least two main … Continue reading →

Rollback procedure for SQL Server updates

As a follow-up to the post, how to install a service pack for a SQL Server cluster, it is important to have the ability to roll back an update. Fortunately, Microsoft has made this process fairly easy. The following process … Continue reading →