Introducing SQL Operations Studio

Note: This is content that I originally wrote for our upcoming book, SQL Server 2017 Administration Inside Out, that did not meet the publishing deadline. A new cross-platform tool for SQL Server and Azure SQL Database Microsoft has announced the preview of SQL Operations Studio, an exciting addition to the administration and development tooling (DevOps) for[…]

Gimmicks that work: XE Profiler in SQL Server Management Studio

I have a favourite new feature of SQL Server Management Studio 17.3 (SSMS), and that’s XE Profiler, which allows you to monitor your instance in real time using Extended Events from inside SSMS with just the click of a mouse. So is it Extended Events or Profiler? Let’s talk about the name XE Profiler quickly. It[…]