But how would any of this be a "poor man's" version of replication? Even SQL Server Standard Edition supports real replication, which may work better than anything you spend time...

Using hash or checksum techniques to detect modifications to bulk numbers of records is inefficient (it has to read and hash all columns) and not reliable (data changes but hash...

The "query governor cost limit" server option (and session override setting) has been around since at least v2000. You basically specify the maximum number of seconds, and then SQL Server...

It would be helpful if backup tools supported backing up and restoring server configurations (linked servers, maxdop, trace flags, etc.) Practically all SQL Server backup solutions are database centric. Maybe...

Occasionally automation means modifying the applications or developing a new table or stored procedure. But in my universe, Operations are part of IT and are capable of implementing their own...

There are probably a lot more multi-TB instances than there are multi-TB databases. I don't currently manage backups, but in our environment we have a 10 TB instance partitioned both...

Scott D. Jacobson (1/8/2015)

---

I for one would really like to know more about the reasons behind the outage. There was a Xen security advisory last September that caused huge ripples...

ScottPletcher (1/8/2015)

---

You could also GROUP directly on the CASE expression itself:

SELECT

CASE

WHEN message_text LIKE '%ThePartToGroupBy%' THEN '%ThePartToGroupBy%'

...

If it's not enterprise applications what are affected, then perhaps it's not that big of a deal. However, it does break my heart to think of all those millions of...

x 45204 (1/8/2015)

---

Hey

First time here, but have been enjoying the articles for some time now on this site.

But got a query question - I am trying to make a query...

The good news is that Verizon cloud services isn't very popular, so the outage should impact only a small percentage of it's customers. 🙂

suppiunna (12/31/2014)

---

Hi,

We are using .net application which is hitting the database using SA Account.. I am looking for any alternative to SA Account like whether can I use groups or...

I think that the majority of people are not entirely forthcoming, in significant ways, when they submit healthcare assessments. That also applies to employee surveys, political polls, customer reviews, and...

Andy Warren (1/5/2015)

---

Matt, wellness plans are an interesting example, and one that bothers me more. Retention (or firing) is part of what a company does to succeed, I can see...

This is similar to something HP has done, trying to predict if employees might leave and intervene to see if something can be done. I heard an interview with the...