SQLSaturday #327 - Johannesburg 2014

Event Date: 08/30/2014 00:00:00

Event Location:

  • Microsoft Office
  • 3201 William Nicol Drive
  • Bryanston, Gauteng, South Africa

PDF of Schedule

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 Best Practices including tips and Tricks for optimizing your SharePoint Farm

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

Track and Room: Track 4 - N/A


Title: SQL Server 2014 Data Access Layers

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

Track and Room: Track 2 - N/A


Title: Common ETL development mistakes (and their solutions)

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

Track and Room: Track 4 - N/A


Title: SQL Skills: Senior In Age / Pay OR Skills

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

Track and Room: Track 1 - N/A


Title: Practical Query Tuning

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

Track and Room: Track 2 - N/A


Title: DAX Ninja in 60 minutes

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

Track and Room: Track 3 - N/A


Title: Introduction to Data Analysis Expressions (DAX)

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

Track and Room: Track 4 - N/A


Title: How New Feature in SQL Server 2014 Could Benefit Business Intelligence Solutions

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

Track and Room: Track 3 - N/A


Title: 10 Things that you already knew about SSIS

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

Track and Room: Track 4 - N/A


Title: In-Memory Optimized Tables - Hands-on demo and Real World applications

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

Track and Room: Track 2 - N/A


Title: Rocking with SQL 2012 Extended Events

Abstract: In this session we will cover getting started with SQL Server extended event. Scripting out events.

Speaker(s):

  • Jody Roberts

Track and Room: Track 2 - N/A


Title: Introduction to AzureML

Abstract: TBC

Speaker(s):

  • Gary Hope

Track and Room: Track 1 - N/A


Title: Keynote address with Franco Rothner

Abstract: Keynote address

Speaker(s):

  • Franco Rothner

Track and Room: Track 4 - N/A


Title: Who’s in Control? Use Sql Server Resource Governor

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

Track and Room: Track 1 - N/A


Title: Master data management - a simple approach to an improved data experience

Abstract: TBC

Speaker(s):

  • Bhavesh Lala

Track and Room: Track 4 - N/A


Title: Creating efficient and effective SSRS BI Solutions

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

Track and Room: Track 3 - N/A


Title: Columnstore Indexing: From SQL Server 2012 to SQL Server 2014

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

Track and Room: Track 3 - N/A


Title: Designing Modern Apps using New Capabilities in Microsoft Azure SQL Database

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

Track and Room: Track 2 - N/A


Title: On Transactions and Atomic Operations

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

Track and Room: Track 1 - N/A


Speakers

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

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.

Sean Pearce

Twitter: - @SeanPearceSQL

LinkedIn: Sean Pearce

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 White

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.

Bhavesh Lala

Information Technology and Services Consultant and Contractor, Sambe Consulting (Owner

Franco Rothner

none

Marius Van Schalkwyk

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.

Alistair Pugin

Twitter: - @alistairpugin

LinkedIn: Alistair Pugin

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.

Sifiso Ndlovu

Twitter: - https://twitter.com/mafiswana

LinkedIn: Sifiso Ndlovu

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.

Jody Roberts

Twitter: - Jody_Wp

LinkedIn: Jody Roberts

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.

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

Brent Samodien

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.

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.

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

Howard Diesel

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.

Frikkie Venter

Technical Manager: Business Intelligence at EOH Microsoft Services

Luis de Sousa

Twitter: - @luis_de_sousa

LinkedIn: Luis de Sousa

Contact: http://www.luisdesousa.co.za

Consult to large financial institutions in South Africa providing Business Intelligence and Analysis insight.

Andreas Bergstedt

Twitter: - @AndreasBergstedt

LinkedIn: Andreas Bergstedt

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.

Martin Phelps

Twitter: - https://twitter.com/mphelps1968

LinkedIn: Martin Phelps

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.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page