Monthly Archives: November 2007

Useful Tricks for Finding Missing and Bad Indexes in SQL Server 2005

As I have written before, having proper indexes in place to support your workload is extremely critical with SQL Server 2005 (as it is with any relational database). Generally speaking, you will want more indexes with a reporting or DSS … Continue reading

Posted in SQL Server 2005 | 72 Comments

Windows Server 2008 Network Performance Improvements

Ward Ralston has a post outlining some of the improvements in the network stack of Windows Server 2008 compared to previous versions. He talks about a 45x improvement in file transfer time to copy a 10.7GB file from one data … Continue reading

Posted in Windows Server 2008 | 2 Comments

SQL Server 2008 November CTP Available

Microsoft has released the November CTP of SQL Server 2008. This version has SQL Server backup compression and Intellisense in SQL Server Management Studio among other things. SQL Server 2008 backup compression typically compresses at about a 5 to 1 … Continue reading

Posted in SQL Server 2008 | Leave a comment

Dell PowerEdge R900 Server Details

Dell has finally released some details about their new, four-socket R900 server that will support the new Xeon 7300 series quad-core CPU. This new box has 32 DIMM slots, so it can hold up to 128GB of RAM. The fastest … Continue reading

Posted in Computer Hardware | 20 Comments

Windows Server 2008 Features and License Limits Revealed

Microsoft has more detailed information published about the different SKUs of Windows Server 2008 that was announced at TechEd IT Forum in Barcelona this week. An interesting point is that they have raised the license limits on Windows Server 2008 … Continue reading

Posted in Windows Server 2008 | 5 Comments

Sixteen New Penryn Chips Released

Intel has a press release detailing the sixteen new Penryn based CPUs that were released today. One of the sixteen is the high-end QX9650 quad-core desktop chip, while the other fifteen are server based Xeon chips. Twelve of the¬†Xeon chips … Continue reading

Posted in Computer Hardware | 4 Comments

Infinite Solutions with Mark Erickson

This site has a nice collection spoof tutorials on how to do things like speed your mail delivery, extend your WiFi range, recharge dead batteries, etc. They are quite well done, and I can’t wait to send some of them … Continue reading

Posted in Entertainment | Leave a comment

How to Determine the Number of Reads and Writes to a Table in SQL Server 2005

Here are a few more useful DMV queries that will give you a better idea which tables in your database are getting the most read and write activity. You need to have VIEW SERVER STATE permission to access the sys.dm_db_index_usage_stats … Continue reading

Posted in SQL Server 2005 | 4 Comments

AMD X4 Phenom and Intel Penryn Quad-Core Pricing

Tom’s Guide Daily has a story detailing pricing information for AMD’s upcoming X4 Phenom quad-core, desktop processor. They also talk about pricing for Intel’s soon to debut quad-core Penryn line (which is supposed to launch on Nov 12, 2007) According … Continue reading

Posted in Computer Hardware | Leave a comment

A Roadmap of Emerging Microsoft Technology

Microsoft’s Jim Cirone (who is an Architect Evangelist with their DPE group), has written up a nice roadmap to some emerging Microsoft developer oriented technology and tools. One mistake I did see was his release date of Q1 2008 for … Continue reading

Posted in Microsoft | Leave a comment