Use [Ctrl+Alt+End] in RDP session to change the password, instead of [Ctrl+Alt+Del]

Email SQL Job Notification to Multiple Recipients

It's actually quite simply if you tried it

1. Create a New Operator
SQL Server Agent -> Operators -> right-click -> New Operator

2. Choose a Name (e.g. "Group") and enter multiple emails in the E-mail name: field, separated by ;
a@gmail.com; b@gmail.com

3. In your SQL Job Notification, select "Group" as Operator and that's it

Source
http://www.dbanation.com/?p=416

Restoring SYSTEM databases

I had the opportunity to restore a few system databases due to disk inconsistency/corruption. Actually my first time in a long time and was it fun. I have a few tips to share

All below were done on a SQL Server 2005 instance

Restoring MASTER Database!!
- start SQL Server in Single User mode (add -m to the startup parameter)
- You can Google this with lots of results. Microsoft How to on SQL 2008 R2

Restoring MSDB Database
- This is easy, just restore like a user database

Restoring MODEL Database!
- Restore model in RECOVERY mode, never in NORECOVERY mode as SQL Server will stop (due to tempdb unable to create, without a model database)
- If you did NORECOVERY, the only way to get in is manual work.
For me, I started it and detach-and-attach the model database that I copy from another location, as one cannot issue RESTORE command in Single-User mode

net start MSSQLSERVER /c /m /T3608 (you can go into SQL BINN and run sqlserver -c -m -T3608 as well)

sqlcmd -E (to connect to the SQL Server)

Detach and Re-attach model databasesp_detach_db 'model'
go
sp_attach_db 'model', 'DATA.mdf', 'LOG.ldf'
go
use model
go

Command line parameter	Use
-c	Forces an instance of SQL Server not to start as a service.
-m	Allows updates to the system catalog.
-T3608	Recovers the master database only.

There is a ($50 USD) benefit to Read and Comment Simple Talk articles!

Today is my lucky day as I unexpectedly found a $50 USD Amazon.com gift card in my email inbox, courtesy of simple-talk, all because I read and commented on Tony's "Cloud Backup: Getting the Users' Backs Up" article

You can subscribe to Simple-Talk's SQL and RSS, and usually each newsletter will end with this comment
Reply to my blog post to be in with the chance of winning a $50 Amazon voucher.

I just love Red Gate more and more (as Simple-Talk is owned by Red Gate)

Change the [Change Connection] shortcut in SSMS

I recently found this shortcut and it has been a lifesaver to manage multiple SQL servers in the [New Query] window

I can now paste/type the SQL statement first, ALT+G, enter new SQL name, F5 to execute

http://narfle.com/blog/2006/07/ssms-keyboard-shortcut-for-change.asp

1.Open a Query Editor window connected to your favorite server.

2.Right click on the Change Connection toolbar button on the Query Toolbar button and select the Customize command at the bottom of the menu.

3.Right click on Change Connection button again and then change the command name "C&hange Connection..." to "Chan&ge Connection...". This will change the hot key from Alt-H (which would conflict with the Help menu hot key) to Alt-G.

4.Finally, in the Right Click menu for the Change Connection button, you need to select the command option to display both "Image and Text". This exposes the Alt-G command to the Query Editor.

5.You can now close the Customize dialog and use Alt-G as your hot key!