Skip to content
  • Facebook
  • GitHub
  • YouTube
  • Pinterest
My Tec Bits
  • Home
  • Microsoft
    • .Net
      • ASP.NET
      • MVC
      • Visual Studio
    • IIS
    • SQL Server
      • SQL Server 2019
      • SQL Server 2017
      • SQL Server 2016
      • SQL Server 2014
      • SQL Server 2012
      • SQL Server 2008
    • Windows OS
  • Web Development
    • Java Script
    • Jquery
    • Python
    • Bootstrap
    • Zurb Foundation
    • Web Security
  • More
    • macOS
    • Reviews
  • Online Tools
    • Fitness Calculators
    • Encoders & Decoders
    • Cryptography
    • Unit Converters
    • Math. Calculators
    • Date & Time Calculators
    • Finance Calculators

SQL Sever Management Studio (SSMS)

How to export a table to JSON file in SQL Server?

Jan 12, 2022 by Beaulin Twinkle

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.

Categories SQL Server Tags SQL Server 2019, SQL Sever Management Studio (SSMS), Transact-SQL (T-SQL) 1 Comment

How to enable XP_CMDSHELL in SQL Server?

Jan 7, 2022 by Beaulin Twinkle
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”

Categories SQL Server Tags Azure Data Studio, SQL Server 2019, SQL Sever Management Studio (SSMS), Transact-SQL (T-SQL) Leave a comment

How To Troubleshoot IntelliSense in SSMS

Dec 17, 2021 by Beaulin Twinkle
Troubleshoot IntelliSense - Enable In Settings

Here are a few techniques which I have used to troubleshoot IntelliSense In SSMS if it stops working for some reason.

Categories SQL Server Tags SQL Server 2019, SQL Sever Management Studio (SSMS) Leave a comment

Why am I unable to save changes after editing table design in SSMS?

Nov 25, 2020 by Beaulin Twinkle
Unable To Save Changes After Editing A Table Design In SSMS

Solution for unable to save changes after editing table in design window of SQL Server Management Studio.

Categories Others, SQL Server Tags SQL, SQL Server 2019, SQL Sever Management Studio (SSMS), Transact-SQL (T-SQL) Leave a comment

Formatting SQL statements in SSMS

Dec 13, 2019 by Beaulin Twinkle
After 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.

Categories SQL Server Tags SQL, SQL Sever Management Studio (SSMS), SQL Tips, Transact-SQL (T-SQL) Leave a comment

Reduce Index Fragmentation

Sep 13, 2018Aug 29, 2018 by Beaulin Twinkle
Reduce Index Fragmentation - Reorganize Indexes popup window

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.

Categories SQL Server Tags SQL, SQL Server 2017, SQL Sever Management Studio (SSMS), Transact-SQL (T-SQL) Leave a comment

Compatibility Level Field Is Disabled In SQL Server

Apr 17, 2018Apr 13, 2018 by Beaulin Twinkle
SQL Server Compatibility Level Disabled

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.

Categories SQL Server Tags Database, SQL, SQL Sever Management Studio (SSMS), SQL Tips, Transact-SQL (T-SQL) Leave a comment

Auto Generate INSERT Statements for a Table in SQL Server

Aug 18, 2018Dec 27, 2017 by Beaulin Twinkle
Auto Generate Insert Script in SQL Server 05

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.

Categories SQL Server Tags SQL, SQL Server 2016, SQL Server 2017, SQL Sever Management Studio (SSMS), SQL Tips 7 Comments

SQL Server Development And Management Tools

Aug 18, 2018Nov 29, 2017 by Beaulin Twinkle
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.

Categories SQL Server Tags Azure SQL Database, MSSQL-CLI, SQL Operations Studio (SQLOPS), SQL Server Data Tools (SSDT), SQL Sever Management Studio (SSMS), Visual Studio Code 1 Comment

Installing SQL Server Management Studio (SSMS)

Aug 18, 2018Aug 9, 2017 by Dahlia Sam
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.

Categories SQL Server Tags SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Sever Management Studio (SSMS) Leave a comment

Article Categories

  • Android (2)
  • Apple (21)
    • macOS (21)
  • Internet & Web Dev. (144)
    • DNN (4)
    • Java Script (10)
    • Jquery (8)
    • PHP (7)
    • Python (75)
    • Twitter Bootstrap (25)
    • Web Security (11)
    • Zurb Foundation (6)
  • Linux (2)
  • Microsoft (296)
    • .Net (64)
    • IIS (10)
    • Internet Explorer (3)
    • Office (2)
    • SQL Server (209)
    • Windows (23)
  • Networks And Distributed Systems (2)
  • Oracle (7)
    • Java (2)
    • Oracle Database (5)
  • Others (5)
  • Reviews (10)

Recent Articles

  • How to find the index of an item in a list in Python? Mar 19, 2023
  • How to check if the given string is a number in python? Mar 10, 2023
  • IIF vs CHOOSE in SQL Server Mar 2, 2023
  • How to insert multiple records with a single SQL query? Feb 25, 2023
  • How to drop all the tables from a database in SQL Server? Feb 25, 2023
  • How to reset user settings in Visual Studio Code? Feb 8, 2023
  • How to launch Visual Studio Code from macOS terminal? Feb 3, 2023
  • How to use CHOOSE in SQL Server Jan 28, 2023
  • How to make SQL script to sleep? Jan 13, 2023
  • How to make a PHP script to sleep? Dec 30, 2022

Subscribe MyTecBits.com

Online Tools

  • Fitness Calculators
  • Encoders & Decoders
  • Cryptography
  • Unit Converters
  • Math. Calculators
  • Date & Time Calculators
  • Finance Calculators

Popular Articles

  • How to compare contents of two files in Visual Studio Code?
  • SQL Server: Concatenate Multiple Rows Into Single String
  • How To Get Day Of Week In SQL Server?
  • Getting The List Of Column Names Of A Table In SQL Server
  • SQL Server: Search and Find Table by Name
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use. Learn more...
  • Home
  • About Us
  • Contact Us
  • Site Map
  • Terms Of Use
  • Privacy Policy
© 2012 - 2023 My Tec Bits. All Rights Reserved.