This will do what you want, although I would suggest protecting the certificate private key with the database master key instead of a password, since the password has to be...

Create a table showing the offset to UTC time for different time ranges, and then query that table to get the correct UTC offset to convert the local time to...

There are fairly simple steps that you can use to eliminate the vast majority of SQL Injection attacks:

Always Use Parameters. Even if you don't use Stored Procedures.

http://weblogs.sqlteam.com/jeffs/archive/2006/07/21/10728.aspx

Replace this:

SUM(trxquantity) / SUM(trxcount)

with this:

SUM(trxquantity) / NULLIF(SUM(trxcount),0)

sturner (4/6/2011)

---

Jeff Moden (4/1/2011)

---

I've also seen folks that do it just the opposite. Encrypt the item you're trying to find and look that up in the encrypted column. ...

My preference would be to find a different vendor.

I consider a vendor who requires sysadmin (or other server role) or dbo access for the normal application login to be incompetent....

Does anyone know how to force a 2005 or 2008 maintenance plan backup to use the WITH CHECKSUM option of the backup command?

I have not been able to find the...

select MonthName = datename(month,'200602'+'01')

Results:

MonthName

------------------------------

February

Steve Jones - SSC Editor (4/1/2011)

---

Michael Valentine Jones (3/31/2011)

---

Don't think of it as a failure.

Think of it as a chance to start over without the burden of all that legacy...

Usually, you only encrypt one or two columns in a database, like a credit card number, and when you encrypt column level data, you only encrypt it when you add...

Jeff Moden (3/31/2011)

---

Grant Fritchey (3/31/2011)

---

Michael Valentine Jones (3/31/2011)

---

I believe that is...

repent_kog_is_near (3/31/2011)

---

since TDE does whole DB encryption, and with less overhead, what may be situation where column only encryption would be a better choice to use with SQL 2008? or...

I believe that is only available in SQL 2008 and later...

Don't think of it as a failure.

Think of it as a chance to start over without the burden of all that legacy data.

As a rule, I give no weight, positive or negative, to certifications when I look at a resume.