SQLSaturday #432 - Cape Town 2015
Event Date: 09/12/2015 00:00:00
Event Location:
- The River Club
- Liesbeek Parkway Observatory Road, Observatory, Cape Town, South Africa
- Cape Town, Western Cape, South Africa
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: SQL Server Reporting Services 2014 on Steroids!!
Abstract: Reporting requests that are required ‘yesterday or sooner’, oft times necessitate working more efficiently and effectively. We have all been through this at one time or another. 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.
Speaker(s):
- Steve Simon
Track and Room: Information Delivery - Limpopo
Title: RC, SI, and RCSI, Oh My! –We’re off to see the Wizard -to understand how it all works.
Abstract: I’m just going to say it straight out. I’m pessimistically optimistic that most really understand transaction concurrency in SQL Server. There is often significant confusion about transaction concurrency and contention options available to Developers -is it ‘pessimistic’, or ‘optimistic’, or in between? Everyone ‘sort of’ understands READ COMMITTED (RC). But do you sometimes feel ‘dirty’ as you attempt to ‘repeatedly’ read that phantasma? In order to reduce locking and blocking conflicts, some folks adopt SNAPSHOT ISOLATION (SI). And a few hardy stalwarts have ventured into the new world of READ COMMITTED SNAPSHOT ISOLATION (RCSI). In this session, we will explore the differences between the three, including a discussion about the positives and negatives of each option. We will discuss the effects of ‘Dirty’, ‘Repeatable’ and ‘Phantom’ reads, and why you may want to know which may be buried in your code. There will be code examples demonstrating the benefits and traps of each option.
Speaker(s):
- Arnie Rowland
Track and Room: Application Database Development - Liesbeeck
Title: Life saver - Resource Governor for applications reporting
Abstract: This critical situation still exists in many live production environments in various organizations. This quick Life Saver techniques will quickly enable you to provide prompt solution as a patch with Resource Governor features. This helps to manage memory, cpu resources and enables various applications reporting to perform better by creating resource pools and allocating the memory for various groups, users, databases, applications. Also this session answers below questions.
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.
Speaker(s):
- Dr. Subramani Paramasivam
Track and Room: Enterprise Database Administration Deployment - Cloud Application Development Deployment
Title: A practical guide to Windows Azure SQL Database for the DBA
Abstract: What is “Windows Azure SQL Database” all about ? What does this mean for me as a DBA ? What is the process for setting up a Windows Azure database ? How would I go about migrating one of my databases to “The Cloud” ? How do I possibly leverage this new technology in my production environment ? 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.
Speaker(s):
- Gareth Swanepoel
Track and Room: Cloud Application Development Deployment - Cloud Application Development Deployment
Title: Introduction to DataZen
Abstract: Microsoft recently acquired DataZen, a mobile BI solution that works on any platform. DataZen plugs the BI information delivery gap in the Microsoft BI ecosystem, offering e responsive mobile solution that works on Android, iOS, Windows Phone, Windows desktop and any web browser. DataZen is an on-premises solution, but works just as well on Azure. Best of all, DataZen is free for SQL Server Enterprise Agreement clients with Software Assurance.
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.
Speaker(s):
- Toufiq Abrahams
Track and Room: BI Information Delivery - Tugela
Title: SQL Server 2014 for the DBA
Abstract: SQL Server 2014 is the newest version of SQL Server available from Microsoft. This session is designed to introduce SQL Server DBA’s to some of the new and exciting features available in that version. Topics covered in this session include AlwaysOn enhancements, Clustered ColumnStore indexes, Memory-optimised tables (In-Memory OLTP, code-named Hekaton) and Extended Events enhancements. 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.
Speaker(s):
- Gareth Swanepoel
Track and Room: Enterprise Database Administration Deployment - Liesbeeck
Title: Complex Event Processing with Azure Stream Analytics
Abstract: Azure Stream Analytics targets complex event streams (CEP’s) to deduce meaningful patterns. Most of the typical use cases for this product is when various devices and sensors are sending data for further processing.
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.
Speaker(s):
- Mihail Mateev
Track and Room: Analytics and Visualization - Limpopo
Title: What is Power BI capable of in azure?
Abstract: Power BI has complete solution for end to end analysis of any type of data factory that you have. This session will enable you to understand how depth you can get to the roots to visualize the solution for your business customers.
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.
Speaker(s):
- Dr. Subramani Paramasivam
Track and Room: Advanced Analysis Techniques - Orange
Title: tSQLt - Database Unit Testing
Abstract: Everyone writes perfect SQL code, but sometimes things happen that make your code run in weird and unexpected ways. 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
Speaker(s):
- Clinton van Blommestein
Track and Room: Application Database Development - Limpopo
Title: Dashboard DAX
Abstract: Say what? The secret sauce for creating smart dashboards with Power BI is DAX (Data Analysis Expressions). Delivering insight isn’t just about data viz, its also about having the right measurements and meaningful context. In this session we show you how to create DAX calculated columns and fields that will take your dashboard creation skills to the next level.
Speaker(s):
- Toufiq Abrahams
Track and Room: Analytics and Visualization - BI Platform Architecture
Title: Lies, Damned Lies And Statistics
Abstract: Ever wondered what the things called statistics are, why they’re important and what needs to be done to maintain them? If so, this session is for you!
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.
Speaker(s):
- Gail Shaw
Track and Room: Enterprise Database Administration Deployment - Development Administration
Title: Designing and Building SQL Database Apps for IoT Scenarios
Abstract: Learn about various features and capabilities of the SQL Database engine that can be leveraged to provide optimal support for IoT and similar applications scenarios in which data is gathered in high volumes from medium-to-large populations of distributed mobile and/or embedded client applications (e.g. Android, industrial micro-controller, etc) that utilize a variety of operating system and programming platforms. Session covers a wide range of topics from optimal physical schema design and tips for building apps that cater for popular protocols and data formats such as JSON and MQTT.
Speaker(s):
- Peter Willmot
Track and Room: Application Database Development - Orange
Title: Dynamic Management Views and Functions - a Practical Overview
Abstract: For anyone working on SQL Server these are an invaluable tool. They provide a means to diagnose problems and performance tune.
This session will cover the more commonly used Dynamic Management Views and introduce the new ones that will be coming in 2016.
Speaker(s):
- Sean Cremer
Track and Room: Professional Development - Liesbeeck
Title: R Language Modules in Azure Machine Learning
Abstract: R has grown into one of the most important programming languages used by academics and industry, for statistical computing 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.
Speaker(s):
- Stiaan Maree
Track and Room: Analytics and Visualization - Limpopo
Title: Data Warehouse Schema Design and Evolution
Abstract: discussion around Data Warehouse Schema Design and evolution.The flexibility of ROLAP model to support all Schema design categorizations and optimizes the performance of the ROLAP model.
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…
Speaker(s):
- Sandesh Nagaraj
Track and Room: BI Platform Architecture, Development Administration - Tugela
Title: Business Analytics with SQL Server Power Map:
Abstract: With the rapid advance in analytic features and the increased capabilities to produce more informative reports, SQL Server 2014 opens a plethora of new and exciting opportunities. 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.
Speaker(s):
- Steve Simon
Track and Room: Advanced Analysis Techniques - BI Platform Architecture
Title: Automating your data-warehouse development with BIML
Abstract: BIML is a great tool for the automaton of your Business Intelligence solution. In this talk you will learn how BIML can be used to create consistent and well-designed SSIS packages to handle the loading of your data warehouse. Using templates and meta-data driven package generation we can quickly build up the ETL solution and just as quickly respond to changing requirements as they arrive.
Speaker(s):
- Michael Johnson
Track and Room: BI Platform Architecture, Development Administration - Tugela
Title: Dealing with Entity Framework 7
Abstract: EF (Entity Framework) is Microsoft’s flagship data access platform – an extended ORM (Object Relational Mapper) that abstracts the calls to the ADO.Net data access provider underneath.
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
Speaker(s):
- Mihail Mateev
Track and Room: Application Database Development - Orange
Title: Backups? What backups?
Abstract: That’s never something you want to hear. Unfortunately it tends to be heard far too often. 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.
Speaker(s):
- Gail Shaw
Track and Room: Enterprise Database Administration Deployment - Limpopo
Title: DBA Guide to Extended Events
Abstract: Extended Events is the profiler tool replacement, it is the premium tool for capturing diagnostic information for SQL Server, with advanced capabilities unlike we’ve had available before, using new features can take time to learn
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
Speaker(s):
- Neil Hambly
Track and Room: Enterprise Database Administration Deployment - Liesbeeck
Title: WomeninTechZA One Year On
Abstract: WomeninTechZA - Diversity in the tech sector - One step forward two steps back? 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.
Speaker(s):
- Samantha Perry
Track and Room: Other - Tugela
Title: Real World Error Handling in SQL Server
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
Track and Room: Application Database Development - Enterprise Database Administration Deployment
Title: What’s New for SQL Developers in SQL Server 2016
Abstract: Next version of SQL Server is just “around the corner”. In this session we will look at what a SQL Server developer may find interesting among a “sea” of new features / functionality.
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
Speaker(s):
- Niels Berglund
Track and Room: Application Database Development - Orange
Title: They said Select * was bad but…
Abstract: So speaking to any smart database people they will generally tell you that the SELECT * FROM … is a bad idea and should not be used. In this session we’ll see some reason why this specifically focused on using them in views. Including an example of where this could go extremely wrong in the real world
Speaker(s):
- Gordon Beeming
Track and Room: Other - Orange
Title: Microsoft Machine Learning Overview
Abstract: Advanced Predicive Analytics Overview with Azure Machine Learning
Speaker(s):
- Gary Hope
Track and Room: Advanced Analysis Techniques - Tugela
Title: Dynamic SQL, not so scary?
Abstract: A look at how dynamic SQL can be used in BAU tasks as a tool and also its use in applications.
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.
Speaker(s):
- Trevor Makoni
Track and Room: Application Database Development - Liesbeeck
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Gail Shaw
Twitter: - @SQLInTheWild
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.
Gareth Swanepoel
Twitter: - @GarethSwan
Contact: http://mygareth.com
Gareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 25 years. He enjoys solving the complex problems that customers encounter when performance tuning SQL Server or when deploying SQL Server in large data warehouse environments. He is originally from South Africa and is currently a Dedicated Support Engineer (PFE) with Microsoft. He is a passionate member of the SQL Server community and is an accomplished author and speaker having presented at various user groups, SQLSaturdays, the PASS Summit and other technical conferences.
Gail Shaw
Twitter: - @SQLInTheWild
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.
Gareth Swanepoel
Twitter: - @GarethSwan
Contact: http://mygareth.com
Gareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 25 years. He enjoys solving the complex problems that customers encounter when performance tuning SQL Server or when deploying SQL Server in large data warehouse environments. He is originally from South Africa and is currently a Dedicated Support Engineer (PFE) with Microsoft. He is a passionate member of the SQL Server community and is an accomplished author and speaker having presented at various user groups, SQLSaturdays, the PASS Summit and other technical conferences.
Gary Hope
Twitter: - GaryHope
Cloud Data and AI Solution Architect at Microsoft South Africa
Trevor Makoni
LinkedIn: Trevor Makoni
Trevor has over 6 Years of experience as a Data Analyst/Developer in the Financial, Telecommunications and retail sectors. Trevor is an accomplished and fluent communicator (verbal and written) with strong investigation, problem-solving and decision-making skills, he has a sharp eye for identifying process constraints and is able to recommend and apply efficiency and optimization solutions.
Trevor’s skillset includes the following but is not limited to: SQL/SSIS/SSAS/C#/VB Development, ETL.
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
Toufiq Abrahams
Twitter: - https://twitter.com/ToufiqAbrahams
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.
Clinton van Blommestein
LinkedIn: Clinton van Blommestein
Clinton is a senior developer at Derivco in Durban (South Africa), a company that is a leader in the online gaming space. He has over 16 years experience in highly transactions systems, with focus on the services and data tiers. He is a regular speaker at SQL events in South Africa, is also the co-leader for the Durban SQL User Group and has recognised as a Couchbase Champion for his contribution to their community.
Peter Willmot
Peter has been writing software (and teaching folk how to write software) for over 30 years. He has worked with SQL Server as an architect and developer for more than 20 years (since SQL 4.2) and has also worked extensively with the .Net and various other development platforms.
Peter is a past MSDN Regional Director and was also an MVP (SQL Server and Architecture) for many years. He is a passionate and regular speaker and various industry events around the world.
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
Arnie Rowland
Twitter: - @ArnieRowland
LinkedIn: Arnie Rowland
Contact: http://sqlblog.com/blogs/arnie_rowland/
Arnie long ago realized that most issues between Developer and DBA comes from incomplete communication and a misunderstanding of each other’s objectives. He is a frequent Trainer and Mentor for Developers and DBAs, bringing both sets of skills to better communicate with teams to create a working solution. For over a decade, Arnie has been a SQL Server MVP, Certified Trainer, technical editor for several publishers, including MOC, and has served as University and Community College adjunct faculty. Clients include Fortune 500 and Multi-Nationals, Federal and State agencies, Foreign governments, and local enterprises –both public and private.
Toufiq Abrahams
Twitter: - https://twitter.com/ToufiqAbrahams
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.
Peter Willmot
Peter has been writing software (and teaching folk how to write software) for over 30 years. He has worked with SQL Server as an architect and developer for more than 20 years (since SQL 4.2) and has also worked extensively with the .Net and various other development platforms.
Peter is a past MSDN Regional Director and was also an MVP (SQL Server and Architecture) for many years. He is a passionate and regular speaker and various industry events around the world.
Sean Cremer
Twitter: - https://twitter.com/seanCremer
LinkedIn: Sean Cremer
Contact: https://seancremer.github.io/
Sean Cremer is a Senior Developer at Derivco. He has worked with SQL Server for nearly two decades on Large OLTP and Data Warehousing Systems and has a wealth of accumulated Database Design and Implementation knowledge.
Michael Johnson
Twitter: - MikeJohnsonZA
LinkedIn: Michael Johnson
Contact: http://michaeladrianjohnson.com/
Michael Johnson is a Microsoft data platform MVP and leader of the Johannesburg SQL User Group and Business Analytics Virtual Group. He works as an Independent Business Intelligence Consultant and regularly presents at local user groups, SQLSaturdays and PASS Virtual Chapters.
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
Niels Berglund
Twitter: - nielsberglund
LinkedIn: Niels Berglund
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.
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
Toufiq Abrahams
Twitter: - https://twitter.com/ToufiqAbrahams
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.
Mihail Mateev
Twitter: - mihailmateev
LinkedIn: Mihail Mateev
Contact: https://mmateev.wordpress.com/
Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.
Toufiq Abrahams
Twitter: - https://twitter.com/ToufiqAbrahams
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.
Mihail Mateev
Twitter: - mihailmateev
LinkedIn: Mihail Mateev
Contact: https://mmateev.wordpress.com/
Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.
Niels Berglund
Twitter: - nielsberglund
LinkedIn: Niels Berglund
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.
Stiaan Maree
Twitter: - www.twitter.com/stiaanmaree
LinkedIn: Stiaan Maree
Stiaan Maree worked as a .NET and BI developer, and founded Light Bulb Research in 2012. He currently focuses on Machine Learning.
Matt Horn
Twitter: - https://twitter.com/maxui
LinkedIn: Matt Horn
Matt Horn is a Business Intelligence Developer and director with Immersant Data Solutions. He has been a regular speaker at SQLSaturday events for many years He is the Co Lead of the IntelliCape Business Intelligence user group based in Cape Town. .
Samantha Perry
Twitter: - @samanthaperry
Samantha Perry is the co-founder of and human behind WomeninTechZA (womenintech.co.za) - an initiative that aims to bridge the gender diversity gap in the South African tech sector. Having worked in the tech sector as a journalist for 18 years, Samantha recently moved back into the strategic communications space. She has a Masters degree in ICT Policy amp; Regulation, likes long walks on the beach, and hopes to one day have the kind of job that gives her time to take them.
Neil Hambly
Twitter: - Neil_Hambly
LinkedIn: Neil Hambly
Contact: http://dataidol.com/NeilHambly
Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.
Gary Hope
Twitter: - GaryHope
Cloud Data and AI Solution Architect at Microsoft South Africa
Gordon Beeming
Twitter: - GordonBeeming
LinkedIn: Gordon Beeming
Contact: http://beeming.net/
Gordon Beeming is a Software Developer at Derivco in the sunny city of Durban, South Africa. He spends most his time hacking away at the keyboard in Visual Studio or with his family relaxing. He is a Visual Studio ALM Ranger, Visual Studio ALM MVP and Friend of Red Gate. His blog is at beeming.net and you can follow him on Twitter at twitter.com/gordonbeeming.
Sandesh Nagaraj
LinkedIn: Sandesh Nagaraj
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.
Dr. Subramani Paramasivam
Twitter: - https://twitter.com/dageop
LinkedIn: Dr. Subramani Paramasivam
Contact: http://www.yoursqlman.com/index.php/blogs
Dr.SubraMANI Paramasivam is a Microsoft MVP, PhD, Microsoft Certified Trainer and Head of Data AI at DAGEOP Ltd having 21 years of DB, BI, Analytics and AI experience. Mani has also spoken in various events like MS IGNITE, PASS Summit, MS Inspire, SQLBITS, Power Platform Summit, Global AI Bootcamp, Data BI Summit, SQLRelay, Power BI World Tour, Data Platform Summit, INSIDESQL UK, Global AI Nights, SQLServerGeeks Summit, MCT Global Summits, Data Day Events and various user group events. Mani also believes in Empowering Every Person in the planet and spreads the awareness on Global challenges via www.EmpoweringEveryPerson.com. He is also a co-owner of 1 Global AI Meetup and 3 Power BI PUG PASS local / user groups.
Mihail Mateev
Twitter: - mihailmateev
LinkedIn: Mihail Mateev
Contact: https://mmateev.wordpress.com/
Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.
Dr. Subramani Paramasivam
Twitter: - https://twitter.com/dageop
LinkedIn: Dr. Subramani Paramasivam
Contact: http://www.yoursqlman.com/index.php/blogs
Dr.SubraMANI Paramasivam is a Microsoft MVP, PhD, Microsoft Certified Trainer and Head of Data AI at DAGEOP Ltd having 21 years of DB, BI, Analytics and AI experience. Mani has also spoken in various events like MS IGNITE, PASS Summit, MS Inspire, SQLBITS, Power Platform Summit, Global AI Bootcamp, Data BI Summit, SQLRelay, Power BI World Tour, Data Platform Summit, INSIDESQL UK, Global AI Nights, SQLServerGeeks Summit, MCT Global Summits, Data Day Events and various user group events. Mani also believes in Empowering Every Person in the planet and spreads the awareness on Global challenges via www.EmpoweringEveryPerson.com. He is also a co-owner of 1 Global AI Meetup and 3 Power BI PUG PASS local / user groups.
Mihail Mateev
Twitter: - mihailmateev
LinkedIn: Mihail Mateev
Contact: https://mmateev.wordpress.com/
Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.
Neil Hambly
Twitter: - Neil_Hambly
LinkedIn: Neil Hambly
Contact: http://dataidol.com/NeilHambly
Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.
Niels Berglund
Twitter: - nielsberglund
LinkedIn: Niels Berglund
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.
Neil Hambly
Twitter: - Neil_Hambly
LinkedIn: Neil Hambly
Contact: http://dataidol.com/NeilHambly
Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.
Gary Hope
Twitter: - GaryHope
Cloud Data and AI Solution Architect at Microsoft South Africa
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
Sandesh Nagaraj
LinkedIn: Sandesh Nagaraj
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.
Dr. Subramani Paramasivam
Twitter: - https://twitter.com/dageop
LinkedIn: Dr. Subramani Paramasivam
Contact: http://www.yoursqlman.com/index.php/blogs
Dr.SubraMANI Paramasivam is a Microsoft MVP, PhD, Microsoft Certified Trainer and Head of Data AI at DAGEOP Ltd having 21 years of DB, BI, Analytics and AI experience. Mani has also spoken in various events like MS IGNITE, PASS Summit, MS Inspire, SQLBITS, Power Platform Summit, Global AI Bootcamp, Data BI Summit, SQLRelay, Power BI World Tour, Data Platform Summit, INSIDESQL UK, Global AI Nights, SQLServerGeeks Summit, MCT Global Summits, Data Day Events and various user group events. Mani also believes in Empowering Every Person in the planet and spreads the awareness on Global challenges via www.EmpoweringEveryPerson.com. He is also a co-owner of 1 Global AI Meetup and 3 Power BI PUG PASS local / user groups.
Neil Hambly
Twitter: - Neil_Hambly
LinkedIn: Neil Hambly
Contact: http://dataidol.com/NeilHambly
Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.
Sponsors
The following is a list of sponsors that helped fund the event: