SQLSaturday #659 - Durban 2017
Event Date: 09/16/2017 00:00:00
Event Location:
- Derivco
- 77 armstrong avenue
- Durban, KwaZulu-Natal, 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: An introduction to Data Mining with SQL Server 2016
Abstract: With the vast amount of changes that occur in our daily business environments, it becomes more and more difficult to achieve our corporate goals without some ‘lighthouse’ to guide our way. Data mining, (while not a panacea to resolve or ‘control’ the effects of these changes), can provide us with statistical trends by analyzing our data and highlighting probable outcomes.
In this hands on BEGINNERS presentation we shall be looking at Microsoft SQL Server’s Data Mining capabilities and we shall be discussing:
1) Defining what questions we want answered and how to go about this in an effective and efficient manner.
2) Creating the data model.
3) How to gather the necessary data, discussing the training and testing aspect.
4) Processing the model.
5) Extracting information from our finished model, discussing the implications of this information.
Speaker(s):
- Steve Simon
Track and Room: BI Information Delivery - Amazon 1
Title: Shedding some light on Windowing Functions
Abstract: Windowing functions in T-SQL add power and speed to your queries, and have myriad uses in all types of situations.
Songs by The Beatles spent a combined 585 weeks on the Top 100 Billboard Chart.
In this session, we’ll combine these unlikely bedfellows, by using The Beatles’ chart data to gain an in-depth knowledge of Windowing Functions in T-SQL. Learn the theory behind each clause in the Windowing Functions and immediately see it applied in both an abstract, and concrete, way. Learn how Windowing Functions can help you enhance your queries, and solve complex problems quickly and easily. From running totals, to lag and lead queries, Windowing Functions will help you deliver high quality information in no time. Once you’ve seen the power of these functions, you’ll wonder how you ever lived without them. Understanding Windowing Functions may seem like a “Long and Winding Road”, but “Come Together” and walk away with a skill that you’ll use “Here, There and Everywhere”.
Speaker(s):
- James McGillivray
Track and Room: Information Delivery - Rainbow Room
Title: Parameter sniffing and other cases of the confused optimiser
Abstract: The SQL Server query optimiser is incredibly good at its job. It can generate good, fast execution plans for 1 row, three table OLTP queries and 1 billion row, all the tables analytics queries and just about everything in between.
But it’s not perfect, and there are query patterns that will send the optimiser for a complete loop and the query execution times through the roof.
We’re going to look at the more common of those query patterns and see exactly what it is about them that causes problems. We’ll spend some time on ways of identifying such queries in production and we’ll look at a variety of ways to write the queries so that they work with the optimiser, not against it.
Along the way you’ll learn enough about the behaviour of the optimiser to be able to identify other problematic query forms before they cause problems.
Speaker(s):
- Gail Shaw
Track and Room: Application Database Development - Amazon 1
Title: Jump Start Into SQL Development
Abstract: What does a SQL Developer do? This presentation will be targeting Entry level developers to give a basic understanding of SQL and its day to day uses.
We will be taking you through a few key concepts along with practical examples:
- Basic SQL
- Best Practices
- Optimizing a Badly Performing Query
Speaker(s):
- Ruben Meyer
Track and Room: Application Database Development - Rainbow Room
Title: Exploring Twitter Campaigns, Facebook and Google Analytics data in PowerBI
Abstract: Social Media data can be very powerful in growing your business, however this is BigData and not many companies know how to consume it and get the most benefit out of it. PowerBI has great features that allow you to use their templates to explore the data and get the most value out of it to make your marketing decisions. There will be a demo on how to set up a PowerBI Twitter Campaign, Facebook and Google Analytics dashboards and how to get value out of them.
Speaker(s):
- Jeanne Combrinck
Track and Room: Analytics and Visualization - Amazon 2
Title: What is a Database?
Abstract: What is a database actually? What does SQL give you out of the box? How is data actually stored? What is a page, what is a log, what does ‘Hardening to disk’ actually mean? Are there only 4 commands in a database?
This session is designed to give a respectful nod to all the things you “Get for free” when working on a Database.
Speaker(s):
- Rory Bolle
Track and Room: Application Database Development - Rainbow Room
Title: Real World Example of Using R in SQL Server
Abstract: In this session we look at how R in SQL Server can be used in a production environment to automatically run models against data coming into SQL Server, as well as update the model with no interference from the data scientist.
Speaker(s):
- Niels Berglund
Track and Room: Advanced Analysis Techniques - Amazon 2
Title: Transactions…because ACID can save you
Abstract: Whether we’re aware of it or not, Transactions are used in all our SQL code. Let’s take a dive into the details and see how we can use Transactions to code defensively and efficiently, and look at gotchas like what does a nested transaction actually mean.
Speaker(s):
- Jonathan Pillay
Track and Room: Application Database Development - Rainbow Room
Title: Get started with R
Abstract: This session will walk through getting started with Microsoft Open R and Visual Studio. We’ll cover reading data into R, accessing R packages, writing R functions, and organizing and commenting R code.
Speaker(s):
- Luis de Sousa
Track and Room: Advanced Analysis Techniques - Amazon 2
Title: Introduction to Database Design
Abstract: Far too few database developers in this day and age get the opportunity to learn how to design relation databases. In most cases, they will on occasion be asked to add a few objects to an existing system while following the standards of the organisation. These relatively infrequent changes do not hone the skills needed for effective design.
Speaker(s):
- Sean Cremer
Track and Room: Application Database Development - Amazon 1
Title: Data without technology
Abstract: In this interactive session we will discuss what and who to take into consideration when thinking about a data strategy
Speaker(s):
- Jody Roberts
Track and Room: Application Database Development - Amazon 2
Title: Getting started with Power BI
Abstract: PowerBI is a powerful suite of tools that enables any user to create and share stunning reports. In this session, you will learn how easily stunning reports can be created and shared with just a few clicks of your mouse.
You will learn how PowerBI can connect to data that exists on-premise as well as in the cloud. that data can then be cleansed, transformed and then modelled to allow the discovery of powerful new insights that can then easily be shared with colleagues and clients. Finally, we will discuss the licencing model behind PowerBI which ranges from the free Desktop tool through to Premium licencing options.
Speaker(s):
- Michael Johnson
Track and Room: Advanced Analysis Techniques - Amazon 2
Title: A Lap Around New Developer Features in SQL Server 2017
Abstract: By the time of me writing this, SQL Server 2017 is out as Community Technical Preview’s and the it shows some very interesting new functionality. In this session we will have a quick look at what is new in SQL Server 2017 from a developers perspective.
Speaker(s):
- Niels Berglund
Track and Room: Application Database Development - Amazon 1
Title: Efficient and Effective coding of Stored Procedures
Abstract: Data does not become information until decision makers are able to view it and make those decisions that affect the enterprise as a whole. Stored procedures are one means of getting the data from the database tables to the reports in an effective and efficient manner. In this hands-on presentation, we shall be looking at best practices with regards to creating and tuning stored procedures. We shall also be discussing parameter sniffing and other gotcha’s that affect us in our daily lives.
Speaker(s):
- Steve Simon
Track and Room: Information Delivery - Amazon 1
Title: Adaptive Query Plans? What’s up with that?
Abstract: One of the new features announced for SQL Server 2017 is Adaptive Query Plans, query plans that can change after the query starts executing.
This session will show why this is a radical departure from the way that things have worked until now and how it can improve the performance of some query forms. We’ll look at the places where adaptive query plans work and compare the performance of queries using adaptive query plans to see just what kind of improvement it can make.
Speaker(s):
- Gail Shaw
Track and Room: Application Database Development - Amazon 1
Title: Docker => Containers => Service Fabric => SQL
Abstract: There are a lot of buzzwords being through around the last few years in the development space… Things like “containers”, “Docker”, “Service Fabric” and the sorts.
In this session we will look at what these various pieces of software are, what they are are good at and how work really well with SQL Server v.Next (2017) to give you exceptional availability for your data store.
Speaker(s):
- Clinton van Blommestein
Track and Room: Application Database Development - Rainbow Room
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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
Sean Cremer
Twitter: - https://twitter.com/seanCremer
LinkedIn: Sean Cremer
Contact: https://seancremer.github.io/
Sean Cremer is a Senior Developer at Derivco. He has worked with SQL Server for nearly two decades on Large OLTP and Data Warehousing Systems and has a wealth of accumulated Database Design and Implementation knowledge.
Jonathan Pillay
Jonathan has had the awesome opportunity of learning from some the best SQL Guru’s in the industry. Being exposed to such wizardry and willingness to share, he has developed his own passion for knowledge sharing.
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.
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.
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
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.
Ruben Meyer
Database Developer
Jody Roberts
Twitter: - Jody_Wp
LinkedIn: Jody Roberts
Contact: http://JodyWP.wordpress.com
Jody Roberts is a Microsoft Data Platform MVP based in Cape Town, South Africa. He specializes in SQL Server architecture, disaster recovery (DR), and server optimization.
Jody serves as a PASS Regional Mentor responsible for the Middle East amp; Africa, Chapter Lead of the SQLCape user group, and Co-Lead of the PASS Cloud Virtual Chapter. Jody is a Principal Consultant at Northern Data.
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.
Luis de Sousa
Twitter: - @luis_de_sousa
LinkedIn: Luis de Sousa
Contact: http://www.luisdesousa.co.za
Consult to large financial institutions in South Africa providing Business Intelligence and Analysis insight.
James McGillivray
Twitter: - JamesMcG_MSBI
LinkedIn: James McGillivray
Contact: https://jimbabwe.co.za/blog-posts/
James McGillivray, Data Management and Analytics MCSE, has been working in Business Intelligence for over a decade. He spends his working hours building solutions that allow people to make informed decisions quickly and accurately. James is a director at Cobalt Analytics.
Before his career in data, James was an avid musical theatre student and musician. This love for performance has developed into a passion for developing and delivering presentations that are informative and enjoyable. James speaks frequently at the Johannesburg SQL User Group, and has delivered sessions at numerous SQLSaturdays, PASS Summit, Power BI World Tour and SQL Bits.
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.
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.
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/.
Rory Bolle
Rory studied Information technology, ran a small computer shop then found Derivco as a Tester. Moved as soon as possible to Data Development and it has stuck.
Rory really loves wood work, general garage tinkering and has a second child on the way which his wife has told him he is excited about.
Rory’s Derivco career has centered around delivering data from 40+ busy source databases to +-120 consumer databases. The main focus in this space is deduplication and compression of data while finding the correct balance between RBAR and batching. If moving data is your thing, Rory can help.
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.
Sponsors
The following is a list of sponsors that helped fund the event: