It's new hardware and a new cluster at a different location, so you're pretty much stuck having to do the busy work of moving each database whether via backup/restore of...

Our responsibilities are nearly identical to Jeff's. The DBA's perform the backups to disk and the storage team is responsible for copying the files to and from tape. ...

Well you could always connect:

[servername],port

This will prevent you from needing the instance name. Quirky but works.

Steve

I'm not sure I completely understand your reply, but it seems as though your saying just let TempDB grow as needed.

TempDB should be sized just like any other database....

Of course you can. ...

With the release of SQL Server 2012, testing DR is a dream. The "always on" works great allowing us to switch over between data centers in less than a...

Well said, Steve!

While I am in my early 40's, I have already seen too many friends be afflicted with cancer and have their life snubbed out before they really had...

I guess I would add that the physical servers are licensed for SQL, so you can have n number of vm sql instances installed and not worry about any additional...

kevaburg (7/9/2013)

---

There is nothing to worry about. TempDB is recreated each time the instance/server is restarted and it will consume however much space it requires to perform its function....

Preventing SQL Injection is a multi-tiered approach.

1. The application needs to inspect the strings where there was input from the user

Here is an MSDN article which lists characters which should...

Thanks for the info.

What you want to updatestats in this case too or is it not applicable? ...

Bobby Glover (6/14/2013)

---

Thanks, does this apply to when the Primary db falls offline too.

Lets say san administrator removed the disks that held the mdf and Ldf files. This would also...

We're in the process of upgrading, and in fact, we're going live this weekend with SQL 2012. It's only one instance of many.

Our company skips releases, so we're moving...

Being that you are not a salaried employee, you cannot be expected to work for free. This is the sort of thing that should have been worked out in...