SQL Server Management Studio

In this tip we look at how we can use the built-in RegEx features in SSMS 2017 to manipulate and reformat T-SQL code.

In this tip we look at how to create your own custom widget using SQL Server Operations Studio.

In this tip we look at how to use the debug feature in SSMS.

Check out this tip to learn about some of the new features in SSMS v17.x.

In this tip we will demonstrate how the Import Flat File Wizard works and see how useful it is over the Import Data Wizard that already exists in SQL Server.

In this tip we cover how to setup a project in SSMS to organize files.

In this tip we look at how to generate scripts for database and instance level objects using SSMS.

Learn how to install SQL Server Management Studio on your local computer via the Installation Center, direct download and installation ini file.

In this tip we will explore more enhancements in SQL Server 2016 Management Studio.

Watch this video tutorial presented by Kevin Kline to show you the ins and out of getting the most out of SSMS.

Learn about SQL Server 2016 Management Studio Enhancements including code highlighting, inline search, Quick Launch, tab customization, pinning tabs and more.

In this tip I will show you a quick way to find database objects using SQL Server Management Studio.

Learn how to correct SQL Server Management Studio error cannot execute script insufficient memory to continue the execution of the program mscorlib.

Learn about the SQL Server Management Studio Performance Dashboard Reports Overview to understand CPU pressure, wait statistics, query plans and more.

Learn how to fix the SQL Server error: Invalid object name 'master.dbo.spt_values' while launching the database property page of a database in SQL Server Management Studio.

There is always a risk of error when you have very high workload with multiple query windows in a single SQL Server Management Studio session. Here I will discuss how to assign a different color to each server connections in query window. This way we can

Some of our developers noticed an issue a few days after celebrating our successful SQL Server 2012 upgrade. When they run a query in SSMS and copy and paste the results to Excel, each row gets split into many rows in Excel instead of one row like it used

At a project we have multiple filegroups created in our SQL Server data warehouse. For example, there was a filegroup to store the fact tables on, a filegroup for the dimensions, a filegroup for heavy indexes and so on. This works great at first, but afte

We will explore how you can create your own custom reports and add them to SSMS.

Learn how to connect remotely to a SQL Server using Windows Authentication that is in another domain.

I’ve downloaded and installed Performance Dashboard reports for SQL Server 2005 from Microsoft’s download site, but I can’t find Performance Dashboard for SQL Server 2008? How can I use this for SQL Server 2008 and 2008R2? In this tip we show you the wor

I am using an advanced text editor which is capable of selecting and editing columns. This is a very useful feature, for example I can highlight and edit the last 5 columns of each row. Read this tip to find out how using SSMS.

I'm creating a table in SQL Server using SSMS and I'm a little overwhelmed with all of the column properties. In this tip we explain what each property is meant for and the options.

When connecting to SQL Server using Management Studio (SSMS), with the limited permissions, you do not see any user databases or receive Error 916 when expanding the database list from Object Explorer. The error message is The server principal Login Nam