(Prashanth Jayaram) SQL Server is the most popular relational database management system, which is used by many organizations to maintain their data. Every user expects that data should be stored in a consistent and integrated form.

(Pinal Dave) Recently I was trying to help a customer who was deploying AlwaysOn Availability Group in Microsoft Azure via template deployment.

(Andrew Pruski) One of the server settings that I always enable when configuring a new instance of SQL is database instant file initialization.

(Shaun J. Stuart) I’ve been spending some time lately working with statistics, specifically auto-created statistics. When auto-create statistics is enabled, SQL Server will create column statistics when it needs them.

(Koen Verbeeck) In the new release of Master Data Services (MDS) in SQL Server 2016, a couple of new features have been added in order to improve performance. In this tip, we’ll introduce the capability to enable data compression on an entity.

(Jason Brimhall) It has been nearly a year since I started an extensive series about Extended Events. Previous to that start, I had already written a bunch of articles about Extended Events.

(Denny Cherry) Up until August 1st if you had 2 vNets in the same Azure region (USWest for example) you needed to create a site to site VPN between them in order for the VMs within each vNet to be able to see each other.

(Arshad Ali) Organizations have been focusing more and investing heavily in Analytics, to gain the knowledge required to make improvements or changes to enhance business.

(Pinal Dave) If you have come on this page by internet search, then you must have seen below error in the ERRORLOG which is about deadlock scheduler.

(Nakul Vachhrajani) Recently, I asked to troubleshoot a performance issue with a stored procedure that was being used for reporting purposes. Looking at the execution plan, I realized that while the joins and the filters were as expected, the core bottleneck were sub-queries in the CASE expression.