Microsoft SQL server 2012 news

Asked By hareendra 0 points N/A Posted on - 01/05/2012

Hi All,

I have a few questions on SQL 2012

1. Sql server 2012 release date

2. SQL Server 2012 – New Features

3. SQL Server 2012 Training

Thank you all

• Status: Open
• Question Views: 1055
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Paul Mac

Go To Solution

Answered By Zorian Crust 80 points N/A #97211

Microsoft SQL server 2012 news

Hello Hareendra,

For your first question which is the release date of Sql server 2012 , there is no exact date yet on when they are going to release it but some says that it will be released early 2012 because sql server 2011 has been released october 2011.

SQL Server 2012 – New Features

• Always On
• Contained databases
• Column store Indexes
• T-SQL enhancements
• Show Plan Enhancements

ForSQL Server 2012 Training please check out their site below:

https://www.microsoft.com/en-us/learning/sql-training.aspx

 

-Zorian

 

About Zorian Crust

Questions
0

Answers
377

Best Answers
138

• Vote Up 0 Vote Down

• Posted on - 01/05/2012
• Question Category: MS SQL Server

Best Answer

Best Answer

Answered By Paul Mac 0 points N/A #97212

Microsoft SQL server 2012 news

 

Microsoft Database Server is releasing   “SQL Server 2012 Denali”

There are many features added to this Denali they are

Exception Handling:

The   “Try Catch” block in 2005 server we cannot simply “re throw”  the exception and we need to raise a new exception after catching it  but  now we can use “throw function”.

Page Data:

Retrieving current page data from database was a complex one but we can retrieve certain range of data from database using “OFFSET” and “FETCH NEXT” keyword.

Full Text Search: 

SQL Server 2012 allows you to search the index data stored in metadata or extended properties.

Data Quality Service:

Data quality service gives you the information about your data depends on and also shows the lineage of the data and where it comes from and the system behind it.

Web based Visualization:

It provides drag and drop ad-hoc reporting functionality.

 

The release  date of  SQL Server  2012 is not  known.

 

 

 

 

 

 

 

About Paul Mac

Questions
0

Answers
42

Best Answers
26

• Vote Up 0 Vote Down

• Posted on - 01/05/2012
• Question Category: MS SQL Server