SQLSaturday #83 - Johannesburg 2011
Event Date: 05/07/2011 00:00:00
Event Location:
- Microsoft Office
- 3201 William Nicol Drive
- Bryanston, Gauteng, 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: Query Optimizer Topics for Better Performance
Abstract: This session will show you how a better understanding of how the Query Optimizer works can help you to improve the performance of your queries. I will show you some of the top Query Optimizer topics that can give you the most benefit by focusing both on concepts and practical solutions. Several areas of the query processor will be covered, everything from troubleshooting query performance problems and identifying what information the Query Optimizer needs to do a better job to the extreme cases where, because of the its limitations, the Query Optimizer may not give you a good plan and you may need to take a different approach.
Speaker(s):
- Benjamin Nevarez
Track and Room: Track 3 - N/A
Title: Database Design Methodologies
Abstract: “Data lasts longer than code, treat it right” - In this session we take a look at database design phases, data modelling and some tools to help you along the way.
Speaker(s):
- Luis de Sousa
Track and Room: Track 2 - N/A
Title: Get your Oracle data into SQL Server faster!
Abstract: In this session, we will explore the usage and performance of the Microsoft Connector Version 1.1 for Oracle by Attunity. Delegates will leave the session empowered to replace their current SQL Server Integration Packages to use the new connector to dramatically increase data transfer speed between SQL Server and Oracle. The session is a must for BI developers working in heterogeneous environments where Oracle source systems or Data Warehouses and Microsoft BI tools co-exist.
Speaker(s):
- Phlippie Smit
Track and Room: Track 1 - N/A
Title: Recursive Queries: Beautiful Events Always Recur
Abstract: (Eng Afrikaans) Within the realm of financial instruments, business structure and rules are highly hierarchical in nature. Investor funds consist of one or many levels of asset ID’s which in turn are comprised of one or more lots. This certainly poses interesting challenges when it comes to creating efficient and effective detailed and summary level queries and reports. This beginners’ to intermediate level hands-on presentations is aimed at showing the attendee how we handle recursive scenarios,utilizing several techniques including, recursive T-SQL, code using memory TABLEs (as custom stacks) and CTE’s.
Speaker(s):
- Steve Simon
Track and Room: Track 3 - N/A
Title: Baseline my Database
Abstract: As a DBA I always get asked by my DBA peers “How many I/Os, Deadlocks, Scans etc. does your database perform?”. Very valid question but in what context? The starting point of answering the context questions starts with implementing a baseline for your database. In this session I will propose concepts and raise important things to consider when implementing a baseline on a production database.
Speaker(s):
- Theo Potgieter
Track and Room: Track 1 - N/A
Title: 12 ways to write badly performing T-SQL
Abstract: Database performance is a hot topic and there are often questions asked pertaining to the best way to write T-SQL queries.
In this presentation, the attendee will NOT be shown the best manner in which to write queries but rather numerous ways of how to write poorly performing queries, with the hope that the attendee will obtain an understanding of what NOT to do.
The user will be guided through each query, be shown why it’s not the optimal way of doing things and then shown a well-written query that achieves the same results.
Speaker(s):
- Gail Shaw
Track and Room: Track 2 - N/A
Title: “GIS in SQL and SSRS using Statistics SA data”
Abstract: “Many data are publicly available , including Geographic Information Systems points, and economic metrics. In this session, Mark will show a couple of these sources, and show how to import this geographic and economic information into a SQL database, and display it as a map in SSRS”
Speaker(s):
- Mark Stacey
Track and Room: Track 2 - N/A
Title: The Transaction Log and VLF performance.
Abstract: Look at what happens to a transaction in the log file, and take a deep dive into VLF’s with a live demo to see how they can affect performance if managed badly.
Speaker(s):
- Stephan Lawson
Track and Room: Track 1 - N/A
Title: Tools for a DB TakeOver
Abstract: In this session we will explore some practical scripts to help create database documentation. We will be looking at how to make some of those documentation tasks easier, while giving you greater insight into your database(s). Attendees will be able to leave with some additional tools for their toolbox and through the use of these scripts the attendee will be able to perform these tasks faster.
Speaker(s):
- Jason Brimhall
Track and Room: Track 3 - 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.
Mark Stacey
Mark is the principal architect at PragmaticWorks SA
Benjamin Nevarez
Twitter: - @BenjaminNevarez
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server independent consultant based in Los Angeles, California, who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning amp; Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals.quot; Benjamin has also been a speaker at many SQL Server conferences, including PASS Summit, SQL Server Connections, and SQLBits. His blog can be found at http://www.benjaminnevarez.com.
Theo Potgieter
Contact: http://www.businessgenetics.co.za/
15 years in IT. What a ride we are on! I am a technical resource that has fell in love with SQL and what it can do. The projects that I work on range from big (50GB) to huge (3 Tb) to massive (30TB) databases and all that that entails. PM, Architect, Lead, Mentor, BA, Developer, DBA, Tester and yes call centre operator.
Massive for me anyway. :-)
Steve Simon
Contact: http://www.infogoldusa.com
Steve Simon is an AVP with State Street Corporation Boston. He has been involved with database design and analysis for over 23 years. He has presented papers at eight PASS Summits and PASS Europe 2009 2010. He is the chairman of the PASS SQL Server / Oracle Virtual Chapter in addition to being a PASS Regional Mentor. He is also a regular presenter at SQLSaturdays and regional Code Camps.
Phlippie Smit
Contact: http://za.linkedin.com/in/pfsmit
Phlippie Smit has over 15 years’ experience with SQL Server. He spent most of his career in a MIS/BI environment and has used SQL Server 6.5 – 2008 in his endeavours. He is passionate about performance and optimisation, and improving out-dated processes and thinking.
Jason Brimhall
Twitter: - sqlrnnr
LinkedIn: Jason Brimhall
Contact: http://jasonbrimhall.info
Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.
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.
Stephan Lawson
Twitter: - sqlarcher
LinkedIn: Stephan Lawson
Contact: https://sqlarcher.com
I am a seasoned data platform professional, with over 10 years experience in the field, with an interest in data platform technologies, as well as the systems they are built on.
I worked for one of the largest banks in South Africa, and was then recruited into the Premier Field Engineering (PFE) division within Microsoft CSS. I spent over 3 years working in PFE for SQL Server and Analytics Platform System (APS).
Currently I am an Data Architect for a South African startup using Azure, the Microsoft Data Platform, and analytics.
I enjoy spending time with my family, listening to podcasts, and learning about new technologies.
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.
Sponsors
The following is a list of sponsors that helped fund the event: