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 Advisor implementation with a demo in this blog post. This tool helps customers in migrating…

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 provided in the past, but we now have the feature for encrypted backups integrated with…

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 some already installed clustered instance, or to continue the installation of a brand new clustered…

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 this feature is that this is installed with the SQL Server 2014 Engine without requiring…

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 install the first node of a clustered SQL Server 2012 instance and how to basically…

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 mentioned are followed properly. This will be helpful when one ISO file is used for…

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 VHD files through a shared and accessible to all nodes volume. Supported from Windows 2008…

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 CTP 2 with screen shots. Future release or final release may not be exactly same…

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 Result ————————————- Rule “Previous SQL product installation” failed. A SQL product other than SQL Server…

Page 6 of 50« First Page...45678...20...Last Page »