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…
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 –…
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…
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…
Today Microsoft announced their next major version of SQLServer, SQL Server 2014 at Tech-Ed NA 2013. This version of SQLServer is indeed a reflection of Microsoft’s vision towards the future computing. A bright…