Event Location:
Microsoft Office
3201 William Nicol Drive
Bryanston, Gauteng, South Africa
Abstract:
SharePoint has become the defacto EIM tool for many large organisations and this comes with a huge responsibility for SQL DBA’s and BI consultants alike. SQL is the heart and soul of any SharePoint Farm and in this session we will be focussing on: • What architectural considerations there are for SQL from SharePoint • Real-world SQL requirements for SharePoint • Simple tips and tricks for SQL before deploying SharePoint • Best practice scenario’s for SQL pertaining to SharePoint Invariably, SharePoint Architects have to co-exist with SQL DBA’s without having to argue and or debate what is required. DBA’s armed with the items listed above will have a better understanding of SharePoint and will also be able to optimize the performance of SharePoint DB’s so as to ensure better overall performance.
Speaker(s): Alistair Pugin,
Abstract:
How often have our SQL Servers been bogged down with a myriad of users issuing lengthy and poorly constructed or poorly performing queries against our tables and views.More often than not,nearly bringing our systems to their knees.Nowhere is this truer than within the financial world where heavy number crunching is par for the course.This beginners to intermediate level hands-on presentation is aimed at the SQL Server developer and business analyst alike and will show the attendee how we had managed to eliminate 90 % of our poorly performing queries by creating a data access layer which provides our end users with a suite of well developed and tuned SQL Server FUNCTIONS and UDT's with which to render their data.
Speaker(s): Steve Simon,
Abstract:
We discuss a list of costly mistakes, and their solutions, made during the design and building of the ETL process. Recommendations to avoid these mistakes are covered as well as a checklist to use to create reliable ETL solutions.
Speaker(s): Luis de Sousa,
Abstract:
This is not for those that are "Gettings Things Done" and already know the "End Game". It is also not for those that are not interested in Professional Development discussions and just want to listen to hard-core technical. It is for those that appreciate being challenged in where they are currently in their professional career and where they are going. It does try to address the decisions "ground rules" required to becoming a "Senior SQL Rockstar" without any regrets and blank spaces in your resume.
Speaker(s): Howard Diesel,
Abstract:
Are you a developer struggling to get maximum performance from your queries? Are you a DBA struggling to get maximum performance from your server? If so then join this session to see Sean Pearce tuning some real life queries and configuring the server accordingly. This session is full of great tips and handy techniques to apply to your code.
Speaker(s): Sean Pearce,
Abstract:
In this session we will cover • Internals of Tabular (and why you should care) • Good and Bad Data Modelling Patterns. • Identifying and fixing bad execution plans.
Speaker(s): Mark White,
Abstract:
In this session we will explore a number of basic data modelling and analytical problems and how to use DAX to solve them. While this session will not make you a DAX Jedi It should provide you with a good understanding of the fundamentals of the language.
Speaker(s): Matt Horn,
Abstract:
This session will explore several of the new SQL Server 2014 features and how they could benefit existing and new BI solutions. This includes features that are typically considered as OLTP feature such as In-memory tables (Hekaton). The session will include a demo that will consider features and the impact they will have on data warehouse load performance, query performance, storage and maintenance. I will be using Windows Azure VMs to do the demo.
Speaker(s): Marius Van Schalkwyk,
Abstract:
We dive into the common knowledge subjects and principles that we already know about but forget to use or just blatantly ignore, Delta management, Project recovery, Best and Worst practice and more. Session is recommended for the intermediate to advanced but the beginner will also gain from this.
Speaker(s): Andreas Bergstedt,
Abstract:
The new SQL 2014 In-Memory Optimized Tables for OLTP is an exiting technology, but with a very specific and focused set of use-cases. This demo will outline their high level functioning and some real word examples.
Speaker(s): Frikkie Venter,
Abstract:
In this session we will cover getting started with SQL Server extended event. Scripting out events.
Speaker(s): Jody Roberts,
Abstract:
TBC
Speaker(s): Gary Hope,
Abstract:
Keynote address
Speaker(s): Franco Rothner,
Abstract:
As a DBA do you control what is utilising the resources within Sql or do the the Applications? Learn how to setup and configure Sql Server Resource Governor, and how it can be used to determine what application or users are hogging the resources and how to limit those that are impacting on the overall system performance.
Speaker(s): Martin Phelps,
Abstract:
TBC
Speaker(s): Bhavesh Lala,
Abstract:
SQL Server 2014: With the vast amounts of data in today’s business warehouses, there has been increased demand on the Business Intelligence solution developer to produce more complex and all inclusive reporting facilities. More complexity, coupled with being all inclusive tends to yield more points of failure.In this hands on presentation we shall be examining new and innovative ways of rendering the required data in some unusual ways.
Speaker(s): Steve Simon,
Abstract:
Columnstore index is an enterprise feature that was introduced in SQL Server 2012 for the purposes of improving the query response on T-SQL queries against OLAP systems. In this session we will look at the initial (SQL Server 2012) implementation of columnstore indexing and how it has been improved in SQL Server 2014.
Speaker(s): Sifiso Ndlovu,
Abstract:
Learn about Microsoft Azure’s relational database service, SQL Database. I will demonstrate key architectural patterns to showcase how customers are achieving mission criticality in the cloud. The focus will be on how and when to apply the new capabilities across business continuity and performance into the design of modern mission-critical applications.
Speaker(s): Brent Samodien,
Abstract:
If there’s one thing that we, as SQL developers, don’t do, it’s use enough transactions. Transactions are critical when multiple changes need to be made entirely or not at all, but even given that it’s rare to see transactions used at all in most production code. In this session, we’ll look at what transactions are and why we should use them. We’ll explore the effects transactions have on locking and the transaction log. We’ll investigate methods of handling errors and undoing data modifications, and we’ll see why nested transactions are a lie.
Speaker(s): Gail Shaw,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
LinkedIn: https://za.linkedin.com/pub/sean-pearce/2/9b5/914
Contact: http://thesqlguy.blogspot.com/
Sean Pearce is a SQL Server consultant with a background in application development. Initially he was exposed to SQL Server 6.5 as a developer but by the time SQL Server 2000 had been released he had stepped into a SQL Server focused role. His understanding of the architecture of SQL Server allows him to excel at performance tuning and problem solving. Sean is actively involved in the SQL Server community, has spoken at PASS SQLSaturday and presents regularly to the Jhb SQL Server User Group.
Mark is a delivery-focused IT manager, with over 19 years multi-disciplined experience spanning banking, short-term insurance, taxation, healthcare, pharmaceutical, broadcast TV, streaming media, manufacturing and retail. Specialties:Leadership Management, Business Intelligence Solutions, Product Training, Programme Management, Enterprise systems architecture.
Information Technology and Services Consultant and Contractor, Sambe Consulting (Owner
none
Contact: http://www.karabina.co.za
I'm a Business Intelligence Solutions Architect specializing in the Microsoft technology stack. I have been in the Business intelligence space for over 9 years now, most of which I spent as a consultant. I specialize in solving business problems with clean and simple technology solutions. I enjoy mentoring and coaching colleagues and sharing knowledge on different platforms. I love spending time with my family, adventure racing, and studying. I just started with my P.hD in Data Warehousing.
LinkedIn: https://www.linkedin.com/in/alistairpugin/
Contact: http://2guysandsharepoint.co.za
Alistair has worked in various capacities in multiple verticals from retail – manufacturing to government, spanning 50 to 50000 users utilizing all aspects of pure Enterprise Information Management. His current position as an Office Servers and Services MVP in South Africa, provides him with a mechanism to assist companies with architecting their SharePoint environment using "best of breed", proven methodologies to foster innovation and growth through an ECM framework.
LinkedIn: https://www.linkedin.com/in/sifiso-w-ndlovu-89239a14
Contact: http://blogs.selectsifiso.com/
I am a certified Microsoft professional with a Master’s degree in IT Management from the University of Johannesburg. I specializes on a range of enterprise and consumer technologies using open source and proprietary software. I am a member of the Johannesburg SQL User Group wherein I have made several presentations on User Group Meetings and SQLSaturday sessions. I have written for a number of publications including SQLShack.com and SQLServerCentral.com.
LinkedIn: http://za.linkedin.com/pub/jody-roberts/7/b29/193/Edit
Contact: http://JodyWP.wordpress.com
Jody Roberts is a Microsoft Data Platform MVP based in Cape Town, South Africa. He specializes in SQL Server architecture, disaster recovery (DR), and server optimization. Jody serves as a PASS Regional Mentor responsible for the Middle East amp; Africa, Chapter Lead of the SQLCape user group, and Co-Lead of the PASS Cloud Virtual Chapter. Jody is a Principal Consultant at Northern Data.
Cloud Data and AI Solution Architect at Microsoft South Africa
LinkedIn: http://www.linkedin.com/in/stephenrsimon/
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
Contact: http://www.ensobyte.com
Passionate technologist who enjoys providing leading-edge Information Technology services to medium and enterprise clients in a wide variety of sectors including retail, public, financial, media and communications, energy and the professional services industry. I create value by bridging the gap between business and technology through a focus on strategy; people, processes, information and communication technology.
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://www.linkedin.com/in/stephenrsimon/
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
Contact: http://www.modelwaresystems.com
Love working with Data in all it different forms and shapes: from business applications to data warehousing and Data management services. Have spent the last 15 years focussing specifically on business data development. Really enjoy the high-end data analysis and reconciliation. Prior to focussing on data development , technical application development on all platforms from Mainframe to embedded systems.
Technical Manager: Business Intelligence at EOH Microsoft Services
LinkedIn: http://za.linkedin.com/in/luisdza
Contact: http://www.luisdesousa.co.za
Consult to large financial institutions in South Africa providing Business Intelligence and Analysis insight.
LinkedIn: http://za.linkedin.com/pub/andreas-bergstedt/10/119/274/
Contact: https://blog.bi360.ml
24+ Years in the IT Sector, Last 12 years in the BI Space, Passionate about knowing and understanding data and what business actually want from their information.
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.
The following is a list of sponsors that helped fund the event.