Friday, January 24, 2020

Query debugger is deprecated in SQL Server Management Studio v18.4

Maybe it will come back if enough people rant!

It looks like it has been deprecated in SSMS 18. I have SSMS v 18.4 installed and the icon is missing. Also missing is the Execute with Debugger drop-down menu in the query pane context.

Debug icon present in 2012 and 2017 SSMS. Missing in v18.4 in the 2019 version.


Missing in the Query drop-down menu. It should have been present below 'Execute'.


Scripting options in SQL Server 2019

What are the scripting options in SQL Server 2019?
The Scripting options can be accessed from Tools: Options in the SQL Server Management Studio v18.4.



In the Options window drill-down on SQL Server Object Explorer | Scripting as shown.

 Expand the node, General scripting options to display the following:


 Expand the node, Object scripting options to display the following:


 Expand the node, Table and view options to display the following:

 Expand the node, Version options to display the following:

In each version of SSMS, the Options window is slightly different or arranged differently.

XEvent Profiler in SQL Server 2019

XEvent Profier's role in SSMS is for troubleshooting SQL Server Issues such as slow running queries, identify long-running queries, monitor SQL statements, etc. From Version SQL Server 7.0, SQL Profiler was used, but it was not easy to use due to the lack of a GUI.

SQL Profiler was replaced by XEvent Profiler which is easy to use and presents a quick view of Extended Events.
XEvents is a feature of SSMS and not SQL Server and it was available in SSMS V17.3.

It is also available in SSMS V18.4 which is the latest version of SSMS as of now. You can find in the Object Explorer (bottom-most node)  of SSMS as shown here.



Friday, January 17, 2020

Debug icon for queries missing in SQL Server Management Studio v 18.4

It looks like it has been deprecated in SSMS 18. I have SSMS v 18.4 installed and the icon is missing. Also missing is the Execute with Debugger drop-down menu in the query pane context.

Debug icon present in 2012 and 2017 SSMS. Missing in v18.4 in the 2019 version.


Missing in the Query drop-down menu. It should have been present below 'Execute'.


Friday, January 10, 2020

Blood sugar measurement made esay

This makes it easier to measure and keep all pieces together neatly. As to accuracy, etc. I am not sure as I have not used it. It needs a phone and an app but no separate hardware.




Next challenges in Diabetes:

Very low-cost test-strips
Easy, cost-effective blood sugar measurement without pricking


Thursday, January 09, 2020

Hands-on Learning Event in Honolulu 1 : Introduction to Structured Query Language

A new session is going to start soon. Sign-up here.


Microsoft SQL Azure Database: SQL Server in Microsoft Cloud
Windows PowerShell for SQL Server


My sincere thanks and best wishes to my students in the previous meets of this course.

DMCA.com Protection Status