Here are the results of my doing a RESTORE FILELISTONLY against the backup file:

LogicalNamePhysicalNameTypeFileGroupNameSizeMaxSizeFileIdCreateLSNDropLSNUniqueIdReadOnlyLSNReadWriteLSNBackupSizeInBytesSourceBlockSizeFileGroupIdLogGroupGUIDDifferentialBaseLSNDifferentialBaseGUIDIsReadOnlyIsPresentTDEThumbprint

VideoLibrary_DataC:\Program Files\Microsoft...

Earlier I said I don't rename things like tables. And that for the most part I oppose it. Well, I've been handled a new project at work, having to take...

Steve Jones - SSC Editor (5/24/2015)

---

Go to tsqlt.org to get a framework. There are others, like dbunit, tsqlunit, etc., but...

David.Poole (5/24/2015)

---

Try http://www.red-gate.com/products/sql-development/sql-test/

It is possible to devise your own method of initialising a starting set of data,...

I agree with you in principal but sometimes, due to things out of your control, you can't do anything about it. I'm in a situation now where I have identified...

How do you do unit tests in T-SQL?

I've used SSMS mostly and prefer it. I've not really used SSDT all that much. Can you do things like create SQL Jobs in SSDT?

Oh this is a good topic! My favorite example of bad code was from a co-worker I used to work with. She wrote really awful code, and the comments weren't...

As a developer I find an MSDN subscription to be essential. I've heard of ReSharper and have seen people using it, but haven't any experience with it. For development I've...

Thought provoking article, Steve. And I see a lot of people have replied to it. I'd like to comment on the first part of it, but think it would be...

I agree with you Steve, but sometimes I wonder. Where I worked we had 18 years worth of data which I've maintained and advocated for years, should be analyzed to...

In looking at the Mapper function more closely I believe that the @word variable is very likely a NVARCHAR. It's assigned a value from the SUBSTRING function call. I'm still...

LutzM (1/19/2015)

---

The description in the original link is somewhat misleading:

the part related to "create function..." and the following part "While EXISTS..." are both part of the same function.

The function should...

I think I did create that custom data type, but will have to check it when I'm on my laptop again.

Thank you for responding!

I agree with most of what you said here, Steve. But sometimes, for reasons I've never understood, the solutions I've proposed haven't been adopted. Instead everything just stayed the same....