The Master location is sent to SQL Server as a startup parameter for the service. In the Configuration manager (or services, don't use that), you can see the parameters. I...

Thanks to new data mining abilities I think I read that they have the ability, to 75% or 90% or something like that, to find an individual in the States...

so this is a string. You might look at the substring functions in SSIS and then derive the various parts based on finding the spaces, or dashe.

Lowell (5/15/2012)

---

MysteryJimbo (5/15/2012)

---

IMHO if its not restored on SQL Server, it hasnt been tested. If a restore fails, no manager in any company will accept the excuse "well it...

Agree with Rob, but are those separate cells or one cell?

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/