SQL Server 2014 Enhanced Debugging Functionality

Since SQL Server 2012 introduced enhancements to interactive debugging in SQL Server Management Studio, including the ability to:

• Specify break conditions, filters, and actions. You can use a breakpoint condition to supply a Transact-SQL expression that the debugger evaluates when a breakpoint is reached. When defining a breakpoint condition, you can use the Is true option to specify that that when the expression is true, the debugger will break execution. You can use the Has changed option to specify that when the value of the expression changes, the debugger should break the transaction. You can use breakpoint filters to specify that a breakpoint should only act on certain computers, processes, or threads. You can use breakpoint actions to change the default behavior of breaking a transaction when a breakpoint is reached. For example, you can create an action that prints a message to the debugger output window.
• Monitor Transact-SQL expressions in the Watch and Quick Watch windows.
• Display a Quick Info pop up by holding the mouse over a Transact-SQL identifier