(Shaun J. Stuart) I’m in the process of creating a post about statistics and came across something in SQL Server Management Studio that was driving me crazy. I thought I’d post it here so that others might not waste an hour or two like I did puzzling over this.

(Jason Brimhall) Finding the right event or combination of events to monitor may seem like quite a daunting task with so many events to explore and xvnt_crossing(frequently) too little familiarity with Extended Events.

(James Serra) For companies that sell an on-prem software solution and are looking to move that solution to the cloud, a challenge arises on how to architect that solution in the cloud. For example, say you have a software solution that stores patient data for hospitals.

(Pinal Dave) This is one of the most interesting stories written by my friend Syrovatchenko Sergey. He is an expert on SQL Server and works at Devart. Just like me he also shares his passion for Wait Stats and new features of the SQL Server.

(Michael Otey) Before you upgrade to SQL Server 2016, review the hardware and software requirements and the supported upgrade paths to help make sure your deployment of the database goes smoothly.

(Kunal Chandratre) A skinny to-the-point overview of the Microsoft Azure Platform and its AWS equivalent

(Joe Celko) With the formatting of code, we sometimes do things because they’ve always been done that way, rather than making code easier to understand. Occasionally these habits get in the way of readability.

(Fikrat Azizov) The SQL Server query cache contains valuable performance statistics and execution plans of recently executed query workloads that can be useful to tuning your server.

(Kenneth Fisher) When restoring a database there are times when it would nice to restore a bit, check what’s been restored so far, restore a bit more etc. However, traditionally most people only know RECOVERY and NORECOVERY.

(Pinal Dave) In this blog post we will be learning about tracking database dependencies.