Views in SQL Server 2019 with SSMS

This article explores how to create and use views in SQL Server 2019 using SSMS.

Azure Data Studio vs SSMS - Who is the winner?

Introduction I have to admit that I love SSMS. It is a great tool, and I felt furious when a colleague mentioned that Azure Data Studio will replace SSMS in the long run. In this new article, we will talk about the main differences between Azure Data Studio and SSMS. We will see if my […]

Comparing Execution Plans

How to Check SQL Server Version When Service is Not Running

In this article we look at several ways to find the version of SQL Server that is installed when the SQL Server service is not running.

SQL Server Management Studio Database Diagram Support Objects Cannot be Installed

In this article we look at how to resolve the error database diagram support objects cannot be installed because the database does not have a valid owner.

The Separation of Tools

SSMs and ADS are the new tools for SQL Server and the data platform, both of which are now available separately from SQL Server.

Adding Custom Stored Procedure Templates to SQL Server Management Studio and Visual Studio 2019

In this article we look at how to build a custom stored procedure template that can be used in either SSMS or Visual Studio for all new development.

Top 5 SSMS Time Saving Tips

In this article we look at how you can use SSMS to filter objects, debug, drag and drop object names, add custom reports and use of operators for emails.

How to Get Started with SQL Server Management Studio

Learn How to Get Started with SQL Server Management Studio with Brent Ozar.

SQL Server Management Studio Connection to Integration Services Error Class Not Registered

In this article we look at some reasons why you cannot connect to SSIS using SQL Server Management Studio and how to solve the problem.