Just about all errors written to the error log can be emailed using the SQL Agent alerts.

Alternatively, I'd look at using the Service broker and event notifications.

I use combination of...

Dev (1/31/2012)

---

Now it’s either a big mistake on my end or over-cautiousness because I work on Financial Projects.

When I read the membership id (16 digits) I interpreted it...

I'd just like to point out that some of the examples of numbers are not really stored as numbers.

Telephone and credit card numbers are strings of set length, so Char...

Personally, I'd be cautious about SSD due to its limited Write lifespan. I'd look at what you doing to be using it for and if its a high write...

Cowboy DBA (1/31/2012)

---

jarid.lawson (1/30/2012)

---

I am not fully as familiar with SSIS yet. I have made a few packages, but I really have no more than the most basic exposure to...

Koen Verbeeck (1/31/2012)

---

How to: Encrypt a Column of Data

First google result for sql server encrypt...

Koen Verbeeck (1/31/2012)

---

Looks a lot like this one:

http://www.sqlservercentral.com/Forums/Topic1244005-391-1.aspx

The reply to the suggested solution is a bit worrysome though.

Thanks for...

There's been a few over complicated solutions offered here in my opinion.

Depending on how big the database is and how much data you need for reporting you have the following...

Alternatively, you could write a tabular function or a stored procedure to use a rowset query to access the file directly when called.

SQL Server wont be aware of when this file is updated.

You could setup a SQL Agent job to run every minute, load the data into a staging table and then...

The global diagram gives my favourite interpretation in conjunction with local backups for recovery.

http://technet.microsoft.com/en-us/library/ms151196.aspx

SQLKnowItAll (1/27/2012)

---

I just did a quick "click" on replication to create a new publisher and went through a bit of the process to see that peer-to-peer is not an...

Peer to peer could be used as a DR solution. It was originally implemented as a multi-site database setup where shared resources weren't possible but two way communication (near...

You've almost answered your own question. In peer...

Evil Kraig F (1/24/2012)

---

For raw data copying I'd go with replication. For immediate data transfers with asynchronous transactions (ie: sending to an audit table on every update via trigger),...