Monthly Archives: August 2007

Lock Pages in Memory in 64-bit SQL Server 2005

Microsoft has a good article (KB918483) that explains why it is so important to grant the "Lock Pages in Memory" right to the SQL Server Service Account when you are running 64-bit SQL Server 2005. According to the KB, this only … Continue reading

Posted in SQL Server 2005 | 21 Comments

Cumulative Update 4 For SQL Server 2005 SP2

Microsoft has announced Cumulative Update 4 for SQL Server 2005 SP2 due in "the October 2007" timeframe. This follows Cumulative Update 3 for SQL Server 2005 SP2, which is supposed to be available by the end of August. Technorati Tags: … Continue reading

Posted in SQL Server 2005 | Leave a comment

Amount of RAM For Procedure Cache Should be Configurable

Adam Machanic has a good suggestion up on Connect. Basically, he is asking for a configuration option that would let you set the maximum size of the procedure cache in SQL Server 2005 (and beyond). This is mainly a problem … Continue reading

Posted in SQL Server 2008 | Leave a comment

Windows Vista Updates

James Bannan spent some time digging into a leaked version of an early build of Vista SP1, and has generally good things to say about it. He also mentions two compatibility and performance updates that Microsoft released "under the radar" … Continue reading

Posted in Windows Vista | Leave a comment

Republican Fear and Desperation

Here is a link to an actual fund raising letter sent out from the "Office of Strategic Information" of the Republican National Committee (RNC).  This letter is quite a hoot, alternating between fear and veiled threats. President Hillary, oh no!!!  … Continue reading

Posted in Politics | Leave a comment

Great American Beer Festival in Denver

The Great American Beer Festival (GABF) will be held in Denver at the Colorado Convention Center from Oct 11-13. This is a little later in the year than last year. I went last year, with a group of co-workers, and had … Continue reading

Posted in Food and drink | 1 Comment

Daytime Television

I was sick (for the first time in well over a year) on Monday and Tuesday, so in between actually sleeping, I watched some daytime TV. What a revelation!  I happened to catch Passions on NBC on both days. This … Continue reading

Posted in Entertainment | Leave a comment

Webb Alert

Morgan Webb (from the G4 Network) has a new video blog that covers tech news. She is very easy on the eyes, but more importantly she seems to really know her stuff.  It sort of reminds me of the old … Continue reading

Posted in Computers and Internet | Leave a comment

Post SP2 SQL Server 2005 Builds

Microsoft KB article 937137 has a list of all the post SP2 builds for SQL Server 2005. The most current build is 3182, released on July 17. More importantly, build 3179 is supposed to have a fix for the TokenAndPermUserStore … Continue reading

Posted in SQL Server 2005 | Leave a comment

SQL Server 2008 July CTP Available

Microsoft has posted the July CTP of SQL Server 2008 (aka CTP 4) on Microsoft Connect. This build has quite a few new features compared to the previous CTP. Euan Garden summarizes them here. One of the more interesting set … Continue reading

Posted in SQL Server 2008 | Leave a comment