SQLSaturday #117 - Columbus 2012
Event Date: 06/02/2012 00:00:00
Event Location:
- Ohio Dominican University
- 1216 Sunbury Road
- Columbus, Ohio
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: Creating a Metadata Mart w/ SSIS - Data Governance
Abstract: This is an expanded and updated version of the session I presented at the SQL Rally in Orlando. We will cover Tactical Data Governance and in detail specific code examples, using Stock and Custom SSIS Transforms ,Data Models, SSAS Cubes used to create and populate a Metadata Mart as defined by Michael Belcher(Gartner). We will demonstrate incorporating complete custom Data Profiling capabilities (SSIS Transform Scripting, TSQL) capable of Profiling any Source and Targeting any destination. In addition we will implement Data Quality(Address Correction, Fuzzy Matching) and Visualization via PowerPivot , Excel and QlikView. Last will will demonstrate code generation.
Speaker(s):
- Ira Warren
Track and Room: Track 3 - N/A
Title: Change Data Capture a tool for BI,DR,Audit more
Abstract: Change Data Capture (CDC) is one of the newest features available for SQL Server 2008 which allows you to easily track and keep history of all DML (Data Manipulation Language) changes on user tables such as INSERT, DELETE, and UPDATE without additional overhead. One of the most important benefits of this feature is that it allows you to see the data before after an UPDATE statement which allows you to recover data overwritten or deleted quickly without the need of a database restore. On this presentation we will go over the steps necessary to configure CDC and do an overview of some real world scenarios where this feature can be applied such as Business Intelligence, Disaster Recovery, Auditing, Debugging, Documentation and more.
Speaker(s):
- Jose Chinchilla
Track and Room: Track 1 - N/A
Title: Performance Tuning for Pirates
Abstract: If you follow baseball you will notice that the Pittsburgh Pirates (this speaker’s favorite team) has to do more with less to be successful. This trend can also exist within IT shops. If you need to improve the performance of your SQL Server instances and cannot purchase 3rd party tools this session is for you. Learn to improve your performance tuning process by using several free tools. This session will cover wait stats, dynamic management objects, perfmon, PAL, SQL Trace, ClearTrace, SQL Nexus and SQLDiag.
This session assumes some knowledge of code tuning and performance tuning and general knowledge about performance counters and SQL Server traces.
Speaker(s):
- John Sterrett
Track and Room: Track 3 - N/A
Title: Design and Implement BI Like Edison!
Abstract: As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.
Speaker(s):
- William E Pearson III
Track and Room: Track 3 - N/A
Title: Choose Your Own Adventure: Performance Tuning
Abstract: Life is all about choices, and when it comes to SQL Server it is no different. If you don’t have a methodology for researching questions and resolving issues then you need to get one, and soon.
Speaker(s):
- Thomas LaRock
Track and Room: Track 1 - N/A
Title: Understanding SQL Server XML Features
Abstract: The XML Functionality embedded into SQL Server 2005 and 2008 is one of its most powerful yet least understood features. This seems to be primarily because DBA’s shy away from it and developers prefer to work with XML in their code. In this session we will explore the XML features of SQL Server and how we can bridge these two worlds. Topics covered will include retrieving relational data as XML, storing XML in the database using the XML Datatype, XML indexes, and the XQuery functions included in SQL Server. We will also look at using XML as stored procedure parameters as a way to pass large amounts of complex data between client and server.
Speaker(s):
- Randy Knight
Track and Room: Track 4 - N/A
Title: SQL Server 101 for IT Pros
Abstract: A high level overview of the SQL Server stack for non-database professionals. We will review some of the most critical things that IT Pros will need to know when managing a SQL Server when there is no professional DBA to be found. Some tips on How and Where to reach out for help with problems and questions, and common gotchas and problems you may see in the field.
Speaker(s):
- Craig Purnell
Track and Room: Track 2 - N/A
Title: 5+ Database Design Blunders and How To Avoid Them
Abstract: What’s going on in your physical data model? How many people can or will update it to match the reality of what’s going on in your databases? Who actually decides what goes into the database design? How do you choose your primary keys? How do you implement them? Are your datatypes the right ones for the data?
In this presentation we discuss five physical data modeling mistakes that cost you dearly: performance snags, development delays, bugs, and professional respect.
Speaker(s):
- Karen Lopez
Track and Room: Track 1 - N/A
Title: Introduction to SQL Server Service Broker
Abstract: In this session, we’ll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos. We’ll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases. If you’ve ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won’t want to miss this session.
Speaker(s):
- Adam Belebczuk
Track and Room: Track 4 - N/A
Title: Visualizing Your Indexes - Science vs Art
Abstract: Indexes make queries run faster, right? Not always, no. And finding the right indexes for your needs is often more of an Art than a Science. Attend this session as we take a visual tour of how indexes are laid out and the way data is accessed when indexes are utilized. We will discuss clustered indexes as well as non-clustered indexes and also when to use indexed views along with some other variations.
Speaker(s):
- Wendy Pastrick
Track and Room: Track 2 - N/A
Title: Profiler? What is this tool you speak of?
Abstract: Many new DBA’s are unaware of the power of SQL Profiler. Many don’t know it exists. And better yet, it’s FREE. This session will generalize the importance of using Profiler to troubleshoot and tune your SQL queries. By demonstrating Profiler on a running server, attendees will get a look at what SQL is currently executing. This session will show how to discover query duration, reads, writes, locks, deadlocks, stored procedure executions and more.
Speaker(s):
- Jason Spangler
Track and Room: Track 4 - N/A
Title: A Complete BI Solution in About an Hour!
Abstract: In this presentation Aaron will cover how to collect data from multiple SQL Servers using SQL Server 2008 Integration Services (SSIS). Then he will use SQL Server Reporting Services (SSRS) to report detail on that data. After that he will use SQL Server Analysis Services (SSAS) to create a KPI. Finally he’ll present that KPI on a dashboard via a web page. The goal of this presentation is to show how seamless the Microsoft Business Intelligence products are. If you’ve only used a few of these products, you’ll appreciate seeing them together all at once. Code will be provided.
Speaker(s):
- Aaron King
Track and Room: Track 3 - N/A
Title: TempDB Performance Troubleshooting and Optimizing
Abstract: Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. After this session, you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.
Speaker(s):
- Eddie Wuerch
Track and Room: Track 1 - N/A
Title: What Sequence objects are (and are not)
Abstract: SQL Server 2012 adds a new object to our arsenal called a sequence that can will give us the capability to implement automatically incrementing values. However, it cannot replace a lot of functionality that we have used a numbers table and windowing functions for (though they can be complimentary to one another). In this session I will demonstrate the uses and performance characteristics of sequences, including how they compliment the use of number tables and windowing functions to create surrogate key and sorting values, and more.
Speaker(s):
- Louis Davidson
Track and Room: Track 2 - N/A
Title: Transaction and Balance Facts: Identical Cousins
Abstract: Ralph Kimball wrote extensively about the difference between transaction facts and balance facts, and rightly so, because transactional facts are additive in time and balance facts are not. But experience with these two seemingly disparate fact types reveals that they are actually identical cousins! This presentation will use a common personal concept – the checking account – to show that these facts are closely related and how to think appropriately about their relationship conceptually and with examples using SQL Server.
Speaker(s):
- Dave Rodabaugh
Track and Room: Track 1 - N/A
Title: Execution Plans a Deep Dive
Abstract: It’s one thing to know to look for scans instead of seeks, but if you really want to know what’s going on in an execution plan, you need to dive deep. This session will cover reading execution plans from the basics, but goes way beyond the basics to cover as much of the information available within an execution plan as you might possibly ever need. We’ll go into how to understand how to interpret parameter sniffing and spot when a join operation is not performing the way you would want. We’ll use the graphical plan and the XML behind to thoroughly explore execution plans.
Speaker(s):
- Grant Fritchey
Track and Room: Track 4 - N/A
Title: Getting Started With PowerShell and SQL Server
Abstract: PowerShell has been emerging on the scene as Microsoft’s command-line shell and scripting language for server administration. The System Admins can tell you how they can automate routine admin tasks for a multitude of servers with a PowerShell script and the click of button. Microsoft also threw us DBAs a bone for our admin tasks as well as development within SQL Server. In this session we will look at what it takes to get started with PowerShell from the perspective of a DBA or SQL developer.
Speaker(s):
- Kevin Bullen
Track and Room: Track 3 - N/A
Title: Parallel Query Execution Deep Dive
Abstract: What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? What can prevent it’s use by the engine? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine.
Speaker(s):
- Kevin Boles
Track and Room: Track 2 - N/A
Title: SQL Server and Sharepoint: Best Frienemies
Abstract: SharePoint is a rapidly growing application that relies heavily on SQL Server. In this session, we will discuss what a DBA needs to know to successfully manage instances hosting SharePoint databases. What configurations options are best for a SharePoint workload? What kind of maintenance shoule be performed? How should databases be provisioned? What the heck are all these databases for anyway? We will also discuss some nomenclature and key components of SharePoint to help better communicate with SharePoint application teams.
Speaker(s):
- Lisa Gardner
Track and Room: Track 2 - N/A
Title: SSIS: Figuring Out Configuring
Abstract: As with most things in the IT world there is more than one way to skin the SSIS configuration cat.* I’ll focus on SQL Server 2008 methods (being called Package Deployment method in SQL 2012) and show how to use 1)XML config files or 2)an environment variable or registry entry that points to a config database. I’ll also give a brief overview of the new project deployment method in SQL 2012.
*[No cats were skinned in the making of this presentation.]
Speaker(s):
- MIKE DONNELLY
Track and Room: Track 4 - 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.
Eddie Wuerch
Twitter: - @EddieW
LinkedIn: Eddie Wuerch
Contact: http://www.indydba.com
Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.
John Sterrett
Twitter: - JohnSterrett
LinkedIn: John Sterrett
Contact: https://johnsterrett.com/community/
John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John’s community activities can be found at https://johnsterrett.com/community/
Karen Lopez
Twitter: - @datachick
LinkedIn: Karen Lopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.
Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
Wendy Pastrick
Twitter: - @wendy_dance
Contact: http://wendyverse.blogspot.com
Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Jason Spangler
Jason is a SQL Server DBA by day, and a Firefighter/EMT by night. Since 2001, he has been a full time DBA with additional duties in Altiris, Sharepoint, and software development. For 12 years, he has also been a volunteer Firefighter and EMT helping his community through fire prevention and teaching firefighting and vehicle extrication techniques to new firefighters.
Craig Purnell
Twitter: - @CraigPurnell
LinkedIn: Craig Purnell
Contact: http://www.craigpurnell.com/
Craig Purnell is a career database professional, trainer, and community activist. He has spent over 10 years as the Database Administrator at a large Midwestern law firm. He has been in IT for 15 years and has spent his entire career working with enterprise databases and ERP systems. Craig is an active member of the Ohio North SQL Server User Group and has presented at many user groups, SQLSaturdays, and the PASS Summit in 2012 and 2013
Kevin Bullen
Twitter: - sqlpadawan
LinkedIn: Kevin Bullen
Kevin has been working with SQL Server since 2006, as a application developer, SQL developer, and Database Administrator. He is currently a Premiere Field Engineer at Microsoft. When he’s not working, he’s usually hiding in his garage working on one of his jeeps.
Grant Fritchey
Twitter: - @gfritchey
LinkedIn: Grant Fritchey
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Louis Davidson
Twitter: - drsql
LinkedIn: Louis Davidson
Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/
Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.
Jose Chinchilla
Twitter: - SQLJoe
LinkedIn: Jose Chinchilla
Contact: http://www.sqljoe.com
Jose Chinchilla is an experienced data analytics professional with multiple certifications including Microsoft Certified Database Administration (MCSE), Microsoft Certified Data Management and Analytics (MCSE), and Microsoft Certified Trainer (MCT). Jose specializes in Data Warehouse and Data Lake Architecture and Development as the Data Analytics Practice Lead at AgileThought, a full-service custom software and analytics consulting firm based in Tampa, FL. Jose is a book author (SQL 2012 Bible, Professional SQL Server 2012 Administration, Exam Ref 70-767 Implementing a SQL Data Warehouse 2016) and leads the Tampa Bay BI Data Analytics PASS Chapter in Tampa, FL.
Randy Knight
Twitter: - randy_knight
LinkedIn: Randy Knight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
Adam Belebczuk
Twitter: - @SQLDiablo
LinkedIn: Adam Belebczuk
Contact: http://www.sqldiablo.com/
Adam Belebczuk is the Owner amp; Principal Consultant at Belebczuk Consulting Services, LLC and has more than 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL Server development, performance tuning, high availability, and disaster recovery.
MIKE DONNELLY
Twitter: - SQLMD
LinkedIn: MIKE DONNELLY
Contact: http://sqlmd.wordpress.com
Michael Donnelly has been working with SQL Server for 15+ years and holds the MCSE: Data Platform certification. He is an avid runner, blogger, and a wannabe gourmet chef. Currently living the SQL Life on the Jersey Shore.
Lisa Gardner
Twitter: - sqlgardner
Contact: http://blogs.msdn.com/sqlgardner
Lisa Gardner is a Microsoft Premier Field Engineer based in Columbus, Ohio. She has been with Microsoft since early 2011 and has been a DBA and database developer since 1998. Throughout her DBA years, she also worked with Sybase and DB2, although SQL Server has always been her favorite RDBMS. Lisa’s passion for working with customers comes from many years of supporting high-profile production systems and wanting to help others gain from her experience.
Aaron King
Twitter: - https://twitter.com/trendoid
LinkedIn: Aaron King
Contact: http://www.aaronstanleyking.com
Aaron King is an application architect specializing in enterprise web applications and very large databases. He has helped several successful startups move to the software plus services model. He is currently working as an independent consultant on several long term engagements. Aaron is also a community leader and active in Indy PASS.
Ira Warren
Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.
Thomas LaRock
Twitter: - @SQLRockstar
LinkedIn: Thomas LaRock
Contact: http://thomaslarock.com
Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.
Dave Rodabaugh
Located in Columbus, Ohio, Dave Rodabaugh has over a decade of experience doing one thing: data warehousing and business intelligence using the Microsoft suite of products. His background as an engineer and exclusive focus on business intelligence has helped clients be successful in both initial-effort and rescued BI projects. He co-owns Atlas Analytics, through which he consults to clients in Ohio and beyond.
Sponsors
The following is a list of sponsors that helped fund the event: