Monthly Archives: November 2011

Tuesday Hardware Tidbits, Nov 29, 2011

Since Microsoft is moving to core-based licensing for SQL Server 2012 Enterprise Edition, with a minimum of four physical core licenses per physical socket, I have had a few questions about what is the “best” quad-core processor to choose for … Continue reading

Posted in Computer Hardware, Processors, SQL Server 2012, SQL Server Denali | Tagged , | 1 Comment

Promoted to Master Group By Thomas LaRock

SQLRockstar Thomas LaRock has updated his blogger rankings this month, and I was pleasantly surprised to see that he had moved me up from the Model group to the Master group. This is quite an honor, since Thomas spends quite … Continue reading

Posted in SQL Server 2008 R2, SQL Server 2012, Teaching | Tagged | 3 Comments

Hotfix for SQL Server 2008/2008 R2 Periodically Does Not Accept Connections Bug

Microsoft has released a hotfix for a very frustrating issue that plagued me for a couple of years at NewsGator.  I recently became reacquainted with this old problem with Error: 18056, Severity: 20, State: 29. Basically what happens is that … Continue reading

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged | 18 Comments

Speaking at Spring 2012 SQL Server Connections in Las Vegas

I am going to be one of the speakers at the Spring 2012 SQL Server Connections Conference in Las Vegas, Nevada. This conference will be held from March 26-29, 2012, and you can register here. The banner on the conference … Continue reading

Posted in SQL Server 2012, Teaching | Tagged | 1 Comment

SQL Server 2008 Service Pack 3 Cumulative Update 2 Released

Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 2, which is Build 10.00.5768.00. I count only 3 fixes in this CU. As I always do, I want to remind everyone that this CU is only for SQL … Continue reading

Posted in Microsoft, SQL Server 2008 | Tagged | Leave a comment

SQL Server 2008 Service Pack 2 Cumulative Update 7 Released

Microsoft has released SQL Server 2008 Service Pack 2 Cumulative Update 7, which is Build 10.00.4323.00. I count 18 fixes in this CU, several of which are related to Full-Text indexes. If you are still on the SQL Server 2008 … Continue reading

Posted in Microsoft, SQL Server 2008 | Tagged | Leave a comment

Tuesday Hardware Tidbits, Nov 15, 2011

A couple of interesting developments this week. First, Intel has officially released (and lifted the embargo) on their new high-end, Sandy Bridge-E desktop processors that use the LGA 2011 platform and X79 chipset. This is relevant for SQL Server professionals … Continue reading

Posted in Computer Hardware, Processors | Tagged | 1 Comment

OT: Amateur Astronomy

Back in 1997, when the Mars Pathfinder bounced down on Mars on July 4, releasing the little Sojourner rover to move around the Martian surface, I became interested in Astronomy. I was living in an apartment in Foothill Ranch, California, … Continue reading

Posted in Astronomy, Hobbies | Tagged | Leave a comment

SQL Server 2012 Licensing and Hardware Considerations

Last week, Microsoft announced some pretty fundamental changes in how SQL Server 2012 will be licensed compared to previous versions of SQL Server. With SQL Server 2012, there will be three main Editions of SQL Server. These are Enterprise Edition, … Continue reading

Posted in Microsoft, Processors, SQL Server 2012 | Tagged , | 37 Comments

Eighty Logical Cores of Goodness!

I recently had the opportunity to specify the purchase of a couple of Dell PowerEdge R810 2U servers that will be used as database servers for SQL Server 2008 R2. These two servers have four Intel Xeon E7-4870 (32nm Westmere-EX) … Continue reading

Posted in Computer Hardware, Processors, SQL Server 2008 R2, SQL Server 2012 | Tagged , | 1 Comment