Kenneth Urena shows how to use Stretch Database, the SQL Server 2016 feature that moves cold table data to Azure while your queries keep working.
SQL SERVER – System Objects Not Visible in SQL Server Management Studio
Why were system objects not visible in SSMS 2016 when SSMS 2014 showed them on the same instance? A client asked me, and here is the answer.
SQL SERVER – Vertical Select Mode feature in SQL Server Management Studio
Balmukund showed me the Vertical Select Mode in SSMS: hold ALT, select a block, then type on every row at once. It works in SQL Server 2012 and later.
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.
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.