SQLSaturday #571 - Auckland 2016
Event Date: 10/15/2016 00:00:00
Event Location:
- Microsoft Auckland
- 5/22 Viaduct Harbour Ave, Auckland CBD, Auckland
- Auckland, Auckland, 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: Protecting your data from SQL Injection attacks
Abstract: Kevin will be talking on the topic of SQL injection - something that all of us need to be aware of and protect against.
And here is a blurb from:
https://www.owasp.org/index.php/Top_10_2013-A1-Injection
” The best way to find out if an application is vulnerable to injection is to verify that all use of interpreters clearly separates untrusted data from the command or query. For SQL calls, this means using bind variables in all prepared statements and stored procedures, and avoiding dynamic queries. Checking the code is a fast and accurate way to see if the application uses interpreters safely. Code analysis tools can help a security analyst find the use of interpreters and trace the data flow through the application. Penetration testers can validate these issues by crafting exploits that confirm the vulnerability.”
Kevin will give us a demo that will show an injection attack in action and how to mitigate it.
Speaker(s):
- Kevin Alcock
Track and Room: Database Administration - Ponui
Title: R; One Ring to Rule Them All
Abstract: R is one of the most popular and powerful analytics languages. That helps data scientists to prepare data, predict data, and visualize it. Microsoft offers several deployment options to bring next-generation advanced analytics to your business. Microsoft R Server delivers R-based analytics to where your data lives. Processing analytics in-place eliminates data movement, reducing latencies and operational costs.
In this session, first basic concepts of machine learning will be discussed. Then, a demo of how to use R for data cleaning, visualization, and prediction will be presented. Subsequently, an introduction to use R server and R in SQL Server 2016 will be shown. Finally, a brief introduction on how to use Azure ML with R will be shown.
Speaker(s):
- Leila Etaati
Track and Room: BI Platform Architecture, Development Administration - Ponui
Title: Security in Power BI
Abstract: Come to this session to learn how to leverage security in Power BI. Share Power BI report with colleagues, or publish it to web, or through an office 365 group. You will also see how to implement Row level security on different data sources either through Power BI security itself, or applying security in the data source level of SSAS Tabular or SQL Server. This is demo heavy session all about Security in Power BI
Speaker(s):
- Reza Rad
Track and Room: BI Platform Architecture, Development Administration - Ponui
Title: Are You High? Can You Recover? - HA and DR in SQL Server.
Abstract: A look at the options for providing High Availability and Disaster Recovery using the native features available in SQL Server. This session will cover the basis of how the technologies work, what is(and isn’t) protected and a list of the advantages and disadvantages of each technology. We’ll also look at the why of High Availability, Disaster recovery and how to get the business to commit to a design to provide Business Continuity when disaster strikes.
Speaker(s):
- Rob Douglas
Track and Room: Database Administration - Ponui
Title: Introduction to the Query Store
Abstract: Query store is an awesome new feature in SQL Server 2016 and Azure SQL Database that allows you to store the history of query plans (what SQL Server turns your SQL statement into), including detailed data on performance, making comparison with previous versions of a statement easy.
The Query Store also lets you identify queries that may degrade performance over time and make necessary adjustments. I#39;ll show how easy it is to work with the Query Store and work with query plans.
Speaker(s):
- Dave Dustin
Track and Room: Database Development - MPC
Title: Restoring SQL Server Database to Old Version
Abstract: In this session , I will demonstrating the approach for restoring SQL Server Database to older version( like restoring SQL server 2014 database to SQL Server 2012) using Microsoft azure cloud migration tool.
Speaker(s):
- kokila kondasamy
Track and Room: Database Development - Ponui
Title: Adding Power to the DBA toolkit!
Abstract: Interested in being able to manage, monitor and document your SQL Environment from a single location? Want to be able to produce modern interactive reports and dashboards that can be viewed on both desktop and mobile devices?
By adding a little “Power” to your DBA toolkit you can!
By combining PowerShell and PowerBi with the more traditional DBA tools I will show how to query and document your entire environment and produce rich interactive reports that can be consumed by all levels of your organisation.
Speaker(s):
- Patrick Flynn
Track and Room: Database Administration - MPC
Title: DW SuperHero-Columnstore Index
Abstract: Columnstore indexes were introduced in SQL 2012. They have the superpower to boost SQL server performance by flipping row based indexing to column based indexing. In this session, we will cover basics of this technology, its usability, performance impact, implementation (through demo), access mechanism and what’s new in SQL 2016.
Speaker(s):
- Manjot Kaur
Track and Room: Database Development - MPC
Title: Data Visualization: How to truly tell a great story!
Abstract: We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There’s a lot more to creating that story than just getting the correct information. Come learn not just the do’s and don’ts, but the whys…
Speaker(s):
- Jonathan Stewart
Track and Room: BI Platform Architecture, Development Administration - MPC
Title: Temporal Databases in Microsoft SQL server 2016
Abstract: Introducing Temporal Databases in SQL Server 2016
More and more organizations are storing archives of data to help them make important business decisions. Traditionally, organizations had to rely on expensive, and tedious methods to go back in time and make sense of growth, negative growth, profit, loss, etc.
Microsoft SQL Server 2016 introduces a new feature called Temporal Databases which essentially solves all the problems mentioned above.
This presentation aims to go deep into Temporal Databases (requirements, use cases, technical know-hows) and present some demo’s in order to gain specific understanding on this new feature which is being called “Time Travel”.
Speaker(s):
- Amit Arora
Track and Room: Database Development - MPC
Title: Package Management in Microsoft R Open with Checkpoint
Abstract: Package Management in Microsoft R Open with Checkpoint
Speaker(s):
- Andrew Worsley
Track and Room: BI Platform Architecture, Development Administration - Ponui
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Jonathan Stewart
Twitter: - sqllocks
LinkedIn: Jonathan Stewart
Contact: https://sqllocks.net/
Jonathan Stewart is a Business Intelligence consultant specializing in data visualization, data warehousing, and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments.
Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and Business Intelligence at numerous SQLSaturday events, local user groups, and conferences throughout the United States and around the world. He participates in webcasts, podcasts, and on
Andrew Worsley
Twitter: - @aworsleynz
LinkedIn: Andrew Worsley
Data scientist passionate about discovering new and inventive ways of gleaning valuable insights from large data sources.
Interests include spatial statistics, data mining, machine learning, dimensionality reduction and statistical programming.
Patrick Flynn
Twitter: - sqllensman
Contact: http://sqllensman.com/blog/
Patrick Flynn is a Senior Database Administrator with 10 years experience in large 24 x 7 enterprise environments. He is a certified master for SQL Server and a regular attendee of the PASS Summit.
Has presented at SQLSaturday events in Sydney, Melbourne, Brisbane and Auckland, Edmonton and Calgary, Oslo and Cambridge
Manjot Kaur
I have been working with SQL server for over 10 years. I have been an internal DBA and a consultant. I am passionate about automation, cloud technologies, performance tuning and learning SQL internals. In my free time I love to read, playing with my toddler and trying my hands on new recipes.
Kevin Alcock
Twitter: - https://twitter.com/kevinnz
LinkedIn: Kevin Alcock
Contact: https://kevin.net.nz
Kevin Alcock Director and Principal Consultant from Katipo Information Security. Kevin has been “Programming for a living since 1986”, including using SQL Server off and on since version 1.1. He has worked in a variety of roles over that time and these days has taken up the mantra of making data safe.
Amit Arora
LinkedIn: Amit Arora
Amit Arora is an SQL Server Consultant with WARDY IT Solutions. Amit has over 10 years of experience working with SQL Server including working as a Technical Advisor and DBA for Microsoft. Amit has recently been working on SQL Server solutions with Microsoft Azure and HDInsight as well as other big data technologies.
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.
Dave Dustin
Twitter: - venzann
With more than 35 years industry experience, Dave has worked with organisations and data systems of all sizes. He is currently Principal Engineer at Xero.
kokila kondasamy
LinkedIn: kokila kondasamy
Working as Database Consultant part of SQL Services Professional Services team, providing SQL Server support to a variety of customer across New Zealand and Australia. Apart from SQL Server, Kokila is passionate about Cloud , NoSQL and BigData Technologies.
Rob Douglas
Twitter: - Rob_DouglasNZ
LinkedIn: Rob Douglas
Contact: http://www.gumption.co.nz
Robs SQL history started as a remote DBA, branched into consultancy and now includes providing SQL Solutions to a variety of businesses, government departments and banks throughout Australia and New Zealand using a variety of native SQL solutions to meet their performance, higher availability and Disaster Recovery needs.
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.
Sponsors
The following is a list of sponsors that helped fund the event: