Event Location:
Microsoft Office
3201 William Nicol Drive
Bryanston, Gauteng, South Africa
Abstract:
“Column dbo.xyz' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.” Seen it; fixed it, but can we explain why we’re getting a syntax in the first place? The optimizer must follow a very specific hierarchy in order to generate a plan. When you understand the hierarchy, then you better understand the behavior of the optimizer. This all-demo session will explain the logical processing hierarchy, giving you the foundation knowledge you need to build well-structured queries that keep the optimizer happy. Learn how the FROM clause is processed, why a calculated column’s alias can’t be addressed in the JOIN, why WHERE isn’t the only filter, and why NULL confuses everything. When you leave, you will think very differently about how you build your queries, and the query optimizer will love you for learning to speak its language.
Speaker(s): Christina Leo,
Abstract:
Windows Azure SQL Database is a fully-managed, scalable service based on SQL Server technology. It is also a shared-environment service which means that you can’t and shouldn’t avoid best practices when it comes to query tuning. Microsoft has put mechanisms in place to ensure that your queries and processes don’t use up too many resources which could seriously impact performance of not only your database, but the database of other organizations as well. This demo-filled session will look at tools and options available to help identify poor performing queries, such as dynamic management views. This session will help identify problem queries and help you understand why a query is running slow through execution plans and other tools in the SQL Database Portal. Ultimately, you will be enabled to find and fix your poorly performing queries and do it all in the cloud.
Speaker(s): Scott Klein,
Abstract:
Do you find yourself battling to describe the difference between a clustered and a non-clustered index. Do you struggle with unhappy users and bad performance. Do you want to know how to identify missing indexes or duplicate indexes? Indexes are a vital cog in the SQL Server engine and getting them right is one of the best performance tuning techniques available. A simple index can make the difference between a sub-second result or waiting 30 minutes for data. A simple index can also make the difference between happy and unhappy users. So what are indexes exactly and why do they make my life so much easier? Find out here.
Speaker(s): Sean Pearce,
Abstract:
When you think of SQL Server, the first thing you think about is probably not SQL as host for messaging / queuing applications. However, in certain scenarios it definitely makes sense to implement messaging inside the SQL engine. In this session we will see the benefits of messaging applications inside SQL as well as what options you have when implementing it and their respective performance implications.
Speaker(s): Niels Berglund,
Abstract:
In this session we will look at how you can easily get started with your first tabular cube. We will importing multiple data sources and creating relationships between them. This data will then be enriched through the use of calculated columns, and custom calculations.
Speaker(s): Michael Johnson,
Abstract:
With a wide variety of products services, Microsoft has really changed the game with their new BI capabilities. In this session Greg will take you through Microsoft Business Intelligence (SQL 2012/2014, SharePoint 2013 and Office 2013) providing useful insights into the present and the future of Microsoft Business Intelligence
Speaker(s): Greg Fibiger,
Abstract:
Database corruption is one of the worst things you can encounter as a DBA. It can result in downtime, data loss, and unhappy users. What’s scary about corruption is that it can strike out of the blue and with no warning, and without having some In this session we’ll look at • Easy maintenance operations you should be running right now to ensure the fastest possible identification and resolution of corruption • Best practices for handling a database that you suspect may be corrupted • Actions that can worsen the problem • Appropriate steps to take and methods of recovery
Speaker(s): Gail Shaw,
Abstract:
Creating a Federated Sql Database in Azure can allow your data to scale out as it grows. Session will primarily be demos cover Setting up and configuring a Federated Sql Database in Azure as well as how to monitor growth of federations and how to split federations. Will also cover some limitations and disadvantages that need to be taken into consideration when deciding if using a Federated Sql Database is suitable for your business.
Speaker(s): Martin Phelps,
Abstract:
SQL server 2012 functions and techniques you wish you knew about before writing that 1000 line UDF. In this session we will explore some interesting and useful tips,tricks, functions and DMVs.
Speaker(s): Matt Horn,
Abstract:
Introduction to the PDW: Gary Hope and Laura Kotlinksi
Speaker(s): Gary Hope Laura Kotlinski,
Abstract:
in this session I will cover 10 mistakes I see developers make on a regular basis. sometimes simple to fix other times just plain stupid.
Speaker(s): Jacques Mostert,
Abstract:
This Session is an introduction to Master Data Services and the role it can play in Data Management and Data Warehouse. Session Highlights: * Managing Slowly Changing Dimensions (SCD) * Managing Hierarchies relationships * managing Version control etc...
Speaker(s): Sandesh Nagaraj,
Abstract:
Overview and introduction to Microsoft's latest self-service BI offering - PowerBI
Speaker(s): Geoffrey Smith,
Abstract:
The Microsoft "Big Data" and "In Memory" Data Management Story. A 360' view of Microsoft's latest investments in scale out, unstructured and high speed transaction processing technologies that form the new Microsoft Data Platform (including PDW, Polybase, HDInsight and Hekaton)
Speaker(s): Gary Hope,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Contact: http://aka.ms/sqlscott
Scott Klein is a senior consultant with SQL Solutions Group with over two decades of experience working with Microsoft SQL Server. Prior to SSG, Scott spent almost 10 years at Microsoft, traveling the globe as a technical evangelist training and speaking about SQL Server and Microsoft’s Azure data services. Scott’s recent focus has been on advanced analytics, including big data and IoT, providing real-world training to help bring intelligence to your data. Scott has authored several books focusing on data and data analytics. Scott is continuously striving and looking for ways to help developers and companies grok the wonderful world of data.
LinkedIn: https://za.linkedin.com/in/niels-berglund-0122593
Contact: https://nielsberglund.com
Niels works as Software Architect at Derivco, where he develops software as well as "dreaming" up new and innovative ways to use existing and new technology. Before joining Derivco, Niels worked as researcher/instructor at Developmentor where he was responsible for the database curriculum. He was a co-author of the first SQL Server 2005 book for developers: quot; A First Look at SQL 2005 for Developersquot;. He has presented at all leading technical conferences; Tech-ED, SQL PASS, DevWeek, Ignite the Tour, etc., and is also a Microsoft Data Platform MVP.
Introduction to the PDW: Gary Hope and Laura Kotlinksi
Contact: http://thesqlguy.blogspot.com/
Sean Pearce is a SQL Server consultant with a background in application development. Sean started his career in 1996 with exposure to SQL Server 6.5. By SQL Server 2000, Sean found a database mentor and never looked back. Stepping into a SQL Server focused role, Sean took to SQL Server like a duck to water. His thorough understanding of the architecture and process driving SQL Server allows him to focus on performance and problem solving for clients. He also writes some mean SQL.
Michael Johnson is an independent Business intelligence consultant from Johannesburg South Africa
Contact: http://www.paradat.co.za
More than 15 years of IT experience with 12 years Technical Consulting in Data Warehousing/Business Intelligence; 15 years’ experience of designing and delivering Microsoft Certified Learning programs; International Microsoft Technology Speaker - Tech-Ed Africa 2008 to 2013 Senior Microsoft Business Intelligence Developer; Co-Founder CEO of Paradigm Data
Contact: http://sqlinthewild.co.za
Gail Shaw is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail holds a Microsoft Certified Master certification for SQL Server 2008 and is a Data Platform MVP. She's a frequent poster on the SQLServerCentral forums, a Pluralsight author, writes articles for both SQLServerCentral.com and Simple-Talk.com, and has spoken at SQLSaturdays, SQL Bits and at the PASS Community Summit. Gail has been responsible for extending the lifespan of many an application, by performance-tuning their databases and providing technical guidance on all things SQL Server related.
Contact: http://www.aphelion.bi/
Business Intelligence consultant at Aphelion Software
LinkedIn: http://www.linkedin.com/in/phelpsm
Martin Phelps is database architect at MiX Telematics. Specialising in Solution Architecture across their OLTP and DW databases. With 20 years of in-the-trenches experience with Sql Server he has provided solutions using Sql Server since version 4.2. Has previously done work for Insurance, ICT, Marketing and Mining companies.
LinkedIn: http://za.linkedin.com/in/sandeshnagaraj
A Certified Data Architect with around 15 years of experience in Data warehouse, Business Intelligence and Database implementation. Sandesh holds MCITP SQL Server in BI, Data Architect certified from Microstrategy etc. He has worked extensively as BI Consultant/Technical Specialist/BI Architect/Sales Engineer/Manager. Sandesh actively participates and speaks at Johannesburg SQL Server User and SQLSaturday events.
Contact: http://sqlinbuddy.wordpress.com/
A family man, Christian, starcraft addict with some SQL on the side. Working on SQL for a long time, started on V6.5. I have seen way to many versions of SQL/BI tools for any sane person. ‘There is evil here that does not sleep” and as far as I can will help where I can. As the “about” title says I wear sandals (Afrikaans: Plakkies) do not like shoes to my wifes/boss dismay. I enjoy going off-road with my “toyota” and when I am not “sql”ing I will be constructing something from wood.
Matt Horn is a senior consultant with Aphelion software and a regular speaker at SQLSaturdays and other community events. He has been the co lead of the BIDN BI user group in Johannesburg and an active member of SQLCape and the JHB SQL Usergroup.
Gary is a legend
Contact: http://christinaleo.net
Christina Leo is a Cloud Solution Architect at Microsoft specialising in the Data and AI Platform. Prior to joining Microsoft in 2016, she worked as an independent consultant focusing on T-SQL and BI development, as well as database performance tuning in the finance and investment banking sector. When she isn't sharing her 18 years of technical experience with the data community, you can find her racing around the Solent on a 40' sailboat or often in the Thames on a little Laser.
The following is a list of sponsors that helped fund the event.