SQL Server Virtual Presentations

23 Oct 2012 Ready, Steady, Catch! hosted at SQL Lunch

SQLLunch.com Session Recording - available soon

Slide Deck

 

1 Nov 2012 Power View for Geographical Analysis hosted at PASS DW/BI VC

Coming soon

 

 

 

24 Hours of PASS – High Volume Data Processing Techniques Without Driving Your DBA Crazy

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 …)

http://msdn.microsoft.com/en-us/library/ms188385%28v=SQL.110%29.aspx

 

Paging Function Performance in SQL Server 2012

http://www.mssqlgirl.com/paging-function-performance-in-sql-server-2012.html

 

Columnstore Indexes

http://msdn.microsoft.com/en-us/library/gg492088(v=SQL.110).aspx

 

 

SSIS

The Data Loading Performance Guide

http://msdn.microsoft.com/en-us/library/dd425070(v=sql.100).aspx

 

Minimally Logging Bulk Load Inserts into SQL Server

http://www.mssqltips.com/sqlservertip/1185/minimally-logging-bulk-load-inserts-into-sql-server/

 

BDD

The “Balanced Data Distributor” SSIS

http://blogs.msdn.com/b/sqlperf/archive/2011/05/25/the-balanced-data-distributor-for-ssis.aspx

 

Download Center – BDD

http://www.microsoft.com/download/en/details.aspx?id=4123

 

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.

 

 

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