New in SSMS 17.4 – Vulnerability Assessment

[Guest post by Oren Buoni EMEA SQL Server PFE) SQL Server Management Studio (SSMS) version 17.4 brings a cool new feature. Vulnerability Assessment [VA], is a great new feature which analyzes your database and generates a report with vulnerability issues that may harm or impact your database. In a one-step wizard, you can start the…


SQL Azure troubleshooting, some ideas and scenarios.

While I was working in a customer request about SQL Azure troubleshooting, I noticed sometimes when we compare the flexibility of SQL on premises tools and SQL Azure, we may feel we are kind of limited. The purpose of this post it is demonstrate something about SQL Azure troubleshooting, at least considering what is available…


Query Store: How it works? How to use the new Query Store Catalog Views?

Part 2 /*Fix 2017.03.28: Not Query Store DMVs but Catalog Views. Thanks Kalen Delaney for point it*/ “The SQL Server Query Store feature provides you with insight on query plan choice and performance. It simplifies performance troubleshooting by helping you quickly find performance differences caused by query plan changes. “msdn. If you want to know,…