How to export a table to JSON file in SQL Server?
To export a table to JSON file, I have used FOR JSON clause to format the retrieved data as JSON and ran the BCP command through XP_CMSSHELL.
SQL Sever Management Studio (SSMS)
How to enable XP_CMDSHELL in SQL Server?
Enable XP_CMDSHELL to fix the error “SQL Server blocked access to procedure ‘sys.xp_cmdshell’ of component because this component is turned off”
How To Troubleshoot IntelliSense in SSMS
Here are a few techniques which I have used to troubleshoot IntelliSense In SSMS if it stops working for some reason.
Why am I unable to save changes after editing table design in SSMS?
Solution for unable to save changes after editing table in design window of SQL Server Management Studio.
Formatting SQL statements in SSMS
Formatting SQL statements or source code of procedures or function in SSMS is a daunting task. Here you will see how to use a plugin to format T-SQL in SSMS.
Reduce Index Fragmentation
Here is the T-SQL queries to reduce index fragmentation by using either INDEX REORGANIZE or INDEX REBUILD. You will also see when to REORGANIZE and REBUILD.
Compatibility Level Field Is Disabled In SQL Server
Unable to change SQL Server database compatibility level from management studio. Because the compatibility level field in the database properties window is disabled and grayed out.
Auto Generate INSERT Statements for a Table in SQL Server
Easy way to auto generate INSERT statements for a table in SQL Server using SSMS. Generate insert statements from sql server tables on the fly.
SQL Server Development And Management Tools
Top SQL Server Development And Management Tools. List of few popular tools which can be used for MS SQL Server development and management.
Installing SQL Server Management Studio (SSMS)
SSMS for SQL Server 2016 and higher. Installing SQL Server Management Studio Release 15 and higher for SQL Server 2008 or higher.