SQL Server 2008 Upgrade Technical Reference Guide

The SQL Server 2008 Upgrade Technical Reference Guide is now Live and available to download.   It is a 490-page white paper  (hold on, do not get scared, you don’t need to read it all :-)) which covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL…

1

X64, Lock Pages in Memory and AWE – Should I or Should I Not?

I’ve heard this question thousands of times so I’ve thought to try to summarize some recommendation in this blog post.    For 32 bits, things are pretty straight-forward. If they are not, I’ve posted some comments some time ago: \3GB \PAE and AWE – Taking away (some) confusion http://blogs.technet.com/beatrice/archive/2008/08/29/3gb-pae-and-awe-taking-away-some-confusion.aspx   For 64 bits, things are…

1

The Hidden Database in SQL Server 2005 and 2008

Have you ever had to move your master database? Or have you ever opened the folder which contains your master database? Both cases – if that ever happened to you, you should already know about the Resource Database – a hidden, read-only database introduced with SQL 2005 which contains all the system objects that are…

0

Performance Monitor, SQL Counters and Tresholds

Whilst surfing on the web last week, I’ve found this very nice blog from Vipul Shah, which happens to be a Microsoft colleague, which explains which are the key performance counters to monitor for your SQL Server instances and most importantly summarizes which are generally the thresholds you want these counters to fit within.  …

0

Reading User Group Meeting – 20th Nov

For those which live or work close to Reading – there will be a UserGroup on the 20th Evening held in TVP – Microsoft Offices.   Agenda:   6pm – 6:30 Registration and networking + Tea/Coffee with biscuits.   Meet and greet.   6:30pm – 7 Round Table discussion – ALL   Take stock and…

1

PPT Plex add on for Power Point – Cool!

PPT Plex is a new tool – or more precisely – a new add on for Microsoft Power Point – which will change the way you will deliver your presentations.   In short, what it allows is a different navigation experience trough your slide deck. Instead of having the classical navigation path – in which…

1

Resource Governor – How to get started?

  Here we are, as promised, with some rumblings on SQL Server 2008 Resource Governor.   I’ve played a lot with the various options which this features provides, especially in preparation of my TechEd presentation last week! Did I ever mention how much I loved it :-)? Yeah, I guess too much already. Ok, so…

2

SQL Server and Virtualization – can we help?

  Just discovered whilst at TechEd that Microsoft policies for SQL Server products that are running in a hardware virtualization environment are not much known as yet to the majority of the public.   Therefore the PFE in me 🙂 wants to be sure that when you opt for virtualization you are in a safe…

1

TechEd ItPro – SQL Server 2008 Resource Governor!

  Wow! Presenting at TechEd yesterday had been one of the best experiences of my life!   Being in front of different customers, which work with SQL Server every day, and being able to share my experience on the field with the new great features included with SQL 2008 had been fantastic, and a great…

1

I’m at TechEd ItPro – Barcelona!

  This week I’m presenting on SQL Server 2008 Resource Governor @TechEd Barcelona http://www.microsoft.com/emea/teched2008/itpro!   My session is on Tuesday, 10:45 – 12:00, make sure to come along if you want to learn about this cool new feature in SQL Server 2008 or if you simply have some questions to ask!   – Beatrice Nicolini…

1