| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:40:00 | Steve Simon | SQL Dev: Soup to Nuts | I wanna learn SQL Server and I know nothing |
| 09:40:00 | Gary Hope | Data Warehouse Business Intelligence | Microsoft Stream Analytics and Real-Time Data Visualisation |
| 09:40:00 | Arnie Rowland | Database Development | RC, SI, and RCSI, Oh My! –We're off to see the Wizard -to understand how it all works. |
| 09:40:00 | Howard Diesel | Strategy And Architecture | The Monkey Wrench of data and information |
| 09:40:00 | Howard Diesel | Database Administration | Introduction to Extended Events in SQL Server 2012 2014 |
| 11:00:00 | Steve Simon | SQL Dev: Soup to Nuts | What you get out is as good as what you put in |
| 11:00:00 | Michael Johnson | Data Warehouse Business Intelligence | Automating your data-warehouse development with BIML |
| 11:00:00 | Sean Cremer | Database Administration | Dynamic Management Views and Functions - a Practical Overview |
| 11:00:00 | Clinton van Blommestein | Database Development | tSQLt - Database Unit Testing |
| 11:00:00 | Howard Diesel | Strategy And Architecture | SQL Server and the Data Management Practice |
| 12:10:00 | Neil Hambly | Database Development | Load Testing With SQL Server Tools |
| 12:10:00 | Steve Simon | SQL Dev: Soup to Nuts | Efficient and Effective coding of Stored Procedures |
| 12:10:00 | Toufiq Abrahams | Strategy And Architecture | Power BI Whirlwind Tour |
| 12:10:00 | Gail Shaw | Database Administration | Backups? What backups? |
| 12:10:00 | Alain Dormehl | Data Warehouse Business Intelligence | Analytics Platform System - SQL 2012 Parallel Data Warehouse vs SQL 201x |
| 13:50:00 | Steve Simon | SQL Dev: Soup to Nuts | Power to the people!! |
| 13:50:00 | Gary Hope | Database Administration | Microsoft Machine Learning Overview |
| 13:50:00 | Gail Shaw | Database Administration | Lies, Damned Lies And Statistics |
| 13:50:00 | Sandesh Nagaraj | Database Development | Data Warehouse Schema Design and Evolution |
| 13:50:00 | Bhavesh Lala | Data Warehouse Business Intelligence | Datazen the new kid on the block |
| 15:00:00 | Neil Hambly | Database Administration | Performance Troubleshooting Using DMVs |
| 15:00:00 | Toufiq Abrahams | Data Warehouse Business Intelligence | Dashboard DAX |
| 15:00:00 | Sandesh Nagaraj | Database Development | Data Profiling in SQL Server |
| 15:00:00 | Nóra Kovács | Strategy And Architecture | SQL licensing aka how to use Microsoft SQL Server legally |
| 15:00:00 | Gary Hope | Database Development | SQL Server Always-Encrypted |
| 15:00:00 | Howard Diesel | SQL Dev: Soup to Nuts | WomenInTech (ZA) - Diversity in the Tech Sector |
| 15:00:00 | Howard Diesel | Database Development | Dynamic SQL, not so scary |
Event Date: 05-09-2015 - Session time: 09:40:00 - Track: SQL Dev: Soup to Nuts
Event Date: 05-09-2015 - Session time: 09:40:00 - Track: Data Warehouse Business Intelligence
Event Date: 05-09-2015 - Session time: 09:40:00 - Track: Database Development
Event Date: 05-09-2015 - Session time: 09:40:00 - Track: Strategy And Architecture
Event Date: 05-09-2015 - Session time: 09:40:00 - Track: Database Administration
Event Date: 05-09-2015 - Session time: 11:00:00 - Track: SQL Dev: Soup to Nuts
Event Date: 05-09-2015 - Session time: 11:00:00 - Track: Data Warehouse Business Intelligence
Event Date: 05-09-2015 - Session time: 11:00:00 - Track: Database Administration
This session will cover the more commonly used Dynamic Management Views and introduce the new ones that will be coming in 2016.
Event Date: 05-09-2015 - Session time: 11:00:00 - Track: 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: 05-09-2015 - Session time: 11:00:00 - Track: Strategy And Architecture
Using SQL Server technologies to build a DAMA framework we will explore how to map the technologies onto the DAMA wheel which is divided into 11 principles: Data Governance, Data Architecture, Data Design Modelling, Data Storage Operations, Data Security, Data Integration Interoperability, Unstructured Data, Reference Master Data, Data Warehousing Business Intelligence, Metadata and Data Quality Management. Technologies such as DQS and Azure Data Catalog are used to achieve Data Quality Management. Power BI and PowerQuery will be mapped onto the Warehousing BI sector of the DAMA framework. The SQL Engine ensures Data Security. A comprehensive set of mappings will be provided. The Data Managemnt Trainline is a set of pat
Event Date: 05-09-2015 - Session time: 12:10:00 - Track: Database Development
Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools – including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler – we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.
Event Date: 05-09-2015 - Session time: 12:10:00 - Track: SQL Dev: Soup to Nuts
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: 05-09-2015 - Session time: 12:10:00 - Track: Strategy And Architecture
While Power BI is in preview, many updates and changes are anticipated. These will be incorporated into the session as far as possible.
Event Date: 05-09-2015 - Session time: 12:10:00 - Track: Database Administration
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: 05-09-2015 - Session time: 12:10:00 - Track: Data Warehouse Business Intelligence
I will go over some of the architectural implementations that make MPP SQL Possible, and that offer its ground breaking performance. Will also briefly cover scenarios where APS will shine and scenarios which are not ideal for APS as well as some of the current limitations on APS. I have access to an actual APS appliance (AU3) so we will be running side by side queries on a comparative SQL 201x Environment and then on the APS to show the performance of an APS as a data warehousing solution. Some of the specific side by side comparisons we will run: Data Loads - BCP, SSIS and BULK INSERT vs DWLoader.exe Data Transformation - CTAS, CRTAS BI Demonstration - Connecting Excel directly to 30 million + rows and doing a real time pivot without a cube off the back of APS. Lastly will cover some of the hybrid hadoop functionality with APS CETAS
Event Date: 05-09-2015 - Session time: 13:50:00 - Track: SQL Dev: Soup to Nuts
In this hands on presentation we shall be looking at practical ways and means of creating reports, utilizing Power Pivot and Power View. We shall take advantage of the BISM and have our data stored within a SQL Server tabular database. All examples come from actual implementations and we shall be looking at the constructive feedback provided by end users.
Event Date: 05-09-2015 - Session time: 13:50:00 - Track: Database Administration
Event Date: 05-09-2015 - Session time: 13:50:00 - Track: Database Administration
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: 05-09-2015 - Session time: 13:50:00 - Track: Database Development
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: 05-09-2015 - Session time: 13:50:00 - Track: Data Warehouse Business Intelligence
Event Date: 05-09-2015 - Session time: 15:00:00 - Track: Database Administration
We’ll be demonstrating using practical examples, including code that can be taken away and used on attendees’ own SQL Servers. We’ll also discuss how to identify common causes of performance issues, and learn how to quickly review and understand the wealth of performance data available
Event Date: 05-09-2015 - Session time: 15:00:00 - Track: Data Warehouse Business Intelligence
Event Date: 05-09-2015 - Session time: 15:00:00 - Track: Database Development
Event Date: 05-09-2015 - Session time: 15:00:00 - Track: Strategy And Architecture
It includes basic Microsoft licensing information (internal usage, third party services, cloud) then goes deeper into SQL licensing through examples - topologies.
Event Date: 05-09-2015 - Session time: 15:00:00 - Track: Database Development
Event Date: 05-09-2015 - Session time: 15:00:00 - Track: SQL Dev: Soup to Nuts
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: 05-09-2015 - Session time: 15:00:00 - Track: Database Development