Monthly Archives: June 2011

The difference between REVOKE and DENY

There was confusion recently with a poster that was moving permissions around and asked why I said they should revoke permissions and not deny them. I decided this was worth a post to explain. If I GRANT SELECT (or UPDATE/INSERT/DELETE) … Continue reading

Posted in Blog | Tagged , , ,

A Little Interviewing Advice

I know there was a great uproar over the interview piece at the beginning of this week and I received lots of opinions on various parts of the article, good and bad to go over. But one comment came yesterday … Continue reading

Posted in Editorial | Tagged | 2 Comments

Why I’m raising my son to be a nerd

A good read, from ESPN and CNN columnist, LZ Granderson: Why I’m raising my son to be a nerd. We need more STEM (science, technology, engineering, and mathematics) education in this country, and probably in all countries.

Posted in Blog | Tagged ,

New Connect Item – TDE

Does the certificate matter for TDE? Apparently not as I found a number of people discussing the fact that the expiration date for certificates is not checked for TDE restores. So if your certificate expires, you can still restore the … Continue reading

Posted in Blog | Tagged , , , ,

A Lost Day

I’m not sure what happened, but I had some sort of stomach bug yesterday. I was up throughout the night in the wee hours of Monday with cramps in my stomach or intestines and feeling miserable. Slightly better at 7:30am, … Continue reading

Posted in Blog | Tagged , | 4 Comments

HASHBYTES – A T-SQL Function

Someone was asking if the HASHBYTES function was a good one to use in T-SQL as far as performance goes.. I wish I had a good reference for the function, but the best one I had on SQLServerCentral was this … Continue reading

Posted in Blog | Tagged , , | 2 Comments

The Test of Time

IBM turns 100, and in this article, they brag about bench pressing more other companies half its age. That’s a great headline, and I still remember when IBM was not only the premier hardware vendor of the computer world, but … Continue reading

Posted in Editorial | Tagged

Cost of the Cloud

One of the benefits of moving to a cloud infrastructure for IT services should be a reduced cost. The economies of scale for having specialized staff, licensing, etc. are more evident when you have more of everything. The larger you … Continue reading

Posted in Editorial | Tagged | 2 Comments

Why Two Devices

I used to travel with two laptops, one as a backup, however lately I’ve switched to taking the iPad and a laptop. The iPad doesn’t double as a backup, but it does let me do things like take notes at … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Five Lines of Code

An interesting story on how a database speeds up by changing some application code. Worth the read for sure. I caught this from Andy Warren’s blog, and it shows why we need developers to think for themselves and ask relevant … Continue reading

Posted in Blog | Tagged ,