SQL Server
Why I prefer surrogate keys instead of natural keys in database design Mladen Prajdic put together a great article about using surrogate keys in database design. The best part is that a lot of bright people sounded off in the comments.
Donald Farmer Discusses the Benefits of Managed Self-Service BI I spoke with Donald Farmer [...]
The Columbus Give Camp is only two weeks away but it’s still not too late for both charities and volunteers to sign up.
GiveCamp is a weekend-long event where software developers, designers, and database administrators donate their time to create custom software for non-profit organizations. This custom software could be a new website for the [...]
SQL Server
Find Last Date Time Updated for Any Table Ever want to know when a table was last updated? Now you can find out. Thanks to Pinal Dave for this slick little piece of code, I was totally astounded to know that you could do that.
Why use stored procedures? A very well reasoned argument for [...]
In a previous life I was a full time C# and ASP.NET developer. While I specialize in SQL Server these days, it’s still nice to keep up to date on new development techniques and technologies. I’ve recently become quite interested in ASP.NET MVC as an alternative to using Web Forms (which I have always disliked).
Now, [...]
SQL Server
A Web Based Search for Books Online Buck Woody provides links to macros for MSDN search that will give the search bar in your browser the ability to search online inside Books Online. This has become my go to method for searching BOL. It’s much faster than opening the desktop BOL client and the [...]