The official PASS Blog is where you’ll find the latest blog posts from PASS community members and the PASS Board. Contributors share their thoughts and discuss a wide variety of topics spanning PASS and the data community.

We've moved!

Looking for the latest blog posts? We've recently moved the PASS Blog to its new home at You can still view older blog posts here but please update your bookmarks so you can continue getting the latest posts from the PASS Blog.

From category archives: PASS Blog

SQL Server 2012

Official Launch of SQL Server 2012 Takes Place March 7, 2012!

Jennifer Moser, Microsoft SQL Server Senior Marketing Manager and PASS Director, spoke with PASS Marketing Vice President Thomas LaRock again to discuss more about the upcoming virtual launch event of SQL Server 2012 on March 7, 2012.

Thomas: Last time we spoke, you told me about the SQL Server Virtual Launch Event, are there updates you can share?
Jennifer:  Absolutely! As you know on March 7, 2012 we will be hosting the first ever Microsoft SQL Server online launch event. We opened registration for the event in late January and the community seems very excited about this event!

Thomas:  Wow! That’s great news. What do you attribute to your success so far?  
Jennifer:  A couple of things. First, we’ve developed a compelling track of sessions that appeals to our core audience, our IT implementers. We’ve created approximately 30 sessions which focus on the new features and improvements of SQL Server 2012 and our vision for the future. Plus we’re showcasing customers who have already implemented SQL Server 2012. It’s one thing to hear how great SQL Server 2012 is from us- but when you hear directly from customers who have already had success, it has a lot more impact. I’d also attribute our success to our community. Our SQL family has really stepped up to help share the exciting news with their inner circles. We couldn’t have had this kind of success without them.

Thomas:  That’s great to hear! I also hear PASS is giving away some goodies as well. :)
Jennifer:  Yes, you’re right! We’re doing a PASS sweepstakes where if you visit the PASS booth in the Expo Hall on March 7, 2012 you will be entered to win one of six PASS Summit 2012 Recorded Sessions DVD sets, or one of three grand prizes - a full-conference pass to PASS Summit 2012! 

Thomas:  Can’t wait! Looking forward to it. 

Register today and join the 14,000+ that have already signed up.




Official Launch of SQL Server 2012

Jennifer Moser, Microsoft SQL Server Senior Marketing Manager and PASS Director, recently talked with PASS Marketing Vice President Thomas LaRock about the upcoming virtual launch event of SQL Server 2012 on March 7, 2012.

Thomas: I understand Microsoft is celebrating the launch of SQL Server 2012 with a Virtual Launch Event.  Why online?

Jennifer:  On March 7, 2012 we will be hosting the first ever online event to officially launch SQL Server 2012. We wanted a place where anyone, anywhere in the world could simply log-in and be a part of this exciting experience. There are so many reasons why hosting an online event made sense to us this year, but the biggest reason is that hosting a virtual launch event allows our customers to consume content at their own pace while still experiencing all the benefits of a live event.

Thomas:  Appreciate the focus on the international community.  What can we expect from this experience?  

Jennifer:  We are excited to have over 30 sessions that introduce customers to the new capabilities of SQL Server 2012. Attendees will hear from industry experts + Microsoft executives and be able to connect with peers from the #SQLFamily. We will also have an expo hall and networking lounge – just as you would have in a live event. One of our favorite features about launching SQL Server 2012 online is the community aspect. Attendees can connect, share, and learn from their peers all from the comfort of their own home or office. Customers can also win badges and hundreds of cool prizes throughout this virtual launch.

Thomas:  How is PASS participating in the SQL Server 2012 Virtual Launch Event?

Jennifer:  We are very excited to have PASS participate in the SQL Server 2012 Launch Event with a PASS booth in the expo hall area. PASS will have videos, links to content, and live chats with board members, local chapter leaders and PASS HQ. Part of the experience will include three live streaming keynote sessions in US, UK & EMEA, and Asia Pacific time zones to reach the maximum number of people. Our goal is to make the event as friendly to people across the globe as possible and we are especially excited to highlight regional & local PASS leaders throughout the experience.

Thomas:  Where do people go to register for the Virtual Launch Event?

Jennifer:  The SQL Server 2012 Virtual Launch Event registration has just gone live. Visit and register today. We’re really excited see you all on March 7th to experience the SQL Server 2012 launch!


SQL Server 2012: Get Production Quality Today!

Jennifer Moser, Microsoft SQL Server Senior Marketing Manager recently spoke with PASS Marketing Vice President Rick Heiges about the latest release of Microsoft SQL Server 2012.

Rick: I hear you just released SQL Server 2012 Release Candidate – what’s the scoop?

Jennifer: Building on our announcement at the PASS Summit 2011 in early October, we are excited to announce the Microsoft SQL Server 2012 Release Candidate (RC). SQL Server 2012 RC is the first release which is feature complete and represents an exciting milestone for customers and partners looking to experience the full value of SQL Server 2012.

Rick: So, what’s in the Release Candidate?

Jennifer: We’re happy to share that SQL Server 2012 RC is a production quality release providing:

  • Greater availability. Deliver the required 9s and data protection with AlwaysOn, with added functionality over CTP3 that allows customers to experience multiple, readable secondaries for distributed scale of reporting and backup workloads and support for FileTable and FILESTREAM which brings first-class HA to complex data types.
  • Blazing-fast performance. More effectively govern performance in multi-tenancy environments like private cloud. Resource Governor enhancements include support for 64 resource pools, greater CPU usage control, and resource pool affinity for partitioning of physical resources and predictable resource allocation.
  • Rapid data exploration. Empower end users with new insights through rapid data exploration and visualization. Discover new insights at the speed of thought with more feature/functionality in Power View, the highly interactive, familiar browser-based data exploration, visualization, and presentation experience for end users.
  • Credible, consistent data. In addition to CTP3 functionality delivered for Data Quality Services and Master Data Services, customers can better support heterogeneous data within Data Warehouses through new Change Data Capture (CDC) support for Oracle.
  • Optimized productivity. Optimize IT and developer productivity across server and cloud with the new SQL Server Data Tools, a unified development experience for database and business intelligence projects, and cloud-ready capabilities within SQL Server Management Studio for snapshot backups to the Windows Azure Platform. Additionally, SQL Server 2012 offers a new version of Express – LocalDB. SQL Express LocalDB is a lightweight version of Express with all its programmability features, yet runs in user mode with a fast, zero-configuration installation and short list of pre-requisites.

Rick: That sounds good, but should I be testing with this release or actually using it?

Jennifer: Today, you can download, preview and deploy the full marquee capabilities being delivered in SQL Server 2012.RC is a production quality release that includes access to upgrade and migration tools like Upgrade Advisor, Distributed Replay and SQL Server Migration Assistant (SSMA). Upgrade Advisor and Distributed Replay allow you to perform thorough analysis and testing of your current SQL Server applications before upgrading so you know what to expect. You can also use SSMA to automate migrate non-SQL Server databases to SQL Server 2012.

Download SQL Server 2012 RC today here:


Preparing for SQL Server 2012: What You Need to Know

Lara Rubbelke, Microsoft SQL Server Community Principal Program Manager, recently talked with PASS Marketing Vice President Rick Heiges about the changes in editions and licensing for SQL Server 2012.

Rick: Thanks for taking the time to answer my questions Lara. Let’s get right to it: What’s new in SQL Server 2012 as far as editions?
We’ve streamlined SQL Server 2012 editions to better align with how customers are deploying applications and solutions and are releasing SQL Server 2012 in three main editions:
•    Enterprise Edition – for mission-critical applications and large-scale data warehousing
•    Business Intelligence (BI) Edition  – a new edition that provides premium corporate and self-service BI
•    Standard Edition – for basic database, reporting, and analytics capabilities

Enterprise Edition will include all features available in SQL Server 2012, and the BI Edition will include premium BI features as well all of the Standard Edition features.

Rick: What about the other editions that currently available in SQL Server 2008 R2?
Good question Rick. With the release of SQL Server 2012, we will be retiring:
•    Datacenter – its features will now be available in Enterprise Edition
•    Workgroup – Standard will become our edition for basic database needs
•    Standard for Small Business – Standard becomes our sole edition for basic database needs

Your readers should also note that SQL Server 2012 will continue to be available in Developer, Express, and Compact editions without licensing or pricing changes. The Web edition will be offered only to hosters via a Services Provider License Agreement (SPLA).

Rick: What are the key licensing changes with SQL Server 2012?
SQL Server 2012 will continue to offer two licensing options: one based on computing power, and one based on users or devices. In the computing power-based license model, however, the way we measure power will shift from processors to cores. Core-based licensing provides a more precise measure of computing power given high core-density server hardware. It also provides a more consistent licensing metric regardless of where the solution is deployed across on-premises to cloud.
Rick: When will these changes go into effect, and how can our readers learn more?
Licensing changes will go into effect with the general availability of SQL Server 2012, which is expected to be released in the first half of 2012. For more information about editions, licensing, and planning for SQL Server 2012, you can check out the Microsoft SQL Server 2012 website.

For customers who would like to understand how to transition to the new license model, Microsoft has a great resource here.


Back to Top