Can I sign up to be one of the 7-3 teams after this week? I need something to go my way.

The "where" votes are nice, and we are looking at new locations, but we're also interested in knowing what you want to learn. What is helpful to you? What types...

Thanks

Chris93147 (11/9/2012)

---

Don't get me wrong, I love RedGate and the tools they bring to the table are awesome. However, the Chicago SQL in the City felt like a day...

:), high on my list

Typos corrected. I'll award back points to this time.

Knock on wood. Machines mostly safe here, hoping it stays that way.

Check that the Windows groups have logins assigned in SQL Server.

Check any other Windows groups that have logins for DENY permissions. NOTE that I hate DENY permissions for this reason.

If...

Ultimately, no.

I've written on this a bit (http://voiceofthedba.wordpress.com/2012/01/09/capacity-planning-for-new-hardware/), but without a real workload, you can't do anything other than guesstimate. There are formulas that look at data types, but they...

The advice above on differentials is correct. One other note, please keep all log backups for all full backups. There is always a possibility that your latest full backup does...

0 should be infinity.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout%28v=VS.71%29.aspx

I would always have a clustered index. Unless I had a really good reason not to have one. I'd read some of the articles mentioned, especially any by Gail on...

Just a clarification. By SSD, I assume you mean SQL Server drive, but that's not the acronym we use. SSD is usually solid state drive these days.

However, if things are...

It's not clear what you mean by a few things. I don't know how "browsing" updates something. Browsing implies looking (SELECT), not changing. If your application changes something, then that's...

No, just to be clear.

You cannot restore system databases (master, model, msdb) from earlier versions to newer ones. As Anthony mentioned, you need to script things out and run the...