Thank you, Orlando.

Happy New Year's Everyone!

There are two languages I would like to learn this year. First, I'd like to learn R. My Bachelor's is in Mathematics. I've always enjoyed data analysis,...

I really want to say thank you for this wonderful website and especially these forums! I've gained more than I ever could give back here. Thank you to all the...

dallas-1069889 (10/16/2015)

---

Hi all,

I'd like to mention the book Expert Business Objects by Rockford Lhokta. One of the principles of the application architecture used in the book is that business logic...

I started in my current job 6 months ago. I work for a large state department. They have a lot of old MS Access databases and applications. (Over 100 at...

OK I now see what I did wrong. I guess the default backup mechanism is to append to the backup set. What I really wanted, at least when moving the...

This one is more interesting. Here's the...

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, executing your...

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...