October 20, 2008 11:05 AM
I'd like to thank the Orange County SQL Server Users Group for having me come and speak at their meeting last week. I had a great time speaking with everyone, and there were a lot of good questions.
If you didn't have a chance to download the slide deck you can download it
October 16, 2008 11:00 AM
Here's a handy query which I've written which I've used to see how much of each table is loaded into the SQL Server Buffer Cache. It shows you how much data is in memory, how much space is used on disk, and the percentage of data in memory compared to the amount of data on disk.
October 15, 2008 7:07 AM
Microsoft and PASS have announced that you can take a free Microsoft Certification exam. Visit the
October 13, 2008 11:01 AM
Take a look at the execution plan for your query. You'll notice that the query is doing an Index Scan (or a table...
October 10, 2008 8:04 PM
Sean McCown posted what I think is an excellent blog post about Database...
October 10, 2008 11:06 AM
Well today is the one year birthday of my blog. It's been a very fun and exciting year. Here's hoping that the next year will be just as fun.
October 8, 2008 1:12 AM
The company I work for just finished our office move into our newer slightly larger office. I've managed to snag myself a Window seat this time around. I just wanted to share the view with everyone. This is the view out my desk window.
October 6, 2008 8:33 AM
Orange County now has its own
October 1, 2008 11:00 AM
With SQL Injection Attacks being all the rage these days, I've been asked a...
September 30, 2008 6:58 PM
This morning I released another tip on SearchSQLServer.com called "SQL Server consolidation: Why...