Skip to main content
Mitch Irsfeld

TechNet Flash, Volume 14, Issue 8 - April 11, 2012
TechNet Flash Editor's Note from Mitch Irsfeld

Your Path to Cloud-Ready Data

SQL Server 2012 is now generally available, with new features that form the foundation of a cloud-ready information platform. With this milestone, we've collected the resources you'll need to get you up to speed on the new capabilities, facilitate your evaluation, and learn how you can extend data across your datacenter as well as private and public cloud environments.

Just starting your exploration of the new data platform? A good place to begin is the SQL Server 2012 What's New White Paper for an overview of the new features, benefits, and functionality. Also see the TechNet Wiki article What's New in SQL Server 2012, where you'll find links to TechNet Library articles detailing the new features in SQL Server 2012.

For a more immersive experience, head on over to the SQL Server 2012 Virtual Launch Event, now available at your convenience. Engage with experts, see the sessions, and harness the power of the SQL Server community.

In Particular
SQL Server 2012 means more deployment opportunities. The hybrid IT approach uses a common data architecture to span servers, appliances, and the cloud, not to mention new high-availability and business intelligence features, and tools for unifying SQL Server and SQL Azure cloud database development.

Be sure to check out the high-availability and disaster recovery capabilities in the AlwaysOn suite that provide redundancy within a datacenter and across datacenters to help enable fast application failover during planned and unplanned downtime. For an overview discussion of how to reduce planned and unplanned downtime, maximize application availability, and provide data protection using SQL Server 2012 AlwaysOn high availability and disaster recovery solutions, check out the SQL Server AlwaysOn Solutions Guide.

Self-service analytics tools, dashboards, and controls will reduce support requests and help monitor user activity and gather performance metrics. Read about the New Analysis Services and see how the SQL Server 2012 Business Intelligence capabilities like Power View and PowerPivot help unlock new insights.

With the advent of SQL Server 2012 comes the ability to create user-defined server roles - a huge step forward for self-service SQL management. TechNet Magazine has published an article on SQL Server 2012 User-Defined Roles, in which author Denny Cherry steps through three ways to create user-defined roles.

Also new with SQL Server 2012 is the ability to set up partially contained databases, databases that are isolated from others and from the instance of SQL Server that hosts them, but allow some features to cross the database boundary. This can ease some migration and consolidation issues, since a partially contained database can store important information so the database still has the information after it is moved. Denny Cherry penned another TechNet Magazine article, Sometimes Partial Is Preferable, which describes how to set up a partially contained database and create a contained user.

Evaluate and Learn
Once you're ready to go hands-on with software, read up on the Hardware and Software Requirements for Installing SQL Server 2012 and get the SQL Server 2012 Trial and the SQL Server 2012 Feature Pack, a collection of additional stand-alone tools and components.

Then head over to the Install SQL Server 2012 page on TechNet to read the latest about SQL Server installation and upgrade, and watch videos that show step-by-step installation of a SQL Server stand-alone or failover cluster instance.

If you're past the evaluation stage and ready to plan for your upgrade, your first stop is the SQL Server 2012 Upgrade Advisor for guidance on using the tool that analyzes installed components from earlier versions of SQL Server, and then generates a report that identifies issues to fix before or after you upgrade. If you're looking to migrate from other database platforms, check out the SQL Server Migration Assistant.

To help you and your team get up to speed on the new SQL Server 2012 capabilities, the Microsoft Virtual Academy (MVA) offers a series of free courses where you can learn at your own pace and gain community recognition for your progress. Here are a few more learning opportunities:

Of course, a great way to learn is from your colleagues, and there are numerous entry points into the expert SQL Server community on TechNet. Get your questions answered or follow the discussion on the SQL Server Forums. For more on why it's important for DBAs to take part in the forums, become MVPs, and otherwise share with the community, Brad McGehee supplied TechNet Magazine with an excerpt from his book How to Become an Exceptional DBA (Red Gate Books, 2008). Read Support the SQL Server Community to understand what you can bring to the SQL DBA community.

Thanks for reading,

Mitch Irsfeld
Editor, TechNet Flash

Subscribe to TechNet's Today's News feed for news updates as they happen, often several times a day.