DBSophic

Posts tagged "publications"

Where did I leave my keys?

Posted by Ami Levin on Tuesday, 31 July 2012

"If you walk into a room full of DBAs or DB developers and you feel like having the same kind of fun as setting fire to a dry hayfield, just ask this question: “What’s a better design, using natural keys or artificial keys?” Satisfaction guaranteed.

When I started to study database design, this was one of the first hot controversies I encountered. If you Google the phrase “natural vs. artificial keys,” you’ll come up with more than 150 million results, including endless debates, numerous articles, blog posts with passionate replies, long theoretical and practical arguments, and even the occasional profanity."

Continue reading
MVP Deep Dives II Project

Posted by Ami Levin on Tuesday, 25 October 2011

I’ve recently had the honor of having an article I’ve written being published in one of the most important projects of the SQL Server community IMHO, the MVP Deep Dives II book.

The original MVP Deep Dives book was published in November 2009, you can read more about the original project inthis blog post by Paul Randal, one of the forefathers of this amazing project.

Continue reading