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 function with greater availability if a single instance fails. By using Failover clustering and also placing virtual machines in an availability set, ensure that the application can work regardless of a hardware failure / Host updates or an application instance failure.

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 R2 Media, if you try to install it against a SQL 2014 Server, you will not be able to proceed ahead with the install.

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 from Microsoft SQL Product team blog http://blogs.technet.com/b/dataplatforminsider/archive/2014/04/01/sql-server-2014-now-generally-available.aspx SQL Server 2014 Datasheet