Viewing 15 posts - 16 through 30 (of 38 total)
I've seem two approaches and the second is always easier 🙂
The first is that you have some data generation scripts that can generate test data - these take quite a...
September 15, 2015 at 2:25 am
nick.latocha (9/15/2015)
September 15, 2015 at 1:39 am
nick.latocha (9/15/2015)
September 15, 2015 at 1:07 am
GeorgeCopeland (9/14/2015)
roger.plowman (9/14/2015)
One of the things I HATE about reading other people's code is lack of comments. In my own code I literally have 75% comments and 25% code.
I struggle...
September 14, 2015 at 12:38 pm
tSQLt is free, the redgate sql test which is a ui around it isn't but you don't need to use it.
Here is a tutorial:
http://tsqlt.org/user-guide/tsqlt-tutorial/
If you get stuck there...
July 24, 2015 at 2:11 am
cgeswein (7/23/2015)
Do we have good unit testing tools for SQL?
There is a tool by RedGate called SQL Test that builds on the tSQLt framework. It makes things much easier.
Yep...
July 23, 2015 at 4:16 pm
Jeff Moden (7/23/2015)
Ed Elliott (7/23/2015)
I guess what I was trying to get across is that it often seems quicker to go and just fix something but it always ends...
July 23, 2015 at 1:39 pm
Have you looked at tSQLt? It really makes writing unit tests a lot simpler and easier.
I talk about why it is good and makes it easier to write tests (
July 23, 2015 at 4:37 am
Hi Peter,
I guess the point is that if a change is made you can see what tests fail and either fix or remove the tests. You can of course do...
July 23, 2015 at 4:01 am
I agree that business logic doesn't really belong in the database, thousand line stored procedures should have the logic moved up into the application.
There are cases though where you need...
July 23, 2015 at 3:54 am
Thank you!
I guess what I was trying to get across is that it often seems quicker to go and just fix something but it always ends up taking longer in...
July 23, 2015 at 2:00 am
cool, stick it on connect as it sounds quite serious!
July 21, 2015 at 3:47 am
I was also going to say that in the editorial you mention that it missed some differences - you should definitely raise connect items or post them in the SSDT...
July 21, 2015 at 2:47 am
Dacpacs are pretty cool, personally I think that the internal format is irrelevant, it is a bit like saying that the CIL for .Net isn't good.
The benefit that we get...
July 21, 2015 at 2:20 am
Yet Another DBA (7/2/2015)
Too many examples of the comments being wrong to trust them.
This is so true, we have had years and years of bad or incorrect comments, lets...
July 2, 2015 at 12:39 am
Viewing 15 posts - 16 through 30 (of 38 total)