Shawn, that is AWESOME. Thank you for checking that. I'll pass this along to our local team.

It's as if a thousand bits cried out at once,...

Shawn Melton (8/23/2015)

---

IIRC if you want to restore a database with a differential you would add the full AND differential files into the device window of the GUI. It has...

I will add some others later, but here's one I frequently use for our non-prod environments.

SELECT TOP 10 *

FROM msdb.dbo.restorehistory

WHERE destination_database_name = 'MyDatabase'

ORDER BY restore_date DESC;

--check the last time a...

Steve Jones - SSC Editor (8/21/2015)

---

I had someone ask recently about seeing more dev articles, especially T-SQL based ones. Anyone up for doing some one-pagers that solve some of the...

Phil Parkin (8/21/2015)

---

Ah yes, tried to take a sneaky shortcut. Needs to be fixed:

and sjh.run_date >= (year(getdate() - 1) * 10000 + month(getdate() - 1) * 100 + day(getdate() -...

Brandie Tarvin (8/20/2015)

---

I don't know about 2012, but in 2008 something would be wrong if the mirrored dbs aren't showing in sys.databases. I have 4 mirrored DBs in 2008 that...

Sean Lange (8/20/2015)

---

Luis Cazares (8/20/2015)

---

Lynn Pettis (8/19/2015)

---

Silver spoon, silver spoon, silver spoon, when are you going to admit you are in over your head and really need to find a...

Did you create this script or did someone else? EDIT:...

I don't know about 2012, but in 2008 something would be wrong if the mirrored dbs aren't showing in sys.databases. I have 4 mirrored DBs in 2008 that do show...

Jack Corbett (8/19/2015)

---

Sean Lange (8/19/2015)

---

Luis Cazares (8/19/2015)

---

Sean Lange (8/19/2015)

---

I am working on putting together my first SSIS package. I haven't done this type of thing since it was...

Sean Lange (8/19/2015)

---

I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is a LOT...

You are WRONG, Sir! Case has absolutely EVERYTHING to do with the way things work. If we didn't have all caps,...

If you want to get technical about it, then case might have a performance issue. In the terms that if you are using case-sensitive collations and you don't call your...

I don't know anything about England or the state of employment there. If you can find a lot of good short-term contracts, then your plan sounds like a good one....