SQLSaturday #296 - Melbourne 2014
Event Date: 04/05/2014 00:00:00
Event Location:
- Monash University, Caulfield Campus
- 888 Dandenong Road
- Caulfield East , Victoria, 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: Kick-ass Ad-hoc Cube Browser build in SSRS 2014
Abstract: Get a sneak preview of my 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 3 - N/A
Title: T-SQL Performance Guidelines for better DB stress powers
Abstract: To reach your desired business functionalities, it can be easy using some common T-SQL practices like MTVF , scalar functions , Temp tables, Union…etc and they might perform pretty well on development server coz neither adequate stress of users or adequate volume of data is exists there but actually they seem totally strange once going to live and they become performing badly ending up with standstill cases sometimes , this is due to lack of stress powers of T-SQL codes which should be considered largely for critical mission DBs so I am going to talk to you about How to capture expensive queries using different techniques ..?and How to optimize them in the shortest time using scientific ways ..? (10 different T-SQL Practices will be analyzed within this session)
Speaker(s):
- Shehab El-Najjar
Track and Room: Track 5 - N/A
Title: Data Quality Services (Deep dive)
Abstract: Data Quality Services (DQS) is one of the main mechanisms for data normalization, removing duplicate content and filling knowledge base. It allows you to perform various operations to obtain quality data. The main feature is the creation of the knowledge base, in which there are basic configuration, data manipulation rules. DQS Cleansing is the standard SSIS control, which is used for normalization (cleansing) data.
In this session two new controls will be introduced: DQS Domain Value Import and DQS Matching Transformation. During the session SSIS package will be created. This package will automate the process of importing domain entities, including synonyms, to the existing knowledge base. Also mechanism for removing duplicates will be applied, relying on returned weights coefficients compared between each set of records.
Speaker(s):
- Konstantin Khomyakov
Track and Room: Track 4 - N/A
Title: Drop your DAX
Abstract: The world of DAX and tabular models opens up some unique opportunities for some really creative modelling to allow the addressing of both technical and business issues. During this session we will look at a number of different real life scenarios including things like:
-
I need to do a quick proof of concept with some new facts that only has business keys, yet my dimensions have surrogate keys coming from the Data Warehouse which is tracking changes over time (SCD2).
-
My users want to look for customers which have certain combinations of products, but not others. i.e “Show me customers who have Product 1 and Product 2, but not Product 3” - How can I support those sort of questions from my tabular model.
-
and a couple of other in
Speaker(s):
- Darren Gosbell
Track and Room: Track 1 - N/A
Title: Hour of Power BI
Abstract: Power BI is Microsoft’s exciting new self-service business intelligence (BI) solution delivered through Excel and Office 365. Using Power BI, business users can discover, combine, model, analyse and visualize data through the creation of immersive BI solutions, share them with other users, and access them from anywhere, on any device.
In this session, Rod will focus on;
- What is Power BI?
- How does Power BI differ to traditional BI tools such as Analysis Services, Reporting Services PerformancePoint Services?
- What do you need to run Power BI, and how do you get it?
- Where does Power BI fit in an organization’s broader enterprise BI strategy?
In addition to answering the above questions, Rod will build a Power BI solution from scratch, in real time. Rod will use Power Query, Power Pivot, Power View and Power Map inside Excel 2013, before deploying the solution to a Power BI site in the cloud, and interacting with it using Q A, the new natural language query techno
Speaker(s):
- Rod Colledge
Track and Room: Track 2 - N/A
Title: Analytical Data Mining - Using Data Mining to Understand Data
Abstract: Data mining is a technique used to derive previously unknown information from large amounts of data. The process of this knowledge discovery can help uncover new patterns within data and help analysts better understand the large datasets. Additionally, once these patterns have been defined, you can use them as part of predictive modelling estimating the likelihood of some event occurring.
SQL Server Analysis Services includes a data mining engine that can be used at various levels within an organization, from analyst to developer. This session will look at data mining as tool for data investigation by the business analyst. We examine the business case, requirements and outcomes of data mining so that it can enhance our understanding of datasets. We will look at both simple and complex implementations of data mining that allow new information to be extracted from data and used in novel ways within the MS Stack.
Speaker(s):
- Paul te Braak
Track and Room: Track 1 - N/A
Title: Agile BI with SQL Server 2014 and TFS 2013
Abstract: In a world where executives/CXOs are keen to perform analytics and data consolidation with lightning speed, there is a strong push towards incorporating the principles of Agile manifesto in the BI world to deliver solutions faster than ever before. In this session, I will share techniques that will help a consultant deliver BI solutions with a rapid prototyping approach and how Agile features of TFS can be leveraged to run projects. The session will include practical demos using Team Foundation Service and SQL Server 2014.
Speaker(s):
- Mohamed Kabiruddin
Track and Room: Track 3 - N/A
Title: The Incredible Shrinking Execution Plan
Abstract: The Query Optimizer can do amazing things with your queries to work out the best plan. If you’re aware of some of techniques it uses, you can leverage this to make your plans be tighter than ever, resulting in better performance and even provide an easier platform for developers who feel less confident with T-SQL. These ideas can even help you query systems such as Microsoft Dynamics in better ways.
Speaker(s):
- Rob Farley
Track and Room: Track 5 - N/A
Title: Leveraging SQL Spatial Analytics for Making Business Decisions
Abstract: Imagine the possibilities if you were able to gather real-time insight into the traffic flow, patterns and behaviors of people while within your premises. Wi-Fi Location Analytics solutions leverage WiFi infrastructure to make this possible by capturing high volume real-time spatial positioning data from mobile devices. The spatial data is extracted, transformed and analysed in SQL Server to provide location based mobility services (such as tracking, mapping and way-finding)This session discusses how these Big Data solutions work and demonstrates data consumption via SQL 2012 spatial (direction, distance, speed, proximity), SSRS 2012 custom maps, and Excel Power View.
Speaker(s):
- Rolf Tesmer
Track and Room: Track 1 - N/A
Title: Automating Deployments with Powershell
Abstract: Some aspects of SQL Server installations are easily repeatable using things like config files and command line installs. However, so much of the preparation and post-install configuration still needs to be done manually.
This session will show how Powershell can be used to prep the servers (including how easy it can be to deploy a cluster) and how Powershell can then be used to deploy and configure SQL Server according to your company standards.
Speaker(s):
- Martin Cairney
Track and Room: Track 4 - N/A
Title: Introducing Microsoft Power Query
Abstract: In this session, I will introduce the audience to Microsoft Power Query for Excel. Power Query is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access. It has often been referred to as the end-user ETL tool, but I believe that it will also be a valuable tool for all technical staff. This demo rich presentation will expose many great features of one of the tools in Microsoft’s Power BI tool belt.
Speaker(s):
- Craig Bryden
Track and Room: Track 2 - 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 3 - N/A
Title: Event notifications for the proactive DBA
Abstract: Event notifications in SQL SERVER have been around for a little while but seem to be one of the most under used features. Combine this feature with database mail and you have a first class alerting system. Come along to this session and find out how to use these features to become a truly proactive DBA. Learn how to get notified about such events as deadlocks and blocking before your users even know they have taken place. Get details of most errors delivered straight to your inbox. You’ll leave this session with a full toolkit that you can start to implement straight away.
Speaker(s):
- Martin Catherall
Track and Room: Track 5 - N/A
Title: Understanding SQL Server 2014’s In-Memory OLTP Table Technology
Abstract: Microsoft’s new In-Memory OLTP Tables (“Hekaton”) promise to seriously change the performance of database solutions that you can design and implement or refactor. In this session, we will examine this new technology’s architecture and internals, new T-SQL syntax, and various use cases. We’ll then discuss how it affects your SQL Server environment, including performance considerations, troubleshooting, administration, and high-availability design considerations.
Speaker(s):
- Victor Isakov
Track and Room: Track 3 - N/A
Title: Building Your Myth Busting Lab With Power BI
Abstract: Did you know that a large portion of Information Workers’ and Data Analysts’ tasks are akin to “myth” busting? How can Power BI be used for these myth busting tasks? What if myth busting can be as easily done as few clicks or asking questions in plain English? This session will demonstrate how to create an ideal Myth Busting lab for data gathering, modelling, analysis, visualisation and collaboration all in one suite.
Speaker(s):
- Julie Koesmarno
Track and Room: Track 2 - N/A
Title: Introduction to SQL Server Data Mining
Abstract: Data mining as a technology is used to analyze data by revealing patterns. These patterns can then be used to derive knowledge about data, and in turn this knowledge can be used to enhance application designs and the user experience. In this session, you will be introduced to the data mining capabilities in SQL Server 2012 Analysis Services, and demonstrations on how to specifically design, develop, explore, evaluate and query data mining models. This session is guaranteed to thrill you with potential, and excite you with the ease in which it can be accomplished.
Speaker(s):
- Peter Myers
Track and Room: Track 2 - N/A
Title: VARIGENCE AUSTRALIA - Build an Integrated Metadata Framework
Abstract: Using a live-typing approach, Peter will briefly show the overall structure of a Biml file and the core syntax patterns. Then he will demonstrate how the power of BimlScript is amplified by the availability of rich metadata sources to drive the automatic creation of your 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. We will bring it together with a walking through a fully featured production framework and the code it generates.
Please refer to the technical walkthrough for more information. http://bimlscript.com/Walkthrough/Details/2074
Speaker(s):
- Peter Avenant
Track and Room: Track 2 - N/A
Title: Why compression matters so much for SQL Server and BI
Abstract: When you want to get good performance from your database applications, compression is one of the most important technologies that you need to consider, yet it’s one of the least understood. In this session Greg will show the evolution of compression technologies from table compression in SQL Server 2008, to columnstore and tabular data models in SQL Server 2012, through to clustered updatable columnstore indexes in SQL Server 2014.
Speaker(s):
- Greg Low
Track and Room: Track 5 - 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.
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.
SQL Server MVPs
Contact: http://sqlsaturday.com/296/
SQL Server MVPs (in alphabetical order): Darren Gosbell, Grant Paisley, Greg Low, Henry Rooney, Julie Koesmarno, Konstantin Khomyakov, Peter Myers, Peter Ward, Rob Farley, Rod Colledge, Victor Isakov
Greg Low
Twitter: - greglow
LinkedIn: Greg Low
Contact: http://blog.greglow.com
Greg Low is well-known in the SQL Server community as a mentor, trainer, author, and community leader. He is a certified master for SQL Server, was an instructor in that program, and holds a PhD in Computer Science. Microsoft often calls on Greg to develop data-related content, and to train their staff. He regularly speaks at tier-one conferences internationally. Greg is best known for his SQL Down Under podcast, SDU Tools, and his eBooks and whitepapers. He heads up a boutique consultancy called SQL Down Under in Melbourne Australia. Greg has been awarded as an MVP since 2001.
Darren Gosbell
Twitter: - darrengosbell
LinkedIn: Darren Gosbell
Contact: http://darren.gosbell.com
Darren Gosbell has been working with the Microsoft Data Platform since 1999. He has practical experience implementing data warehousing and business intelligence solutions for some of Australia’s largest corporations. Darren has been awarded as a Microsoft MVP SQL Server since 2006 in recognition of his contribution to the community specially in the areas of Analysis Services, MDX and DAX. Darren is a contributor to a number of open source projects including BIDS Helper, DAX Studio and ASStoredProcedures.
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
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.
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.
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.
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
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
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.
Konstantin Khomyakov
Константин Хомяков (MVP SQL Server) специализируется в Microsoft Business Inteligence: разработка SSIS пакетов, построение кубов и анализ данных в SSAS. Последние несколько лет занимается интеграцией данных.
Rod Colledge
Twitter: - @rodcolledge
LinkedIn: Rod Colledge
Contact: http://www.rodcolledge.com
Rod Colledge is the national BI practice lead for DWS, a leading publicly listed Australian IT Services company. With 15+ years of SQL Server experience, Rod#39;s commitment and depth of knowledge was recognized in 2010 with a Microsoft MVP award for SQL Server. This is Rod#39;s 6th consecutive year as an MVP. Rod has authored or contributed to three books, including the “SQL Server MVP Deep Dives” series. He#39;s a sought-after speaker at both local and international SQL Server conferences.
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.
Paul te Braak
Twitter: - @paultebraak
LinkedIn: Paul te Braak
Contact: http://www.paultebraak.wordpress.com
Paul te Braak is the principle consultant of abaX Data and has over a decade of experience in delivering reporting and business intelligence solutions across a variety of verticals. This experience includes systems auditing, planning and business simulation models that predict activity through heuristic rules imbedded into the model. He holds several qualifications including MCT, CA, MIT, MComm.
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;.
Peter Myers
LinkedIn: Peter Myers
Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services.
He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.
Rolf Tesmer
Rolf has 18 years IT experience with more than 15 years across all facets of SQL Server/Windows BI platforms, operating in both freelance consulting roles and within large multi-nationals, including Dimension Data, BHP Biliton, Honda and Australia Post.Rolf’s SQL experience covers SQL BI architecture/design, MS Qlik business intelligence (BI), disaster recovery (DR), performance management, security and compliance, consolidation/strategy, licencing and virtualisation.
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
Sponsors
The following is a list of sponsors that helped fund the event: