SQLSaturday #83 - Johannesburg 2011 5/7/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat83 Johannesburg , South Africa http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 4263 Jason Brimhall Track 3 Room 3 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. 5/7/2011 12:15:00 PM 5/7/2011 1:00:00 PM 4270 Stephan Lawson Track 1 Room 1 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. 5/7/2011 12:15:00 PM 5/7/2011 1:00:00 PM 4274 Steve Simon Track 3 Room 3 (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. 5/7/2011 11:15:00 AM 5/7/2011 12:00:00 PM 4276 Phlippie Smit Track 1 Room 1 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. 5/7/2011 10:15:00 AM 5/7/2011 11:00:00 AM 4293 Theo Potgieter Track 1 Room 1 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. 5/7/2011 11:15:00 AM 5/7/2011 12:00:00 PM 4309 Mark Stacey Track 2 Room 2 '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' 5/7/2011 11:15:00 AM 5/7/2011 12:00:00 PM 4325 Benjamin Nevarez Track 3 Room 3 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. 5/7/2011 10:15:00 AM 5/7/2011 11:00:00 AM 4329 Luis de Sousa Track 2 Room 2 '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. 5/7/2011 10:15:00 AM 5/7/2011 11:00:00 AM 4386 Gail Shaw Track 2 Room 2 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. 5/7/2011 12:15:00 PM 5/7/2011 1:00:00 PM