Color code the SQL Server Management Studio status bar so you always know which server you are on before you run a script. A quick video.
Comparing Session SET Options Between SSMS and the Application
Fast in SSMS, slow in the app? The query may be fine and the connection settings different. Here is how to check, with nothing to set up.
SQL SERVER – How do I Record Video and Webcast – Milestone – 2200th Blog Post – SQL in Sixty Seconds #022 – Video
My 2200th blog post and the 22nd SQL in Sixty Seconds episode: a short video on how I record video and webcast content, plus thanks to the people who help.
Generate Script for Schema and Data in SQL Server: SQL in Sixty Seconds #021
To generate script for schema and data, choose Schema and data in the SSMS wizard and review the result before you run it. The tests here build such a script with T-SQL on SQL Server 2025 and show three ways it breaks: identity columns, apostrophes and the 1,000 row limit.
SQL SERVER – 2012 Functions – FORMAT() and CONCAT() – An Interesting Usage
An interesting way to use the SQL Server 2012 FORMAT() and CONCAT() functions together to show a string like Current Time is Sunday July 16, 2012.
Debug Button in Older SSMS: SQL in Sixty Seconds #020
The Debug button in older SSMS could be mistaken for Execute, and the debugger is gone from current versions. This page keeps the 2012 episode and tests four ways to debug T-SQL without it on SQL Server 2025: parse only, error line numbers, progress messages and the OUTPUT clause.
![SQL SERVER - CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis](https://blog.sqlauthority.com/wp-content/uploads/2012/07/cursor3.jpg){kind=small}
SQL SERVER – CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis
CTRL+SHIFT+] in SSMS lets you select code between two parenthesis, handy for subqueries and CTEs. Here is how it works at a few cursor positions.