SQLSaturday #54 - Salt Lake City 2010
Event Date: 10/23/2010 00:00:00
Event Location:
- Neumont University
- 10701 South River Front Parkway
- Salt Lake City, Utah
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: How to decide if your database is a good candidate
Abstract: We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea. Like all problems in the database world there are no hard set answers as to if virtualization is a good idea, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money. There are some other times when you will be shooting yourself in the foot and shouldn’t. We’ll be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision. How to determine it your SQL Server database is a good candidate for virtualization.
Speaker(s):
- Denny Cherry
Track and Room: Room 200 - N/A
Title: Be safe out there: Ship those logs
Abstract: What happens if your hardware fails or your data center loses power? Do you have a Disaster Recovery (DR) plan in place that you can implement quickly? Log shipping allows you to keep copies of your databases closely synced and ready to come online in an emergency. Log shipping also offers options for read-only warm standby databases to reduce load from your production servers, adding additional value to your investment. In this session we’ll Log Shipping, how it works, and how it differs from its cousin, Mirroring. We’ll discuss practical uses for Log Shipping and work through a demonstration to show you how you can get it up and running in your environment.
Speaker(s):
- Nicholas Cain
Track and Room: Room 206 - N/A
Title: Database Switch
Abstract: If you maintain a Hot/Warm/DR solution, you may need to switch between these, from time to time. Ensuring that your systems are in sync and ready to be failed over too, at a moment’s notice is imperative. Performing this task on your own time scale will assist with practicing the steps necessary inside the database, as well as outside the database. A lot of moving parts are involved in a DB Switch. Let’s discuss what you as a data professional can do to assist in this endeavor.
Speaker(s):
- TJay Belt
Track and Room: Room 206 - N/A
Title: Getting Started with MDX
Abstract: In this session we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.
Speaker(s):
- William E Pearson III
Track and Room: Room 206 - N/A
Title: Visual Studio 2010 Database Projects
Abstract: Managing DDL scripts has always been one of the biggest challenges facing Database Developers. How do you keep your Development, Test, Stage, and Production Environments in sync? Why aren’t databases tightly integrated into source control systems like application code is? Visual Studio 2010 Database projects solve all these problems and more. In this session, we will learn how to use Visual Studio to treat database objects as the first-class citizens they have always been.
Speaker(s):
- Randy Knight
Track and Room: Room 206 - N/A
Title: Many-to-Many: Multiple Calendars in a Single Cube
Abstract: Including the fiscal calendars of major customers within the date dimensions of their own cubes has great appeal to many organizations, including financial services firms and the like. After all, having customer calendars in their cubes’ date dimension means sales and marketing managers can analyze - and report upon - data according to the fiscal calendar of the customer, as well as within the context of their own. In this session, we look at a way we can accomplish this by implementing a SQL Server Analysis Services many-to-many scenario.
Speaker(s):
- William E Pearson III
Track and Room: Room 209 - N/A
Title: Getting to Know Your DB
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: Room 200 - N/A
Title: What’s in your Toolbox?
Abstract: Over the last 3 versions of SQL Server, Microsoft has included a variety of tools which make managing and monitoring SQL Server much easier. Policy Based Management, the Management Data Warehouse, Central Management Servers, and Utility Control Points all make a DBA’s job much easier, particularly if you are responsbile for a large number of instances. In this session, we will review each of these tools and how they can be implemented in an integrated fashion to provide an enterprise view of your database ecosystem.
Speaker(s):
- Randy Knight
Track and Room: Room 206 - N/A
Title: SQL Server Clustering 101
Abstract: In this session we will cover the basics and delve into the advanced techniques which can be used to cluster Windows servers using the Windows Cluster Service, what sort of protection this provides you, and how to properly set up your clusters for a rock solid environment which will last you for many years to come. We will start with planning our cluster configuration, selecting our software, and walk through the process of clustering two servers together into an active passive cluster. We will cover the differences between a standalone machine and clusters with regard to licensing and multiple instance configurations.
Speaker(s):
- Denny Cherry
Track and Room: Room 200 - N/A
Title: Registration Breakfast
Abstract: Breakfast of bagels and coffee will be served during registration.
Speaker(s):
- Pat Wright
Track and Room: Room 200 - N/A
Title: Backup Restore Basics
Abstract: The key to being able to recover data in an emergency is to have a good backup and to know how to restore that backup to get up and running again as quickly as possible. In this session we’ll talk about how to design a backup and restore strategy that’s a good fit for you, including discussion around the types of backups that can be taken. We will also work through a couple of demos showing backup and restore in action. After all a backup is only good if you can restore it.
Speaker(s):
- Nicholas Cain
Track and Room: Room 200 - N/A
Title: Shortest Path Problem at DisneyLand
Abstract: We have all been on a vacation. Our thoughts sometimes are to get to the rides quickly so that we can hit each one and get through the park without missing anything.
This talk will be on given a list of points (Attractions) and their pairwise distances, the task is to find a shortest possible tour that visits each point (Attractions) exactly once. We will be discussing Dkjkstra’s routing algorithm to solve the problem using T-SQL.
Speaker(s):
- Scott Heffron
Track and Room: Room 209 - N/A
Title: SQL Server TDE
Abstract: Ever wondered how SQL Server can provide extra security for your database as it sits on the disk? This session will cover how to set it up, and some of the requirements to make it work. I will also discuss some of the gotchas that you must watch for when using TDE.
Speaker(s):
- Ben Miller
Track and Room: Room 209 - N/A
Title: Become a Bilingual DBA! Oracle for the SQL Server
Abstract: In today’s enterprise environments, it is becoming increasingly necessary to integrate data from a variety of sources. As SQL Server continues its march into the enterprise, the days of focusing 100% on one platform are over. At a bare minimum, we need to be able to communicate with DBA’s for other platforms. Terminology as simple as Instance and Database mean very different things in Oracle than they do in SQL Server. In this session, we will compare and contrast the two platforms in terms of features and terminology. We will also discuss some of the best practices and pitfalls when integrating the two.
Speaker(s):
- Randy Knight
Track and Room: Room 200 - N/A
Title: Performance Tuning Queries
Abstract: We all hear that infamous statement “My query is running slow”. In this session we’ll review queries to show you what can be done to correct poorly running queries. We’ll review the execution plans and what you should look for. We’ll discuss Set based logic vs procedural based logic. We’ll discuss Functions and their effect on performance.
Speaker(s):
- Pat Wright
Track and Room: Room 209 - N/A
Title: SQL Server Profiler and Tracing, a “How To”
Abstract: We have all needed to know what is happening in our database systems. We have often been tasked with finding poor performing queries. Maybe we are being hit with Auditing and Compliance needs. All these and many more issues can be resolved with SQL Server Profiler. Maybe with SQL Server Trace. But which one, and when? Auditing databases can be tiresome, but a good trace and supporting reports can really help out. This presentation will show you some of my own ideas, along with others’ ideas on best uses for Profiler and Trace. Once armed with this knowledge, you should be able to take it back to your shops and implement systems that assist you track down these issues more easily.
Speaker(s):
- TJay Belt
Track and Room: Room 209 - N/A
Title: Lunch Provided by Tek systems
Abstract: Lunch will be provided by Tek systems.
Speaker(s):
- Pat Wright
Track and Room: Room 200 - N/A
Title: Storage for the DBA
Abstract: One of the biggest issues in database performance centers around storage. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives. We’ll be digging into LUNs, HBAs, the fabric, as well as RAID Groups. In addition to theory, we’ll be looking at an actual EMC SAN so that we can translate what we see in the Storage Array with what we see on the actual server.
Speaker(s):
- Denny Cherry
Track and Room: Room 200 - N/A
Title: Visual Studio LightSwitch for the DBA
Abstract: LightSwitch is a new member of the Visual Studio family that is targeted to the business developer. But as a DBA, you may find great functionality from it. This session will provide a high-level overview of LightSwitch and discuss how users will access data. You will also learn useful ways to use LightSwitch in your daily work.
Speaker(s):
- Craig Berntson
Track and Room: Room 206 - 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.
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
Ben Miller
Twitter: - DBAduck
LinkedIn: Ben Miller
Contact: https://dbaduck.com
Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.
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
Randy Knight
Randy Knight (MCITP) is an IT Professional who has been working with Microsoft technology for over 20 years, focusing on SQL Server for the last 14. He has worked in a variety of settings, including six years as a Database Architect for one of the largest and most successful dot coms.
Pat Wright
Twitter: - www.twitter.com/sqlasylum
LinkedIn: Pat Wright
Contact: http://www.sqlasylum.com
Pat Wright has been working in the DBA space for 10+ years. Focusing on Performance tuning and ETL/DW projects. He helped found the local SQL Users group(www.slcsql.com) and founded the Not For profit Organization Utah Geek Events(www.utahgeekevents.com) which was founded to help the local community put on events.
Craig Berntson
Contact: http://www.craigberntson.com
Craig Berntson has been a Microsoft MVP since 1996, most recently for C# and has spoken at developer events across the US, Canada, and Europe. He is the co-author of the book “Continuous Integration in .NET” available from Manning. Craig lives Salt Lake City where he develops hospital database and analytical software for a Fortune 100 company. You can contact him at craig@craigberntson.com, through his blog at www.craigberntson.com/blog, or on Twitter, www.twtter.com/craigber.
Denny Cherry
Twitter: - mrdenny
LinkedIn: Denny Cherry
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
Nicholas Cain
Contact: http://sirsql.net
Nicholas Cain is a Microsoft Certified Master with over 12 years of enterprise database administration experience. He has worked with all versions of SQL Server since 7.0 in critical highly available production environments. He has not hired dozens of DBAs over the last few years.
TJay Belt
Twitter: - @tjaybelt
LinkedIn: TJay Belt
Contact: http://tjaybelt.blogspot.com
TJay Belt is an outdoorsman at heart who enjoys riding dirtbikes, waterskiing, boating, playing racquetball and spending time with his family. When he can’t be out playing, TJay loves to tinker with databases. TJay has been an IT professional for over a decade and a half. Currently serving as a Senior Database Administrator with Imagine Learning. TJay has progressed through several roles in his database career including developer, data guy, database developer, database analyst and DBA.
Scott Heffron
Contact: http://www.CTR-SQL.com
Scott Heffron has been developing database integration processes for 20+ years. His initial project was a GIS project that transferred data between Oracle, SQL Server, and Sybase. He has been working in the integration area ever since. He is currently working on integration project that analyzes data across multiple carriers.
Nicholas Cain
Contact: http://sirsql.net
Nicholas Cain is a Microsoft Certified Master with over 12 years of enterprise database administration experience. He has worked with all versions of SQL Server since 7.0 in critical highly available production environments. He has not hired dozens of DBAs over the last few years.
Randy Knight
Randy Knight (MCITP) is an IT Professional who has been working with Microsoft technology for over 20 years, focusing on SQL Server for the last 14. He has worked in a variety of settings, including six years as a Database Architect for one of the largest and most successful dot coms.
Pat Wright
Twitter: - www.twitter.com/sqlasylum
LinkedIn: Pat Wright
Contact: http://www.sqlasylum.com
Pat Wright has been working in the DBA space for 10+ years. Focusing on Performance tuning and ETL/DW projects. He helped found the local SQL Users group(www.slcsql.com) and founded the Not For profit Organization Utah Geek Events(www.utahgeekevents.com) which was founded to help the local community put on events.
Denny Cherry
Twitter: - mrdenny
LinkedIn: Denny Cherry
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
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.
Randy Knight
Randy Knight (MCITP) is an IT Professional who has been working with Microsoft technology for over 20 years, focusing on SQL Server for the last 14. He has worked in a variety of settings, including six years as a Database Architect for one of the largest and most successful dot coms.
Pat Wright
Twitter: - www.twitter.com/sqlasylum
LinkedIn: Pat Wright
Contact: http://www.sqlasylum.com
Pat Wright has been working in the DBA space for 10+ years. Focusing on Performance tuning and ETL/DW projects. He helped found the local SQL Users group(www.slcsql.com) and founded the Not For profit Organization Utah Geek Events(www.utahgeekevents.com) which was founded to help the local community put on events.
TJay Belt
Twitter: - @tjaybelt
LinkedIn: TJay Belt
Contact: http://tjaybelt.blogspot.com
TJay Belt is an outdoorsman at heart who enjoys riding dirtbikes, waterskiing, boating, playing racquetball and spending time with his family. When he can’t be out playing, TJay loves to tinker with databases. TJay has been an IT professional for over a decade and a half. Currently serving as a Senior Database Administrator with Imagine Learning. TJay has progressed through several roles in his database career including developer, data guy, database developer, database analyst and DBA.
Denny Cherry
Twitter: - mrdenny
LinkedIn: Denny Cherry
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
Sponsors
The following is a list of sponsors that helped fund the event: