SQLSaturday #559 - Cape Town 2016
Event Date: 09/10/2016 00:00:00
Event Location:
- The River Club
- Observatory Rd, Observatory, Cape Town, South Africa
- Cape Town, Western Cape, South Africa
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: SQL Server 2016: A dive into Data Quality Services
Abstract: SQL Server 2016: Data quality and data cleansing have always been major challenges to any enterprise that deals with data. For those of us who have dealt with Data Profiler Tasks in SQL Server 2008, we were shocked yet pleasantly surprised with the great advances that Microsoft has made with the advent of Data Quality Services, in the SQL Server 2012 release. In this hands-on presentation we shall be looking at how to set up a new knowledge base, based upon an existing one, set up rules, do knowledge discovery within the new knowledge base and finally cleanse the data through a data quality project. The end results being more effective data, guaranteed to keep end users and management happy.
Speaker(s):
- Steve Simon
Track and Room: BI Information Delivery - Liesbeeck
Title: Dive into the Query Optimizer - Undocumented Insight
Abstract: This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.
Speaker(s):
- Benjamin Nevarez
Track and Room: Application Database Development - Tugela
Title: Query Processing in In-Memory OLTP (Hekaton)
Abstract: In-Memory OLTP (code name: Hekaton) is the most important new feature in SQL Server 2014, and this session will teach you how query processing and optimization work with this new database engine. After explaining the basics, we will discuss how the query optimizer is used in In-Memory OLTP by both natively compiled stored procedures and by traditional stored procedures accessing memory-optimized tables through the query interop functionality. We will also take a look at how the new hash and range indexes are used, as well as how their performance implications are also covered along with the process of translating the plan created by the query optimizer into C code. Finally, some limitations with the current release will also be explained.
Speaker(s):
- Benjamin Nevarez
Track and Room: Application Database Development - Orange
Title: Getting started with Azure SQL Data Warehouse
Abstract: As data warehouses continue to see rapid expansions of data, traditional architectures struggle to keep up. Massively Parallel Processing is a technique that allows a data warehouse to be seamlessly distributed across multiple machines allowing for near linear scaling. Massively Parallel processing was first introduced to SQL through Parallel Data Warehouse (PDW) which was a large and often expensive deployment process. Azure SQL Data Warehouse brings much of the Power of Parallel Data Warehouse but with many advantages of the cloud such as lower costs and faster deployment. In this session we will look at how the Azure SQL Data Warehouse works behind the scenes. We will also look at various options for provisioning and loading data before ending with a look at how queries executed.
Speaker(s):
- Michael Johnson
Track and Room: BI Platform Architecture, Development Administration - Zambezi
Title: The language informally known as M
Abstract: At the heart of Power BI is the Power Query Formula Language (informally known as M), a dynamically typed, case-sensitive functional language for creating mashup queries, similar to the F# language.
Although Power BI Desktop has a number of great UI features for transformations, under the hood it’s all M, and the better you understand the language, the more you can take advantage of the capabilities inherent in Power BI.
In this session I will introduce you to the basics of the M language and demonstrate some of the more advanced features.
Speaker(s):
- Matt Horn
Track and Room: BI Information Delivery - Liesbeeck
Title: Real-Time Operational Analytics
Abstract: It used to be that if you want to do analysis of data that is stored in SQL Server, you had to extract the data into a data ware-house or something similar, and run you analysis there. The downside with that is the time it takes from the time of insertion into the transaction store until the data is available in the DW. In this session we will see how we can use SQL Server 2016 to do real time analytics against your OLTP database.
Speaker(s):
- Niels Berglund
Track and Room: BI Platform Architecture, Development Administration - Orange
Title: From Me BI to We BI, take your BI solution beyond the clouds
Abstract: ne of the main challenges organizations face in the BI world is to allow, via a single platform, contradicting needs of self-service BI with governance and Enterprise scale. Come and see the game changing approach of Pyramid Analytics that allows organizations to obtain these impossible needs of business users and IT in a singular BI platform. Pyramid Analytics the platform that Microsoft selected as a strategic partner for PowerBI.
Pyramid Analytics revolutionary platform provides a single platform that delivers: • Self Service – No code necessary. • Web based central administration and security. • Role based functionality for different roles in the organization (Professional, Analyst and Consumer). • Universal configuration – build once use anywhere (PC, Tablet and Mobile). • Enterprise scale – parallel processing, clustering and load balancing. • And more ….
Speaker(s):
- Michael Raam
Track and Room: BI Information Delivery - Tugela
Title: SQL Server 2016: Master Data Services and Rapid Application Development
Abstract: Master Data Services can be readily be employed for Rapid Application Development. We shall be looking at important development, data security and data maintenance aspects, all based upon a recent client implementation.
Speaker(s):
- Steve Simon
Track and Room: BI Information Delivery - Zambezi
Title: Your code is not just…your code
Abstract: When you code do you only thing about your code? What about how you release it fast, with high Quality and in a regulated environment?
We’ll take a look at how SQL code traditionally (or at least most commonly) gets into production. We’ll then switch our focus to using unit tests as a way to help improve quality in the fast paced world we live in and a release pipeline to simplify it all
Speaker(s):
- Gordon Beeming
Track and Room: Professional Development - Orange
Title: So, when you say database what do you mean?
Abstract: These days when you say “database server” it could really mean many things.
For something like SQL server there are so many options: on-premise server, off-premise server. On-premise server with off-premise data. Then there are the various Azure offerings with fancy names like Azure SQL, Data Lake, Hadoop.
You also get graph databases and document databases.
This session will cover some of the more popular types of data stores that are available today and we will look at their use cases. While SQL server is great for many things, one has to be aware of the other options that are available out there.
Speaker(s):
- Clinton van Blommestein
Track and Room: Application Database Development - Liesbeeck
Title: What R You Analyzing
Abstract: R has become one of the leading analysis tools for developers and data scientists alike. However, in order for R to do its magic it needs data so historically we have imported data from various sources, SQL Server being one of those sources. In SQL Server 2016, Microsoft has embedded R in the SQL engine. Yes, we do now have access to R natively in SQL Server.
In this session we will look at how R works in SQL Server, and also talk about some performance improvements you are getting by running R in SQL Server.
Speaker(s):
- Niels Berglund
Track and Room: Analytics and Visualization - Zambezi
Title: Data Driven: finding value in the digital maze
Abstract: No one needs to be convinced that data is valuable. But trying to understand where to look for value in your data and what to focus on is challenging. We try to give meaningful context to terminology such as big data, digital disruption, 4th industrial revolution, etc.
This is a non-technical session that will give an overview of how your data landscape is changing and what you need to be aware of to derive value from data.
Speaker(s):
- Toufiq Abrahams
Track and Room: Professional Development - Zambezi
Title: Introduction to Indexes
Abstract: In this session, we’ll look at design considerations for clustered and non-clustered indexes. We’ll investigate what makes an index useful to SQL Server and what common mistakes make indexes useless. We’ll go into the details of how various query predicates interact with indexes and what the primary driver is when designing indexes for any database application.
This session is aimed at people who are relatively new to indexing.
Speaker(s):
- Gail Shaw
Track and Room: Application Database Development - Orange
Title: Infographics using PowerBI and BI Office
Abstract: Utilization of infographics through PowerBI and BI Office
Speaker(s):
- Jason Basterfield
Track and Room: Analytics and Visualization - Liesbeeck
Title: On Transactions and Atomic Operations
Abstract: If there’s one thing that we, as SQL developers, do, it’s not use enough transactions.
Transactions are critical when multiple changes need to be made entirely or not at all, but even given that it’s rare to see transactions used at all in most production code
In this session, we’ll look at what transactions are and why we should use them. We’ll explore the effects transactions have on locking and the transaction log. We’ll investigate methods of handling errors and undoing data modifications, and we’ll see why nested transactions are a lie.
Speaker(s):
- Gail Shaw
Track and Room: Application Database Development - Zambezi
Title: Using the SQL 2016 Query Store to optimise Performance and Scalability
Abstract: SQL 2016 introduces the Query Store, a mechanism that has been built into the SQL 2016 database engine in order to facilitate rapid identification and resolution of performance and scalability bottlenecks in SQL application scenarios. In the session we will examine Query Store architecture and features and gain an understanding of how the tools should be used.
Speaker(s):
- Peter Willmot
Track and Room: Other - Tugela
Title: Introduction to Business Intelligence Markup Language (BIML)
Abstract: Demonstrating how you can easily generate SSIS packages based on metadata, allowing us to effectively apply code reuse, templates and patterns in our ETL solutions using BIML
Speaker(s):
- Ziyaad Mohamed
Track and Room: BI Information Delivery - Liesbeeck
Title: BI Office Analytic Platforms and the Value of Shared Context
Abstract: Modern self-service personal productivity analytic tools allow individual users to create sophisticated calculations and sets. However, for an organization to maximize the value of analytics this business logic must be released from myriad of spreadsheets and documents that it is embedded. Join us to discuss how analytic platforms allow data-driven organizations to centralize, share and contextualize this content.
Speaker(s):
- Sandesh Nagaraj
Track and Room: BI Information Delivery - Zambezi
Title: Query Performance Tuning on a budget (Free)
Abstract: SQL Server has built in tools available to assist you in Query Performance Tuning. We will go through the tools and how you can use them to quickly identify various performance issues. There are also various free software and scripts available provided by third parties which I use on a daily basis which I will recommend.
Speaker(s):
- Martin Phelps
Track and Room: Application Database Development - Tugela
Title: Windows on Data
Abstract: A look at Window functions, and how their performance has improved over the SQL versions. Also ideas/samples of potential use cases.
Speaker(s):
- Desmond Norton
Track and Room: Application Database Development - Tugela
Title: Detecting ETL Duration Anomalies with Simple Linear Regression
Abstract: When an ETL is initially deployed it is expected to run for a certain amount of time based on testing during development. It does not always come to our attention that the duration the ETL takes to complete starts growing at an abnormal rate. Using Simple Linear Regression, we can detect the duration anomalies of ETLs. Will be going into detail on what Simple Linear Regression is and how you can use it to your advantage to detect ETL duration anomalies.
Speaker(s):
- Jeanne Combrinck
Track and Room: BI Platform Architecture, Development Administration - Orange
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Clinton van Blommestein
LinkedIn: Clinton van Blommestein
Clinton is a senior developer at Derivco in Durban (South Africa), a company that is a leader in the online gaming space. He has over 16 years experience in highly transactions systems, with focus on the services and data tiers. He is a regular speaker at SQL events in South Africa, is also the co-leader for the Durban SQL User Group and has recognised as a Couchbase Champion for his contribution to their community.
Gail Shaw
Twitter: - @SQLInTheWild
Contact: http://sqlinthewild.co.za
Gail Shaw is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail holds a Microsoft Certified Master certification for SQL Server 2008 and is a Data Platform MVP. She’s a frequent poster on the SQLServerCentral forums, a Pluralsight author, writes articles for both SQLServerCentral.com and Simple-Talk.com, and has spoken at SQLSaturdays, SQL Bits and at the PASS Community Summit. Gail has been responsible for extending the lifespan of many an application, by performance-tuning their databases and providing technical guidance on all things SQL Server related.
Gordon Beeming
Twitter: - GordonBeeming
LinkedIn: Gordon Beeming
Contact: http://beeming.net/
Gordon Beeming is a Software Developer at Derivco in the sunny city of Durban, South Africa. He spends most his time hacking away at the keyboard in Visual Studio or with his family relaxing. He is a Visual Studio ALM Ranger, Visual Studio ALM MVP and Friend of Red Gate. His blog is at beeming.net and you can follow him on Twitter at twitter.com/gordonbeeming.
Benjamin Nevarez
Twitter: - @BenjaminNevarez
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server independent consultant based in Los Angeles, California, who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning amp; Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals.quot; Benjamin has also been a speaker at many SQL Server conferences, including PASS Summit, SQL Server Connections, and SQLBits. His blog can be found at http://www.benjaminnevarez.com.
Niels Berglund
Twitter: - nielsberglund
LinkedIn: Niels Berglund
Contact: https://nielsberglund.com
Niels works as Software Architect at Derivco, where he develops software as well as “dreaming” up new and innovative ways to use existing and new technology. Before joining Derivco, Niels worked as researcher/instructor at Developmentor where he was responsible for the database curriculum. He was a co-author of the first SQL Server 2005 book for developers: quot; A First Look at SQL 2005 for Developersquot;. He has presented at all leading technical conferences; Tech-ED, SQL PASS, DevWeek, Ignite the Tour, etc., and is also a Microsoft Data Platform MVP.
Benjamin Nevarez
Twitter: - @BenjaminNevarez
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server independent consultant based in Los Angeles, California, who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning amp; Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals.quot; Benjamin has also been a speaker at many SQL Server conferences, including PASS Summit, SQL Server Connections, and SQLBits. His blog can be found at http://www.benjaminnevarez.com.
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
Martin Phelps
Twitter: - https://twitter.com/mphelps1968
LinkedIn: Martin Phelps
Martin Phelps is database architect at MiX Telematics. Specialising in Solution Architecture across their OLTP and DW databases. With 20 years of in-the-trenches experience with Sql Server he has provided solutions using Sql Server since version 4.2. Has previously done work for Insurance, ICT, Marketing and Mining companies.
Jeanne Combrinck
Twitter: - TheSQLGirl
LinkedIn: Jeanne Combrinck
Contact: http://thesqlgirl.com
Senior BI Developer at Britehouse. In her spare time she can be found spending time with her animals, doing SQL puzzles and writing on her blog http://thesqlgirl.com/.
Peter Willmot
Peter has been writing software (and teaching folk how to write software) for over 30 years. He has worked with SQL Server as an architect and developer for more than 20 years (since SQL 4.2) and has also worked extensively with the .Net and various other development platforms.
Peter is a past MSDN Regional Director and was also an MVP (SQL Server and Architecture) for many years. He is a passionate and regular speaker and various industry events around the world.
Niels Berglund
Twitter: - nielsberglund
LinkedIn: Niels Berglund
Contact: https://nielsberglund.com
Niels works as Software Architect at Derivco, where he develops software as well as “dreaming” up new and innovative ways to use existing and new technology. Before joining Derivco, Niels worked as researcher/instructor at Developmentor where he was responsible for the database curriculum. He was a co-author of the first SQL Server 2005 book for developers: quot; A First Look at SQL 2005 for Developersquot;. He has presented at all leading technical conferences; Tech-ED, SQL PASS, DevWeek, Ignite the Tour, etc., and is also a Microsoft Data Platform MVP.
Michael Johnson
Twitter: - MikeJohnsonZA
LinkedIn: Michael Johnson
Contact: http://michaeladrianjohnson.com/
Michael Johnson is a Microsoft data platform MVP and leader of the Johannesburg SQL User Group and Business Analytics Virtual Group. He works as an Independent Business Intelligence Consultant and regularly presents at local user groups, SQLSaturdays and PASS Virtual Chapters.
Ziyaad Mohamed
Studied Software Development at CPUT. Now currently working at EOH as an Intermediate SQL developer within the financial services industry for around 5 years, while also obtaining my Microsoft Certifications. When I am not drilling down data I enjoy keeping fit at the gym.
Jason Basterfield
Director of a Business Intelligence company called Expeditus. Having over 15 years experience in Business Intelligence using multiple technologies and implementing numerous successful data warehousing projects within different verticals. Always looking to the future of Business Intelligence and data, trying to stay abreast of the curve.
Toufiq Abrahams
Twitter: - https://twitter.com/ToufiqAbrahams
Contact: http://www.osmosisconsulting.co.za
Toufiq Abrahams is the Principal Consultant at Osmosis Consulting and Technology Director at Plain Sight Analytics. He has a passion for turning data into business value with one foot in the cloud and the other on-prem.
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
Michael Raam
Data amp; Analytics Principal at Pyramid Analytics
Desmond Norton
Desmond is a senior database developer at Derivco, with 15 years development experience. He started out as a full stack developer, and made the move to a purely SQL developer 9 years ago.
Sandesh Nagaraj
LinkedIn: Sandesh Nagaraj
A Certified Data Architect with around 15 years of experience in Data warehouse, Business Intelligence and Database implementation. Sandesh holds MCITP SQL Server in BI, Data Architect certified from Microstrategy etc. He has worked extensively as BI Consultant/Technical Specialist/BI Architect/Sales Engineer/Manager. Sandesh actively participates and speaks at Johannesburg SQL Server User and SQLSaturday events.
Gail Shaw
Twitter: - @SQLInTheWild
Contact: http://sqlinthewild.co.za
Gail Shaw is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail holds a Microsoft Certified Master certification for SQL Server 2008 and is a Data Platform MVP. She’s a frequent poster on the SQLServerCentral forums, a Pluralsight author, writes articles for both SQLServerCentral.com and Simple-Talk.com, and has spoken at SQLSaturdays, SQL Bits and at the PASS Community Summit. Gail has been responsible for extending the lifespan of many an application, by performance-tuning their databases and providing technical guidance on all things SQL Server related.
Matt Horn
Twitter: - https://twitter.com/maxui
LinkedIn: Matt Horn
Matt Horn is a Business Intelligence Developer and director with Immersant Data Solutions. He has been a regular speaker at SQLSaturday events for many years He is the Co Lead of the IntelliCape Business Intelligence user group based in Cape Town. .
Sponsors
The following is a list of sponsors that helped fund the event: