Firefly is on my Netflix list. Once I finish Battlestar Galactica

That will not work. Once you attach to...

fuller.artful (5/25/2012)

---

Excellent article, Steve.

...

Reason #2 is the big thing. "Kids" just crank up the editor and start coding. Experience teaches you to avoid coding until the last possible moment...

Jeff Moden (5/25/2012)

---

I've not run into that problem...

If sp_spaceused is the same a 2008, then there are queries against the allocation units system DMV. This is not necessarily going to be 100% accurate at a point in...

These should help

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

http://www.bidn.com/blogs/KeithHyer/bidn-blog/2512/creating-excel-worksheets-dynamically-in-ssis

http://www.sqlservercentral.com/articles/74225/

http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/68025/

If you want to stick with your method: http://www.sqlservercentral.com/articles/Excel/64838/

I assume SQL Server 2012. No such thing as SQL 12 yet.

This is much easier to do in SSIS. Is there a reason you don't do that?

As far as what...

I wouldn't necessarily trust sp_spaceused, especially in a short period of time.

If you are deleting rows, the size is going down. Garbage collection, and perhaps lots of free space...

That covers most everything.

For admin, I'd say this one: http://www.amazon.com/Professional-Microsoft-Server-Administration-Programmer/dp/0470247967/ref=sr_1_30?ie=UTF8&qid=1337967674&sr=8-30

Dev: http://www.amazon.com/Beginning-SQL-Server-2008-Developers/dp/1590599586/ref=sr_1_16?ie=UTF8&qid=1337967619&sr=8-16

mlbakerak (5/25/2012)

---

How about taking time to remember the men and women who have sacrificed their lives for the country we live in and the freedoms we enjoy? I think...

herladygeekedness (5/25/2012)

---

I'm with you. Blame is absolutely a negative word.

"Who is responsible" is nicer but still smacks of my mother being mad about something and demanding to know "who...

Glad you had a good time and made it back. Everything OK, I assume.

I would lean towards alerts here, as opc.three suggested.

Good answers above for the HA stuff.

For the core databases: how often does the data change? Would replication work well? You could replicate data from the 7 to the 93...

IIRC, the decision to log something is from the RaiseError command, not the error. If the WITH LOG parameter is used, it's logged. If the severity is high enough, this...