The tools a DBA installs on day one include SSMS, command line utilities, a checked script library, and managed source control.
Drawing a Diagram of an Existing Database
A diagram of an existing database starts with real foreign keys, uses SSMS to reveal relationships, and records the important paths a picture misses.
Templates and Snippets in SSMS
Templates and snippets in SSMS turn repeated SQL patterns into editable starting points while keeping environment assumptions visible.
SQL SERVER – 2005 – Forced Parameterization and Simple Parameterization – T-SQL and SSMS
Forced parameterization can cut query compilations for busy databases. I explain FORCED vs SIMPLE parameterization and how to set each with T-SQL and SSMS.
SQL SERVER – 2005 – Fix : Error : Msg 7411, Level 16, State 1 Server is not configured for RPC
Msg 7411 says the server is not configured for RPC. A Jr. DBA I am training found the fix on his own: turn the RPC option from False to True.
SQL SERVER – 2005 – Connection Property of SQL Server Management Studio SSMS
How to change connection properties in SSMS as you connect, like using named pipes instead of TCP/IP, as I do for one of our servers. Screenshots show each step.
SQL SERVER – 2005 – Open SSMS From Command Prompt – sqlwb.exe Example
Open SSMS from command prompt with the sqlwb command. I show its syntax and the switches I use, like -E and -nosplash, to start Management Studio.