Author: Prakash Karia

Today we are going to discuss one of the powerful new functions of SQL Server 2012. The name of the feature is Distributed Replay which can be used to assess the impact of changes and upgrades or SQL Server tunings…

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…

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…

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…

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…

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 https://technet.microsoft.com/en-US/evalcenter/dn205290.aspx. This post covers a step-by-step installation guide of SQL Server 2014…

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…

Introduction: Almost all of us in our DBA life would have patch/upgrades SQL Server instance and would have faced many issues while upgrading the SQL Server build. Today I will discuss in little detail about the background of the Script…

Introduction: We will discuss Column Store Index and will try to understand the performance improvements of the same query by multiple times using column store index. What is Column store Index: Column Store Index is a feature introduced in SQL Server 2012…

Recently I was trying to upgrade SQL Server 2008 to SQL Server 2008 R2. The upgrade failed with error message below.   TITLE: Message Details —————————— The Instance ID ‘MSSQLSERVER’ is already in use by SQL Server instance ‘MSSQLSERVER.INACTIVE’. To…