Benjamin Wright-Jones

Exploring Information, Infrastructure and Solution Architecture

February, 2008

Posts
  • Benjamin Wright-Jones

    Wondering what's new in CTP6?

    • 0 Comments

    https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5470

  • Benjamin Wright-Jones

    Transactional replication and support for partitioning in Katmai

    • 0 Comments

    Its nice to see that transactional replication in SQL Server 2008 will support the use of the SWITCH partition statement.  Unfortunately it looks like the ALTER PARTITION statements will not make it so this will have to be performed manually on the subscriber. 

  • Benjamin Wright-Jones

    Windows Server 2008 EE and Katmai CTP6 - installation experience

    • 1 Comments
    • One of the first mistakes I made was to try a Katmai install on Windows Server 2008 EE core - don't do this as it will not work (although it would be nice if it did).  SQL Server Katmai is only supported on Windows Server 2008 full as the .NET framework is not included in the core build. 
    • SQL Server installer UI has changed, aptly named, SQL Server Installation Centre. 
    • Adding components to an existing CTP6 instance is only supported via the command prompt e.g. setup.exe /FEATURES=AS,RS; which is a pain if your initial installation fails.
    • This is a feature-rich CTP; filestream, resource governor, DMF, performance warehouse etc. are all there.  Things like TABLIX and the gauge controls are also present in reporting services.
    • CTP6 supports SxS installation with Server 2005.  I took the plunge and installed it on my Vista x64 laptop, and the installation worked first time (no problems) unlike the install on WS 2008 EE, which caused me a few problems. 
    • Surface area configuration has disappeared.  I'm sure there are plenty of other things I have missed but these are the areas which I remember. 
  • Benjamin Wright-Jones

    New whitepaper from HP

    • 0 Comments

    It's a good read and highlights the impact of the CHECKPOINT duration on database mirroring.  The paper also compares the use of HP array based technologies. 

    High availability for Microsoft SQL Server 2005 using array-based replication and host-based mirroring technologies http://h71028.www7.hp.com/enterprise/cache/581666-0-0-0-121.html

  • Benjamin Wright-Jones

    Thoughts about Hyper-V

    • 0 Comments

    I've just had the opportunity of listening to a program manager talk about Hyper-V in Windows Server 2008.  I must admit that it looks really impressive, particularly the support for up to 4 cores and the snapshot facility.  I can see where I could use this for testing SQL Server builds/installations and troubleshooting performance issues.  All I need now is a quad core proc, 8gb RAM, 1 TB storage and a copy of Windows Server 2008 Enterprise Edition!

  • Benjamin Wright-Jones

    Windows Server 2008 hits RTM and is on Connect

    • 0 Comments

    Just noticed an email in my inbox stating that Windows Server 2008 RTM is available for download on the Connect website, however product keys are not being provided.  I'll have to download it later today/tomorrow and have a play with the new features. I'll report back here with my thoughts, particularly the Katmai install experience. 

Page 1 of 1 (6 items)