| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 10:00:00 | Steve Simon | Application Database Development | SQL Server 2016 Efficient and Effective coding of Stored Procedures |
| 10:00:00 | Vanessa Raath | Professional Development | How to become the most sought after SQL Server professionals in SA |
| 10:00:00 | Clinton van Blommestein | Application Database Development | The NoSQL DBA |
| 10:00:00 | Sean Cremer | Application Database Development | Introduction to Database Design |
| 10:00:00 | Jody Roberts | Strategy and Architecture | Data without technology |
| 11:10:00 | Hugo Kornelis | Application Database Development | Now Where Did THAT Estimate Come From? - Part 1 |
| 11:10:00 | Heinrich Smit | Enterprise Database Administration Deployment | Running and interacting with SQL Server in Docker |
| 11:10:00 | Niels Berglund | Advanced Analysis Techniques | A Drill Down into R and Python in SQL Server 2017 |
| 11:10:00 | James McGillivray | Information Delivery | Shedding some light on Windowing Functions |
| 13:00:00 | Jeanne Combrinck | Analytics and Visualization | The Power of Social Media with PowerBI using Twitter, Facebook and Google Analytics |
| 13:00:00 | Gail Shaw | Enterprise Database Administration Deployment | Go, Go, QueryStore! |
| 13:00:00 | Hugo Kornelis | Application Database Development | Now Where Did THAT Estimate Come From? - Part 2 |
| 14:10:00 | Desmond Norton | Professional Development | T-SQL Anti-Patterns |
| 14:10:00 | Arohan Naidoo | BI Platform Architecture, Development Administration | Zero to Pi to 10 on Cloud,Intro to Windows 10 IoT Core on a Raspberry Pi and BI using Azure IoT Hub |
| 14:10:00 | Erwin Bisschops | Information Delivery | Creating an adaptive party domain model in SQL Master Data Services |
| 14:10:00 | Denny Cherry | Database Administration | SQL Server 2016 Database Administration for the non-DBA |
| 15:20:00 | Jacques Mostert | Information Delivery | The hustle and bustle of SQL pages |
| 15:20:00 | Sean Pearce | Application Database Development | Practical Query Tuning |
| 15:20:00 | Minette Steynberg | BI Platform Architecture, Development Administration | Azure SQL DW vs Azure Cosmos DB vs Azure Data Lake Store |
| 15:20:00 | Mladen Prajdić | Application Database Development | SQL Server and Application Security for Developers |
Event Date: 02-09-2017 - Session time: 10:00:00 - Track: Application Database Development
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.
Event Date: 02-09-2017 - Session time: 10:00:00 - Track: Professional Development
Event Date: 02-09-2017 - Session time: 10:00:00 - Track: Application Database Development
Fast forward a few years, and the "No" now means "Not Only" as traditional and document stores live happily side by side.
The manufacturers of these NoSQL systems have also realized that SQL is the language that is used to manage and query data - SQL is well known and there are many people that are very good at it.
In this quick session we will look at N1QL (pronounced Nickel) which is the Couchbase query language, and how your skills in relational can cross over into NoSQL by only learning a few extra keywords.
Event Date: 02-09-2017 - Session time: 10:00:00 - Track: Application Database Development
This session will go through the fundamentals of database design. Topics such as normalization, Understanding Data Relationships as well as the Language of Data Modeling and Design will be discussed. The Database Design Sequence Phases of Conceptual, Logical and Physical will be introduced as well.
Event Date: 02-09-2017 - Session time: 10:00:00 - Track: Strategy and Architecture
About Jody Jody is a Principal Consultant at Northern Data. He is a Microsoft Data Platform MVP and PASS Regional Mentor for the MEA region.His current focus is helping organizations of all sizes gain greater insight into their businesses as a better ROI by using their data more effectively.
Event Date: 02-09-2017 - Session time: 11:10:00 - Track: Application Database Development
In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates.
Though the focus of this session is on understanding the cause of bad estimates, you will also learn ways to fix the problems and get better estimates - and hence, better performing queries.
Event Date: 02-09-2017 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 02-09-2017 - Session time: 11:10:00 - Track: Advanced Analysis Techniques
Event Date: 02-09-2017 - Session time: 11:10:00 - Track: Information Delivery
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".
Event Date: 02-09-2017 - Session time: 13:00:00 - Track: Analytics and Visualization
Event Date: 02-09-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
In this session we’ll take a look at what the QueryStore is and how it works, before diving into a scenario where overall performance suddenly degraded, and we’ll see why QueryStore is the best new feature in SQL Server 2016, bar none.
Event Date: 02-09-2017 - Session time: 13:00:00 - Track: Application Database Development
In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates.
Though the focus of this session is on understanding the cause of bad estimates, you will also learn ways to fix the problems and get better estimates - and hence, better performing queries.
Event Date: 02-09-2017 - Session time: 14:10:00 - Track: Professional Development
This session will cover a few T-SQL anti-patterns, explaining the problem being solved, and better alternatives.
Event Date: 02-09-2017 - Session time: 14:10:00 - Track: BI Platform Architecture, Development Administration
Event Date: 02-09-2017 - Session time: 14:10:00 - Track: Information Delivery
In this session I will take you through the approach and the various modelling steps to set up a party domain model in the SQL Server MDS environment.
Event Date: 02-09-2017 - Session time: 14:10:00 - Track: Database Administration
While this session won't teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.
During this session Microsoft MVP and Certified Master Denny Cherry will give you the basic information that is needed to get that new SQL Server that you've just been told that you need to manage running and safe. After this session you will be armed with the basic information needed to know how to properly backup the database so that you can recover it after a failure. You will learn how to properly maintain t
Event Date: 02-09-2017 - Session time: 15:20:00 - Track: Information Delivery
Event Date: 02-09-2017 - Session time: 15:20:00 - Track: Application Database Development
Event Date: 02-09-2017 - Session time: 15:20:00 - Track: BI Platform Architecture, Development Administration
Event Date: 02-09-2017 - Session time: 15:20:00 - Track: Application Database Development
In this session we'll look at a few attack vectors that can be used against your company, and what you as a developer can and should do to protect against them. It will involve a good mix of security conscious SQL Server and application development, because you care about your work and nobody messes with you.