Tag: Microsoft SQL Server

SQL Server 2014 CTP2 – Memory Optimization Advisor

Today I am going to discuss one of the amazing new features, Memory Optimization Advisor of SQL Server 2014 CTP2. I discussed architectural details of SQL Server 2014 In-Memory Optimizer in my last blog post here. We will discuss Memory Optimization…

Read More >

SQL Server 2014 CTP 2 : Native Backup Encryption

Today we will discuss the native backup encryption new feature introduced in SQL Server 2014 CTP2. The native backup encryption feature will create an encrypted backup file for SQL Server database. This is a feature that third party vendors have…

Read More >

How to Install a Clustered SQL Server 2012 Instance – Part 3

In continuation of our series on how to install a SQL Server 2012 clustered instance, let’s discuss how to add a node into an existing SQL Server clustered instance. The following steps are performed either to add one more node to…

Read More >

In-memory OLTP Engine (Hekaton) in SQL Server 2014 CTP2

Today I am going to discuss the new SQL Server 2014 feature In-memory OLTP a.k.a. Hekaton — a Greek word which means hundred or hundredfold. In-memory OLTP significantly reduces the time required for OLTP workload processing. The best part of…

Read More >

How to Install a Clustered SQL Server 2012 Instance – Part 2

In continuation of our series on how to install a SQL Server 2012 clustered instance, let´s begin the actual installation, starting from the first node. The objective of this second blog post in my series of three is to demonstrate how to…

Read More >

How to Install a Clustered SQL Server 2012 Instance – Part 1

In this series, I will demonstrate how to install a SQL Server 2012 clustered instance in a cluster of two nodes. In general, the installation will be done in two parts: New instance installation in one of the nodes. Add…

Read More >

SQL Server 2012 – Installation Failed

Today I will discuss a strange SQL Server installation failure scenario,where the setup was failing with a misguided error message. This blog post will be helpful in avoiding any SQL Server installation issues due to bad media if the steps…

Read More >

Increasing the availability of your clustered instance using CSV

The new face on SQL Server 2014, the “Clustered Shared Volumes” technology, or simply CSV, is not that new in the Microsoft world. CSV was used to make the Virtual Machine management easier on Windows environments, facilitating the access to…

Read More >

SQL Server 2014 CTP 2 – Installation

SQL Server 2014 CTP 2 was already announced, which is available now for download as a community technology preview. You can now download SQL Server 2014 CTP2 from http://technet.microsoft.com/en-US/evalcenter/dn205290.aspx. This post covers a step-by-step installation guide of SQL Server 2014…

Read More >

SQL Server 2014 CTP 1 – Installation failure

Recently I was trying to install SQL Server 2014 CTP 1 on my Windows Server 2008 R2 Virtual Machine to explore SQL Server 2014. What I encountered was a failure of a rule “Previous SQL Product installation” ———————————— Rule Check…

Read More >