It has been a year since SQL Server 2012 released.
There were some fun posts on Twitter about the SQL Server 2012 birthday or anniversary. For instance:
declare @greetings varchar(100) SET @greetings= 'Happy Birthday @SQLServer 2012' SELECT @greetings
and another anniversary query (which doesn’t actually run):
SELECT Happy FROM Anniversary WHERE Year = 1 AND Version = '11.0.2100.60';
1 year out since SQL 2012 released, and here are some things to note:
There is no more Business Intelligence Development Studio (BIDS) in SQL Server 2012, instead it has been replaced with the SQL Server Data Tools that uses the core of Visual Studio 2010, with the Report Builder and Report Designer built in to the new Visual Studio.
SQL Server 2012 introduced the IIF statement. It is very similar to the IIF statement in MS Access.
In SQL Server 2012 there is a new function called CHOOSE that takes in an offset, and a list of options.
The OFFSET and FETCH functionality was added to achieve data paging server side in TSQL.
Other Notable features:
- Analytics – Analytic Functions – PERCENT_RANK
- Analytics PERCENTILE_DISC and PERCENTILE_CONT
- IIF function in TSQL.
- TSQL Analytic Functions LEAD and LAG
- OVER clause with ROWS PRECEDING and FOLLOWING in TSQL 2012
- Cumulative Distribution Function (CDF) or as it is known in TSQL CUME_DIST()
I hope you are able to get as much out of SQL Server 2012 as I am. Happy Birthday to SQL Server 2012.