Event Location:
Sanlam Head Office
2 Strand Rd, Bellville
Cape Town, , South Africa
Abstract:
At the very least, a T-SQL developer should know that the APPLY operator lets you access data from a table-valued function in a dynamic manner. But why stop there? When getting the data you need requires going around your elbow to get to your nose, that's when the savvy developer remembers the APPLY operator can be used with any table expression. Have you ever wished you could get multiple columns or multiple rows from a correlated sub-query? What about needing to UNPIVOT a data set, or parse some XML code? Have you simply wanted to find a way to handle complex calculations without having to cut and paste the entire formula in the WHERE or GROUP BY clause? This all-demo session answers those needs by revealing the secret life of APPLY, and helping you count yourself among those ace developers that use this handy operator to work smarter, not harder.
Speaker(s): Christina Leo,
Abstract:
Have you pulled a script to identify duplicates from a blog post, but couldn’t quite get it to work, because you weren’t sure what that ROW_NUMBER() function was doing. Maybe you heard talk about creating running totals without using sub-queries, but you got frustrated when the groups weren’t totaling correctly. Or maybe, you’ve never even heard of Window Functions. All are good reasons to attend this all-demo session which demystifies this versatile T-SQL tool. First, we’ll break apart the OVER clause, the key to understanding how window functions work. Then we’ll expand on each group of functions that can use the OVER clause: ranking, aggregate, and analytic functions. Finally, we’ll look at real scenarios where this tool works and talk about performance considerations. When you leave, you’ll have the fundamentals you need to fully develop your mastery of Window Functions.
Speaker(s): Christina Leo,
Abstract:
Why Upgrade? This is the big question that every SQL Server user will be asking, from my experience I say not just for shiny new features but increase your productivity and do-more with-less practices. Data Platform Upgrade topic has been a popular session that I've presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits since 2009. In this session, we will overview end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server 2000, 2005, SQL Server 2008 R2 (with a good overview on 2012 too) by using best practices and available resources. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution is offered.
Speaker(s): Satya Jayanty,
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:
In this session Juan will provide a brief overview of an Enterprise Data Warehouse Architecture approach and valuable ETL lessons learnt from his experience working on a number of strategic BI solutions. This will be the backdrop for a discussion of the differences between Microsoft's traditional SMP and emerging MPP platforms. Juan will highlight the considerations to take into account when migrating to a MPP platform and explain the performance differences you can expect.
Speaker(s): Juan Thomas,
Abstract:
There are many treatments of table design for slowly changing dimenions, and almost as many on doing ETL on an SCD. Much less has been said about building a cube around a slowly changing dimension.In this session, Mark will review the types of slowly changing dimensions, describe the performance implications of various methods of loading SCDs in SSIS (SCD task, Lookups, Merge, and Script component), and build the versioning directly into the dimension in Analysis Services
Speaker(s): Mark Stacey,
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 explore an easy way to leverage SharePoint to manage Role Based Security in the cube. The benefits of this is to allow a non technical person to administer access permissions at the click of a button.
Speaker(s): Matt Horn,
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:
So you already know and understand Row Groups, Delta Stores and Compression Methods, but let me show you how Clustered Columnstore Indexes work when locking blocking, when using different compression methods and technics. Let us dive deep into the Dictionaries creation and different methods for the ETL processes.
Speaker(s): Niko Neugebauer,
Abstract:
Master Data is not only a source in your organisation, but very often requires data feedback from various other IT systems. In addition to a high level introduction to Master Data Services(MDS) in SQL 2012, we will focus on closing the loop between MDS and your Data Warehouse. This will be a technical talk on the back-end integration points of MDS and how we can exploit these with SSIS.
Speaker(s): Dudley Drummond-Hay,
Abstract:
You can create professional, interactive and visually appealing Power View reports in Excel or SharePoint. The best part is that Power View is so easy to use. However, a report will always only be as good as the content (model) it is based on. In this session we look at how to design a Power Pivot (or Tabular) model with the Power View author in mind. The session will include how to work with KPIs, images, hierarchies and geo-spatial mapping.
Speaker(s): Toufiq Abrahams,
Abstract:
Every SQL developers should by now be aware of the new error handling introduced in SQL Server 2005, i.e. BEGIN TRY ... END TRY BEGIN CATCH ... END CATCH, and all of us are most likely extremely happy that we finally have "proper" error handling. 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.
Speaker(s): Niels Berglund,
Abstract:
Performance of a SQL Server depends on many factors and due to the nature of development SQL Server developers sometimes miss basic performance tips. Easily implemented tips such as using an appropriate index or solving a data mismatch problem on where conditions could affect the application performance significantly. In this session, we will cover the top 10 tips to improve the performance of your SQL Server with real life examples.
Speaker(s): Turgay Sahtiyan,
Abstract:
SQL Server 2014 receives a very new important feature - Clustered Columnstore Indexes. Using a xVelocity compression and a batch processing mode this type of indexes which was introduced in SQL Server 2012 is greatly enhanced by making it a Clustered and making it a default recommend solution for the DataWarehouse solutions. Join to discover the Clustered Columnstore Indexes by understanding on which principles they are built and what should you do get the best out of them. This new feature is targeted at the OLAP installations and it is already available for the PDW (Parallel DataWarehouse) v2.
Speaker(s): Niko Neugebauer,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://uk.linkedin.com/sqlmaster
Contact: http://www.sqlserver-qa.net
My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast
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.
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.
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.
Juan is a Solutions Architect, who loves getting his hands dirty delivering and building Data Warehouses and BI solutions. He is based in Cape Town and works for Saratoga. His most recent proposed architecture was assessed and given the top 5 % rubber stamp by the Kimball Group. Juan contributes actively to the local SQL scene speaking to anyone who will listen to his topic of passion namely BI Solution Architecture.
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.
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.
LinkedIn: http://pt.linkedin.com/in/webcaravela/
Contact: http://www.nikoport.com
Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.
LinkedIn: http://pt.linkedin.com/in/webcaravela/
Contact: http://www.nikoport.com
Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.
Dudley is a Lead Data Architect for EOH MC. He has been a BI developer and architect for over 13 years and has a string of successful data warehouse implementations. He specialises in the Microsoft BI Stack but has worked extensively with oracle and other DBMS's.
Contact: http://MarkGStacey.net
Mark Stacey founded the Aphelion Software Group, and works tirelessly to cross the business/technical boundaries in Business Intelligence, working in both SharePoint and SQL. He has published two books on BI - Sharepoint 2010 BI and Visual Intelligence and frequently speaks at both SQLSaturday and SharePoint Saturday events. Mark is one of the few Microsoft PDW trainers, and has trained in Africa, India and Europe on the PDW, as well as all over the world on other technologies
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.
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.
Contact: http://www.osmosisconsulting.co.za
Toufiq Abrahams is the Principal Consultant at Osmosis Consulting and Technology Director at Plain Sight Analytics. He has a passion for turning data into business value with one foot in the cloud and the other on-prem.
LinkedIn: http://tr.linkedin.com/pub/turgay-sahtiyan/15/b46/682
Contact: http://www.turgaysahtiyan.com/
Turgay Sahtiyan has been working in IT industry over a decade and he currently works as a PMC (Premier Mission Critical) Solution Engineer at Microsoft.He is based in Turkey and primarily giving proactive and reactive services with solution based approach to top enterprise customer in the MEA region.Before joined to Microsoft, he was one of the SQL Server MVP in Turkey,in addition he is founder and former president of SQLPass Turkey Chapter.(Detailed BIO http://www.turgaysahtiyan.com/about.aspx)
The following is a list of sponsors that helped fund the event.