This is really the first article I've seen where someone is praising Service Broker (SB). We tried SB when it was released in 2005 and it was a disaster....

In our environment we have error handling around the Update/Insert SQL syntax since we don't know what the customer values are when they come into our OLTP system. We...

When my team tried it we couldn't get CDC to capture the hostname of the server/workstation/laptop that made...

Eric M Russell (7/27/2011)

---

mar10br0 (7/27/2011)

---

paul.knibbs (7/27/2011)

---

I'm not sure increasing the row length in SQL would help much--after all, the largest data types are stored in off-row data pages anyway, and...

Curious why you would think IOPs and RAID will be forgotten. Based on recent hiring here, I would say most DBA's don't know anything about RAID or IOPs now...

NoSQL DB's like Cassandra are good at scaling out rather than up, more so than SQL Server. It allows a dept to move away from expensive big-iron SANs and...

bsheets 73864 (1/7/2011)

---

SQLArcher (1/7/2011)

---

Hi,

It depends on the nature of the system. I work in a financial institute with a lot of trading; in a downtime vs. partial data loss situation...

Nakul Vachhrajani (1/7/2011)

---

Hello!

To me, the strategy that I have followed is:

1. Get the database online as soon as possible - non-current data allowed

2. Attempt to restore the most-recent data first...

I think the real value in using a mobile monitoring device like the iPad is the fact you can display your results on other displays. You can use the...

True, but there's some overhead with constantly running a perfmon. Just scraping the already collected data from the DMV's...

[/quote]

Needing to stay abreast of the latest technology is utterly irrelevant: that's what your staff is supposed to do.

[/quote]

This is true for some environments. In my role...

Only 2 that have implemented SOX where I was directly involved with compliance/processes. The requirements around SOX and PCI are vague in some areas and open to interpretation. ...

Usually for SOX the separation of duties only comes into play if the duties are related. ie, can a developer deploy his or her own code into production even...

I agree with Pete here. Cursors have a bad rep, but are good for those cases where you actually want to process something 'RBAR' as someone earlier in this...

I think the root problem is testing your DR solution. If you rely on tapes for DR then they should be tested (restored) on a regular basis as part...