Click here to Skip to main content

Submit your article

SSMS

SSMS

Great Reads

How to Generate C# Classes from Microsoft SQL Server

by Mashudu Nemukula

Generate C# object class from common SQL databases types

How to Create SQL Server Management Studio 18 (SSMS) Extension

by Stefan Timovski

Tutorial on how to start developing SSMS extensions

Debug Stored Procedures in Visual Studio and SSMS

by Kuv Patel

Debug stored procedures in Visual Studio and SQL Server Management Studio.

How to Migrate SQL Database to Azure SQL Database using SSMS Export/Import

by Vivek Johari

Migrating SQL Database to Azure SQL Database using SSMS Export/Import Contents

Latest Articles

SQL Table Dependency Diagram Generator (SSMS 18,19 & 20)

by Bert O Neill

This article provides an overview for developers, on how to quickly generate a dependency Entity Relationship Diagram for a table and its immediately related tables, within SQL Server.

spSearchTables: Search and Find Tables or Columns by Name or Value

by Federico Di Marco

spSearchTables: a helper T-SQL stored procedure for digging into (large) databases

Query Excel or CSV files with T-SQL

by Federico Di Marco

Query Excel or CSV files with T-SQL without importing them in a table first

Visual Studio Box Selection with Alt Key

by Vadim Loboda

This is an alternative for "VS2010 Box Selection with Copy and Paste"

All Articles

SSMS

Build Your Own Movie Database with SQL Server

24 Oct 2016 by Aless Alessio

Use the OLE Automation Procedures to retrieve data from a Web Service and parse the JSON response into a table format

SSMS Configure Auto Commit

7 Mar 2016 by connect ashish yadav

Configure Auto-Commit in SQL Server Management Studio to avoid accidental query execution

Who Logged In Using SA Credentials?

1 Feb 2016 by Deepak A S

An ALL SERVER trigger to know who it is!

Query Excel or CSV files with T-SQL

24 Oct 2023 by Federico Di Marco

Query Excel or CSV files with T-SQL without importing them in a table first

Code Generator for SQL Server

8 Jan 2020 by Homero Ibarra Ramírez

Tool on T-SQL to code basic generator for SQL Server

Applying Database Principal Throughout the Server (for all Databases) for a Particular User

10 Sep 2018 by Manjuke Fernando

How to give db_datareader access to a specific user across all the databases on a particular SQL Server

How to Generate C# Classes from Microsoft SQL Server

11 Jun 2021 by Mashudu Nemukula

Generate C# object class from common SQL databases types

Create Query Shortcuts in SQL Server Management Studio

31 Jan 2017 by saddam_msp

Shortcuts to execute your query faster while working or debugging T-SQL statement

SSMS 2016: Enhanced Scrollbar

5 Sep 2016 by Suvendu Shekhar Giri

Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016

SQL-Server-2016

Move Database File from One Drive to Another Drive

17 Oct 2018 by User-12551084

Moving database file from one drive to another drive

Visual Studio Box Selection with Alt Key

24 Jun 2023 by Vadim Loboda

This is an alternative for "VS2010 Box Selection with Copy and Paste"