SQL DBA Blog

Tag: SQL Server Management Studio (SSMS)

SQL Server Management Studio (SSMS) Blog Post Archives: Includes tips and tricks for using SSMS, from an experienced Microsoft SQL Server Database Administrator.

  • SSMS 21 (Preview Release)

    This week I installed SQL Server Management Studio SSMS v21 for the first time, which is currently in preview release. From the get-go, I noticed this is shaping up to be a major update to SSMS. The installation process now uses the Visual Studio Installer, which is a…

    Read More

  • How to Filter Objects in SSMS

    SQL Server Management Studio (SSMS) offers a quick filtering feature that lets you narrow down your search by criteria such as name, schema, or creation date, which will definitely save you some time. When working with large databases with a lot of objects in SQL Server, finding specific…

    Read More

  • Download and Install SQL Server Management Studio (SSMS)

    In this short post, I’ll share how to easily download and install SQL Server Management Studio (SSMS) on your Windows computer. I’ll include some tips to help improve your SSMS experience too! Step 1: Download SSMS Go to the official Microsoft website to download the latest version of…

    Read More

  • How to Set the Default Database for SQL Server Users

    This blog post contains a quick guide on how to set your default database in SQL Server using SQL Management Studio. When you log into SQL Server using SSMS and open a new query window, you will automatically be set to use your logins default database which was…

    Read More

  • How to Open SSMS as a Different Domain User

    If you’re connecting to SQL Server within a corporate environment, you might need to connect to SQL Server using a different Domain User account. This can be done by opening SQL Server Management Studio (SSMS) as a another user, which I’ll demo in this post. Connecting to SQL…

    Read More

  • How to Silently Install SSMS

    This is a note on how to silently install SQL Server Management Studio (SSMS) via command (PowerShell). SSMS is a tool most people use when working with SQL Server. If you need to install SSMS on multiple computers, you may want to use the silent installation feature for…

    Read More

  • How to Increase Maximum Characters Displayed in SSMS

    In this post I’m showing you how to increase the maximum characters displayed in SQL Server Management Studio (SSMS). By default, the max number of characters displayed in a single column of a query in SSMS when outputting as text is 256 characters. This means sometimes if we…

    Read More

  • How to Show Line Numbers in SSMS

    This post contains a quick guide on how to show line numbers in the SSMS query window. Useful if you want to see line numbers while you code. As well as general preference, enabling line numbers in SQL Server Management Studio is particularly useful when debugging an error…

    Read More

  • Connecting to SQL Server on Another Domain

    This post contains a guide on how to connect to SQL Server with Windows Authentication, but using a different Domain User other than your own. The regular Windows SQL Server User connects & runs their queries via SQL Server Management Studio (SSMS). If you’re in a corporate environment,…

    Read More

Categories
Tags

Always On Availability Groups (AAG) (4) AWS (4) AWS Redshift (6) Database Admin (72) Database Backups & Recovery (14) Database Mirroring (2) Error Messages (5) Failover Cluster Instances (FCI) (1) Git Commands (6) Importing & Exporting Data (2) Linked Servers (3) Linux Administration (2) Logging & Monitoring (1) Microsoft Patching (2) MySQL (4) Postgres (6) PowerShell Scripts (2) SQL Certificates & Encryption (3) SQL Server Agent (5) SQL Server CDC (2) SQL Server Data Types (2) SQL Server Management Studio (SSMS) (17) SQL Server Networking (3) SQL Server on Linux (1) SQL Server Patching (2) SQL Server Performance Tuning (6) SQL Server Processes (SPIDs) (7) SQL Server Replication (2) SQL Server Scripts (13) SQL Server Security (4) SQL Server Storage (10) Windows Admin (20) Windows Authentication (2) Windows Automation (1) Windows Events (2) Windows Firewall (4) Windows Subsystem for Linux (WSL) (18)