SQL Kiwi (5/17/2012)

---

Steve Jones - SSC Editor (5/17/2012)

---

Zip, gender, birthdate gets some crazy % identified, or closely identified. Add in one other thing and I think it gets to like...

You shouldn't have to explicitly. It does have to be open, but if you just ran this, then the SMK should automatically open it.

If this is all your code,...

Short answer: my boss wanted the StackExchange style forums on the site

Long Answer: my boss made us implement the StackExchange style Q&A, which I think has merits. As Grant, Lynn,...

I use WordPress.com at http://www.voiceofthedba.com

1. Used the Titan theme from Theme Foundary. Didn't spend a lot of time looking around though. After seeing 5 or 10, my eyes start to...

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