SSMS

Tutorials on how to use SSMS, abbreviation of SQL Server Management Studio, which is the central tool used to connect and query MS SQL databases. SSMS is also used to deploy and manage MS BI objects like SSIS packages and SSAS cubes and tabular models.

SSMS

Check if object exists with SSMS

28 July 2022

How to add or remove a script to check if an object exists in SQL creation scripts generated with SQL Server Management Studio (SSMS)? To add dynamically the existence check before generating the create statement for you SQL Objects like tables, views,  functions or stored procedures, it’s easy. Simply activate this SSMS option to check object existence in your SQL Server Management Studio software. For example, …

SSMS

Download SSMS 18 (SQL Server Management Studio)

9 March 2022

SSMS allow users to connect to a SQL Server database to query tables or views. But also, SSAS cubes. Or to develop a full database project, SSMS is the most used software, and it’s a free Microsoft tool! How to download the latest SSMS version, i.e., SSMS 18? In other words, this article shows how to download SQL Server Management Studio from the official …