Becoming a better BI Developer with SQL Server 2012

The 12 Hours of SQL Server 2012 event started at 10:12 PM on February 24th, 2012 GMT and delivered 12 hours back-to-back sessions.

I attended three of them (due to the time zone difference) and am very impressed with how much I have learnt. I highly recommend the following sessions, which I think are useful for me in becoming a better BI developer with SQL Server 2012.

1. 14:12 – 15:12 Power View from the Data Visualisation Perspective

Jen Stirrup reminds us on Data Visualisation principles and discusses how Power View supports Data Visualisation best practices. I enjoy Jen’s examples of good and bad Data Visualisation and how good Data Visulisation contributes to strategic enterprise decisions. Further reading: http://www.jenstirrup.com/2012/02/sqlpass-business-intelligence-virtual.html

2. 18:12 – 19:12 Building the Perfect BI Semantic Tabular models for Power View

Kasper De Jonge demonstrates that the right BISM Tabular Model would enable users to fully utilise Power View capabilities and building great data visulisation. I particularly like how Kasper incorporates Data Mining query in the Tabular Model to show how powerful Power View could be. Further reading: http://www.powerpivotblog.nl/tutorial-optimize-a-sample-powerpivot-model-for-power-view-reports

3. 21:12 – 22-12 Database Schema Management & Deployment using SQL Server Data Tools (SSDT)

Gert Drapers shows how SSDT makes it easier for database development development, testing, deployment and migrations; some features of the Visual Studio 2010 Database Development have been incorporated in SSDT. I like how Gert uses plenty of demos to show a more streamlined database development to deployment. Further reading: http://social.msdn.microsoft.com/Forums/sr-sp-latn/ssdt/thread/ee6f7d4f-aa6c-4051-b4b9-d187e8f89c5d

Hopefully the recorded sessions will be available very soon.

12 Hours of SQL Server 2012

Sharing with SQL Server Community

I have just attended a local SQL Server User Group in Sydney run by Victor Isakov earlier this month.

In this meeting, Victor went through some updates on SQL Server 2012, the launch date and most notably the changes to the certifications and the courses being offered. More information about the certifications can be found here: http://specialops.sqlpass.org/Certification.aspx#fbid=Z7vC96QRoxV

Special Ops tour is starting in USA from early March. We, in the southern hemisphere, can watch the Launch online on March 7th. Hopefully there is going to be a SQL Saturday event held in Sydney shortly to go through changes in SQL Server 2012.

Also, the 24 Hours of PASS is on next month on 21 March 2012 00:00GMT (check your local time by clicking here). I attended last year’s sessions and they were very impressive. There are 24 back-to-back sessions that you can pick from and I will be presenting one of them with a topic called “High Volume Data Processing Without Driving Your DBA Crazy!”. So, why not Register Now?

SQLRally 2012 is fast approaching. 40 General Sessions have been announced and there is a chance for the Community to vote for the next 20 Sessions. Check out these sessions and hope to see you there!

Edit: ANZ SQL Saturday Tour is here from 12 – 28 April 2012. For more info on the relevant cities, please go to:

Brisbane http://sqlsaturday.com/135/eventhome.aspx
Wellington http://sqlsaturday.com/136/eventhome.aspx
Canberra http://sqlsaturday.com/137/eventhome.aspx
Sydney http://sqlsaturday.com/138/eventhome.aspx
Adelaide http://sqlsaturday.com/139/eventhome.aspx
Perth http://sqlsaturday.com/140/eventhome.aspx

Hope to see you there!

(Special thanks to Rob Farley for letting me know!)