桃子视频

Categories
Monday Morning Mistakes Syndication

Monday Morning Mistakes: Connecting to Wrong Environments

罢辞诲补测鈥檚 Monday Morning Mistake issue is another painfully common one that we all run into at some point. You鈥檝e got some new code given to you by a developer that鈥檚 supposed to be ran against QA (because you鈥檙e a good DBA and you don鈥檛 grant developers access to anything outside of Development). Part of the code drops some existing tables and recreates them with new schemas, objects, etc. You hit the execute button when the blood drains from your face when you realize the instance you were connected to was a production instance!

Issue

You have multiple instances of SQL Server to manage and you want a visual indicator in SQL Server Management Studio (SSMS) to let you quickly know which environment you鈥檙e connected to.