May 14, 2008
Kevin describes an unusual load condition and how to troubleshoot it.
May 2, 2008
Kevin discusses how mirroring can impact a SQL Server's workload backlog.
April 24, 2008
Kevin describes confusing information on the TPC site describing how SQL Server works with NUMA.
April 21, 2008
Kevin gives a tip about writing a hash function that serves as the backbone for hashed partition.
March 12, 2008
Kevin discusses a number of websites and blogs he's been scanning for good tips.
February 7, 2008
Kevin has released a new white paper about his favorite features in SQL Server 2008.
January 21, 2008
Kevin's been in the SQL Server business for a long time and accumulated a LOT of swag over the years. Have you got more?
January 16, 2008
Kevin discusses the recent acquisitions of BEA Systems and MySQL AG.
January 2, 2008
Kevin describes how to find passwords in multiple versions of SQL Server.
December 20, 2007
SQLDumper is an internally called process that can produce a stack dump in mini, full, and filtered formats. Learn more about it here...
November 26, 2007
If you encounter one of SQL Server's mini-dump files and want more information, you'll be happy to know that there's a lot of information on-lin
November 8, 2007
There's a great aggregation site for SQL Server information started by Rod Colledge called SQLCrunch. I encourage you to take a look. Any site or feed that makes me do less work instead of more work is good with me.
October 31, 2007
Ever have a situation where you’d like to know what TCP/IP ports are open on your server?
October 26, 2007
...it is possible to perform a table scan on more pages than actually existed in the heap table.
Add these Headlines to your Website