SQL DBA Blog

Tag: SQL Server Management Studio (SSMS)

  • SSMS

    SSMS, SQL Server Management Studio, is the standard application that we use to run queries and administer instances of SQL Server. The Microsoft Documentation and links to download can be found here – Download SSMS My blog posts with the SQL Server Management Studio (SSMS) Tag may help guide you through common configuration tasks and/or…

    read more

  • SSMS Silent Install

    This is a note on how to silently install SQL Server Management Studio (SSMS) via command (PowerShell). SSMS is a tool most people use to administer SQL Server and to run SQL queries. If you need to install SSMS many times or on multiple computers, you may want to use the silent installation feature when…

    read more

  • SSMS Maximum Characters Displayed

    By default, the max number of characters displayed in a single column of a query in SSMS when outputting as text is 256 characters. We can amend our query outputs in SSMS to Results to Text, rather than the default grid layout. This can be done by clicking the top bar menu button as shown…

    read more

  • SSMS Show Line Numbers

    This post contains a 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 message in a SQL script. The demo below…

    read more

  • How to Connect to SQL Server with a Different Domain User Account

    This post is a guide on how to connect to SQL Server with Windows Authentication, but using a different Domain User rather 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, you’ll likely be logged into your computer…

    read more

  • USE Command in SQL Server

    USE [database] in SQL Server is a way to change the context to a specific database when you are running a query in Microsoft SQL Server. When you log into SQL Server using SQL Server Management Studio (SSMS), your database context will be automatically set to your default database which was set during the creation…

    read more

  • Change Default Database in SQL Server

    When you log into SQL Server using SQL Server Management Studio (SSMS), opening a new query window will automatically scope you within the default database set when your user was created. If this isn’t explicitly set during creation it’ll be set to the master database which isn’t very convenient for users. DBA’s might have to…

    read more

  • Disk Usage by Top Tables Report in SQL Server

    The Disk Usage by Top Tables Report in SQL Server is a quick way to get the sizes of all tables within a database. It’ll show all tables largest to smallest tables by total size on disk. If you notice that a database is growing larger in size, then you will want to know what…

    read more

  • Include Execution Trace Messages in SQL Server Error Logs

    Logs are always important if you’re supporting systems. The SQL Server Agent has always been a heavily used tool in my experience, so writing execution trace messages to the logs might help investigate an issue one day. This guide follows the Microsoft Docs page – Write Execution Trace Messages to the SQL Server Agent Error…

    read more

  • “Index was out of range” SQL Server Management Studio

    If you try to change the order of steps in an Agent Job within SQL Server Management Studio (SSMS), you may encounter the error “Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index (mscorlib)“. This error can occur even if you are using the latest…

    read more

Recent Posts

Categories

Tags

Active Directory (AD) AWS CLI CDC Certificates & Encryption Change Data Capture CSV Files Database Admin Database Backups Data Types Deleting Data Error Messages Featured Git Git Commands Git Log Installing SQL Server Linked Servers Linux Admin Measuring Databases MSSQL SPIDs NetFirewallProfile New-Item PowerShell PowerShell Create Folder PowerShell Delete Files PowerShell ForEach PowerShell Tips PowerShell Version Restoring Databases SQL Server Agent SQL Server ETL SQL Server Management Studio (SSMS) SQL Server Processes SQL Server Scripts SQL Tips SSH SSMS Tips Temp DB Windows Admin Windows Firewall WordPress Tutorials WSL WSL1 WSL2 WSL Ubuntu WSL Version