Gary Varga (3/17/2016)

---

Jeff Moden (3/16/2016)

---

The drawing in the article is what I've seen a whole lot of automated testing do. People don't know how to write the testing any...

Correct, you need a BLOCK predicate to stop writes.

Sorry for the typo, I'll correct things.

RobertMcClean (3/17/2016)

---

MS could well implement this as a VM - sort of like a windows-based-docker thing. That would simplify compatibility and versioning.

As someone whose job involves using linux, mysql, windows,...

Both.

Disable SQL auth if you can.

Change sa regularly. Just in case someone "re-enables" the account/athentication method. I've seen people change the password for a consultant, disable the auth, then forget...

I tend to do what Hugo has suggested. Use a CASE to only return values when some criteria is met, then sum those.

Well, I've spent all day, and a good portion of yesterday, in VSTS and TFVC online, trying to get database code to automatically build and release.

Good news, it's building.

Bad...

Vote count. You need lots of them, but they do matter. There are some Connect items on split_string(), but you may be able to influence how it evolves.

Log shipping works by taking a log backup, copying to the secondary, and applying it as a restore (with norecovery/standby). These restores occur at discrete intervals (every 5 minutes, every...

I was going to note this. If you want transactional replication (for example), then you can move over data regularly, with minimal delays, but have different indexes on the subscriber,...

There are a few more: http://www.sqlservercentral.com/articles/powershell/130717/

http://www.sqlservercentral.com/articles/Excel/64838/

Really you need a driver, which can be some scheduler. SQL Agent, Windows Scheduler, etc.

Then you need automation. There are numerous ways, but if you...

Iwas Bornready (3/16/2016)

---

I find myself constantly automating things, everything. But to me automation means more than creating something that does a task for me so I don't have to, the...

Gary Varga (3/16/2016)

---

There is no harm in part automation i.e. automating part of a task. Over time this may lead to a fully automated task. Or it might not. Either...

Wayne West (3/16/2016)

---

Automation is a good thing. As pointed out, it reduces error as long as the inputs remain consistent to the design.

Here's the thing: any code that we...

+1. I've done this.

I will send suggestions to...

This is kind of a really open ended question. I think if you have specifics, like JSON <-> SQL Server, it's easier.

The API from third parties dictate what you need...