| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Angela Henry | Application Database Development | Data Types Do Matter |
| 09:00:00 | Steve Simon | Information Delivery | DAX and the tabular model |
| 09:00:00 | Niels Berglund | Application Database Development | What is the PiRate, Snake, and Cup of Coffee Doing in My Database? |
| 09:00:00 | Gail Shaw | Cloud Application Development Deployment | Hyperscale! Database at the speed of cloud |
| 09:00:00 | Jeanne Combrinck | Cloud Application Development Deployment | Azure ML Studio for Beginners - Exploring, Creating Training Models |
| 10:15:00 | Vanessa Raath | Professional Development | Are you making sure that you are standing out as a TOP IT Professional in South Africa? |
| 10:15:00 | Jean-Pierre Voogt | Advanced Analysis Techniques | Working with data in Python for Beginners |
| 10:15:00 | James McGillivray | Analytics and Visualization | Design Strategies and Advanced Data Visualization: The Ingredients for a Delicious Data Story |
| 10:15:00 | Alain Dormehl | Enterprise Database Administration Deployment | Fully Managed Cloud Born DBaaS - Azure SQL DB Managed Instance |
| 10:15:00 | Warren du Toit | Cloud Application Development Deployment | SQL Server Always On Availability Groups on Azure Kubernetes Services |
| 11:30:00 | Tinus Visagie | BI Platform Architecture, Development Administration | A Beginners guide to Data Modeling |
| 11:30:00 | Niels Berglund | Application Database Development | A Lap Around SQL Server Big Data Cluster |
| 11:30:00 | Buck Woody | Advanced Analysis Techniques | A Day in the Life of the Data Scientist |
| 11:30:00 | Jody Roberts | Strategy and Architecture | Data Estate Modernization : Taking the guess work out of migrating to the cloud. |
| 13:30:00 | Arohan Naidoo | Analytics and Visualization | Paginated Reports in Power BI and SSRS |
| 13:30:00 | Gail Shaw | Cloud Application Development Deployment | There are Gremlins in my CosmosDB |
| 13:30:00 | Sven Vosse | BI Platform Architecture, Development Administration | Power BI + Microsoft Flow + PowerApps = Real Magic |
| 13:30:00 | Anna Hoffman | Advanced Analysis Techniques | How to Migrate to Azure SQL |
| 13:30:00 | Vernon Du Preez | Professional Development | How to Become Microsoft Certified |
| 14:45:00 | Angela Henry | Application Database Development | Profiling Your Data |
| 14:45:00 | Andrew Collier | Analytics and Visualization | Web Scraping |
| 14:45:00 | Kathryn Varrall | Advanced Analysis Techniques | Big Data Analytics with Power BI |
| 14:45:00 | Sandesh Nagaraj | BI Platform Architecture, Development Administration | Data wrangling using Power Query and M language |
| 14:45:00 | Bob Ward | Enterprise Database Administration Deployment | SQL Server 2019: The Modern Database Platform |
Event Date: 07-09-2019 - Session time: 09:00:00 - Track: Application Database Development
Event Date: 07-09-2019 - Session time: 09:00:00 - Track: Information Delivery
We shall discuss many of the often used functions, discuss their 'overloads' (utilizing several practical examples) and see how to turn the extracted data into valuable information that may be used by decision makers to help the enterprise achieve its corporate goals.
Event Date: 07-09-2019 - Session time: 09:00:00 - Track: Application Database Development
Here we look at the SQL Server Extensibility Framework, and we see how we can call out to external languages from inside SQL Server. We look at R, Python and Java, and what we can do from SQL Server having access to those languages.
Event Date: 07-09-2019 - Session time: 09:00:00 - Track: Cloud Application Development Deployment
What is this 'hyperscale' thing all about?
In this talk I'll show how the hyperscale architecture differs from a normal database architecture and why, in theory, it promises near infinite scalability for transactional workloads
Event Date: 07-09-2019 - Session time: 09:00:00 - Track: Cloud Application Development Deployment
Event Date: 07-09-2019 - Session time: 10:15:00 - Track: Professional Development
In order to be seen as a Thought Leader in your chosen IT discipline these days, you need to be developing and nurturing your personal brand. This is going to be vitally important for you in your next career move.
Event Date: 07-09-2019 - Session time: 10:15:00 - Track: Advanced Analysis Techniques
In this session, we will use Python in an easy to understand layout by using Notebooks as our Interface and pandas as our data manipulation library in Python. This session is for everyone that is just starting off in Python. We will learn how to import/export data into Python as well as manipulate and analyse data. Finally, we will look at how to bring this back into our SQL Server world.
Event Date: 07-09-2019 - Session time: 10:15:00 - Track: Analytics and Visualization
In this session, we will learn how to design for accessibility, allowing more people to benefit from our work. We’ll learn the difference between designing for users to explore information, and for users to consume insights. This will lead us into the basics of constructing a data story. From choosing the relevant data points, to removing all unnecessary distractions and constructing a cohesive narrative.
Every data story is unique, but the techniques for effective data presentation are universal. Improve your reports, dashboards, and slide decks by learning the art and science of quality data visualization.
Event Date: 07-09-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Azure SQL Database Managed Instance is a new deployment option for Azure SQL Database, that enables easy SQL server applications migration from on-premises to a fully managed platform as a service. Managed Instance provides SQL Server application compatibility, security isolation with VNET support.
Event Date: 07-09-2019 - Session time: 10:15:00 - Track: Cloud Application Development Deployment
Event Date: 07-09-2019 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration
It's a statement we've all heard before. No doubt people are realizing just how valuable data is becoming. Ultimately though for data to be valuable it needs to be usable. With the growth of new technologies like AI, Data Lakes, IOT to name a few the modelling of data is even more important than ever. Stop your data lakes from turning into data swamps.
This session will cover the basic terminology and methods of modelling data. It will also show some of the most common models and what they are best suited for.
Go from Zoolander too Right Said Fred and be Too Sexy for your data in 50 minutes.
Event Date: 07-09-2019 - Session time: 11:30:00 - Track: Application Database Development
This session gives you an overview of what a SQL Server Big Data Cluster is, and what you can do with it. We look at the various components, (Kubernetes, Spark, HDFS, PolyBase, etc.), and what you can do with them.
Event Date: 07-09-2019 - Session time: 11:30:00 - Track: Advanced Analysis Techniques
Event Date: 07-09-2019 - Session time: 11:30:00 - Track: Strategy and Architecture
In this session we will look at : How to take the guess work out of developing a cloud roadmap. Look at how cost effective cloud will be in a very accurate manner. How to assess applications and their dependencies. Reduce time to cloud by telling exactly which lines of code to change in your applications and databases. Effort estimation to complete each task. Including 3 migration options in Microsoft Azure for your applications and databases.
Event Date: 07-09-2019 - Session time: 13:30:00 - Track: Analytics and Visualization
Event Date: 07-09-2019 - Session time: 13:30:00 - Track: Cloud Application Development Deployment
In this presentation I’m going to take you through the basics of what CosmosDB is, show how to create and configure a database. Once we've got a database, we'll look at the the gremlin api, including how to create and query the graphs.
Event Date: 07-09-2019 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
In this session we’ll explore how combining Power BI and two other Power Platform apps, namely Microsoft Flow and Microsoft PowerApps, we can turn BI into “insights AND action”.
We will walk through a popular use case of a Sales Rep visiting a client, and integrating Flow, PowerApps and Power BI on a tablet one can vastly improve customer satisfaction, significantly reduce workload and administration, and improve sales volumes.
Here are some of the things we’ll cover: • Validate stock levels on the spot to avoid ordering an out-of-stock item • Place orders directly from Power BI using Flow and PowerApps to integrate with your ERP system • Don’t miss out on any lost opportunities by viewing past order history using insightful Power BI visuals • Trigger workflows automatically instead of completing the admin later • CRM Integration
Event Date: 07-09-2019 - Session time: 13:30:00 - Track: Advanced Analysis Techniques
Event Date: 07-09-2019 - Session time: 13:30:00 - Track: Professional Development
Then Microsoft Certifications are for you. In this session, we will look at the different types of certification paths and what you can do to pass the exams. I will take you on the journey to selecting the right exam for you and assist you to pass these exams with confidence.
Event Date: 07-09-2019 - Session time: 14:45:00 - Track: Application Database Development
Event Date: 07-09-2019 - Session time: 14:45:00 - Track: Analytics and Visualization
Session code: https://github.com/datawookie/talks/tree/master/2019-09-07-sql-saturday-johannesburg
Event Date: 07-09-2019 - Session time: 14:45:00 - Track: Advanced Analysis Techniques
Event Date: 07-09-2019 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
Using Power Query and M language one can define a step by step process of transforming and mapping data from one "raw" data form into another format with the intent of making it more appropriate and valuable for a variety of downstream purposes such as analytics.
The final transformed dataset is available one can use it to create visualizations that can be added to Power BI reports and publish to the Power BI service.
M stands for Data Mashup and M is a functional language.
In this session, I will demonstrate around 30 Things that one can do with Power Query
Event Date: 07-09-2019 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment