Monthly Archives: October 2009

Suggested Max Memory Settings for SQL Server 2005/2008

Posted on October 29, 2009 by Glenn Berry

It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something besides the default setting (which allows SQL Server to use as much memory as it wants, subject to signals from … Continue reading →

Posted in SQL Server 2008 | 24 Comments

Special Events at PASS Summit

Posted on October 26, 2009 by Glenn Berry

Besides giving two Community Session presentations (here and here), next week, I will be involved in the Birds of a Feather (BOF) Lunch on Tuesday, November 3 at 11:30AM and the SQL Server MVP Deep Dives Book Launch and Signing … Continue reading →

Posted in Teaching | 1 Comment

PASS Summit Birds of a Feather Lunch

Posted on October 21, 2009 by Glenn Berry

Mike Walsh, who is a PASS volunteer, has done a nice job organizing the PASS Summit Birds of a Feather Lunch, on Tuesday, November 3 at the PASS Summit in Seattle. You might be wondering what this is. In Mike’s … Continue reading →

Posted in SQL Server 2008 | 4 Comments

SQL Server 2005 SP3 CU6 Released

Posted on October 20, 2009 by Glenn Berry

Microsoft released Cumulative Update 6 for SQL Server 2005 SP3 yesterday (and the KB link is working today). This is Build 4266. There are over twenty fixes included in the CU, including a couple for database mirroring. All of the … Continue reading →

Posted in SQL Server 2005 | 22 Comments

SharePoint 2010 And SQL Server 2008 R2

Posted on October 19, 2009 by Glenn Berry

Lots of interesting news and announcements coming out of the SharePoint 2009 Conference that started today in Las Vegas. Microsoft’s Jie Lie has a good post up describing the technical requirements for SharePoint 2010, which include requiring x64 Windows Server … Continue reading →

Posted in SQL Server 2008 | 1 Comment

Visual Studio 2010 Beta 2 Available On MSDN Subscribers

Posted on October 19, 2009 by Glenn Berry

Mary Jo Foley posted about Visual Studio 2010 Beta 2 being available on the MSDN Subscriber’s site today, so I popped over to check, and sure enough it was there, relatively early in the day.  She claims that it is … Continue reading →

Posted in Visual Studio 2010 | Leave a comment

More SQL Server 2008 Book Involvement

Posted on October 15, 2009 by Glenn Berry

Last night, I received my hard-copy of Pro SQL Server 2008 Mirroring from APress. This book has a lot of useful information and code to help you easily create and monitor database mirrors in SQL Server 2008. I was the … Continue reading →

Posted in SQL Server 2008 | Leave a comment

What Is Using The Most Space In Your Database ?

Posted on October 14, 2009 by Glenn Berry

As I work on moving a large system with multiple database servers from a 27TB SAN to a single database server with about 6TB of direct attached storage (DAS), I have to worry much more about space utilization. The stakes … Continue reading →

Posted in SQL Server 2008 | 10 Comments

New Dell PowerEdge R710 Database Server

Posted on October 9, 2009 by Glenn Berry

My long awaited new database server arrived today! It has two, quad-core Xeon X5550 processors, 72GB of DDR3 RAM, and eight 73GB 10K SAS drives. I have hyper-threading enabled, so the OS sees 16 cores. Intel offers two slightly faster … Continue reading →

Posted in SQL Server 2008 | 6 Comments

SQL Server Announcements From Microsoft

Posted on October 9, 2009 by Glenn Berry

Microsoft has announced the upcoming end of mainstream support for SQL Server 2005 SP2 on January 12, 2010, and for SQL Server 2008 RTM on April 13, 2010. This just means that you need to upgrade to a newer Service … Continue reading →

Posted in SQL Server 2008 | Leave a comment