Category Archives: SQL Server

How to set different connection colors in SSMS

Posted On June 21, 2021 by Jaison Menezes Posted in Tagged in ,

In Microsoft SQL Studio Management Server (SSMS) there is an interesting feature that helps users quickly determine which connection tab they are using currently this can be done by setting custom connection colors in SSMS for different SQL Server nodes. In this blog we are going to see how we can use this feature Open … Continue reading How to set different connection colors in SSMS

Share Story :

Displaying Line Number in SSMS Query Editor

Sometimes while working on large SQL Queries we may face errors. SSMS tells us the line where the error has occurred after the faulty query gets executed but there is no line no. in the Query editor so it is tedious sometimes to fish out these errors. The solution to this issue would be adding … Continue reading Displaying Line Number in SSMS Query Editor

Share Story :

Use Web Browser along side SQL Query editor

Posted On April 22, 2021 by Jaison Menezes Posted in

Sometimes while writing SQL Queries we would feel the need to refer to the internet for logic, syntax etc. But constant switching between our web browser and SSMS would interrupt our flow while writing queries. This problem can be solved by using SSMS’s inbuilt web browser. It can be accessed pressing CTRL+ALT+R As you click … Continue reading Use Web Browser along side SQL Query editor

Share Story :

How to convert SQL table into Excel sheet and Excel sheet into a SQL Table

Introduction: Sometimes a user wants to analyze their SQL query results in Microsoft Excel or import existing Excel data sheets as tables in SQL in order to do various data transformations. In both scenarios we can achieve this goal as: Converting Data from SQL table to Excel sheet: Go to tools option on the toolbar … Continue reading How to convert SQL table into Excel sheet and Excel sheet into a SQL Table

Share Story :