Monthly Archives: November 2006

USMC 1979-83 – Part 1

Since I made the mistake of revealing that I had been a tank commander in the Marine Corps when I gave my two minute biography during my first week at NewsGator, people here often call me the Sarge. I just … Continue reading

Posted in Uncategorized | 5 Comments

SQL Server Improvements for Katmai

At the SQL PASS conference, outgoing SQL Server development chief Paul Flessner talked about upcoming improvements for the next version of SQL Server, code-named Katmai, which is due in 2008. Microsoft also released the November 2006 CTP build of SQL Server 2005 … Continue reading

Posted in Uncategorized | Leave a comment

Both Windows Vista RTM and Office 2007 RTM Bits on MSDN Subscribers

Earlier this week, Microsoft put the Office 2007 RTM bits on MSDN Subscribers, followed yesterday afternoon by the Vista RTM bits. I was able to get all of them downloaded overnight (including both 32 and 64-bit versions of Vista), so … Continue reading

Posted in Uncategorized | Leave a comment

A great whitepaper about Compilation issues in SQL Server 2005

Microsoft’s Arun Marathe wrote a very informative white paper back in 2004 titled Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005. It has a lot of good information about the relationship between statistics and compilation and recompilation. … Continue reading

Posted in SQL Server 2005 | 1 Comment

Windows Server 2003 Service Pack 2 Release Candidate

Microsoft is scheduled to release SP2 for Windows Server 2003 in Q1 of 2007. In the meantime, they have made the Release Candidate available for download. You can get the 32-bit version here, and the x64 version here. I am … Continue reading

Posted in SQL Server 2005 | Leave a comment

SQL Server 2005 Stored Procedure Execution Statistics

Here is a slightly improved DMV query that lets you look at the sys.dm_exec_query_stats and sys.dm_exec_sql_text views to find out which cached stored procedures are being executed most frequently. The times are in microseconds, while the Age in Cache is in … Continue reading

Posted in SQL Server 2005 | 71 Comments

Microsoft Robotics Studio November 2006 CTP

Microsoft has yet another CTP available here. This version adds security support. Microsoft’s Tandy Trower says that they are getting pretty close to releasing version 1.0

Posted in Hobbies | Leave a comment

Fun with SQL Server 2005 DMV’s

Here is another useful Dynamic Management View (DMV) query to find out which cached query plans are executed most fequently. SELECT TOP 50 qt.text, qs.execution_count, qs.total_elapsed_time/qs.execution_count AS ‘AvgElapsedTime’, qs.total_worker_time/qs.execution_count AS ‘AvgWorkerTime’,qs.max_logical_reads, qs.max_logical_writesFROM sys.dm_exec_query_stats AS qsCROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qtWHERE qt.dbid … Continue reading

Posted in SQL Server 2005 | 14 Comments

Looking for a Silver Lining

It’s interesting for me to see how some of the most famous right-wing propagandists are trying to spin the titanic thumpin’ (to use the Dear Leader’s term), that the Republicans took on Tuesday. Here is Rush Limbaugh: "The way I … Continue reading

Posted in News and politics | Leave a comment

A resounding victory for the country!

Last night, we witnessed a massive defeat for the Bush Administration and their enablers, the the now broken rubber-stamp Republican House and Senate. Glenn Greenwald has a great post that debunks some of the upcoming spin and mythology.

Posted in News and politics | Leave a comment