For all these years Windows Server 2016 is the Windows version I was waiting for, and this blog post will explain why I’m super excited about this! With Windows Server 2016, you can…
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…
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…
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…
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…
A short and sweet post for a gorgeous morning – Have you seen a file with extension .wrk in the log shipping copy folder ? What is this all about, Curious? Then here is…
In development environments I prefer to use ‘detach’ database option to move around databases. It’s simple, fast and easy. Almost all the time when I detached a database earlier the…
One of the advanced Server level options for SQL Server is Max Text Replication Size and this is really not a common one. In most of cases the default value is not…
When your cluster install fails, then there is lot to learn!!! Today I am writing about my very recent experience working on a clustering deployment. It was for a two node cluster with…
Automatic Page Repair is one feature which is not really famous, however pretty much known to most of us. I wanted to write about Automatic Page Repair since a very…