Viewing 15 posts - 406 through 420 (of 584 total)
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...
June 13, 2015 at 10:37 pm
Steve Jones - SSC Editor (5/24/2015)
Doctor Who 2 (5/24/2015)
How do you do unit tests in T-SQL?
Go to tsqlt.org to get a framework. There are others, like dbunit, tsqlunit, etc., but...
May 24, 2015 at 6:38 pm
David.Poole (5/24/2015)
Doctor Who 2 (5/24/2015)
How do you do unit tests in T-SQL?
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...
May 24, 2015 at 6:38 pm
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...
May 24, 2015 at 5:17 pm
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?
April 5, 2015 at 1:42 pm
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...
March 21, 2015 at 4:24 pm
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...
February 19, 2015 at 7:57 am
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...
February 14, 2015 at 8:59 am
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...
January 31, 2015 at 5:54 pm
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...
January 26, 2015 at 7:37 am
LutzM (1/19/2015)
the part related to "create function..." and the following part "While EXISTS..." are both part of the same function.
The function should...
January 26, 2015 at 6:48 am
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!
January 20, 2015 at 6:31 pm
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....
January 16, 2015 at 2:27 pm
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...
January 5, 2015 at 5:53 pm
Viewing 15 posts - 406 through 420 (of 584 total)