There's Something about SQL!

...SQL Server, BI and other Cool Technology... var sc_project=1839145; var sc_invisible=1; var sc_partition=17; var sc_security="180bc290";

November, 2008

  • 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...
  • 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...
  • 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...
  • 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...
  • 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 –...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...