20

I found a new title called SQL Server "Denali" in the drop down list on MSDN, but I didn't find much information about it:

Does anyone have more detailed information about new features or significant bug fixes in this release? I'm hoping someone has used or tested it.

New Features

Improve this question
4
  • 2
    Aaron also posted a great list here.
    – Nick Chammas
    Commented Mar 13, 2012 at 20:34
  • certainly if it's too broad to ask where a database violates a spec, it's too broad to ask what a database provides that's "new"
    – Evan Carroll
    Commented Jan 16, 2017 at 4:45
  • @EvanCarroll While there are some questions that would get closed today, I don't think we should be actively closing existing questions that were apparently useful "back when" (judging by the number of votes).
    – Colin 't Hart
    Commented Jan 16, 2017 at 10:57
  • 1
    Questions aren't judged by usefulness but by the ideology of an elite few.
    – Evan Carroll
    Commented Jan 16, 2017 at 23:10

6 Answers 6

Reset to default
13

The new features include :

  • Multi-Subnet Failover Clustering
  • Programming Enhancements including sequences, ad-hoc query paging and full-text search tweaks
  • BI and Web Development Environment Improvements
  • Web-based Visualization
  • Data Quality Services enhanced

You can view the detailed review here : New Features Of Denali

"Denali" is a code name. Here is the list of the code name of other versions of SQL Server:

  • 1993 – SQL Server 4.21 for Windows NT
  • 1995 – SQL Server 6.0, codenamed SQL95
  • 1996 – SQL Server 6.5, codenamed Hydra
  • 1999 – SQL Server 7.0, codenamed Sphinx
  • 1999 – SQL Server 7.0 OLAP, codenamed Plato
  • 2000 – SQL Server 2000 32-bit, codenamed Shiloh (version 8.0)
  • 2003 – SQL Server 2000 64-bit, codenamed Liberty
  • 2005 – SQL Server 2005, codenamed Yukon (version 9.0)
  • 2008 – SQL Server 2008, codenamed Katmai (version 10.0)
  • 2010 – SQL Server 2008 R2, Codenamed Kilimanjaro (aka KJ)
  • 2011 – SQL Server 2012, Codenamed Denali
Improve this answer
1
  • @vettipayyan : semma username:)
    – Ashwin
    Commented Dec 3, 2012 at 15:13
9

AlwaysOn High Availability and Disaster Recovery

If you're interested in the extra disaster recovery stuff that is included with Denali, there was a useful series of articles on Microsoft's CSS blog:

http://blogs.msdn.com/b/psssql/archive/tags/alwayson/

Additional resources:

Improve this answer
1
  • 2
    Personally, I am really excited about the AlwaysOn Availability Groups. On paper, it will make Database Mirroring on interrelated databases much less of a pain.
    – Matt M
    Commented Oct 4, 2011 at 12:05
8

LAG and LEAD (Blog article) and the other OVER clause (MSDN) stuff.

And these blog articles cover most of them

Improve this answer
1
  • 3
    It was about time for those :)
    – user1822
    Commented Oct 21, 2011 at 8:08
7

Columnstore Indexes

From MSDN:

Columnstore indexes group and store data for each column and then join all the columns to complete the whole index.

Notes:

Improve this answer
1
  • 1
    FYI you can also get 15K partitions in 2008 SP2 & 2008 R2 SP1 - so this isn't strictly a 2012 feature. I know you're talking about the combination of 15K & ColumnStore but I just wanted to clarify.
    – Aaron Bertrand
    Commented Mar 9, 2012 at 20:50
7

IIF() and CHOOSE()

These are new switching functions that were once available only on Microsoft Access. They are syntactic sugar for CASE expressions and compile to the same plans (source: IIF, CHOOSE).

Syntax

IIF ( boolean_expression, true_value, false_value )
CHOOSE ( 1-based-index, val_1, val_2 [, val_n ] )

Note: Both these functions cast their output to the data type with the highest precedence from the set of types passed in as arguments.

Examples

SELECT IIF(1 = 1, 'true', 'false') iif_example;
SELECT CHOOSE(3, 10.3354, 'It slices!', 1337, N'It dices!') choose_example;

Note how in the second example the output is 1337.0000. That's because 10.3354 gets implicitly cast to NUMERIC(8, 4), which has the highest data type precedence in the list of arguments passed to CHOOSE(). Thus, the output also get cast to NUMERIC(8, 4), which is why you see four trailing zeros after the decimal.

Improve this answer
5

Its the codename for the next SQL Server engine..

The ctp can be downloaded at http://www.microsoft.com/sqlserver/en/us/product-info/future-editions.aspx

http://msdn.microsoft.com/en-us/sqlserver/denali_resource_center.aspx

Articles/Blogs which have interesting links...

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.