Getting those memory setting in SQL Server just right.

When using 64bit SQL Server getting the memory settings right is pretty easy. Simply set the maximum to what you want and you are good to go. Getting them right in the 32bit versions of SQL Server is a bit harder. You have to deal with the OS level of enabling the Physical Address Extensions...
Webcast turnout was fantastic

Thanks to all who attended this morning webcast ‘Under The Hood of SQL Server - Checking...
Heroes Happen Here {Comic Series}

For those that don't get the Tech Net news letter Microsoft and Seagate are producing a new comic strip called Heroes Happen Here. It's published on the Tech Net blog here. You can also grab the RSS feed in your...
New Paper Published: Picking the Right Instrument for SQL Server Performance Management

The folks at Quest Software asked me to write a paper for them discussing the differences between managing a SQL Server using just the Microsoft provided tools and their Spotlight on SQL Server Enterprise product. That paper has just been released and can be downloaded
Today is my birthday!

Well today is my birthday. Since it's a regular posting day I figured I'd skip the technical posting and just say hi. (I've got this thing against working on my birthday. I'd much rather spend the day with family and friends. It's my day and I'll do what I want, as long as it's ok with the...
Webcast: ‘Under The Hood of SQL Server – Checking Out Internals’

On Thursday Feb 7, 2008 at 8am Pacific (11am Eastern, 4pm GMT) myself and Jason Hall, Systems Consultant at Quest Software will be co-hosting a webcast looking into the challenges in seeing exactly what is happening within SQL Server (including SQL Server 2008) using Spotlight® on SQL Server...