SQLSaturday #243 - Cape Town 2013
Event Date: 09/07/2013 00:00:00
Event Location:
- Sanlam Head Office
- 2 Strand Rd, Bellville
- Cape Town, 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: The Secret Life of APPLY: Helping Developers Work Smarter, Not Harder
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
Track and Room: SQL Dev - N/A
Title: Building Your T-SQL Tool Kit: Window Function Fundamentals
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
Track and Room: SQL Dev - N/A
Title: SQL Server Data platform upgrade Techniques, best practices notes from the field
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
Track and Room: DBA - N/A
Title: Dos and don’ts of database corruption
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
Track and Room: DBA - N/A
Title: Introduction to SQL Server 2012 PDW - The POC
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
Track and Room: BI - N/A
Title: Slowly changing dimensions- an integrated approach
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
Track and Room: BI - N/A
Title: Enhance SQL Performance by Messaging and Queuing Applications
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
Track and Room: SQL Dev - N/A
Title: Role based security from SharePoint through to the cube
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
Track and Room: BI - N/A
Title: Divide and Conquer - Scale out using Federated Database in Azure
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
Track and Room: DBA - N/A
Title: Deep Dive into Clustered Columnstore
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
Track and Room: DBA - N/A
Title: Closing the data loop with Master Data Services
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
Track and Room: BI - N/A
Title: How to Model for Power View
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
Track and Room: BI - N/A
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: SQL Dev - N/A
Title: Top 10 Performance Tips for SQL Server Developers
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
Track and Room: SQL Dev - N/A
Title: Clustered Columnstore - Introduction
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
Track and Room: DBA - 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.
Satya Jayanty
Twitter: - sqlmaster
LinkedIn: Satya Jayanty
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
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.
Christina Leo
Twitter: - christinaleo
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.
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.
Juan Thomas
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
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.
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.
Niko Neugebauer
Twitter: - NikoNeugebauer
LinkedIn: Niko Neugebauer
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.
Niko Neugebauer
Twitter: - NikoNeugebauer
LinkedIn: Niko Neugebauer
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 Drummond-Hay
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.
Mark Stacey
Twitter: - @MarkGStacey
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
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.
Christina Leo
Twitter: - christinaleo
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.
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.
Turgay Sahtiyan
Twitter: - https://twitter.com/turgaysahtiyan
LinkedIn: Turgay Sahtiyan
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)
Sponsors
The following is a list of sponsors that helped fund the event: