SQLSaturday #153 - Salt Lake City 2012
Event Date: 10/20/2012 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: SMO Internals for High Performance PowerShell
Abstract: Ever wanted to know what happens in SQL Server when you use PowerShell and SMO to manage a SQL Server? How fast can your automation really go? I will take you through the most common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. We will dive deep through the collections that make SMO the powerful tool it is. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come peek behing the curtain and squeeze the speed out of your automation scripts using PowerShell and SMO. You’ll be glad you did.
Speaker(s):
- Ben Miller
Track and Room: Track 2 - N/A
Title: Table Compression
Abstract: SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.
Speaker(s):
- Jason Brimhall
Track and Room: Track 1 - N/A
Title: Microsoft Hadoop and Your Enterprise BI Strategy
Abstract: What is this Big Data thing and why should you care? Learn about Microsoft’s Hadoop connectors, the Hive add-in for Excel, what Pig and Hive are, and more. Big Data is an exciting foray into the world of data previously too big to load and query in an affordable manner. With the new Big Data tools you can expand your BI reach and be the hero who helps your company make better business decisions.
Session takeaways: • Understand what Big Data, Hadoop, Hive, and Pig are at a high level and how to use Hadoop, Hive and Pig as part of an integrated enterprise strategy for analyzing Big Data. • Learn why Big Data is so important in the business intelligence arena. • Kickstart your Big Data learning and know where to go to learn more.
Speaker(s):
- Dipti Sangani
Track and Room: Track 2 - N/A
Title: Introduction to Dimensional Data Modeling
Abstract: Data modeling is all about representing the real world in the database, and for 30 years the ER Model has been the preferred method for designing databases where the goal is to “get the data in” by capturing business transactions. But the ER Model is not the most efficient model where the goal is to “get the data back out”. The Dimensional Model allows us to take a very different look at all that data and restructure it in a way that is optimized for aggregation and summarizing so that we can unlock its information potential and build effective “Business Intelligence” systems. This presentation takes you “through the looking glass” to introduce you to a world of “fact tables”, “dimensions”, “star schemas” and more.
Speaker(s):
- Martin Miller
Track and Room: Track 3 - N/A
Title: SQL Azure Scalability with Federations
Abstract: With more and more companies moving to a cloud solution, the necessity to easily and efficiently scale their database solution is critical. This session will discuss how to scale SQL Azure using SQL Azure Federations, a recent addition to SQL Azure that provides the ability to build scalable, elastic, and multi-tenant solutions in SQL Azure. SQL Azzure Federations bring the sharding pattern into SQL Azure as a first class citizen as a way to achieve greater scalability and performance from the database tier of your application through horizontal partitioning at the database level. This session will look at Federations from a real-world point of view, by applying Federations to a real-life database. We will also look at performance benefits.
Speaker(s):
- Scott Klein
Track and Room: Track 2 - N/A
Title: The Accidental Programmer
Abstract: Most people in the database world have heard of the term, “The Accidental DBA”, those programmers who have to work with databases. How about the other side of the coin? What about DBA’s an Dev’s who have to write code or have to work closely with programmers? This presentation is a best practices guide for working with SQL Server in a .Net environment. You will learn how to recognize when bad code is written that interacts with the database, how to track it down, and most importantly how to fix it. On top of that you will also receive an introduction to object oriented programming concepts such as data abstraction, encapsulation, tier architecture, and class objects so that you can better communicate with your programmers.
Speaker(s):
- Jason Kassay
Track and Room: Track 3 - N/A
Title: SQL Server TDE
Abstract: Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? This session will go over all the steps and caveats that go with this technology. This is a topic that is an Enterprise Feature, but allows you to have your database encrypted on disk. We will discuss the Encryption Hierarchy as well as how it relates to SQL Server TDE.
Speaker(s):
- Ben Miller
Track and Room: Track 1 - N/A
Title: DBA Open Panel
Abstract: We have 3 excellent DBA’s/Designers/Architects from here in the Valley that will be available to answer questions about your system. If you have specific design questions or what’s the best way to do X this is the session to attend! Ben Miller, Jason Brimhall and Randy Knight will be on the panel and Pat Wright will be moderating.
Speaker(s):
- Pat Wright
Track and Room: Track 3 - N/A
Title: Processing XML Files into SQL Server using SSIS
Abstract: This talk will show the steps needed to process an XML file for an order entry system. We will go through the lifecycle of the XML file and how the data is processed so that it is usable for entry in an order entry system. We will show the different pieces of the XML process and files and how they work together. We will also show how to dynamically change information as the need arises.
Speaker(s):
- Scott Heffron
Track and Room: Track 2 - N/A
Title: Deploying without a Hitch
Abstract: Making life a little easier by creating an airtight deployment process. Will address methods of scripting, versioning, creating bootstrap and test data, security, rolling back, etc. By reducing human interaction (and thus error) and increasing the ability to reproduce development, QA and production conditions, deployment night will be much less stressful and much shorter.
Speaker(s):
- Tobe Pittman
Track and Room: Track 4 - N/A
Title: Understanding Transaction Isolation Levels
Abstract: SQL Server offers several isolation levels beyond the default “READ COMMITTED”. But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.
Speaker(s):
- Randy Knight
Track and Room: Track 1 - N/A
Title: Introduction to SSIS Event Handlers.
Abstract: SSIS event handlers are the simplest means of turning an SSIS script into a reliable system that is auditable, reacts appropriately to error conditions, reports progress and allows instrumentation and monitoring your SSIS packages. They are easy to implement, and provide a great deal of flexibility. Rob Sheldon once again provides the easy, clear introduction
Speaker(s):
- Scott Heffron
Track and Room: Track 4 - N/A
Title: SSIS 2012: More Than Just a Pretty UI
Abstract: SSIS 2012 added rounded corners and Undo/Redo to the designer, but what else was added to make this worth the upgrade? In this session there will be as many demos of the new features as can be fit into the time provided. Along with the rounded corners, you will also see the changes to deployment, SSIS catalog database, metadata/XML updates, Parameters, logging updates, Data Taps, ODBC support, script debugging, PowerShell interface and as many others as we can get through. If you haven’t seen what has been updated in SSIS 2012, this will be the session to cover the most!
Speaker(s):
- Steve Wake
Track and Room: Track 2 - N/A
Title: Release Management: A Necessary Evil
Abstract: The very nature of a database system is to be dynamic; rarely static. The applications that use databases tend to change, requiring changes to occur within our databases. The totality of pieces and parts that comprise this ‘change’ will be combined into a ‘Release’ that will be applied to your systems. Controlling this change is not rocket science, but it is not without its complexities. We will discuss various terms, processes, ideas, and suggest tools to assist you in performing this necessary function, while minimizing risk, and impacting your systems in a graceful fashion.
Speaker(s):
- TJay Belt
Track and Room: Track 1 - N/A
Title: But it worked great in Dev! Perfomance for Devs
Abstract: If you’ve ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why “SQL that works” is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that “worked great in dev” but caused major issues when it hit production.
Speaker(s):
- Randy Knight
Track and Room: Track 3 - N/A
Title: Power View and PowerPivot: High-Octane Self-svc BI
Abstract: The next-generation analytic, self-service reporting tools will knock your socks off! The Power View reporting experience in SQL Server 2012 and SharePoint 2010 takes user reporting to the next level and makes data exploration fun without writing queries and code. Come see the impressive performance capabilities of BI Semantic Tabular models used with high-volume, enterprise data. Two great things that go great together!
Speaker(s):
- Paul Turley
Track and Room: Track 3 - N/A
Title: T-SQL Tips Tricks
Abstract: Do you ever wonder how you can make T-SQL do what you really want? Do you want to know how to make it jump through loops, perform amazing twists and turns, and execute other wondrous performances? In this session you’ll learn about various features such as CTE, ROW_NUMBER, and other great features that will enable you to make your T-SQL queries and stored procedures more efficient and give you the results you really want.
Speaker(s):
- Aaron Cutshall
Track and Room: Track 4 - N/A
Title: SQL Azure - What is it and why do I need it?
Abstract: This session will take an exploratory look at Microsoft’s cloud-based relational database offering. We’ll lift the hood and look at its many benefits and features, and how it easily fills the need for a highly available and scalable database service in the cloud. We’ll discuss how SQL Azure helps ease provisioning and deployment, and how Microsoft takes care of the physical administration so that developers and DBA’s alike can focus on the aspects of their job they really care about.
Speaker(s):
- Scott Klein
Track and Room: Track 4 - N/A
Title: What’s all the Buzz about Hadoop and Hive?
Abstract: Everyone is buzzing about Hive and trumpeting the virtues of Hadoop. But what does it mean? Why does it matter to a SQL Server and/or BI professional? Come get a taste of the Hive honey and see why this new technology is worth buzzing about!
Speaker(s):
- Dipti Sangani
Track and Room: Track 1 - N/A
Title: Oh, so Tabular!
Abstract: Relational, multidimensional, now Tabular… how many ways can you bend your data (and your brain)? It took some work to get our heads around cubes, MDX OLAP concepts; and now the next generation of analytical data technology from Microsoft is not so radical. Learn how to enable deep analytics BI in your environment without popping brain cells learning yet another foriegn technology. The magic of VertiPaq: PowerPivot on the desktop BISM Tabular models leverage modern computing power in a new way. Gain insight about how to choose among all these options and build compelling dashboards reports with SharePoint, Reporting Services Power View.
Speaker(s):
- Paul Turley
Track and Room: Track 2 - N/A
Title: What Every DBA Should Know About NoSQL
Abstract: NoSQL is one of the hot “new” things in the developer world. As DBAs inevitably someone will come to us for help or advice on (or possibly choosing) a NoSQL solution. This session aims to give you a basic understanding in order to best answer those questions for your organization.
In this presentation I will cover: What exactly NoSQL is (and is not), ACID compliance of some popular NoSQL solutions, main differences between traditional RDBMS and NoSQL, why NoSQL popular with developers, and when you might (or might not) want to leverage it for a solution.
Speaker(s):
- Kelly Martinez
Track and Room: Track 4 - N/A
Title: Service Broker in Action
Abstract: SQL Server Service Broker is a messaging framework built into the SQL Server engine. It enables SQL Server to handle messaging between servers and applications with light setup and overhead. The flexibility of the framework enables Service Broker to queue event notifications, task execution requests or other messages while leveraging the strength of SQL Server transaction management, reliability and recoverability. In this session we will see how to set up Service Broker, discuss case studies where it has been implemented in industry, and step through a practical example implementing an audit log.
Speaker(s):
- Chad Crawford
Track and Room: Track 1 - N/A
Title: SQL 2012 Extended Events
Abstract: Extended Events were introduced in SQL Server 2008. With SQL 2012, we have seen a significant upgrade to this feature. Join me for a little adventure into what extended events are. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events.
Speaker(s):
- Jason Brimhall
Track and Room: Track 3 - 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.
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.
Paul Turley
Twitter: - paul_turley
LinkedIn: Paul Turley
Contact: http://www.sqlserverbiblog.com
Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.
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.
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.
Jason Kassay
Twitter: - @jasonkassay
LinkedIn: Jason Kassay
Contact: http://www.JasonKassay.com
Jason Kassay is a database administrator, software engineer amp; speaker from Colorado with over 12 years of experience. He is passionate about SQL Server, programming, release process, automation amp; performance tuning. Jason is an active member of the SQL Server community amp; volunteers/presents at events such as Colorado User Groups, SQLSaturday amp; Colorado GiveCamp. When not tuning databases or coding, Jason will most likely be found spending time with his family, playing hockey or running.
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.
Scott Klein
Twitter: - SQLScott
Contact: http://aka.ms/sqlscott
Scott Klein is a senior consultant with SQL Solutions Group with over two decades of experience working with Microsoft SQL Server. Prior to SSG, Scott spent almost 10 years at Microsoft, traveling the globe as a technical evangelist training and speaking about SQL Server and Microsoft’s Azure data services. Scott’s recent focus has been on advanced analytics, including big data and IoT, providing real-world training to help bring intelligence to your data. Scott has authored several books focusing on data and data analytics. Scott is continuously striving and looking for ways to help developers and companies grok the wonderful world of data.
Scott Heffron
Scott Heffron is a ETL engineer located in the Salt Lake City area. He has been involved in client/server, GIS, Web, and Mobile projects for the past 25 years. He is currently on ETL projects in SQL Server and Oracle.
Paul Turley
Twitter: - paul_turley
LinkedIn: Paul Turley
Contact: http://www.sqlserverbiblog.com
Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.
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.
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.
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.
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.
Steve Wake
Twitter: - stevewake
LinkedIn: Steve Wake
Contact: http://blog.wakebi.com
Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in consulting, advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full on-premises Microsoft BI stack. Recent experience with the Azure services: Analysis Services, Logic Apps, Data Factory, Databricks, Snowflake and Power BI. Steve is also very involved in the SQL community, speaking at events around the world.
Chad Crawford
Twitter: - @DBAChad
LinkedIn: Chad Crawford
Chad Crawford is an MCM and Principal Database Engineer with 19 years’ experience in database architecture, development, and administration. He has worked in the manufacturing, health care, and consulting industries, primarily focusing on design, performance, and high-availability of customer facing SAAS systems. He loves teaching and sharing new ideas, and created a custom training course that helped dozens of coworkers prepare for certification exams. He speaks regularly for users groups and SQLSaturday, and leads the Utah County SQL Users Group. When he isn’t optimizing a query or analyzing performance tests, you will find him running, tweaking a ham radio, or looking for a new strategy board game.
Tobe Pittman
Have worked as a database architech for the last 6 years. Have worked with both SQL Server (since 6.5) and several versions of Oracle.
Scott Klein
Twitter: - SQLScott
Contact: http://aka.ms/sqlscott
Scott Klein is a senior consultant with SQL Solutions Group with over two decades of experience working with Microsoft SQL Server. Prior to SSG, Scott spent almost 10 years at Microsoft, traveling the globe as a technical evangelist training and speaking about SQL Server and Microsoft’s Azure data services. Scott’s recent focus has been on advanced analytics, including big data and IoT, providing real-world training to help bring intelligence to your data. Scott has authored several books focusing on data and data analytics. Scott is continuously striving and looking for ways to help developers and companies grok the wonderful world of data.
Aaron Cutshall
Twitter: - sqlrv
LinkedIn: Aaron Cutshall
Contact: http://sqlrv.com
Aaron N. Cutshall is an Enterprise Data Architect with 20 years of experience in analysis, design and development for applications and databases in manufacturing and warehousing plus over 15 years in the Healthcare Informatics field. His primary focus is in designing and developing solutions for extremely large data sets that perform quite well in SQL Server. He is active in the SQL Server community and speaks at SQLSaturday sessions across the country.
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.
Dipti Sangani
Kelly Martinez
Contact: http://zero1design.com
Kelly Martinez, a Programmer/Analyst with the City of Greeley, Colorado has over 15 years of I.T. experience. His primary focus is on the Microsoft stack but has also has worked on various open source platforms specializing in web and database development. When not thinking about databases and code he enjoys spending time with his family, traveling, camping, and reading.
Martin Miller
Contact: http://www.libertybi.com
Martin Miller is a senior BI architect for a large health care organization, and is the founder of Liberty BI Consulting Services. Martin has over 10 years of experience designing and developing large scale, enterprise BI solutions for a wide variety of platforms and technologies, including Oracle, SQL Server and BusinessObjects. In his spare time, he enjoys watching sports, playing outdoors, and spending time with his wife and 3 kids.
Dipti Sangani
Sponsors
The following is a list of sponsors that helped fund the event: