SQL Server Mentalist

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.

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 :

• Developer Experience #1 – What’s new in SSIS ! No More NEW from Now !!
• Breakthrough Insight SQL Server 2012 , SQL Server Evolution 2000 – 2012
• New Features , SSDT Introduction and links
• Installation, Problem, Support and Help !
• Migrating to SQL Server 2012 Failover Clustering and Availability Groups

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:

• Install SQL Server 2012 from the Command Prompt.
• Install SQL Server 2012 Using a Configuration File
• Install SQL Server 2012 Using SysPrep
• Create a New SQL Server Failover Cluster (Setup).
• Upgrade to SQL Server 2012 Using the Installation Wizard (Setup)

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

• Availability Enhancements (Database Engine) : High availability features
• Manageability Enhancements (Database Engine) :Tools and monitoring features
• Programmability Enhancements (Database Engine)
• Scalability and Performance Enhancements (Database Engine)
• Security Enhancements (Database Engine)
• Resource Governor Enhancements (Database Engine)
• Microsoft.SqlServer.Dac and Microsoft.SqlServer.Dac.Extensions 

From above all topic you can decide weightage of this page

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:

• Deployment
• Management and Troubleshooting
• Development Enhancements
• Performance
• Data Quality
• Access to Samples and Tutorials

Introducing Data Quality Services

Introducing Data Quality Services : The data-quality solution provided by Data Quality Services (DQS) enables a data steward or IT professional to maintain the quality of their data and ensure that the data is suited for its business usageIn this topic we have
• The Business Need for DQS
• Answering the Need with DQS
• A Knowledge-Driven Solution
• DQS Components
• Data Quality Functionality in Integration Services and Master Data 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


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

Second quick observation SQL server Version

Two Additional folder component for more research and better performance

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

Reference link

• The SQL Server Management Studio Environment
• Features in SQL Server Management Studio
• Build Database Projects by Using SQL Server Management Studio
• Tool Windows in SQL Server Management Studio
• Understand SQL Server Management Studio Windows Management
• Administer Servers with SQL Server Management Studio
• User Assistance in SQL Server Management Studio
• Customize Menus and Shortcut Keys
• Property Pages in SQL Server Management Studio
• Introduction to SQL Server Management Studio for Business Intelligence
• Add an External Tool to the Tools Menu (SQL Server Management Studio)
• Configure Login Auditing (SQL Server Management Studio)
• Configure WMI to Show Server Status in SQL Server

You may also interested in reading topics like

• MSBI #45 – SQL Server 2012 #1 – Now SQL Server ‘Denali’ is 2012 !
• BISQL # 51 : SQL Server Denali Feature # 2 – Sequence number –All Explanation !!
• BISQL # 53 : SQL Server Denali Feature # 3 – Always On (Concept ,Architecture)
• BISQL # 50 : SQL Server Denali Feature # 1- File Tables # 2 – Demo and Scripting
• BISQL # 49 : SQL Server Denali Feature # 1–File Tables #1 – Introduction & Theory

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 |