I was today doing SQL Server Advanced Training at Bangalore and I had few attendees asked me if I can give them review of the SQL Server Denali. I had not downloaded Denali on my work computer so I could not do demonstration of the same. However, I promised to blog about with additional details very next day. So here is a quick look at what’s new in SQL Server Denali.
Denali is also known as SQL 11 and the compatibility mode number is 110.
Here are few details about it.
What is new in SQL Server “Denali”
Download CTP1
What’s New in SQL Server Denali, Now Called SQL Server 2012
Denali was the code name, and it shipped as SQL Server 2012. If you found this post while reading about older versions, here are the changes from that release I still use or talk about most:
- AlwaysOn Availability Groups for high availability, with readable secondary replicas.
- Columnstore indexes, which made large reporting queries much faster. The first version was read-only, and later versions improved it a lot.
- New T-SQL such as
SEQUENCE,OFFSETandFETCHfor paging,THROW,TRY_CONVERT,IIF,CONCATandEOMONTH. - Window functions like
LAG,LEADand running totals withROWS BETWEEN. - Contained databases, which can keep users inside the database instead of at the server.
- SQL Server Data Tools, a new home for database projects inside Visual Studio.
The number 110 is also a handy way to tell releases apart: 90 is SQL Server 2005, 100 is 2008 and 2008 R2, and 110 is 2012. You will see these numbers in sys.databases and in every upgrade plan.
Compatibility level 110 matters too. A database restored on a newer server usually keeps its old level until you change it, and some newer behavior depends on that level. If a feature does not act the way the documentation says, check the level before you blame the feature.
My tip for any new release: read the official what is new page, then pick two features and try them on your own data. That is how a long list turns into real skills.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
5 Comments. Leave new
Ahhh … You should have called me for a quick demo on Denali !!!
I would have loved to show them some cool stuff !!!
I have close to 3-4 posts waiting to get released by next week on denali findings. There are tons …
Vinod
I agree, I missed and did not think it right at that time. I for sure have called you for the Denali Demo.
I am sure Denali is going ot be very interesting for others.
Overall, it was great to meet you!
Hurry up guys, Denali CTP 1 becomes 15 days old now.
sir,
i m anil gurjar
i m not getting records from a table which has a integer field and not exists value in that table like::
table name = table1
field = id (integer type)
inserted value = 2,4,9
getting = 1,3,5,6,7,8 which are i m not gettting.
please help me
thank to all who try solution for this.
Anil Gurjar
i read sql and related code want to entrer in sql server plz share me wt to do….