Analysis Services Performance Optimization Tips

Over the last few weeks I have focused most of my blog energy into writing a couple articles.  So I...

Running a Small User Group - Getting Help

When we first started Midlands PASS, we tried to do it the way PASS suggested. We tried to get folks...

Starting the year out right

It's the end of another year, and thus the beginning of the next one. Whether you had a successful 2009...

The Other Server

I had a fun support call I need to share. A developer called up to tell me that a particular...

The Power of Networking

I was contacted recently by someone that was hiring a new employee. They had searched out applicants on the Internet...

Windows ReadyBoost in Windows 7

Perhaps you heard of or actually tried Windows ReadyBoost in Windows Vista, and were (like me) disappointed with the results?...

Writing Proposals for Training

I had a student recently who said that to get any type of training she had to write a proposal...

Fun With DBCC FREEPROCCACHE

Nearly anytime you see the command DBCC FREEPROCCACHE mentioned in a blog post, magazine article or book, you get some...

How To Get a Count of SQL Connections BY IP Address

These queries (which work on both SQL Server 2005 and 2008) are very handy if you want to know who...

Little info about Resouce DB (SQL Server 2008-2005)

Little info about System Resource Database in (SQL Server 2008/2005)

The fifth system database in both versions (SQL Server 2008 - 2005)...