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

I wonder about this, especially with HP. The suburb I live in is sort of a call center mecca. One of those call centers is owned by HP. They've been...

I just read this post today (Jan. 5, 2015), so I'm behind the times. However I think this is one of your best posts of 2014, Steve. I'm still "in...

I love that "Mission Statement" song by Yankovic! You wouldn't believe out many companies post job openings using so many buzz words! It's not a majority, but its more than...

(I hesitate to post to this, only because I fear getting inundated with recruiters seeking only to satisfy companies needing to fill positions at openings, rather than paying any attention...

Michael L John (12/18/2014)

---

Agree. There are some good ones, and some bad ones.

In my area (Pennsylvania), there seems to be lot of recruiters that really did not look...