I have always broke them up but my new client insists that it is OK. Even when I was testing a report query that ran for 32 minutes on...

---

I work in a very small shop. I have to wear both the DBA hat and the developer hat. So for me, there's no conflict. However I do wonder about...

Last week, the developer asked me if it would be OK to add indexes to columns A,B,C,D,E,F,G,H, and I on TableA? I was a bit confused and asked him...

I totally agree! And now I see more and more developers embracing ORMs like Entity Framework so that they "don't have to mess with all that database crap" and...

I use to want to know how my data was secured and make sure it was not being put at risk. Use to being the key phase here. ...

I normally agree with (and am interested in) most of what is written in these blogs but in this instance this is not the case, to the extent that I...

They are working on the Snow Crash movie right now, should be out in 2015 or 2016 if all goes well.

I love the Anita Blake series and it happens in...

I use to work for a company that was in the health care business. We had databases full of PII (Name, Address, SSN, DOB, Insurance Membership, etc.) and none...

Steve Jones - SSC Editor (2/12/2014)

---

As Gail mentioned, disasters vary. It's easy to think of HA as protecting you from disaster, but it doesn't. Don't conflate the idea of HA...

OMG!!!

June 6 - The smalldatetime fields in SQL-Server databases will wrap around to January 1, 1900.

I had no clue. Have to start getting ready for this. Thanks for...

I would love to see a Clone_User feature in SSMS! I cannot tell you have many times I have been asked to set up new user xyz to be...

When developers stop coming to me and asking me why their 5 page SELECT statement with 82 subselects takes so long to run, then I will worry. Until then,...

At my last job, we had a use it or lose it policy. If you did not use your two weeks, then you lost it. The bad part...

If you use HASHBYTES with the SHA1 you can expect a collision after you generate hashes for about 1,208,925,819,614,629,174,706,176 rows of data. This would take me a few million...

Yes, SELECT * will include the rowDiffHash if it has a value. My process checks the record set received today against the record set received the day before, so...