SQL Server 2008 R2: November CTP Feature Pack

Microsoft provides some cool features to help get the most out of SQL

To ensure that SQL Server continues to live up to the promised hype. Micorsoft has released the Novemebr CTP feature pack. The feature pack is a collection of packages that will help to expand and improve SQL Server 2008 R2. Some useful packages that I saw in the CTP are:

  • The SQL Server Management Objects (SMO) - which will allow developers to create client side applications that can be used to manage and administer SQL Server instances.
  • PowerShell Extensions for SQL Server 2008 R2 -  Using the SMO, this package will allow you to manage SQL instances by using Powershell cmdlets. The extensions allow SQL Admins to used cmdlets to execute T-SQL scripts or evaluate SQL Server policies.
  • SQL Server 2008 R2 Upgrade Advisor - will anaylyze instances of SQL Server 2000, SQL Server 2005 and SQL Server 2008. To ensure preparedness and a smooth transition into SQL Server 2008 R2. The advisor identifies and features and confiugration changes and provides useful links to help move an instance successfully.
  • SQL Server Reporting Services Add-in for SharePoint 2007 & SharePoint 2010 - While allowing you to take advantage of report processing and management in the SharePoint 2007 package. The SharePoint 2010 package provides: Multizone support, SharePoint list support and Ribbon User experience. Making the most of Reporting Services by adding SharePoint collaborative features.

The Novemebr CTP Feature Pack is full of some great tools to really extend the usefulness of SQL Server 2008 R2. To see the full set of features and download the packages visit Microsoft’s Download’s

Recent Posts Windows Server 2008 R2: Security Changes and Additions Part III Windows Server 2008 R2: Security Changes and Additions Part II Windows Server 2008 R2: Security Changes and Additions Part I Windows Mobile 6.5 leaves me un-impressed Exchange Server 2010 tools: Do not forget these tools in your Beta Tests 7 tools for Windows 7 rollouts ESF Database Migration Toolkit: From SQL to ORACLE without any fuss Slide Rocket: Create, Collaborate and share your slideshows in the cloud Remote Desktop Services: Some help to keep you from feeling 'Terminal'-ly lost ExRCA: Test your Exchange Server 2007 remote connectivity The iland Workforce Cloud: Go ahead keep your head and desktop in the cloud
Windows 7 Windows 7 Unveiled Will Windows 7 upgrade strategy keep XP users away…NO! Fun with Windows 7 Why Windows 7 will crush Linux Why XP users will switch to Windows 7 Why IT will adopt Windows 7
See my lists of great tools 12 killer freebie SharePoint add-ons Five great Windows open source tools 8 little-known technologies that instantly make Microsoft shops run smoother 9 wickedly useful Web sites for Windows administrators 12 cool cross-platform tools for Windows, Macs and Linux 20 great Windows open source projects you should get to know A Better Windows World Tools Library
Like this and want more? Check out the other tools I've written about in A Better Windows World. the Microsoft Subnet home page for more bloggers, news, humor, security alerts and more.

Plus, check out

Join the Network World communities on Facebook and LinkedIn to comment on topics that are top of mind.
Take IDG’s 2020 IT Salary Survey: You’ll provide important data and have a chance to win $500.