Eric M Russell (1/14/2016)

---

I'm not convinced that all the sacrifices were making in terms of privacy are even making us safer. These occasional domestic terrorists who get caught during the...

The code he's using is filtering the object type, there's 26 different objects. BOL for SQL 2014 shows the types as:

AF = Aggregate function (CLR)

C = CHECK constraint

D =...

I don't know if you might find this useful, but a long time ago I wrote some code for SQL Server 2000 for a similar purpose. It's probably overkill,...

Thanks for the info. Definitely good to know and worth bookmarking what you went through just in case....

Lynn Pettis (1/7/2016)

---

I have one for you. Years ago as a computer operator work at Data General, my supervisor ordered rehabilitated 2400' 9 track magnetic tapes. He was...

My problem with maintenance plans is the lack of reporting. I'm old school: I started writing maintenance scripts with the first version of SQL Server and I've continued the...

Greed, pure and simple. The drive...

TheSQLGuru (12/25/2015)

---

Jason A. Long (12/25/2015)

---

TheSQLGuru (12/25/2015)

---

How about I do a remote presentation of my Common TSQL Mistakes session? I have presented it somewhere around 100 times now for companies, User...

Thank you, J! Yep, PEBKAC strikes again.

Steve, I'd like to see your code because I can't duplicate it. I ran the following:

DECLARE @HashThis VARCHAR(20) = 'January 1, 2016';

SELECT 'MD2' AS HashType, hashbytes('MD2',@HashThis) AS HashVal

UNION

SELECT 'MD4',...

There's some gaps that have developed in my knowledge of T-SQL that I need to fill in. I'd like to work on that and also on re-learning VB as...

The last time I did a temp consulting gig in Phoenix, some 15 years ago, I was paid $120 an hour because when I left, the system continued to work...

Steve, that's far too much free time on your hands!

Here's hoping you had a great holiday. 🙂

I'd recommend double-ROT13 as the crypto algorithm for the...

Yeah, if you're passing a query to an Oracle box, do you have any way of knowing if the delay is there? Totally different situation than a SQL Server...