Skip to main content Microsoft Intelligent Data Platform Azure Arc Azure databases Power BI SQL Server 2025 SQL Server BI SQL Server 2022 SQL Server 2019 SQL Server 2017 SQL Server 2016 SQL Server 2005 - 2014 Downloads Community SQL End of Support Data Security - SQL Server Encryption SQL Server blog SQL Server and Azure SQL workshops Browse Microsoft Solutions Hub SQL Server Tech Community Azure Databases Tech Community Azure Synapse Analytics Tech Community Developer Find a partner Become a partner Partner resources Try SQL Server 2025 Microsoft Security Azure Dynamics 365 Microsoft 365 Microsoft Teams Windows 365 Microsoft AI Azure Space Mixed reality Microsoft HoloLens Microsoft Viva Quantum computing Sustainability Education Automotive Financial services Government Healthcare Manufacturing Retail Find a partner Become a partner Partner Network Microsoft Marketplace Software companies Blog Microsoft Advertising Developer Center Documentation Events Licensing Microsoft Learn Microsoft Research View Sitemap

The Fantastic 12 of 2012: Behind the Scenes of Creating Optimized Productivity

The 11th episode of The Fantastic 12 of 2012: Behind the Scenes Blog Series is here, and we are excited to be discussing optimized IT and developer productivity across server and cloud with a common toolset. In this latest episode, Tobias Ternstrom, Lead Program Manager discusses the “Sequence Generator.” Tobias also talks about the discoveries that were made while testing the primary key-generating feature for optimization of performance and ease of use. Watch the full episode below and see what they discovered!

Watch all previous episodes here. There is only one week left in the Twitter Contest that follows every episode of this series, which takes place on Thursdays at 10:30am PDT (through the end of June 2012), where you could win the SQL Server T-Shirt of your choice!

11 Optimized Productivity

Optimize IT and developer productivity across server and cloud with common tools

Build

  • SQL Server Data Tools: Take database development to the next level with SQL Server Data Tools, an integrated development experience for devlopers building next-generation web, enterprise, and data-aware mobile applications across on-premises and public cloud.
  • T-SQL Enhancements: Simplify complex programming tasks with T-SQL enhancements and ease database migrations with improved support for ANSI SQL standards. Additionally, the new Sequence object enables developers to tie unique row identifiers across multiple tables.

Extend

  • Common Tools: Build, extend, and manage database or business intelligence solutions across on-premises and cloud environments using the same development tools, frameworks and T-SQL based model.

Manage

  • SQL Server Management Studio: Manage efficiently at scale with a single console to deploy and manage database assets across servers, private cloud and public cloud. Additionally, use SSMS to manage high availability configurations, BI services, and resource utilization.
    • Automate infrastructure maintenance tasks, streamline troubleshooting and diagnostics and optimize hardware resources with built-in easy-to-use manageability tools.
    • Streamline virtualization management with System Center Virtual Machine Manager.
    • Support for Windows PowerShell 2.0 automates management tasks across the Microsoft platform.

For more information SQL Server 2012, and to download the trial version, please visit: http://cm-edgetun.pages.dev/sqlserver.

English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Microsoft Privacy Manage cookies Terms of use Trademarks Safety & eco Recycling About our ads