Category: SQL

SQL Server 2016 Failover Cluster Instances in Azure

Microsoft recently announced additional support scenarios for using Guest Clusters in Azure. In this blog post, let’s have a look how we can build a two node SQL 2016 Guest clustering in Azure using Windows Server 2016 Storage Spaces Direct. Utilizing Guest clusters in Azure enables mission critical application such as a SQL backend to

Continue reading
No comments

Service Manager 2012 R2 with SQL 2014

Microsoft announced support for SQL 2014 with Update Rollup 6 for System Center Service Manager 2012 R2. While working on a recent project, I wanted to explore the possibility of building a fresh instance of Service Manager 2012 R2 with SQL 2014. Since UR 6 update is not slipstreamed in to System Center Service Manager

Continue reading

SQL Server 2014 General Availability

Today morning, Microsoft announced general availability for next major release of Microsoft SQL Server product which is called “SQL Server 2014”. I have listed below some of the key highlights of SQL Server 2014 release Up to 30x In-Memory OLTP performance gains New Cloud Migration Wizard Clustered Columnstore indexes – please find below official announcement

Continue reading