top of page

A Journey into SQL Server 2012

On February 20th I attended the Microsoft event – A Journey into SQL Server 2012. The event was very interesting, and included many great sessions…

Roy Pasternak (Microsoft) presented a short overview of the new features in SQL Server 2012. There are so many of them. SQL Server 2012 is truly a big advancement in all areas of the product – mission-critical confidence, dynamic development, breakthrough insight and cloud-ready. More information can be found here.

Yossi Elkayam (Microsoft) then drilled down into the new BI features, like Power View and Data Quality Services. There are really so many…

Danny Ravid (Brillix) presented the new high availability solution in SQL Server 2012 – AlwaysOn. This is one of the most exciting new features in SQL Server 2012, in my opinion. Microsoft took the best parts of Failover Clustering and Database Mirroring, added some more, and came up with a robust platform that enables true high availability as well as load balancing at the database level. With this platform we can have multiple readable replicas of a group of databases with a single virtual name for the application. More information can be found here.

Itai Binyamin (Veracity) presented the new tool for developers in SQL Server 2012 – SQL Server Data Tools. The SSDT brings together all the great functionality from Visual Studio 2010 and SQL Server Management Studio, and it creates a unified and rich development environment for application developers and database developers alike. And it’s part of the SQL Server product stack, so you get it for free.

Ami Levin (DBSophic) presented some new T-SQL features, like metadata discovery, paging and the new Sequence object.

Rachel Yehezkel (Microsoft) presented a short overview of the SQL Azure platform – Microsoft’s data platform in the cloud. If you have questions about SQL Azure, then there is a new forum in Hebrew about Windows Azure and SQL Azure. You can find it here.

I presented a session about FileTables – a new exciting feature in SQL Server 2012 that enables applications to manage structured as well as unstructured data seamlessly. I plan to write more about FileTables in the near future. In the meanwhile, here are the materials from my presentation:

I hope you enjoyed the event in general and my presentation in particular. I’ll be glad to hear your feedback…




Get New posts delivered straight to your inbox

Thank you for subscribing!

bottom of page