One of the attendees of my TechEd session “DAT315 - Manageability Series: Uncover Hidden Secrets of T-SQL Scripts with Microsoft SQL Server Management Studio” suggested that I post the list of demos that I did for the session so that they could remember the ah-ha moments. Here we go.
Object Explorer Details (OED)
Solutions and Projects
SSMS Start-Up Options and Activity Monitor
Multi-Server Query Execution
-- Change SA password across servers USE [master] GO ALTER LOGIN [sa] WITH PASSWORD='<Password_String, sysname, SAPassWord>'; GO SELECT name, sid, modify_date FROM sys.sql_logins WHERE name = 'sa'; GO
Use the Ctrl+Shift+M key to replace the SA password.
Thank you everyone who attended the session.
PingBack from http://asp-net-hosting.simplynetdev.com/dat315-%e2%80%93-session-review-for-ssms-tips-tricks-session/
This is one of those tips you don't see very often. It's really useful when you want consistency.
Nice job Bill!