How do you sort query results by a column passed in a variable? Here is how to sort query output dynamically without EXEC or sp_executesql.
SQL SERVER – Event ID 107- Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.
Event ID 107 says the Report Server Windows service cannot connect to the report server database. Here is how I fixed it.
SQL SERVER – Maintain Carriage Return (Enter Key) in SQL Server 2016 Management Studio While Copy and Paste
Copy grid results with line breaks and paste them: SQL Server 2016 Management Studio drops the carriage returns. Here is the setting that keeps them.
SQL SERVER – Puzzle – Solve Splitting Strings Puzzle
A Splitting Strings puzzle: take a column holding delimited values, split them and return how many values each row has. How would you solve it?
What You May and May Not Do With SQL Server Developer Edition
Understand Developer Edition rights, identify the installed SQL Server edition, and keep shared test systems separate from production work.
SQL SERVER – Identifying Application vs Network Performance Issues
But what do you do? Let us learn in this blog about How to Identify Application vs Network Performance Issues and their solution.
SQL SERVER – SSMS Tip: How to Get Larger Fonts for Results in Grid Output
At GIDS I could not read a speaker’s SSMS output from the back row. Here is a quick SSMS tip to get larger fonts for results in grid output.