Notes on SQL

Random articles from a puzzled DBA

Background SQL Server Management Studio (SSMS) is now a separate installation, so it can be updated without any impact on the SQL Server engine. Updating the newer versions is as easy as you would expect but removing an older SSMS that was included as part of SQL Server requires a little bit of concentration.

Background I know, I know – I should be using Extended Events instead of Profiler, but I still have a soft spot for Profiler. Profiler is deprecated and in theory could vanish with little warning – it certainly isn’t having the enhancements that Extended Events is getting. One of these enhancements has just arrived in …

Continue reading