SQL Server Authentication is used primarily used in Azure Services for accessing data, integration, etc. At start during Installation it is disabled by default. So, in this blog we will see how to enable SQL Server Authentication for your Local Server in SSMS. First open SQL Server Management Studio and Connect to Windows Authentication method … Continue reading How to Enable SQL Server Authentication for your Local Server in SSMS →

In this blog we will see how to import/restore SQL Database (.bak) file in SQL Server. If you have a new downloaded .bak file or the Backup of any other database in .bak file format then you can import/restore it in your SQL Server. Open SSMS and Connect to your SQL Server Expand the SQL … Continue reading How to Import/Restore SQL Database (.bak Files) in SQL Server →

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 →

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 →

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 →

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 →