What is "looks very busy"? How can you measure this? What do you look at in performance monitor?

Good catch and thanks

Apologies on the versioning.

SQL 2008R2 and below are no longer supported from MS as they are too old. Typically the current version(s) should be used, though I changed the question...

hence my statement. I was agreeing with Gary. Just wanted to clairfy.

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