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…
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…
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…
Today I noticed couple of changes(Neat changes !) for Data Collector in SQLServer 2014. This post is a detailed walk-through of setting up Data Collector in SQL2014. In the walk-through if…
Hot cake for the day is SQLServer 2014 RTM bits. Its generally available starting today, and I downloaded a fresh copy to start testing it. I will be writing a…
SQLServer 2014 CTP2 came with an inbuilt tool called Memory Optimization Advisor which will help you in migrating your normal tables to memory optimized tables. Where can I find this…
SQL Server 2014 CTP2(All new,shiny shiny !) availability was announced yesterday at #SQLPASS Summit. Native backup encryption is one of the key features which was announced with this release, and…
Starting SQL 2014 monitoring memory usage of the memory optimized objects is super important to ensure that your instance don’t run out of memory and cause real bad situations. One…
You must be really busy spinning up VMs to test SQL Server 2014 CTP1 and Windows Server 2012 R2 preview. If your on-premise desktop computer/laptop is running low on resources…