OK, sorry, was busy with other work.

First, if you're doing this for users, you're going to find yourself in a bind at some point. Users leave companies, and new users...

It's reasonable in general. Whether that's reasonable for your situation is another issue.

Every monitoring system has an impact. I'm not sure that anything up to 10% is a problem,...

I think that's just how it works. The TFS integration from SSMS isn't great from Microsoft. If you want separate folders, I think you'll need a third party plugin.

I think...

As far as I know, these are tools in TFS 2015 Update 2. That's available in Visual Studio Online (VSO) or on prem if you apply Update 2.

This is crazy. I hope if it happens, someone discovers it and we know about it quickly.

For automatic failovers, the master might not be there. So you can't ask for something to run and move logins.

What you should have is a process to move new logins...

You can't easily do this. Jobs are at the row level.

What you could do is create your own procedures in msdb (script and save in a VCS for DR purposes)...

There isn't really any good integration from SSMS to TFS VC.

You can use Visual Studio and manually create folders, but then you'd need to then link your db project to...

Which tool? Do you mean this? https://www.visualstudio.com/en-us/docs/work/overview

Try this: https://blogs.msdn.microsoft.com/brunoterkaly/2013/09/26/how-to-export-an-on-premises-sql-server-database-to-windows-azure-storage/

TomThomson (7/16/2016)

---

I very much like this editorial, it is about what sort of thing the process actually is unlike most of the awful hype about Devops, Continuous Integration, Continuous Delivery,...

Andrew..Peterson (7/15/2016)

---

Steve,

I think it is great that you continually push (CP) for CI/CD and now DevOps. I setup a shop over ten years ago with CI (continuous integration)...

xsevensinzx (7/16/2016)

---

The way I look at it is ease of use in the cloud than on-premise. It's extremely easy to launch and go in the cloud. Not so much on-premise...

mjh 45389 (7/15/2016)

---

When I was working at company that had this modus operandi I had to stay late one Friday evening to do an out-of-hours upgrade on a client's system....

Check the Recovery tab in services, might be a restart. Or there's some other monitoring process that looks to restart the service.