Eric M Russell (4/15/2016)

---

Aggregate downtime per year is a common baseline measurement, but it may not be the right question. In many cases it's really a matter of how much...

Terje Hermanseter (4/15/2016)

---

My company runs a 24/7 business. As a DBA I take down our main DB servers for maintenance every 6th week for about 1 to 1 1/2 hour...

Thomas Hütter (4/15/2016)

---

Well, concerning downtimes of Azure, here's some recent experience of mine:

I attended 2 SQL events so far this year, at both there were speakers breaking their demos because...

I'll echo my sympathies.

I'll also say that you should setup a backup when you create a db. That's a good time to just make sure you at least run one...

Because of what GilaMonster brought up, get the DBA involved. Make a permanent table.

Apologies, forgot to tick the second answer. 🙁

Points awarded back to this time.

MarlonRibunal (4/14/2016)

---

Kick-off Meeting - that's the one important meeting in any project. It is where all the parties gauge their expectations.

and you said this:

Sometimes I think the problems in software...

Well, apparently I don't write good questions to teach these people things.

Maybe some of you should write some questions to help people learn how to write DML?

:-P:-D:w00t::hehe:

Seriously, looking for...

You want to be careful with triggers, and think through carefully if this always needs to happen, including when DBAs need to fix data.

However, if you do need to...

I agree with adding an index. Often the indexing by vendors, including Microsoft, is poor.

Support won't like it, so you'll need scripts ready to remove anything you add, and re-create...

Iulian -207023 (4/14/2016)

---

yes , nice question

Last week I think there was a topic on parallel queries , now this Query Store. Really nice.

Is there a way to make a sandbox...

Too much stuff tied together, in a way that isn't good design. It showcases all features, but it's cumbersome to work with at times.

Gary Varga (4/13/2016)

---

I have to take umbrage with this. Almost every example I can think of this...

Don't miss the deadline. Move things to get your resume ready, including an all nighter.

below86 (4/12/2016)

---

I...