In my experience, agility wins over perfection.  Mainly because perfection never arrives at the fight!  That being said, no testing at all can be a little too agile.   And...

Love it!  Thanks for helping me conceive of databases in a whole new way.

I feel like there are some developers that really like tracking down and fixing bugs and others that really don't - regardless of whether they are junior or senior.  There...

I get the same issue as Rune.  It appears to be ignoring the count as well.

PRINT 'What Up?'
GO 3

Messages: 
Beginning execution loop
WhatUP?
WhatUP?
WhatUP?
Batch execution completed 3 times.

PRINT 'What...

Thanks for verifying, Rune!  I wasn't familiar with the

!!DIR

command, so thanks for that too.

Yeah, definitely in SQLCMD mode.  I use it alot. I tried

!! GO

as well.

I get an error when I use !!GO:

'Go' is not recognized as an internal or external command,
operable program or batch file.

But i can use:

GO...

I've got to go with Carlo...the question was about returning info, not just data.  There are clearly more than the three listed answers.  Still, it was a great question because...

Thanks Steve,

One more bit of useful knowledge for 2019, thanks!  Happy 2020!

I agree with Eric.  Just because nothing has been done about it so far doesn't mean that change isn't coming.  Personally, I think the balance between privacy and security has...

As a developer I wrestle with this all the time.  Should my clients go with custom or off the shelf?  As the computer revolution matures, it seems the answer is...

We use CLR as a last resort and usually on an analysis instance -- rarely on production.  Main functions we use are very simple and for reporting -- Group_Concat, and...

To my mind, the Microsoft case seems to be more about customer manipulation than data loss.  If they hadn't forced/coerced people into "upgrading", would there still be a case against...

Great article! This can be one of the biggest 'gotchas'! I've had production code go bonkers using round before because I didn't understand why Round() didn't just work...

I'm fortunate to work in an environment where there are always new database projects emerging. I've created many, many databases, data warehouses, and front-end apps to go with them....