I haven't used it, but compression in terms of row/data is fairly minimal load. You will be reading the logs, compressing the data, and sending it off.

VikingDBA is right. This is why you use roles. If you have to do this once, you'll do it again.

Create a role, and use a script to get all permissions...

Third vote for XML here.

What you do need to do is consider what happens when someone inserts multiple records. An XML recordset can handle "inserted cust1", "inserted Cust2" as...

This is already built in. Use Micheal's advice.

Your master key is not automatically opening. Perhaps it wasn't created with encryption by the SMK as well?

Try:

OPEN MASTER KEY BY PASSWORD = 'XXX'

CREATE CERTIFICATE XXX

http://msdn.microsoft.com/en-us/library/ms174433.aspx%5DOPEN MASTER KEY

Craig-315134 (5/16/2012)

---

What we always need to remember is that it's the practitioners, not the methodology *or* the patterns, that are going to make the critical difference between success or failure....

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