Blogs

Today I had to figure out how to access a label control on the masterpage my page was using. It isn't quite as straightforward as one might imagine, but still not difficult. For this, I am using C# 2008 (v3.5) For this particular page, I have an <asp...

In order to make CLR stored procedures run, you must first enable the CLR in SQL Server, other wise you will just get this error: Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option. Enabling the...

Recently a friend of mine called with a question about how to do something in T-SQL that he wanted to do for the leaderboard for a game he wrote. The issue was that tens of thousands of people are playing his game (on the iPhone) and the screen real estate...

Recently I got a request for a top 10 list of things that a DBA should be doing on a daily basis from an engineering managers perspective. Well, here is what I came up with, and please note, that this list is dependant on the poor guy being a full-time...

Found this great article on interpreting PERFMON statistics. Being able to make sense of this is critical to doing advanced performance tuning on your SQL Server. This type of stuff goes more towards system administration more than programming. I myself...

Ok, so it's a little late, but just uploaded some pics of me and some friends at Dolores Park in San Francisco dressed as easter peeps. There is also a YouTube video with many cameos of us :-)

Recently I had to migrate our primary databases to a new server. Yaay for the faster hardware, everything went smoothly until the next day when users started reporting that searches were failing. Turned out to be the full text catalogs do not move over...

In the world of RDBMS' you may hear the term "table scan" thrown around, this is a term used to describe an event that occurs when you search for data in a table, and your query either doesn't take advantage of an existing index, or...