Home > Link, Query, SQL > BISQL # 95 – SQL Server 2012–What’s new Or Summary for future SQL server

BISQL # 95 – SQL Server 2012–What’s new Or Summary for future SQL server

Hi friends ,

In this article I am trying to provide you all new future and information  related SQL Server 2012 based on MSDN topics in which MS has all topics we with concept which is very well explained features.

image

My aim is to provide you SQL Server 2012 Summery future and maximum overview covering all topics which are Part of Release of SQL Server 2012.

I have already covered following topics on my BI blog as follows with there respective links if you have missed any :

In this topics we are going to cover

  • What new SQL Server 2012
  • Install SQL Server 2012 from the Installation Wizard
  • Editions and Components of SQL Server 2012
  • What’s New in SQL Server Installation
  • What’s New (Database Engine)
  • What’s New (Analysis Services)
  • What’s New (Integration Services)
  • Introducing Data Quality Services
  • What’s New (Master Data Services)
  • What’s New (Replication)
  • What’s New (Reporting Services)
  • SQL Server 2012 – SSMS – @ First Glance
    Install SQL Server 2012 from the Installation Wizard

For installation we can see topic : Install SQL Server 2012 from the Installation Wizard (Setup) in which we have detailed steps to install SQL Server 2012

Also We have installation topics such as:

    Editions and Components of SQL Server 2012

On this topic what are the different editions of SQL Server accommodate the unique performance, runtime, and price requirements of organizations and individuals explained nicely :Editions and Components of SQL Server 2012

SQL Server Components

  • SQL Server Database Engine
  • Analysis Services
  • Integration Services
  • Reporting Services
  • Master Data Services
  • This list is somewhat same but inner content has more but powerful difference.

    Management tools List
  • SQL Server Management Studio
  • SQL Server Configuration Manager
  • SQL Server Profiler
  • Database Engine Tuning Advisor
  • Data Quality Client
  • SQL Server Data Tools
  • Connectivity Components SSDT – SQL Server Data Tools is key holder for now we have already discuss on my BI Blog
  • New Lets focus on compressive changes from MSDN :

What’s New in SQL Server Installation

What’s New in SQL Server Installation : In this topics we have list of changes related to installation such as Datacenter Edition,Business Intelligence edition,Enterprise Editions,Microsoft Sync Framework,SQL Server Data Tools ,Data Quality Services,Server Core Installation,SMB file share is a supported storage option . Click on topic header for View.

What’s New (Database Engine)

What’s New (Database Engine) : This is most important change in which we have various interesting topics such as

What’s New (Analysis Services)

What’s New (Analysis Services) : This is also extended and bigger change by introducing and placing new and old features to form  Robust Architecture for development .

Lots of link are there in this page also following are some key topics for same

  • Server Instance and Server Monitoring
  • Tabular Modeling
  • Multidimensional Modeling
  • PowerPivot for Excel
  • PowerPivot for SharePoint
  • Programmability
  • Design Tools
    What’s New (Integration Services)

What’s New (Integration Services) : Way we look @ SSIS is now very different and easy now in SQL server 2012 w.r.t SSIS

The following list to find new features and enhancements by area:

    Introducing Data Quality Services
    What’s New (Master Data Services)
    What’s New (Master Data Services) : Around more than 10+ feature such as Use Excel to Manage Master Data,Match Data before Loading,New Model Deployment Tools,SharePoint Integration Introduced,Security Simplified and Installation is Part of SQL Server with many more topics ..

What’s New (Replication)

    What’s New (Replication) : In this release of SQL Server introduces several new features and improvements to replication such as Replication Support for AlwaysOn Availability Groups ,Replication Extended Events and many more

What’s New (Reporting Services)

What’s New (Reporting Services) : Now Reporting is different world in way of SQL server 2012 in which have most important as follows :

  1. Power View
  2. SharePoint Mode
  3. Data Alerts
  4. Report Server Projects in SQL Server Data Tools for Visual Studio 2010
  5. Excel Renderer for Microsoft Excel 2007-2010 and Microsoft Excel 2003
  6. Word Renderer for Microsoft Word 2007-2010 and Microsoft Word 2003

  7. SQL Server 2012 – SSMS – @ First Glance

Now , following are my quick observation while using SSMS very first time in back ..

At SSMS start we can find change and updated logo i.e. Powered By Visual Studio

image

Second quick observation SQL server Version

image

Two Additional folder component for more research and better performance

image

We will have lot of post on above related to this topic in my upcoming post .

Reference link

    Hope you will like this post on What’s new Or Summary for future SQL server .

    If you really like reading my blog and understood at least few thing then please don’t forget to subscribe my blog.

If you want daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog :

Link Resource Website

For More information related to BI World visit my Mentalist Blog

Link Resource Blog >> Daily Interesting links

SQL Server Mentalist >> SQL Learning Blog

Business Intelligence Mentalist >> BI World

Connect With me on

| Facebook |Twitter | LinkedIn| Google+ | Word Press | RSS |

Categories: Link, Query, SQL
  1. Pallavi
    May 9, 2012 at 11:27 am

    Good information & links collection. Thanks

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,120 other followers

%d bloggers like this: