Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Anup SivaDas handles the Database Engineering initiatives for Expedia, Inc. (, having IT experience of more than 9 years. Anup is an active blogger with, and can also be found on MSDN SQLServer forums and He has handled multiple SQLServer projects for various fortune 500 companies, and gained enrich proficiency within Database Administration, Database Architecture for Cloud, Consulting, Virtualization, Build, and Production Support activities. Blog | Twitter | LinkedIn

AlwaysOn Availability Group Database Level Health Detection – SQL Server 2016

SQL Server 2016 AlwaysOn AG got many improvements, and I’m pretty impressed with the log throughput improvements and redo improvements based on some of my test cases(A detailed blog post on that will follow soon). In this blog post we will look at another key improvement, ie Database Level Health… Read more

0 comments, 1,494 reads

Posted in on 30 June 2016

Why you should think about upgrading to SQL Server 2016!

SQL Server 2005 is out of support and you might be (Or rather, you should be) planning an enterprise wide upgrade of SQL Server. Are you thinking of upgrading to SQL Server 2014? If yes, then wait! SQL Server 2016 is packed with great features and mainly, there is plenty… Read more

0 comments, 1,390 reads

Posted in on 1 May 2016

Curious case of SYS.MESSAGES

A strange error struck me last week, and this post is all about that.

What you normally expect when you run SELECT * FROM sys.messages? The query will return a row for each message_id or language_id of the error messages in the system, for both system-defined and user-defined messages. Read more

3 comments, 1,089 reads

Posted in on 7 March 2016

Encrypting AlwaysOn Availability Group Transport- Some thoughts!

Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable.

The transport security involves encryption of packets exchanged between the servers involved, and for AlwaysOn AG the encryption is made possible on the Hadr_endpoint.

By default, its encrypted using AES Read more

0 comments, 384 reads

Posted in on 28 January 2016

SQL Server 2016 CTP 3 Setup – UI Improvements

There are some improvements in the setup UI for SQL Server 2016 CTP3, and its great to see Microsoft making these changes as they receive feedback from multiple customers and early adopters.

My earlier post on setup UI changes for CTP 2 is available here.

The 1st change is… Read more

0 comments, 326 reads

Posted in on 11 November 2015

Azure Virtual Machine Blog Series – Changing the size of a VM

I’m starting a new blog series on Microsoft Azure Virtual Machines, and my goal is to write blog posts exclusively on Azure VM/SQL Server related topics.Here is the 1st post –

“Changing the size of a VM”

When creating an Azure VM to host your SQL Server, you have an… Read more

2 comments, 1,118 reads

Posted in on 24 September 2015

SQL Server Data Tools is now a separate installer – Things to know!

Recently I had to develop some SSRS report, and my desktop machine had SQL Server 2014 installed on it. I had previously used SQL Server Data Tools, and I tried to search for it under Programs. To my surprise, it was missing.

I thought I might have missed adding it… Read more

0 comments, 513 reads

Posted in on 8 September 2015

Why I won’t be running SQL Server Standard Edition on Business Critical Servers!

I keep getting questions around what core features are missing in Standard Edition of SQL Server,and why there is a need to install Enterprise edition for business critical systems.Here are my top features which are missing in standard edition –

Scale limits

Memory – Standard only supports 128 GB memory. Read more

0 comments, 798 reads

Posted in on 9 July 2015

Installing SQL Server 2016 CTP2 – UI Changes

SQL Server 2016 CTP2 public build was released by Microsoft yesterday, and if you haven’t downloaded it yet, then drop everything(No, not a Production DB !) and go and get it from here.

This post is based on the UI changes/additions which I observed while I installed this specific… Read more

1 comments, 1,482 reads

Posted in on 29 May 2015

Full Domain Trust and Natively Compiled Stored Procedures – In Memory OLTP

Recently one of my developers brought this specific problem to my attention. He was trying to create a natively compiled stored procedure(With Execute as Owner), and was getting an error –


Could not obtain information about Windows NT group/user ‘Domain\UserName’, error code 0x5.

My first reaction was to… Read more

1 comments, 961 reads

Posted in on 26 May 2015

SQL Server 2016 Announced, and it stretches to the Cloud!

Last week during Ignite, Microsoft CEO Satya Nadella announced the next version(Till then it was called as SQL vNext) of SQL Server, and its SQL Server 2016.

Satya started the Ignite keynote, and he looked really pumped when he announced SQL 2016.

“SQL 2016 perhaps is the biggest breakthrough…

Read more

0 comments, 658 reads

Posted in on 10 May 2015

Exploring AlwaysOn Availability Group Template in Azure

This is one of those posts which is due for a long time. I was really excited when Microsoft announced the release of an AlwaysOn AG template for the Azure Portal back in August 2014.

I had decided to explore this AG template soon after the launch, and this post… Read more

0 comments, 5,720 reads

Posted in on 1 April 2015

This one enhancement makes AlwaysOn Availability Group better in SQL Server 2014 !

I keep getting questions on what is improved other than the increased number of secondaries(8 now) with AlwaysOn Availability Group(AG) in SQL 2014. In this blog post  I would like to talk about one major enhancement around the increased readable secondaries availability in SQL Server 2014.

In SQL Server 2012… Read more

0 comments, 7,369 reads

Posted in on 19 February 2015

SELECT INTO Improvements in SQL Server 2014 !

SQL Server 2014 is a great release with high performance features like In Memory OLTP, Updatable Column Store Indexes etc.

These features still remains as the top favorite and the most compelling reasons for organizations to do an upgrade, However SQL Server 2014 also includes very small but very relevant… Read more

8 comments, 9,221 reads

Posted in on 13 January 2015


Let’s talk about something simple today. You might already be knowing this, but if you haven’t seen/noted this before then this post will definitely help you.

I was working on requirement wherein I had to simulate a workload which will do massive inserts to a table which had computed column.… Read more

4 comments, 6,889 reads

Posted in on 14 November 2014

#SQLPASS #Summit14 Day 2 Keynote Highlights !

This was one of those days I was waiting to happen. You might be wondering whats special? Yes, this day is very special because Rimma Nehme will be giving a keynote on  Cloud Databases 101.

Rimma Nehme is one of those super smart people who works for Microsoft Gray… Read more

1 comments, 451 reads

Posted in on 10 November 2014

#SQLPASS #Summit14 Day 1 Keynote Highlights !

PASS President Thomas LaRock on stage !

PASS President Thomas LaRock kicked off the summit keynote.


Tom talked about the history of PASS and its growth curve. Positive numbers all over the place !

One of the key things to note is that PASS has delivered 1.3 million hours… Read more

1 comments, 532 reads

Posted in on 5 November 2014

My 1st SQL in the City Experience !

I attended my 1st #SQLinthecity event hosted by RedGate yesterday. This is one of those events which I wanted to attend for a long time, and I’m glad I could make it this year.

Attendees registering for the event

This whole day event was packed with some cool sessions, and… Read more

3 comments, 636 reads

Posted in on 5 November 2014

SQLPASS Summit 2014 is here, The largest SQLServer Conference !

November is not the right time to visit Seattle (Blame the rain!), but I kinda like November because that’s when #SQLPASS Summit happens.

SQLPASS Summit is the largest SQLServer conference in the world, and this year the number seems pretty huge with over 5000 attendees !

#Summit14 will be my… Read more

5 comments, 317 reads

Posted in on 3 November 2014

Checking out Windows Server Technical Preview on Azure !

I’m a great fan of running the latest version of Windows Server whenever I deploy SQLServer. I always try to push the latest and greatest windows server builds along with latest SQLServer builds because of many reasons (That can be a whole different post altogether).

I was all excited when… Read more

0 comments, 5,828 reads

Posted in on 4 October 2014

Older posts