Archives: December 2008
Traditionally, analyzing Performance Monitor data has not been an easy task. It often involved viewing Performance Monitor logs in graph view, seeing what was happening, and hoping that your knowledge and background in SQL Server and the Windows OS provided you with enough information in order to help you to… Read more
In a previous blog post, I suggested that less than professional content, that you or others post on the Internet about yourself, could have a negative effect on your career as a DBA. In this post, I offer suggestions on how to project a professional image on the Internet. Read more
I have been active on the Internet for 15 years, and during that time I have left a long trail behind me. If you Google my name, there are over 5,000 hits. If you check my name in Live Search, there are over 8,000 hits. If you wanted to, you… Read more
With the world economy on the downside, there is at least one bright light, and that is DBAs are still in high demand, and will continue to be in high demand for many years to come.
SQL Server 2008 (Enterprise Edition) offers row and page compression, which can potentially offer a boost in disk I/O in return for giving up some CPU resources. While this feature has lots of potential, one of the greatest difficulties in using it is how to determine which tables and indexes… Read more