SQLSaturday #93 - Toronto 2011
Event Date: 09/17/2011 00:00:00
Event Location:
- Guelph-Humber Building, Humber College
- 205 Humber College Boulevard
- Toronto, Ontario, Canada
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: Architecting Microsoft SQL Server Availability in
Abstract: The addition of virtualization support has changed the way architects and DBAs need to look at availability in the SQL Server world. How does Hyper-V Live Migration or vMWare’s vMotion work in conjunction with existing SQL Server availability technologies like log shipping, database mirroring, or replication? As you architect your SQL Server infrastructure virtually, what do you need to know to ensure that you help provide the best solution using available technologies? Through demonstration using a scenario-based approach, learn when and how to use virtualization availability features and Windows Failover Clustering in combination with SQL Server technologies and the impact of combining them. See how Live Migration does not cover you in al
Speaker(s):
- Michael Lato
Track and Room: Database Administration - N/A
Title: Indexes and Data Access
Abstract: Are you interested to know how SQL Server utilize indexes for data accessing, modification, joins and aggregates, and why an index cannot be utilized? This is what we are going to talk about – from index internal to stragegies.
Speaker(s):
- John Huang
Track and Room: Database Development - N/A
Title: Manage your database with VS2010 Db Dev tools
Abstract: Too many times, database maintenance and deployment represent a challenge during application development. And now with Visual Studio 2010, Oracle databases are first class citizens of development solutions. This session will demonstrate how Visual Studio Database Development Tools can ease database managements, deployment and version control integration. New features of 2010 will be covered as well as database unit testing and data generation. Developers will learn how database can be part of their Visual Studio solutions and how easy it is to deploy database objects with other projects.
Speaker(s):
- Christian Cote
Track and Room: Business Intelligence - N/A
Title: Transactional Replication – Follow the Data
Abstract: Okay, you’ve run the Wizard and have Replication up and running; but how does it really work? Learn the behind the scenes for Transactional Replication as we follow the data from Publisher to Subscriber. We’ll look at both design and troubleshooting techniques to ensure your data is moving at near-real-time through your topology.
Speaker(s):
- Chris Skorlinski
Track and Room: Business Intelligence - N/A
Title: Gone Clustering in 60 Minutes
Abstract: Creating a SQL Server 2008 Failover Cluster on Windows Server 2008 has become a lot easier with the availability of online resources such as blog posts and articles. However, making it easy does not mean ignoring the basic principles of the underlying technology. In this session, learn the fundamentals and principles behind how Windows Failover Clustering works and how SQL Server leverages on the technology, allowing you to build highly available database infrastructures.
Speaker(s):
- Edwin Sarmiento
Track and Room: Database Administration - N/A
Title: Streamline development with VS build contributors
Abstract: While many teams are now using Visual Studio for database project development, few have begun to take advantage of build contributors. Build contributors represent a powerful technology that is particularly adept at responding to changes in the database project. This technology can enable integration scenarios which might otherwise be difficult or time-consuming, such as automatically updating documentation or installation scripts. In this session, you will understand how build contributors are enabled, and see this technology in action.
Speaker(s):
- Robert Schoedel
Track and Room: Database Development - N/A
Title: Manage Your Legacy Applications with Windows Power
Abstract: Using Windows Powershell presents us with many of options never seen before. You can easily execute SQL Queries to manage legacy systems, Manipulate console and Vbscript applications, and extend Applications run via webproxy as well as built in Regex. This session is intended shatter the myth that using Poweshell means trashing the legacy.
Speaker(s):
- Sean Kearney
Track and Room: Expanded Horizons - N/A
Title: SSIS for the faint of heart
Abstract: Scott’s gentle introduction to SQL Server Integration Services (or SSSIS) will primarily be demonstrating how to you can use this tool in the real world to get work done. READ: very little PowerPoint time. SSIS is a high performance ETL solutions introduced in SQL Server 2005 to replace SQL Server’s DTS functionality. ETL? It’s okay, Scott will briefly cover some of these concepts too. Relax, sit back and learn how to simplify your “Extract, Transform, and Load” processes.
Speaker(s):
- Scott Stauffer
Track and Room: Business Intelligence - N/A
Title: Don’t Panic, DBAs! Databases on VMware made easy.
Abstract: More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment.
Speaker(s):
- Janis Griffin
Track and Room: Expanded Horizons - N/A
Title: CAMP Geekalot for DBAs
Abstract: This instructor lead workshop encourages open dialog by all attendees as they share experience and best practices around key SQL Server DBA topics like 1) how big is your database? 2) Disaster planning, 3) security, security, security, 4) common server best practices, 4) common SQL best practices
Speaker(s):
- Chris Skorlinski
Track and Room: Expanded Horizons - N/A
Title: Database Recovery Techniques To Keep Handy
Abstract: Nothing is more frightening to a DBA as getting that wake-up phone call that the system is down, especially when it’s a mission critical one.This session will focus on being prepared for and dealing with a recovery situation for a SQL Server 2005/2008 database, an instance or an entire server. Topics covered will be backup schemes, partial backups and piecemeal restores, and page-level recovery
Speaker(s):
- Edwin Sarmiento
Track and Room: Database Administration - N/A
Title: Query Plans
Abstract: This is the session help developers to interpret the query plans, understand frequently seen operators and properties in the plan. At the end, it will show how SQL Server estimates the cost of operators and how SQL Server make decisions to choose a plan out of numerous alternatives.
Speaker(s):
- John Huang
Track and Room: Database Development - N/A
Title: How to get Hired in the first 10 minutes
Abstract: Are you looking for a career change? Good News! Technology is back on the move and companies are again hiring. We’ll cover key strategies you can use during the interviews first 10 minutes to increase chances for a new job and new adventure.
Speaker(s):
- Chris Skorlinski
Track and Room: Expanded Horizons - N/A
Title: Obliterate Excessive Blocking and Deadlocking
Abstract: Your databases are getting bigger and busier and you need to make the most out of the hardware you have. On your servers, excessive locking can often cause timeouts and database traffic jams! In this session I explore steps you can take to address unexpected locking issues. I also explain what steps to take to avoid contention in the future. Lots of examples taken from experience.
Speaker(s):
- Michael Swart
Track and Room: Database Administration - N/A
Title: There Is a Better Way to Back Up Your SQL Servers
Abstract: SQL Server administrators are looking for a better way to protect and recover SQL Server databases. In this session Islam is going to present how to back up your SQL Server efficiently using System Center Data Protection Manager 2010, he will show cases on how to backup advanced SQL Server configuration such as SQL Server clustering, SQL Server mirrored databases, log shipping or Simple recovery model” configurations.
Speaker(s):
- Islam Gomaa
Track and Room: Database Administration - N/A
Title: What is MS Sync. Framework
Abstract: Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline access for applications, services and devices. It features technologies and tools that enable roaming, sharing, and taking data offline. Using Microsoft Sync Framework, developers can build sync ecosystems that integrate any application, with any data from any store using any protocol over any network.
Speaker(s):
- Jean Rene Roy
Track and Room: Expanded Horizons - N/A
Title: Looney Tuner? No, there IS a method to my madness!
Abstract: SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL Diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
Speaker(s):
- Janis Griffin
Track and Room: Database Administration - N/A
Title: Discovering the Delta: SQL Server to SQL Azure
Abstract: Brain hurting from technology overload? The endless talk about cloud? Private cloud, public cloud, Windows Azure, SQL Azure, Office 365, Cloud is everywhere! When it comes to SQL though, there’s good news - if you know SQL Server, you already know 90% of SQL Azure. In this session, you’ll learn the differences between SQL Server and SQL Azure and how you can use your existing SQL knowledge to start creating solutions in the Cloud.
Speaker(s):
- Michael Lato
Track and Room: Database Development - N/A
Title: Multi-threading TSQL
Abstract: Can T-SQL be run in multi-threaded manner? Yes, this session will explain how to use TSQL to implement multi-threading application, including process control, resource access, execution ordering, synchronization, semaphore, etc. If you are looking for a solution to turn your processes to run in parallel, you should not miss it.
Speaker(s):
- John Huang
Track and Room: Database Development - N/A
Title: Implement data validation strategies with SSIS
Abstract: While SSIS is a great tool to extract and load data, how can we validate the data while loading it? In this session I will talk about different validations strategies that I have been using over the years to ensure that the old adage “Garbage in, garbage out” is not necessarily true.
Speaker(s):
- Christian Cote
Track and Room: Business Intelligence - N/A
Title: XML in SQL Server. Why bother?
Abstract: Many of the Developers and DBAs have the XML syndrome. We can’t blame them because XML document are not simple. But what most Developers and DBA don’t know is how SQL Server can help you overcome the XML syndrome. XML is here to say, we will need to save some XML in the database more often than ever. This session will cover usable scenarios when using Xpath, Xquery the XML type in SQL server and the XSD. We will look at the different tools available in SQL Server Management Studio (SSMS) and Visual Studio (VS). This is the chance to bring the DBA and Developer to the same level in using XML in SQL Server.
Speaker(s):
- Jean Rene Roy
Track and Room: Expanded Horizons - N/A
Title: Seven solutions for highly expensive queries
Abstract: Many query performance problems follow similar patterns. Thankfully, the solutions are also similar. In this session, you’ll learn how to identify and correct seven common causes of slow performance.
Speaker(s):
- Robert Schoedel
Track and Room: Database Development - N/A
Title: Build a Scale-Out Reporting Services 2008 R2 Farm
Abstract: Delivering reports is becoming more critical due to the increasing demand for business intelligence solutions. And while there are a lot of guides that walk us through building a highly available database engine, you’ll rarely see one for SQL Server Reporting Services. This session will walk you through building a scale-out SQL Server 2008 R2 Reporting Services farm from the ground up. You’ll be surprised how easy it is to do so that you can start building your own test environment.
Speaker(s):
- Edwin Sarmiento
Track and Room: Business Intelligence - N/A
Title: Exploring SSAS data folder
Abstract: In this presentation you will learn (high level) how Microsoft SQL Server Analysis Services (SSAS) stores MOLAP data in database folder. Then you will see how using this information you can quickly calculate size of the cube, measure group, partition, dimension, attributes and aggregations. You will also learn how some dimension attribute changes affects your fact data size.
Speaker(s):
- Vidas Matelis
Track and Room: Business Intelligence - 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.
John Huang
Twitter: - @sqlnotes
LinkedIn: John Huang
Contact: http://www.sqlnotes.info
John Huang, SQL MCM and MVP, has been working with SQL Server since 1994. He is an independent SQL Server consultant in Vancouver specialized in complex data processing, data warehouse, and performance tuning.
Islam Gomaa
Contact: http://owsug.ca/blogs/islamgomaa/
Islam Gomaa is a Data Protection Manager MVP from Ottawa, Canada, specialised in System Center Products, disaster recovery and system infrastructures running on the Microsoft server technology stack. Islam brings over 12 years of expertise in helping organizations align their business goals using Microsoft technology and deploying Microsoft-based solutions for the private and public sector He is also a member of the Windows Springboard Technical Expert Panel [STEP] for Windows 7 and Server 2008.
Edwin Sarmiento
Contact: http://bassplayerdoc.wordpress.com
Edwin Sarmiento is a SQL Server MVP from Ottawa,Canada specializing in high availability,disaster recovery system infrastructures running on the Microsoft server technology stack.He is very passionate about technology but has interests in music,professional organizational development,leadership management matters when not working with databases.He lives up to his primary mission statement -“To help people and organizations grow and develop their full potential as God has planned for them.”
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Chris Skorlinski
Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;
Sean Kearney
Contact: http://www.powershell.ca
Sean Kearney is an infrastructure support analyst and Microsoft MVP in Window PowerShell. He is absolutely passionate about automation technologies—especially Windows PowerShell. If you say, “Powershell,” he may just break into song. Sean considers himself “just a tech at heart,” but he can often be found dabbling with most Microsoft technologies at a moment’s notice. He is also the voice and words behind “A Powershell Carol” on “Hey Scripting Guy” from our recent Holiday Season
John Huang
Twitter: - @sqlnotes
LinkedIn: John Huang
Contact: http://www.sqlnotes.info
John Huang, SQL MCM and MVP, has been working with SQL Server since 1994. He is an independent SQL Server consultant in Vancouver specialized in complex data processing, data warehouse, and performance tuning.
Edwin Sarmiento
Contact: http://bassplayerdoc.wordpress.com
Edwin Sarmiento is a SQL Server MVP from Ottawa,Canada specializing in high availability,disaster recovery system infrastructures running on the Microsoft server technology stack.He is very passionate about technology but has interests in music,professional organizational development,leadership management matters when not working with databases.He lives up to his primary mission statement -“To help people and organizations grow and develop their full potential as God has planned for them.”
John Huang
Twitter: - @sqlnotes
LinkedIn: John Huang
Contact: http://www.sqlnotes.info
John Huang, SQL MCM and MVP, has been working with SQL Server since 1994. He is an independent SQL Server consultant in Vancouver specialized in complex data processing, data warehouse, and performance tuning.
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Michael Swart
Contact: http://michaeljswart.com
Michael J Swart is an active blogger and SQL Server MVP since 2012. He works as a database developer in Kitchener, Ontario, Canada.
Scott Stauffer
Twitter: - @SQLSocialite
LinkedIn: Scott Stauffer
Contact: http://scottstauffer.ca
Scott Stauffer (@SQLSocialite) is very PASSionate about data and enjoys meeting with like-minded data geeks. He started the Vancouver PASS Chapter in 2004. In 2008, Scott was recognized by Microsoft with a SQL Server MVP award. In 2009, Scott started a PASS BI Chapter in Vancouver, and was also at one time the PASS Regional Chapter Mentor for Canada. For over 10 years he has been an independent consultant working with clients to solve their data woes and extract insight from their business data.
Christian Cote
Twitter: - Christian_SQL
LinkedIn: Christian Cote
Contact: http://bi-blogger.typepad.com/
Christian Coté is an IT professional with more than 15 years of experience working in data warehouse and business intelligence projects. Christian developed an expertise in data warehousing over the years and designed many ETL/BI processes using a range of tools on multiple platforms. He’s been presenting at several conferences and code camps. He currently co-leads the SQL Server PASS chapter in Montreal as well as Global French SQL PASS Chapter. He is also a Microsoft Data Platform Most Valuable Professional (MVP).
Robert Schoedel
Rob Schoedel is a database architect at IDI Billing Solutions, a Microsoft Gold Certified Partner in Victor, NY. Prior to IDI, Rob spent 15 years leading internal database development projects at Microsoft. A veteran of SQL Server, Rob first trained on SQL 1.1 in 1992.
Michael Lato
Twitter: - @polymathAtHeart
Michael Lato has more than 10 years of experience consulting on various database systems with a special focus in the CRM (Customer Relationship Management) field. Michael’s roles have included project manager, system designer and trainer. He is currently the senior SQL Server developer and database administrator for an international in-building wireless company.
Christian Cote
Twitter: - Christian_SQL
LinkedIn: Christian Cote
Contact: http://bi-blogger.typepad.com/
Christian Coté is an IT professional with more than 15 years of experience working in data warehouse and business intelligence projects. Christian developed an expertise in data warehousing over the years and designed many ETL/BI processes using a range of tools on multiple platforms. He’s been presenting at several conferences and code camps. He currently co-leads the SQL Server PASS chapter in Montreal as well as Global French SQL PASS Chapter. He is also a Microsoft Data Platform Most Valuable Professional (MVP).
Edwin Sarmiento
Contact: http://bassplayerdoc.wordpress.com
Edwin Sarmiento is a SQL Server MVP from Ottawa,Canada specializing in high availability,disaster recovery system infrastructures running on the Microsoft server technology stack.He is very passionate about technology but has interests in music,professional organizational development,leadership management matters when not working with databases.He lives up to his primary mission statement -“To help people and organizations grow and develop their full potential as God has planned for them.”
Michael Lato
Twitter: - @polymathAtHeart
Michael Lato has more than 10 years of experience consulting on various database systems with a special focus in the CRM (Customer Relationship Management) field. Michael’s roles have included project manager, system designer and trainer. He is currently the senior SQL Server developer and database administrator for an international in-building wireless company.
Vidas Matelis
Contact: http://www.ssas-info.com/VidasMatelisBlog/
Vidas Matelis is Business Intelligence Consultant who specializes in building data warehouse solutions using Microsoft technologies (SQL Server, SSAS, SSIS and PowerPivot). He has more than 12 years of experience in this area. He maintains popular websites http://ssas-info.com and http://powerpivot-info.com. His blog can be found here: http://www.ssas-info.com/VidasMatelisBlog/. He is Microsoft SQL Server MVP.
Chris Skorlinski
Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;
Jean Rene Roy
Twitter: - https://twitter.com/#!/DevTeachConfere
LinkedIn: Jean Rene Roy
Contact: http://www.softdesign.ca/blog
Jean-Ren#233; Roy has been developing IT solution for large and small enterprises since 1987. In 1991 he founded the consulting firm Technologies SoftDesign Inc.
Since that time he has worked on projects for House of Commons, Innovapost, Bell Canada, CGI, CNSC, Kraft, and many other clients assuming the responsibility of Business Analyst, Software Architect,ETL and BI Architect, Software Developers, Analyst, Team leader and mentor. Jean-Ren#233; Roy is a SQL Server Microsoft MVP.
Chris Skorlinski
Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;
Robert Schoedel
Rob Schoedel is a database architect at IDI Billing Solutions, a Microsoft Gold Certified Partner in Victor, NY. Prior to IDI, Rob spent 15 years leading internal database development projects at Microsoft. A veteran of SQL Server, Rob first trained on SQL 1.1 in 1992.
Jean Rene Roy
Twitter: - https://twitter.com/#!/DevTeachConfere
LinkedIn: Jean Rene Roy
Contact: http://www.softdesign.ca/blog
Jean-Ren#233; Roy has been developing IT solution for large and small enterprises since 1987. In 1991 he founded the consulting firm Technologies SoftDesign Inc.
Since that time he has worked on projects for House of Commons, Innovapost, Bell Canada, CGI, CNSC, Kraft, and many other clients assuming the responsibility of Business Analyst, Software Architect,ETL and BI Architect, Software Developers, Analyst, Team leader and mentor. Jean-Ren#233; Roy is a SQL Server Microsoft MVP.
Sponsors
The following is a list of sponsors that helped fund the event: