2 New Things in SSMS 17.2 – I Think You’ll Like.

QueryStoreUI reports now supports additional metrics (RowCount, DOP, CLR Time etc.) from sys.query_store_runtime_stats. Performance Dashboard server report now available as a default report: Can connect to SQL Server 2008 and newer versions. Missing indexes sub-report uses scoring to assist in identifying most useful indexes. Historical wait stats sub-report now aggregates waits by category. Idle and… Continue reading 2 New Things in SSMS 17.2 – I Think You’ll Like.

SQL Server 2014 SP2 Update – Silent Install

Long story short, you should reboot the server twice, before and after running the command. Thanks, Hiram If you want to keep reading, keep going. The installation summary file can be found here, which you can double check the status of the update: C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\Summary.txt First time I tried this, the cmd… Continue reading SQL Server 2014 SP2 Update – Silent Install