23 Oct 2012 Ready, Steady, Catch! hosted at SQL Lunch
SQLLunch.com Session Recording - available soon
1 Nov 2012 Power View for Geographical Analysis hosted at PASS DW/BI VC
Julie's journey as a Microsoft SQL Server [Professional | Girl]
I have just delivered my presentation on “High Volume Data Processing Techniques Without Driving Your DBA Crazy!” via webinar at 24 Hours of PASS (24HOP) Spring 2012. Thank you for those who attended the session. Hope it was useful for you. If you have any questions, please don’t hestitate to contact me and I will do my best to answer them.
As promised, below is a list of links that I briefly touched on at the presentation.
SQL Server 2012
ORDER BY Clause (OFFSET .. FETCH NEXT …)
Paging Function Performance in SQL Server 2012
The Data Loading Performance Guide
Minimally Logging Bulk Load Inserts into SQL Server
The “Balanced Data Distributor” SSIS
Download Center – BDD
Special thanks to 24HOP team and IBTalk for everything. I hope to present with 24HOP in the near future. The recording will be available in a few weeks time via the 24HOP website.
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.