SQLSaturday #316 - Christchurch 2014
Event Date: 06/14/2014 00:00:00
Event Location:
- Christchurch Polytechnic Institute of Technology (CPIT)
- Madras Street
- Christchurch, , New Zealand
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: (Unusual) Problem solving with SSIS scripts
Abstract:
Every once in a while a client will have an unusual or obscure requirement that is either very difficult or not possible to satisfy with the out of the box tools provided by SSIS.
What do you do when your data sources aren’t predictable or in a format not easily read by standard SSIS adapters?
This is when scripting “#8 fencing wire” of SSIS really comes to the fore.
During this session we’ll explore and solve some interesting real life scenarios with SSIS scripts.
Speaker(s):
- Simon Peck
Track and Room: Business Intelligence - N/A
Title: Metadata Driven SSIS With Biml
Abstract: The power of BimlScript is amplified by the availability of rich metadata to drive the automation of your SSIS solution. Peter will demonstrate a flexible and reusable framework for storing and managing the metadata that you will use as an input to your BimlScripts. The framework demonstrated will be made available to all attendees and can be used with the free BidsHelper Visual Studio add in.
Speaker(s):
- Peter Avenant
Track and Room: BIML - N/A
Title: Real-World Biml Framework (Yours For The Taking)
Abstract: Following on from the Metadata driven session Peter will introduce BimlScript transformers and show how they can be used, either interactively or as part of an automatically applied framework. Topics will include transformer syntax, merge modes, target types, execution options, and transformer layering. Peter will also show you how you can enforce these patterns using validators that ensure best practices within your enterprise. This session focus on more advanced Biml features available in Varigence Mist.
Speaker(s):
- Peter Avenant
Track and Room: BIML - N/A
Title: SARGability
Abstract: SARGability is such a significant thing in the database world, and goes far beyond “Keep your columns on the left and functions on the right”. In this talk, you’ll be able learn principles that will affect not only how easily your data can be located, but also the way that joins are performed and more. You can even learn ways to tune poorly performing queries without having to rewrite anything.
Speaker(s):
- Rob Farley
Track and Room: Business Intelligence - N/A
Title: Performance Eye for the SQL Guy
Abstract: With the release of SQL Server 2014 comes some new features which can provide performance improvements for your SQL Server environment. In this session Warwick will take you through these new features including Buffer Pool Extension, Resource Governor for I/O, InMemory OLTP, InMemory DW, Managed Lock Priority Single Partition Online Index Build that could help improve performance in your SQL Server environment .
Speaker(s):
- Warwick Rudd
Track and Room: Enterprise DBA - N/A
Title: SQL Server 2014
Abstract: Since November 2013, Kiwibank has had SQL Server 2014 running live in Production, despite it only going RTM in April 2014. This session will go over the pros and cons of deploying a pre-release version and also cover some of the things that we did do, didn’t do and couldn’t do. This deployment is fully supported by Microsoft and I’ll share some of the background info on that too. This session will be a beginner to intermediate with some advanced aspects as well.
Speaker(s):
- Brent McCracken
Track and Room: Enterprise DBA - N/A
Title: ETL Architecture for Solving Data Warehouse Challenges
Abstract: Data Warehouses are heavily in use nowadays in most of businesses around the world. Data Warehousing brings higher performance, faster and more insightful data analysis out of operational databases. By the way there are some challenges in design and implementing Data Warehouses which needs robust and reliable ETL implementation. In this session you will learn an ETL Architecture implemented by SSIS and MDS to solve couple of most challengeable Data Warehousing scenarios which are Slowly Changing Dimension and Inferred Dimension Member. There will be many demos through this session which helps you to understand design and implementation of the architecture.
Speaker(s):
- Reza Rad
Track and Room: Business Intelligence - N/A
Title: Meet The Masters / Ask The Experts(Rob Farley, Brent McCraken , Warwick Rudd, Dave Dustin, Reza Rad)
Abstract: With 2 MCM’s and 2 MVP’s in Christchurch to present it’s an excellent opportunity to have an open forum to pretty much ask any of those SQL related questions that you’ve always wondered about. Format will be pretty informal - it you have advance questions please email then through to sqlsaturday316@sqlsaturday.com Look forward to seeing you all there.
Speaker(s):
- Martin Catherall
Track and Room: Business Intelligence - N/A
Title: Hitch Hikers Guide to High Availability
Abstract: With the release of SQL Server 2012 the High Availability landscape has moved. Like anything in this world we live in we need to move and keep up with the changes. In this session Warwick will look at what is needed to design and implement a Highly Available solution in your SQL environment.
Speaker(s):
- Warwick Rudd
Track and Room: Enterprise DBA - N/A
Title: Fast Track Your BI Projects With Biml
Abstract: You’re a business intelligence developer or manager trying to provide quality data in a timely, cost-effective manner. Perhaps you’ve considered Agile methodology, but found that the details of ETL, the plumbing if you will, makes iterative development all but impossible. In just this session Peter will demonstrate a flexible and reusable framework for storing and managing the metadata that you will use as an input to your BimlScripts, alleviating the pain and tedium of data warehouse development.
Speaker(s):
- Peter Avenant
Track and Room: BIML - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Peter Avenant
Contact: http://www.bimlscript.com
Peter is the Technical Director at Varigence Australia, an SSIS Developer, Trainer and Consultant, and SQL Server data warehouse specialist. His background includes developing a metadata framework that integrates with BimlScript to create dimensional data warehouses. Prior to joining Varigence Australia, Peter was an early adopter of Biml and has given numerous community talks and training sessions on Biml in Australia and New Zealand
Brent McCracken
Twitter: - @sqldba_nz
LinkedIn: Brent McCracken
Contact: http://www.sqldba.co.nz
I’ve been working with SQL Server since v6.5 and nearly completed my MCM qualification. I am the technical lead for the database operations team in a nationwide bank in New Zealand.
Warwick Rudd
Twitter: - @warwick_Rudd
LinkedIn: Warwick Rudd
Contact: http://www.sqlmastersconsulting.com.au/Blog
Warwick Rudd is a Microsoft Certified Master – SQL Server 2008 and Principal Consultant at SQL Master Consulting. He is a frequent speaker at local SQL Server User Groups and SQLSaturday events in Australia. When not playing with the SQL stack, Warwick likes to get away to the cold and spend time snowboarding.
Warwick Rudd
Twitter: - @warwick_Rudd
LinkedIn: Warwick Rudd
Contact: http://www.sqlmastersconsulting.com.au/Blog
Warwick Rudd is a Microsoft Certified Master – SQL Server 2008 and Principal Consultant at SQL Master Consulting. He is a frequent speaker at local SQL Server User Groups and SQLSaturday events in Australia. When not playing with the SQL stack, Warwick likes to get away to the cold and spend time snowboarding.
Reza Rad
Twitter: - Rad_Reza
LinkedIn: Reza Rad
Contact: http://radacad.com/blog
Reza Rad is a Microsoft Regional Director, MVP, author, trainer, speaker and consultant. He is a Microsoft Data Platform MVP for nine years from 2011. Reza wrote many books on Power BI subjects including the Power BI from Rookie to Rock Star, and Pro Power BI Architecture. Reza is the invited speaker at the world’s well-known conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Ignite Tour, PASS Summit, and many other conferences. Reza is an active blogger and writes regularly about Power BI at https://radacad.com.
Simon Peck
Twitter: - @BIGUYNZ
LinkedIn: Simon Peck
Simon is a MCSE in data analytics, certified Biml Expert (BimlHero) and co-author of “The Biml Book” he has been working with SQL Server since the 90’s. Simon is a director of Data Engineers a Christchurch based data solutions provider specialising in Microsoft based cloud and on-premise BI and Data Warehousing solutions. Having worked for 50+ organisations worldwide over last 20 years he has a wealth of experience across many business sectors, he is also a co-leader of the Christchurch SQL User Group.
Peter Avenant
Contact: http://www.bimlscript.com
Peter is the Technical Director at Varigence Australia, an SSIS Developer, Trainer and Consultant, and SQL Server data warehouse specialist. His background includes developing a metadata framework that integrates with BimlScript to create dimensional data warehouses. Prior to joining Varigence Australia, Peter was an early adopter of Biml and has given numerous community talks and training sessions on Biml in Australia and New Zealand
Rob Farley
Twitter: - rob_farley
LinkedIn: Rob Farley
Contact: http://blogs.lobsterpot.com.au
Rob Farley runs LobsterPot Solutions in Australia, where he’s a consultant in the Microsoft Data Platform and Analytics space. He’s been an MVP since 2006, probably because of his blogging, his presentations around the world, and his dedication to the Adelaide Data Analytics User Group which he has led since before the release of SQL Server 2005. He’s on Twitter at @rob_farley, but you can always email him using rob@lobsterpot.com.au
Peter Avenant
Contact: http://www.bimlscript.com
Peter is the Technical Director at Varigence Australia, an SSIS Developer, Trainer and Consultant, and SQL Server data warehouse specialist. His background includes developing a metadata framework that integrates with BimlScript to create dimensional data warehouses. Prior to joining Varigence Australia, Peter was an early adopter of Biml and has given numerous community talks and training sessions on Biml in Australia and New Zealand
Martin Catherall
Twitter: - MartyCatherall
LinkedIn: Martin Catherall
Contact: http://martincatherall.com
Martin is a data consultant in Melbourne, Australia, a Microsoft Data Platform MVP, and PASS Regional Mentor for the Asia Pacific (APAC) region. Martin founded the Christchurch, New Zealand PASS Local Group and lead the group for a number of years before relocating to Melbourne. He has been using SQL Server in various roles since 2000. In addition to anything data related, he enjoys playing the guitar and having fun with his family.
Sponsors
The following is a list of sponsors that helped fund the event: