SQLSaturday #352 - Sydney 2014
Event Date: 10/25/2014 00:00:00
Event Location:
- Camperdown Campus - New Law Building
- Camperdown Campus
- Sydney, NSW, Australia
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: Automate your Data Profiling insights using Power BI
Abstract: Data profiling is a critical input task to any database initiative that incorporates source data from external systems. With the right data profiling, it’s possible to gain a huge amount of insight into the data quality in your systems, and as a result, be able to make radically more accurate estimates of the cost to go from the “as is” to the “to be”. The Data Profiling task in SSIS can be very powerful, but it is tricky to use and time consuming to review the findings, until now. In this session I will demonstrate how you can automate data profiling of any SQL Server Database using Integration Services, and use the output of the data profiling task to populate a Power Pivot data model. This data model can then be used to analyse table structures, data quality and identify problems with your data. By using the different profiles you can determine how to clean up your incoming data prior to loading it into your database.
Speaker(s):
- Craig Bryden
Track and Room: Track 024 - N/A
Title: Mash it up with Power Query
Abstract: In this session you will see how to unleash Microsoft Excel and gain an understanding of what all the hype is about in the world of Power BI. We will show you the true meaning of the word ‘Power’ in Power BI. You will witness world-shattering evolutionary changes in Excel data access with Power Query and how this product can be used to transform this widely known and well used tool into a sophisticated next generation ETL platform that rivals even the likes of SQL Server Integration Services (SSIS) itself! Not only will we show you how to access data from both internal and external sources, but you will see how simple and easy it is to transform and shape data in a variety of sophisticated ways. From world population statistics, economic and health trend indicators, scraping web pages and spreadsheets to MotoGP championship racing and your favourite movies – the world of data is changing, attend this session to see how you can enable yourself to catch the wave and ‘mash it up’ today!
Speaker(s):
- Geoff Black
Track and Room: Track 104 - N/A
Title: Performance dreams wait for you at SQL Server 2014
Abstract: Performance dreams wait for you at SQL Server 2014 , it is just like this because you will that unbelievable performance reads and substantial improvement that you will not give up at all those new SQL Server 2014 features , come in here to my session and you will know more about many new features and rich powers of SQL Server 2014 regarding performance particularly like Microsoft project “Hekaton” for In-memory built for OLTP , In-Memory columnstore index ,Resource Governor for IO consumption,lock management and also Single partition online index rebuild technologies ,you will get much hands-on experience for all definitions , architecture design , values and benefits ,caveats and recommendations related to each one of them and in addition I will add a practical flavor for this session by conducting multiple stress tests on most of these technologies to be more close to these performance dreams and explorer concretely these outstanding performance improvements of SQL Server 2014
Speaker(s):
- Shehab El-Najjar
Track and Room: Track 106 - N/A
Title: Interactive Actionable Data Visualisation With Power View
Abstract: Historically, users have been constrained to consume data in fixed platforms, with one specific dimension for digital viewings and a couple of printed layouts. Nowadays, with the ubiquitous mobile devices available, Management expects to know key business indicators and day-to-day operation performance on the go. Using well-designed data models and visualization techniques, Power View can leverage timely and quick dashboards for analysis on the go.
This session will discuss how to design the appropriate data model to enable self-service data exploration and insightful analysis in Power View, and how to create pixel perfect visualization for mobile devices. You will also learn how the techniques differ from traditional platforms. Using live demo, we will walk through ways to channel users focus on actionable analytics.
Speaker(s):
- Julie Koesmarno
Track and Room: Track 104 - N/A
Title: Thinking Out of the Box: Manage SQL Server Using Built-in Tools
Abstract: It’s often the case that your budget doesn’t stretch far enough for all the great third party tools that help manage your SQL Servers. So, how can the in-built components of SQL Server help you with your daily tasks?
Policy Management, Data Collector and Extended Events, all included in both Enterprise and Standard Editions, provide a framework to keep your configurations consistent and give you some insights into the performance of your SQL Server instances. In this session, we will see how to make use of these components to formalize your configuration and track some performance attributes.
After this session you’ll be able to build out an effective management and monitoring toolkit using only “out-of-the-box” features.
Speaker(s):
- Martin Cairney
Track and Room: Track 106 - N/A
Title: “Show Me Potential Customers “ : Data Mining Approach
Abstract: In the most marketing departments, the tactical question is about who are going to buy our products. It is more cost effective to identify and spend money on highly potential customers (than those who are not likely to purchase). This also affects the advertisement strategy. Potential customers and their traits can be identified by analysing previous purchasing information. Management experts can predict who is going to be their new customers by analysing their current customer purchase information. There are many data mining algorithms which can help with this task. Microsoft Business Intelligence employs data mining algorithms that are deployed in an easy to use environment. This demonstration based session will show how to use previous customer purchase information to predict potential customers. We will discuss how to set data sets and use different data mining algorithms to get predictive results and then demonstrate how to find the best predictions.
Speaker(s):
- Leila Etaati
Track and Room: Track 024 - N/A
Title: Kick-ass Ad-hoc Cube Browser build in SSRS 2014
Abstract: Hot from USA PASS Analytics Conference session.
You will learn how to use generic reporting techniques in SQL Server Reporting Services (SSRS) to create a virtually unlimited set of dynamic reports for your users by simply changing report parameters. Just change dashboard report contents and share components for looking up values.
The techniques we will discuss are based on concepts in the books “Advanced Reporting Services 2012” and “Reporting Services Recipes.” By attending this session, you will learn enough to use the Angry Koala Cube Browser and Angry Koala Cube Surfer and modify to your own organization’s needs. Join this practical session, which will give you lots of ideas for your own users.
Speaker(s):
- Grant Paisley
Track and Room: Track 104 - N/A
Title: A New Approach to Unit Testing and Integration Testing in SSIS
Abstract: Testing is critical to managing a high-quality data lifecycle. Unfortunately, SSIS has no built-in support for test authoring and the tools for relational database testing are limited. As a result, most organizations forgo automated testing and focus entirely on manual user testing, which is both expensive and often occurs too late in the process to address all of the issues discovered. In this session, a new approach to unit testing (focusing on verifying the correctness of individual packages, tasks, or dataflows) and integration testing (focusing on validating that the data produced by an entire sequence of transformations) will be discussed. This approach uses metadata authored by analysts in Excel to automatically generate testing logic within the corresponding packages or to automatically generate standalone test packages that contain all of the necessary validation logic. All code will be shared with attendees for free and unrestricted use within their own projects.
Speaker(s):
- Peter Avenant
Track and Room: Track 024 - N/A
Title: Understanding the High-Availability Options in SQL Server 2014
Abstract: With the release of SQL Server 2014 (and Windows Server 2012R2) there are more High-Availability (HA) options available than ever before. And your prior knowledge / experience might be detrimental to you architecting an appropriate HA solution for your organization. In this session Victor Isakov (MCA, MCM, MCT, MVP) will cover the different HA options available in SQL Server 2014. Along the was he will discuss the important considerations and offer some practical advice and practices to help you implement the correct HA solution.
Speaker(s):
- Victor Isakov
Track and Room: Track 106 - 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: Track 024 - 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: Track 106 - N/A
Title: Indexing for performance
Abstract: An effective indexing strategy is one of the most important responsibilities of a database professional. In this session we will briefly look at the internals of indexes and how the engine decides how to utilise them. We will explore the different options and choices available in the different versions of SQL Server.
Speaker(s):
- Stanley Roos
Track and Room: Track 106 - N/A
Title: 365 days with Power BI
Abstract: In this session Iman will share his 1 year journey with Power BI, evolution of the toolset, ups and downs, feedbacks from clients, etc.
He will also demonstrate scenarios which include the end-to-end build of a report using Power Query, Power Pivot, Power Map, and Power View. Also the cloud features such as sharing reports/data sets, setting up Data Management Gateway, automated data refresh, QA, and mobile access.
Speaker(s):
- Iman Eftekhari
Track and Room: Track 104 - N/A
Title: Crack open the AMO for SSAS Tabular
Abstract: Analysis Services Management Objects API is under utilised by many organisations (and not even heard of by some). In this session, I will walk through the features in AMO that help organisations build, customise, manage and administer SSAS tabular models using an automated and programmatic approach. The session will include demos to illustrate the capability of various AMO classes and methods. If you want to show off the length and breadth of programmatic features available in SSAS to your stakeholders, this session is your sure shot guide to being a glorified SSAS professional.
Speaker(s):
- Mohamed Kabiruddin
Track and Room: Track 024 - N/A
Title: Everything you would like to know about Power BI - QA
Abstract: One of the Power BI features users have been interested in is QA, which takes data exploration to a whole new level. With QA, users type ad-hoc questions and the system provides them with answers in the form of interactive charts and graphs. The search like experience is instantaneous and uses a natural language query, interpreting the semantics of question the user is typing. This session will be covered with a lot of samples of deployment, configuration, optimization etc.
Speaker(s):
- Konstantin Khomyakov
Track and Room: Track 104 - 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.
Shehab El-Najjar
Twitter: - https://twitter.com/MSQLPerformance
LinkedIn: Shehab El-Najjar
Contact: http://sqlserver-performance-tuning.net/
Shehab El-Najjar was the ONLY Microsoft SQL Server MVP in Gulf for the past 6 years and the 2nd one all over the Middle East , he is the founder of SQL Gulf events series (SQL Gulf #1 , #2 and #3 ) where he spent so much time and efforts to broadcast Microsoft SQL Server technologies all over the Gulf such as KSA and Emirates and other Gulf cities ahead ..)
He is now Professional Services Manager at Saudi Emircom
He was previously COO and business leader in KSA market through his startup WAJA IT for 3 years
He is an influencing Database community leader all over the region A senior Database Consultant (SQL Server MVP for 6 years in row) -The 2nd MVP awardee SQL Server all over Middle East and Arabic region
Craig Bryden
Twitter: - @cbryden
LinkedIn: Craig Bryden
Craig has been working with SQL Server for over 20 years and currently holds several SQL Server based certifications. He has also previously held an MCT certification. Craig’s contribution to the SQL Server community was recognised in 2018 with a Microsoft MVP award. He was involved with Microsoft Learning to set some of the current SQL server Exams. Craig is the Chief Data Strategist at BiTQ. Craig is an organiser of the QLD Power BI User Group
Julie Koesmarno
Twitter: - @mssqlgirl
LinkedIn: Julie Koesmarno
Contact: http://www.mssqlgirl.com
Julie Koesmarno, MCSE Data Platform, and MCSE Business Intelligence, MCT, is a Senior Program Manager at Microsoft, with a Bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her past projects include delivering a SQL Server 2012 data warehouse and BI solutions in the US and Australia. She now works with hybrid, cloud and on-prem SQL projects.
Leila Etaati
Twitter: - @leila_etaati
LinkedIn: Leila Etaati
Contact: http://blog.radacad.com
Leila Etaati is the First Microsoft AI MVP in New Zealand and Australia, as well as a Data Platform MVP. She has a Ph.D. from the University of Auckland and is the co-director and data scientist in RADACAD company with many clients around the world. Additionally, she is the co-organizer of Microsoft Business Intelligence and Power BI Use group in Auckland with more than 1300 members. Leila has also co-organized 3 main conferences in Auckland: SQLSaturday Auckland (from 2015), Difinity (from 2017) and Global AI Bootcamp. She is a data scientist, BI consultant, trainer, and speaker. She is a well-known International speaker to many conferences such as MS Ignite, SQL PASS, Data Platform Summit, SQLSaturday, Power BI World Tour and in Europe, USA, Asia, Australia, and NZ. She has over 10 years’ experience with databases and software systems. Leila is an active Technical Microsoft AI blogger in RADACAD.
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.
Konstantin Khomyakov
Константин Хомяков (MVP SQL Server) специализируется в Microsoft Business Inteligence: разработка SSIS пакетов, построение кубов и анализ данных в SSAS. Последние несколько лет занимается интеграцией данных.
Grant Paisley
Twitter: - @angrykoala
Grant Paisley is a Data Platform MVP and founder of Angry Koala, a Microsoft Business Intelligence partner based in Sydney, Australia. Grant is president of the SQL Server Usergroup Sydney and created http://reportsurfer.com, a community built around reporting, where you can also run the reports. He was contributing author for quot;SQL Server 2008 Analysis Services with MDXquot; and quot;Microsoft SQL Server Reporting Services Recipesquot;.
Martin Cairney
Twitter: - martin_cairney
LinkedIn: Martin Cairney
Martin has 20 years’ experience in SQL Server technologies. His experience spans both the Database Engine and infrastructure requirements, and Data Warehousing and BI implementations. He has worked across many industry sectors including London’s global financial institutions and both State and Federal Government Departments. He is a SQL Server MVP, MCT and an experienced conference presenter, having presented at PASS Summit, SQLBits, and SQLSaturday events and User Groups round the world
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.
Iman Eftekhari
LinkedIn: Iman Eftekhari
Contact: http://www.agilebi.com.au
Iman Eftekhari (MCSE BI, MCITP, CSP) has more than 15 years of experience predominantly in Microsoft BI space. He has been involved in many successful BI projects across the country mainly with financial services, health and the public sectors. He is the co-founder of Agile BI and is passionate about delivering BI projects using Agile methods.
Victor Isakov
Twitter: - @victorisakov
LinkedIn: Victor Isakov
Contact: http://www.victorisakov.com
Victor Isakov (MCA, MCM, MCSM, MCT, MVP) is a Database Architect and trainer who provides consulting and training services to various organizations in the public, private, and NGO sectors globally. He regularly speaks at international conferences such as Microsoft TechEd/Ignite, PASS Summit, IT/Dev Connections, and SQLSaturdays. Victor has written a number of books on SQL Server and has worked with Microsoft to develop the SQL Server exams and certification. In 2017 he authored “Exam Ref 70-764 Administering a SQL Database Infrastructure (1st Edition)”. He is one of only three non-Microsoft, Microsoft Certified Architects in the world.
Stanley Roos
Stanley Roos is a SQL Server MCM with 20 years experience in SQL server from version 4.2. He is an independent contractor based in South Africa.
Geoff Black
Contact: http://wardyit.com
Geoff is the Training Team Leader at WARDYIT Solutions. With more than 30 years experience in the world of IT, Geoff has been witness to some major changes in technology throughout out his various roles as a Microsoft Certified Trainer, Database Developer, Consultant and Business Intelligence Specialist. High performance and power has always been the driving force behind both his professional and personal interests as an avid fan of the MotoGP and a keen motorcyclist.
Mohamed Kabiruddin
Twitter: - mdkabir
LinkedIn: Mohamed Kabiruddin
Contact: http://www.nobrainerlab.com
Mohamed is a Cloud Solutions Architect with extensive experience in designing BI / Data Analytics solutions with expertise in analysis, design, modelling and implementation. He is a keen data enthusiast with a flair for managing and consolidating data.
Peter Avenant
Twitter: - @BimlDownunder
Contact: http://www.varigence.com.au
Peter Avenant is the Technical Director at Varigence Australia, an SSIS Developer, Trainer and Consultant, and SQL Server data warehouse specialist. His background includes developing a cloud metadata framework that integrates with BimlScript to create both data vault and dimensional data warehouses.
Sponsors
The following is a list of sponsors that helped fund the event: