WesleyB's Blog

My long term memory for SQL Server related information.

Browse by Tags

Tagged Content List
  • Blog Post: SQL Server Day 2009

    The Belgian SQL Server User Group is organizing the second SQL Server Day on the 3rd of December. Last year about 200 people gathered for this event and of course we hope to have even more this year! Please visit http://www.sqlserverday.be for more information and registration (coming soon). There...
  • Blog Post: Cumulative update package 3 for SQL Server 2008 SP1

    The third cumulative update package for SQL Server 2008 SP1 is now available @ http://support.microsoft.com/kb/971491 . This will take you to build 10.00.2723. People using the auditing function will probably be interested in the following fix http://support.microsoft.com/kb/967552 .
  • Blog Post: Data Compression and Heaps

    I think we can all agree that Data Compression is a great new functionality in SQL Server 2008. I know many of you have been experimenting with it but there was one little catch I wanted you to be aware of. When you apply page compression to a table the pages get compressed when they are full but there...
  • Blog Post: Cumulative update package 2 for SQL Server 2008 SP1

    The second cumulative update package for SQL Server 2008 SP1 is now available @ http://support.microsoft.com/kb/970315 . This will take you to build 10.00.2714. And do not forget the "Lock Pages In Memory" change ( here )!
  • Blog Post: Lock Pages In Memory in SQL Server Standard Edition

    Until now "Lock Pages In Memory" was an option only available to SQL Server Enterprise Edition customers. Very simply put it prevents SQL Server from paging out the memory it has allocated (a deep explanation can be found in the references below). We got a lot of feedback from customers who wanted to...
  • Blog Post: Cumulative update package 1 for SQL Server 2008 SP1

    Wow, the guys in the SQL Server team are working really hard. The first CU for SQL Server 2008 SP1 has already been released and will take you to build 10.00.2710. More information here .
  • Blog Post: SQL Server 2008 Service Pack 1

    We are very proud to announce the release of the first service pack for SQL Server 2008. With the release of SQL Server 2008 we have also made great investments in the installer. I am sure you have all noticed that the setup experience is completely different from the previous version of SQL Server...
  • Blog Post: Cumulative update package 4 for SQL Server 2008

    The guys that deliver the CUs sure do a great job, yet another one delivered on time. This one will take you to build 10.00.1798. More information here .
  • Blog Post: SQL Server 2008 Service Pack 1 - CTP

    We are very pleased to announce the first CTP of Service Pack 1 for SQL Server 2008. Apart from all the fixes we also made a couple investments that you will appreciate. The change that will make many of you very happy is that we now allow slipstreaming of service packs and hotfixes!!! Read more or...
  • Blog Post: The Data Loading Performance Guide

    SQL Server has been gaining a lot of credibility in the data warehousing market the last couple of years. With that the challenge arises more and more to load massive amounts of data in SQL Server. Obviously this is a matter of good hardware in combination with the 'right' way of doing things. Lucky...
  • Blog Post: SAP on SQL Server 2008 and Windows Server 2008

    We are very proud to announce that SQL Server 2008 and Windows Server 2008 are now officially a supported solution for SAP. More information can be found in this press release . Some quick facts from our SAP portal site: Over 65,000 SAP installations are on the Windows Server platform...
  • Blog Post: Microsoft SQL Server 2008 Books Online - January 2009 Update

    Another update to the Books Online for SQL Server 2008 has been posted. Get it here . Is it just me or is SQL Server a very well documented product? What is your experience with other products?
  • Blog Post: Cumulative update package 3 for SQL Server 2008

    Again another 2 months have passed since the last CU for SQL Server 2008 was released. We all know that means the new CU has arrived, this time it will take you to build 10.00.1787. More information here . PS. Sorry for the delay in posting but I am on a holiday :-)
  • Blog Post: SQL Server 2008 Upgrade Technical Reference Guide

    Just a quick notification that the SQL Server 2008 version of this wonderful guide is out. If you are looking at upgrading to SQL Server 2008 this is a must read! Get it here .
  • Blog Post: Cumulative update package 2 for SQL Server 2008

    It has been almost 2 months so here is CU2 for SQL Server 2008 RTM. This time it will take you to build 1779. Check out the details here .
  • Blog Post: SQL Server Day

    It was a couple of months ago that the people from the Belgian SQL Server User Group came up with the idea to organize a large event focused on SQL Server 2008. Of course we thought this was a great idea but we also understood that this would not be something that you arrange in a couple of minutes....
  • Blog Post: Report Builder 2.0 RTM

    We are very proud to announce that Report Builder 2.0 is now available for download! Check out the announcement on the RS Team Blog here or go to the download directly. This is a very important release for our BI stack since ad hoc reporting is becoming more and more important these days. With Report...
  • Blog Post: What happens when I update my partitioning key?

    This is a question someone asked me yesterday and if you think about it, this is really a good question. The partitioning function defines on which partition the row will be mapped based on the partitioning column value. Imagine that you have a table on which you have defined partitioning to make...
  • Blog Post: Running SQL Server 2008 in a Hyper-V Environment

    This is probably one of the most frequently asked questions since we have released Hyper-V and SQL Server 2008. I guess you all know we do support running SQL Server 2008 in a virtual environment ask explained here . Like always there is no good answer to whether you should or should not run SQL Server...
  • Blog Post: Cumulative update package 1 for SQL Server 2008

    Just like we did with SQL Server 2005 we will be releasing cumulative update packages on regular intervals for SQL Server 2008 too. This package contains all of the SQL Server 2008 hotfixes that have been released since the initial release. This first package takes SQL Server 2008 from build 1600...
  • Blog Post: Policy Based Management coolness

    As you all know PBM is one of my favorite features in SQL Server 2008. It is an extremely powerful feature and to make it powerful we need an extensive list of properties to check. If you look at the number of facets and properties for those facets you may be overwhelmed. Lucky for you (and me) we...
  • Blog Post: Report Builder 2.0 RC1

    With the SQL Server 2008 preview releases there was a new tool called Report Builder for your end-user reporting experience. As you probably know this tool was later moved to the Feature Pack and is released seperately. If you are looking for more information about the release plan for this tool please...
  • Blog Post: SQL Server 2008 RTM

    Ladies and gentlemen, the moment we have all been waiting for (well us SQL Server geeks at least). SQL Server 2008 RTM is available for download on http://msdn.microsoft.com/en-us/subscriptions/downloads/default.aspx . Finally some of the exciting features I have been talking about will be applied...
  • Blog Post: SQLRSS Community Application

    This open source project (on CodePlex ) shows how to use different technologies to display table changes as an RSS/Atom feed. It uses the new Change Tracking feature in SQL Server 2008 together with WCF and LINQ to XML. Check out the homepage and if you want to add some features to it feel free to...
  • Blog Post: Best Practices using Policy Based Management

    Another fine addition to SQL Server 2008 is Policy Based Management. This new feature allows you to enforce (or check) policies on your database servers which is a bit comparable to the well known Group Policies in Windows. The list of things you can check is really large and together with the ability...
Page 1 of 2 (29 items) 12