I know some folks using Splunk for log analysis on enterprise internet connections that generate 150GB+ of log data per day. So far, they are pretty happy with the tool,...

Jeff, you should also check to see if the AS400 you need to extract from has any third party query tools on it, or Query/400. Those generally have th eability...

Jeff Moden (4/29/2013)

---

I guess I'll ask a similar question on these thread. Is there any way to bulk export data from DB2 to a Tab delimited file? One...

Gary Varga (4/22/2013)

---

Gary Varga (4/22/2013)

---

Clearly if Steve had written a poor editorial he wouldn't be putting it down to the tool he wrote it in.

Has Word ever won a Pulitzer...

kevaburg (3/20/2013)

---

My train of thought is that although from my side it is far more work and attention to detail, I can reduce the amount of damage that...

Eric M Russell (3/16/2013)

---

I don't understand why a script to scan across all tables in a database would be needed. Generally speaking, we know ahead of time if we're looking...

I forgot to add to my earlier post that adding an order by table name and ordinal position in the information_schema select that drives the cursor made a huge difference...

I would add a criteria to only search the columns that could conceivably contain the data. There's no use searching numeric columns for character data, and if you are looking...

I fell into SQL Server when I started a new job in 2001 supporting a new version of an accounting package I had supported elsewhere. From day 1, everything clicked....

No movies stand out for me this year, but for TV with a sci-fi component, I highly recommend the UK TV shows Life on Mars and Ashes to Ashes. Great...

I've always taken the hard drives out of the computers I've disposed of, and deconstructed them into their component pieces. The magnets go into a jar, the housings go into...

Steve Jones - SSC Editor (12/12/2012)

---

Ross McMicken (12/12/2012)

---

Your DR plans should be tested with a scenario where more than half your staff can't be found or can't connect. In real...

A few comments on disasters.

If you are critical, then you need a real landline and a phone that doens't require power to operate. This is one huge reason we have...

A good start to this would be to not grant sysadmin privileges to the DBA's every day ID's, but require them to use a special ID to perform sysadmnin tasks....

I've used MS Access as a quick compare tool across servers (we aren't allowed to use linked servers, or this would be possibl ein SQL Server itself). Use ODBC to...