| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Peter Willmot | Application Database Development | Designing and Building SQL Database Apps for IoT Scenarios |
| 09:00:00 | Mihail Mateev | Analytics and Visualization | Complex Event Processing with Azure Stream Analytics |
| 09:00:00 | Sean Cremer | Professional Development | Dynamic Management Views and Functions - a Practical Overview |
| 09:00:00 | Samantha Perry | Other | WomeninTechZA One Year On |
| 11:10:00 | Steve Simon | Information Delivery | SQL Server Reporting Services 2014 on Steroids!! |
| 11:10:00 | Steve Simon | Advanced Analysis Techniques | Business Analytics with SQL Server Power Map: |
| 11:10:00 | Niels Berglund | Application Database Development | Real World Error Handling in SQL Server |
| 11:10:00 | Gary Hope | Advanced Analysis Techniques | Microsoft Machine Learning Overview |
| 11:10:00 | Arnie Rowland | Application Database Development | RC, SI, and RCSI, Oh My! –We're off to see the Wizard -to understand how it all works. |
| 11:10:00 | Niels Berglund | Application Database Development | What's New for SQL Developers in SQL Server 2016 |
| 12:00:00 | Gareth Swanepoel | Cloud Application Development Deployment | A practical guide to Windows Azure SQL Database for the DBA |
| 13:00:00 | Gordon Beeming | Other | They said Select * was bad but... |
| 13:00:00 | Clinton van Blommestein | Application Database Development | tSQLt - Database Unit Testing |
| 13:00:00 | Michael Johnson | BI Platform Architecture, Development Administration | Automating your data-warehouse development with BIML |
| 13:00:00 | Trevor Makoni | Application Database Development | Dynamic SQL, not so scary? |
| 14:00:00 | Toufiq Abrahams | Analytics and Visualization | Dashboard DAX |
| 14:00:00 | Gail Shaw | Enterprise Database Administration Deployment | Lies, Damned Lies And Statistics |
| 14:00:00 | Gail Shaw | Enterprise Database Administration Deployment | Backups? What backups? |
| 14:00:00 | Toufiq Abrahams | BI Information Delivery | Introduction to DataZen |
| 14:00:00 | Gareth Swanepoel | Enterprise Database Administration Deployment | SQL Server 2014 for the DBA |
| 14:00:00 | Mihail Mateev | Application Database Development | Dealing with Entity Framework 7 |
| 14:00:00 | Dr. Subramani Paramasivam | Enterprise Database Administration Deployment | Life saver - Resource Governor for applications reporting |
| 15:00:00 | Sandesh Nagaraj | BI Platform Architecture, Development Administration | Data Warehouse Schema Design and Evolution |
| 15:00:00 | Dr. Subramani Paramasivam | Advanced Analysis Techniques | What is Power BI capable of in azure? |
| 15:00:00 | Neil Hambly | Enterprise Database Administration Deployment | DBA Guide to Extended Events |
| 15:00:00 | Stiaan Maree | Analytics and Visualization | R Language Modules in Azure Machine Learning |
Event Date: 12-09-2015 - Session time: 09:00:00 - Track: Application Database Development
Event Date: 12-09-2015 - Session time: 09:00:00 - Track: Analytics and Visualization
This technology uses a T-SQL like syntax to express its intents. A language that most data-power users will be familiar with.
The biggest advantage of Stream Analytics is when events are being published to the Stream Analytics, the only thing that event publishers needs to know is which Event Bus or Blob storage to place the data. Stream Analytics will then fetch the data.
This talk is about the main concepts and solution architecture when using Azure Stream Analytics, and also how to use this technology together with MS SQL Server, Azure SQL Database and Power BI.
Event Date: 12-09-2015 - Session time: 09:00:00 - Track: Professional Development
This session will cover the more commonly used Dynamic Management Views and introduce the new ones that will be coming in 2016.
Event Date: 12-09-2015 - Session time: 09:00:00 - Track: Other
One year on from WomeninTechZA's launch and much has changed in the tech sector, and a lot has not. In this talk we look at changing attitudes to diversity, specifically in the tech sector, why diversity is profitable, and what local companies can do to tackle the diversity challenge.
Event Date: 12-09-2015 - Session time: 11:10:00 - Track: Information Delivery
In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.
Event Date: 12-09-2015 - Session time: 11:10:00 - Track: Advanced Analysis Techniques
In the hands-on presentation we shall be constructing a few simple analytic reports (from background financial data). More importantly we shall see how our conclusions help us target new prospective business opportunities.
Event Date: 12-09-2015 - Session time: 11:10:00 - Track: Application Database Development
However, in the "real world" it may not be so straight forward as just using this new error handling. As we at Derivco have seen there are quite a few "gotchas" when it comes to how to handle errors. In this session we will take a look and see what issues we have to be aware of, in order not to be bitten by our error handling.
Event Date: 12-09-2015 - Session time: 11:10:00 - Track: Advanced Analysis Techniques
Event Date: 12-09-2015 - Session time: 11:10:00 - Track: Application Database Development
Event Date: 12-09-2015 - Session time: 11:10:00 - Track: Application Database Development
Things we will look at is: improvements to In-Memory OLTP (the "artist" formerly known as Hekaton), Operational Analysis - how to combine OLTP processes together with the ability to analyse the data at the same time, new JSON support and other odd and "sundry" things
Event Date: 12-09-2015 - Session time: 12:00:00 - Track: Cloud Application Development Deployment
If you are a production DBA and have contemplated one or more of these questions, this session is for you! Maybe, you have been tasked with finding out about "The Cloud". Join me in exploring the cloud where I will show you how SQL Server works in the Windows Azure SQL Database world. We will run through the simple process of configuring a Windows Azure SQL database. We will investigate the similarities and differences between on premises SQL Server and Windows Azure SQL Databases. We will even look into the DR, HA, monitoring and performance tuning options available with Windows Azure.
Event Date: 12-09-2015 - Session time: 13:00:00 - Track: Other
Event Date: 12-09-2015 - Session time: 13:00:00 - Track: Application Database Development
Or you are that lucky person that has to make changes to business critical code, where a mistake can put you on a fist name basis with the CEO.
Sure, we have testing departments that will check our code, and some of us have to test our code ourselves. But you might still end up lying awake at night wondering about that edge case scenario.
Testing takes time, and database tables have foreign keys and constraints and all sorts of other things that make it hard to get the system into a specific state. Then you change your code and have to do it all over again.
tSQLt allows you to prepare your database for a test, and once the test is run the database is set back like nothing happened. All that remains is whether your test succeeded.
We will go through setting up the framework, how to write tests and run them - either manually or as part of your build process
Event Date: 12-09-2015 - Session time: 13:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 12-09-2015 - Session time: 13:00:00 - Track: Application Database Development
I will be looking at the specific example of an application runtime need to import all or a subset of database objects tables, views, functions, procedures, triggers from one database to another.
I will also look at how to store the result of a SQL select into a .NET Data Table object and then to XML and then the reverse of picking up the XML and then recreating the dataset back to SQL.
Event Date: 12-09-2015 - Session time: 14:00:00 - Track: Analytics and Visualization
Event Date: 12-09-2015 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
In this session well take a look at what statistics are and why SQL keeps them; at how SQL maintains them and under what circumstances that maintenance is insufficient; and well look at the problems that result when they are inaccurate.
Finally we'll cover some suggestions and options around maintenance of statistics when the automatic maintenance is not sufficient.
Event Date: 12-09-2015 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
In this introductory session, we’ll look at backups, backups and more backups (because there’s no such thing as too many backups)
We’ll look at full backups, what they are and how often they should be run. We’ll look at differential backups, how they fit into backup strategies and the pitfalls you may encounter when using them. We’ll look at transaction log backups, at why they are an essential part of the backup strategy for important databases and at what happens when transaction log backups go wrong.
Event Date: 12-09-2015 - Session time: 14:00:00 - Track: BI Information Delivery
Learn how to quickly leverage existing data and provide compelling dashboards "on the go" with DataZen. In this session we cover the basics, including how to work with different data sources and configuring common visualisations such as maps, treemaps, gauges, etc.
Walk away from this session confident that you can boost your BI presence with DataZen and minimal effort.
Event Date: 12-09-2015 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
The target of this session is SQL Server DBA’s, developers, architects or IT professionals who are excited about the new SQL Server 2014 features and are looking to learn more about them. This class assumes that you have average to good T-SQL skills already and a good understanding of SQL Server fundamentals.
Event Date: 12-09-2015 - Session time: 14:00:00 - Track: Application Database Development
The latest version of this ORM is Entity Framework 7. EF 7 is an extensible and lightweight version of Entity Framework that enables provides support for new platforms and new data stores. Entity Framework 7 is a major redesign of Entity Framework and is the default data stack for ASP.Net 5 application
This talk is about new features in Microsoft Entity Framework 7 - access to data across relational and non-relational stores and also... how to use it in Microsoft Azure
Event Date: 12-09-2015 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
What does Resource Governor do? What is a resource Pool? Why any basic/intermediate users are given caution before implementing Resource Governor? What is this capable of doing in terms of allocating resources to the users, databases and applications? What are the methods to implement Resource Governor how to monitor the resource pools in terms of GUI T-SQL?
You can take away working scripts, functions, tools to make a Resource Governor work and manage them.
Event Date: 12-09-2015 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration
Different types Schema Design: In terms of tables accessed, Joins, data modification, data loading/Maintenance, data redundancy, design and size.
• Completely • Normalized • Moderately de-normalized • Completely de-normalized • Star
And lastly discuss around the common schema design roadblocks that people face like Hierarchy, SCD etc…
Event Date: 12-09-2015 - Session time: 15:00:00 - Track: Advanced Analysis Techniques
What is regular Power BI look like? And what about connecting this to the cloud service/on-premise/hybrid with structured, semi, unstructured data in Haddop with statistical analysis using Machine Learning. It is really mind blowing to have one analytical tool to visualized data against various different types of data sources.
This session helps you to explore the possibilities of how far latest Power BI Azure lets you to stretch to visualize the future.
Take away a mind blowing experience on the unbelievable possibilities which will excel you in your career/business.
Event Date: 12-09-2015 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
This session is focused to make you Effective with Extended Events, find out how to be up and running with using EE in just minutes not hours or days, join us to take a look what EE can do and discover what's happening inside your SQL Servers in ways no possible before
Event Date: 12-09-2015 - Session time: 15:00:00 - Track: Analytics and Visualization
The number of packages available on CRAN increased from just 110 in 2001 to more than 7000 today, with many focused on machine learning. In this session we will look at the R Language Modules available in Azure Machine Learning.