cdonlan 18448 (5/16/2012)

---

I suppose my own assumption (and fear) is that this new magical self-service database would be used as part of a mission- critical solution.

(Sorry Steve, this didn't...

Some good replies from Jared and Anthony. Here's my take.

I've mostly worked with third party software (like you develop) that did not allow any changes, even new indexes. However I...

I've often cobbled together some type of monitoring solution myself, and it has worked OK. However someone noted the other day that implementing monitoring means you have to maintain it,...

A few outer join resources:

http://www.sqlservercentral.com/articles/SQL+Puzzles/outerjointrouble/2226/

http://www.sqlservercentral.com/articles/Advanced+Querying/outerjoinmystery/2382/

http://www.sqlservercentral.com/articles/T-SQL/2937/

Ditto with Lynn's experience. Works fine, same as a regular backup.

cdonlan 18448 (5/16/2012)

---

I think a big part of the problem lies in a convergence of false assumptions and the desire to offer a new product. To me, the implied assumption...

We have Azure forums: http://www.sqlservercentral.com/Forums/Admin/AdminEditForums2570.aspx

I'll add a few more items in there, like general cloud computing and non-MS vendors and rename this to cloud computing.

That's an interesting definition. It certainly makes some...

If you do an in place upgrade, your system databases are upgraded. You should not have issues with linked servers, but job, maintenance plans and SSIS packages could potentially have...

Lisa Slater Nicholls (5/15/2012)

---

The key thing here is (pace Steve) we don't actually "do the same work for decades". Come to think of it, really good carpenters don't...

Sean Lange (5/15/2012)

---

I certainly would never want to stifle creativity or new ideas. That is truly the basis of the business we are in. The self-service side of the industry...

How often do we see on this site decisions made by people who work as DBAs that are awful? These people are often trained for this work and still make...

I thought the parallel with Mrs. Streep from levynissim was pretty good. We don't think that experienced people in many industries are worse than younger people or worth less.

I see what you are saying and clone/snapshots make some backup scenarios work, but changes, incorrect loads, any number of issues occur that require backups. I suppose logs work, but...

There is no way in SQL Server 2008 to do this inside the database. Actually, this always is the app level, even in SQL Server 2012.