| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Steve Simon | BI Information Delivery | An introduction to Data Mining with SQL Server 2016 |
| 09:00:00 | Peter Willmot | Other | Using the SQL 2016 Query Store to optimise Performance and Scalability |
| 09:00:00 | James McGillivray | BI Information Delivery | Why you should be BI curious |
| 09:00:00 | Sean Cremer | Application Database Development | Introduction to Database Design |
| 09:00:00 | Gordon Beeming | Professional Development | Your code is not just...your code |
| 09:00:00 | Michael Raam | BI Information Delivery | From Me BI to We BI, take your BI solution beyond the clouds |
| 09:00:00 | Vanessa Raath | Professional Development | How to become the most sought after SQL Server professionals in J |
| 10:15:00 | Jody Roberts | Enterprise Database Administration Deployment | The magic that is Stretchdb |
| 10:15:00 | Clinton van Blommestein | Application Database Development | So, when you say database what do you mean? |
| 10:15:00 | Uwe Ricken | Application Database Development | Daily problems with indexing and its - possible - solution |
| 10:15:00 | Matt Horn | BI Information Delivery | The language informally known as M |
| 10:15:00 | Anthony Fourie | Enterprise Database Administration Deployment | Welcome to the core soldier |
| 10:15:00 | Gail Shaw | Professional Development | Becoming a successful SQL Developer |
| 11:30:00 | Fabiano Amorim | Application Database Development | I'm a DBA. Now what? |
| 11:30:00 | Jean-Pierre Voogt | Information Delivery | What!!! a new AdventureWorks? Welcome to WorldWideImporters |
| 11:30:00 | Steve Simon | Professional Development | Becoming a successful Business Intelligence developer |
| 13:30:00 | Sean Pearce | Enterprise Database Administration Deployment | Hitchhikers Guide to Table Partitioning |
| 13:30:00 | Kirsten Burnett | BI Platform Architecture, Development Administration | Tabular End to End |
| 13:30:00 | Jacques Mostert | Information Delivery | You hit F5 and now what? |
| 13:30:00 | Jody Roberts | Professional Development | Becoming a successful Database Administrator (DBA) |
| 13:30:00 | Luis de Sousa | Advanced Analysis Techniques | Advanced Analytics with SQL Server R Services using R Tools for V |
| 14:45:00 | Gail Shaw | Application Database Development | On Transactions and Atomic Operations |
| 14:45:00 | Sifiso Ndlovu | BI Platform Architecture, Development Administration | SQL Server 2016 JSON Support FOR Data Warehousing |
| 14:45:00 | Sandesh Nagaraj | BI Information Delivery | BI Office Analytic Platforms and the Value of Shared Context |
| 14:45:00 | Samantha Perry | Professional Development | The thing about women in tech |
Event Date: 03-09-2016 - Session time: 09:00:00 - Track: BI Information Delivery
In this hands on BEGINNERS presentation we shall be looking at Microsoft SQL Server’s Data Mining capabilities and we shall be discussing:
Defining what questions we want answered and how to go about this in an effective and efficient manner.
Creating the data model.
How to gather the necessary data, discussing the training and testing aspect.
Processing the model.
Extracting information from our finished model, discussing the implications of this information.
Event Date: 03-09-2016 - Session time: 09:00:00 - Track: Other
Event Date: 03-09-2016 - Session time: 09:00:00 - Track: BI Information Delivery
In this beginner level session, learn the basics of Business Intelligence, the stages of BI maturity and get introduced to the Microsoft BI Stack, starting from the humble roots of Reporting Services, through to the incredible power of Interactive Dashboards in Power BI.
Whether you're looking for a different career option, or you're just interested in broadening your knowledge base, come and experience the wonders of being (in) BI!
Note: This session comes packaged with a series of double entendres and other innuendos.
Event Date: 03-09-2016 - Session time: 09: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: 03-09-2016 - Session time: 09:00:00 - Track: Professional Development
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
Event Date: 03-09-2016 - Session time: 09:00:00 - Track: BI Information Delivery
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 ….
Event Date: 03-09-2016 - Session time: 09:00:00 - Track: Professional Development
Event Date: 03-09-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 03-09-2016 - Session time: 10:15:00 - Track: Application Database Development
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.
Event Date: 03-09-2016 - Session time: 10:15:00 - Track: Application Database Development
Event Date: 03-09-2016 - Session time: 10:15:00 - Track: BI Information Delivery
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.
Event Date: 03-09-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
We take a look at configuring and deploying an AlwaysOn availability group across Windows Server Core machines using PowerShell.
Event Date: 03-09-2016 - Session time: 10:15:00 - Track: Professional Development
This session will begin with a 30 minute overview of is required of a SQL Developer, what training options are available as well as what career prospects are as you career progresses. This will be followed by a 20 min QA session where you will be able to ask the panel questions.
Event Date: 03-09-2016 - Session time: 11:30:00 - Track: Application Database Development
Event Date: 03-09-2016 - Session time: 11:30:00 - Track: Information Delivery
Event Date: 03-09-2016 - Session time: 11:30:00 - Track: Professional Development
The session will begin with a 30 minute overview of what is required of a business developer, what training options are available for you to and what career opportunities exist as you career progresses. The final 20 minutes will be a QA session for you to ask the Panel any career related questions you may have.
Event Date: 03-09-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 03-09-2016 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 03-09-2016 - Session time: 13:30:00 - Track: Information Delivery
Event Date: 03-09-2016 - Session time: 13:30:00 - Track: Professional Development
We will spend 20 minutes looking at what the typical day for a DBA looks like as well as training that you may need to become a DBA. This will be followed by a 20 minute QA session where you will be given the opportunity to ask questions from senior DBA's
Event Date: 03-09-2016 - Session time: 13:30:00 - Track: Advanced Analysis Techniques
We'll demo these capacities and wrap up with guidelines/advice for your own advanced analytics journey.
Event Date: 03-09-2016 - Session time: 14:45:00 - Track: Application Database Development
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.
Event Date: 03-09-2016 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 03-09-2016 - Session time: 14:45:00 - Track: BI Information Delivery
Event Date: 03-09-2016 - Session time: 14:45:00 - Track: Professional Development