LightVader (10/31/2016)

---

Jeff Moden (10/30/2016)

---

aaron.reese (10/30/2016)

---

Agreed. but when you are prototyping it is very likely that you don't have the full story from the business, especially where they need to persist...

You should also tell them that LINQ is evil personified:-D (not really, but...)

I have this discussion with developers from time to time, and have had to use Profiler to show...

It's always good to reinforce this point. It's why, in the environment I work in, only...

My office moved from 3 miles away to 29 miles away, so my commute went from 10 minutes to 45. I am in a van pool, and drive in the...

Eric M Russell (7/20/2016)

---

dndaughtery (7/20/2016)

---

Hey guys, had one of my team members drop our main table by accident. Is there a way to prevent a table from being truncated or...

Hugo Kornelis (3/31/2016)

---

Chitown (3/31/2016)

---

Hugo Kornelis (3/31/2016)

---

1200 logical files? That is a lot!

I recommend using this opportunity as a test case to check how long the restore will take. Then compare...

We have one system where the core DB has been around since 1965. It serves its purpose very well. Mainframe applications can be very long lived, and seldom need to...

Wayne West (5/25/2015)

---

Ross McMicken (5/25/2015)

---

GPO (5/23/2015)

---

Of course all of this assumes your DBA or sysadmin is beyond reproach. I worked as a bank clerk many years before I'd ever heard...

GPO (5/23/2015)

---

Of course all of this assumes your DBA or sysadmin is beyond reproach. I worked as a bank clerk many years before I'd ever heard of SQL Server. In...

I did something like this a couple of years ago looking for specific 3 to 6 character strings in every table in a database (what fools we were to not...

SumOfDavid (4/21/2015)

---

There was a case where somebody was leaving USB sticks with malware on the ground outside the corporate front doors. Guess what, dozens of employees picked them up...

During the last 5 years in an SAP support role, I've often thought that a SQL server version of the SAP transport management process would be extremely useful. It tracks...

The problem with random salts is they have to be stored somewhere, which probably makes them available to the hacker, especially if they are prepended to the hash, which is...

I've been thinking for a while that the userid, especially if it's an email address, would be a good salt. It's unique per user, doesn't have to be stored separately,...

We've told several vendors that there is not a chance that they will get to use sa to do anything, and that they need to change their product to meet...