SQLSaturday #169 - Denver 2012
Event Date: 09/22/2012 00:00:00
Event Location:
- Cherry Creek Presbyterian Church - Community Life Center
- 10150 E. Belleview Avenue
- Englewood, Colorado
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: Big Data for the SQL Server DBA w/Kevin Cox-Part 1
Abstract: If you’re like most Database Administrators then you already work with data that is big, so what is this big data thing all about? This session will cover the significance of big data by comparing and contrasting it to the SQL Server relational database environment. It will also demonstrate the value a big data ecosystem can provide to your technology infrastructure organization by using it to complement your existing data architecture, and by having it co-exist in effective ways with your SQL Server databases. Live demonstrations will show how you to get maximum value out of big data with tools such as Sqoop, Hive and Pig so that you can perform bulk data transfers, queries, and ETL using SQL Server and HDFS, the Hadoop file system.
Speaker(s):
- Carlos Bossy
Track and Room: Big Data/Cloud - N/A
Title: Big Data for the SQL Server DBA w/Kevin Cox-Part 2
Abstract: If you’re like most Database Administrators then you already work with data that is big, so what is this big data thing all about? This session will cover the significance of big data by comparing and contrasting it to the SQL Server relational database environment. It will also demonstrate the value a big data ecosystem can provide to your technology infrastructure organization by using it to complement your existing data architecture, and by having it co-exist in effective ways with your SQL Server databases. Live demonstrations will show how you to get maximum value out of big data with tools such as Sqoop, Hive and Pig so that you can perform bulk data transfers, queries, and ETL using SQL Server and HDFS, the Hadoop file system.
Speaker(s):
- Carlos Bossy
Track and Room: Big Data/Cloud - N/A
Title: “What is the Best Disaster Recovery Solution?”
Abstract: It depends, every situation is different. The question is often asked of DBA’s to provide a solution to very open ended requirements. However, the best solution can only be provided if the database professional is getting all the answers. This session is a case study into many of Disaster Recovery options that we as database professionals have. Understand the answers to the important questions that we should be asking to provide the best solution not only for the database but for the business as well. As an attendee you will learn how to change an answer from it depends into a solid solution that can be built upon. We will take examples from experiences and as a group determine what the best solution is.
Speaker(s):
- Chris Shaw
Track and Room: DB Developer/DBA - N/A
Title: T-SQL Brush-up: The Best Things You Forgot
Abstract: You’re a good SQL professional – you attend conferences and webinars, you read articles and books, and you know your way around SQL Server. But sometimes – just SOMEtimes – some piece of T-SQL slips by you unnoticed, or falls out of memory. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. You’ll learn that Common Table Expressions are, in fact, very cool. This session is chock full of code examples, including before-and-after demos and how-tos.
Speaker(s):
- Jennifer McCown
Track and Room: DB Developer/DBA - N/A
Title: Oracle for the SQL Server DBA
Abstract: Well known RDBMS’ have similar physical designs to meet ACID requirements and production standards. As most DBA’s are required to support more than one platform these days, this presentation will introduce the SQL Server DBA to the fundamental concepts of Oracle database administration.
The attendee will leave this session with a solid understanding of the similarities and differences in comparison to common Oracle features, design basics and how they correspond to SQL Server architecture.
Prerequisites: An open mind to different database platforms and a solid understanding of SQL Server. No exposure to Oracle database administration is required to attend this presentation.
Speaker(s):
- Kellyn Pot’Vin-Gorman
Track and Room: DBA - N/A
Title: The Backup Tune-Up
Abstract: Have you ever gotten tired of your 1TB database taking 4+ hrs to backup? Are you sick of having your users breathe down your neck for 2hrs because it’s taking too long to restore a DB? Well now you don’t have to worry about that anymore. I’m going to show you some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query. Backups actually have kind of an execution plan that you can access if you know how, and knowing how to get the individual portions of your backup process down will allow you to knock 80% and even more off of your backup and restore time. I’m not holding anything back in this session. This is a method I’ve used for 15yrs to tune my backups and I’ve had great success.
Speaker(s):
- Sean McCown
Track and Room: DBA - N/A
Title: The Accidental Programmer
Abstract: Most people in the database world have heard of the term, “The Accidental DBA”, those programmers who out of nowhere get thrown into working with databases. Well what about the other side of the coin? What about those DB Developers and DBA’s who have to write code? 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: DB Developer/DBA - N/A
Title: SSIS Configurations
Abstract: Join us for an in-depth discussion on SSIS Configurations. What are the different types? Can we make it easy to promote our packages from development? The answer is YES, we can! In this session, we’ll cover the various configuration methods, configuration tables, and how we can make those same tables dynamic.
Speaker(s):
- Chris Schmidt
Track and Room: Business Intelligence - N/A
Title: Complex DAX Functions
Abstract: PowerPivot is a powerful new tool able to slice and dice data in memory very fast. But how do you acheive complex situations like, parent child hierarchies, Many to Many, and using inactive Relationships. Come see these complex DAX functions and leave with some great DAX knowledge.
Speaker(s):
- Mike Davis
Track and Room: Business Intelligence - N/A
Title: Exposing the Core: SQL 2012 on Server Core
Abstract: Everything that’s old is new again, as Windows Server moves back to the terminal interface. With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure. This presentation will introduce you to Server Core, how to prepare it for a SQL installation(including using Powershell for management), and how to actually install SQL 2012 on to it.
Speaker(s):
- Michael Fal
Track and Room: DB Developer/DBA - N/A
Title: SSIS 2012 New Features
Abstract: The newest version of SQL Server is out and packed with new features. Come see all of the newest features and best practices in SSIS 2012. Learn about the new SSIS parameters, environments, deployment, and the new tasks. Understand the new project deployment mode and how to execute SSIS 2012 packages with T-SQL.
Speaker(s):
- Mike Davis
Track and Room: SQL Server 2012 Roundup - N/A
Title: SQL Azure and Hadoop: A practical example
Abstract: Increasingly, firms are encountering issues when attempting to turn massive data sets from social media and other textual sources into usable information. Solutions like Hadoop and MapReduce offer the ability to mine and aggregate large amounts of information, but there is quite a difference between these systems and traditional relational databases. This session will provide an overview and demonstration of Microsoft’s Azure cloud offering with Hadoop and will cover the benefits and challenges of implementing a “Big Data” solution
Speaker(s):
- Scott Berkley
Track and Room: Big Data/Cloud - N/A
Title: 10 Things That Every DBA Should Know!
Abstract: Are you just starting out in the DB world? Are you unsure of things that you should know? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered ‘Yes’ to any of those question, then this is the session for you! John will be talk about things that he’s seen in the trenches that every DBA should know and understand.
Speaker(s):
- John Morehouse
Track and Room: DBA - N/A
Title: Mouth Wide Shut: Coherent Interviewing
Abstract: “Interviews are so easy,” says absolutely nobody. In fact, interviewing for your next DBA or SQL developer job is a very tricky process, with many common pitfalls. In this fun and interactive session, we’ll give you all the best advice you’ve never heard about pre-interview preparation, typical traps, and the new professionalism. You will start to refine the way you present yourself, tailor your answers appropriately, and learn about our revolutionary negotiating tactics. Most importantly, we’ll quantify the most difficult aspect of interviews: knowing when to keep silent.
Speaker(s):
- Sean McCown
Track and Room: Professional Development - N/A
Title: DMV Emergency Room!
Abstract: If you have ever been responsible for a mission critical database, you have probably been faced with a high stress, emergency situation where a database issue is causing unacceptable application performance, resulting in angry users and hovering managers and executives. If this hasn’t happened to you yet, thank your lucky stars, but start getting prepared for your time in the hot seat. This session will show you how to use DMV queries to quickly detect and diagnose the problem, starting at the server and instance level, and then progressing down to the database and object level. Based on the initial assessment of the problem, different types of DMV queries will help you narrow down and identify the problem.
Speaker(s):
- Glenn Berry
Track and Room: DBA - N/A
Title: Musically Speaking: Building Better Presentations
Abstract: Have you wanted to speak, but weren’t sure how or where to start? Maybe you’ve done some presentations, but still aren’t comfortable with building your deck or working in front of an audiance? This session will show you how you how to create great presentations by using many of the same techniques musicians use to create songs and perform on stage. Participants won’t need to have any musical training or previous speaking experience to benefit from this session.
Speaker(s):
- Michael Fal
Track and Room: Professional Development - N/A
Title: A Practical Approach to Table Partitioning
Abstract: There are many white papers and articles about table partitioning, but when it comes down to implementing partitioning there is little “real world” documentation. This presentation will cover definitions (so you will know what I am talking about), tips on what tables to partition and how to pick a partition key, and finally a real world example with scripts on implementation and ongoing maintenance of the partitioned tables.
Speaker(s):
- Mike Byrd
Track and Room: DBA - N/A
Title: SSRS Patterns and Practices: Cube Reporting
Abstract: This session focuses on many patterns, practices, and general considerations for accessing SQL Server Analysis Services (SSAS) cube data using SQL Server Reporting Services.
Speaker(s):
- Joe Salvatore
Track and Room: Business Intelligence - N/A
Title: SQL 2012 Encryption and You
Abstract: When do you need your data encrypted? After providing a brief history and intro to encryption and cryptography, we will look at several ways to secure your SQL Server 2012 data and systems. We are going to cover: column level encryption, transparent data encryption (TDE), discuss third party tools, and enterprise key management (EKM) using hardware security modules (HSM)s. We will also cover certain gotchas and pitfalls to avoid.
Speaker(s):
- Todd Kleinhans
Track and Room: SQL Server 2012 Roundup - N/A
Title: Develop a Quick and Dirty Web interface to your DB
Abstract: Develop a Quick and Dirty Web interface to your database: for the DBA and other non-developers. So you want to develop to your database? Do you have your own tools to check performance? Does Chris Shaw’s Utility Database sound like a tool you have and want a web interface, but don’t want to write a lot of code? I will demonstrate how a simple ASP.Net MVC site can be developed and deployed against your database. See firsthand how easy we can use Shaw’s utility database and access across the web over a mobile device so you may manage performance online whilst zipping your drink of choice.
Speaker(s):
- Gabriel Villa
Track and Room: DB Developer/DBA - N/A
Title: Track’em! What are DBA’s doing on my server?
Abstract: Everyday a DBA needs to access our system. They might need to make a change. Can I see what they did, of course. Let’s look at DDL tracking, events and service broker to see how we can see security, object and jog changes. What did that DBA really to in our Sql Server? We need a log to show our auditor, let’s prove what the DBA did.
Speaker(s):
- Thomas Norman
Track and Room: DBA - N/A
Title: Upgrading and Overhauling SSIS Packages for 2012
Abstract: SQL Server 2012 makes great strides in the development, maintainability, and administration features of Integration Services packages. Whether you already have packages from an earlier version or you are starting from scratch, you will learn how to take advantage of these new features. In this session, we will show: an upgrade of Integration Services packages from 2008 R2 to 2012, the modifications needed to run these packages in 2012, and the information produced about package execution.
Speaker(s):
- Jessica Moss
Track and Room: SQL Server 2012 Roundup - N/A
Title: What To Do When It’s Just You
Abstract: Are you the only SQL Server professional at your company? Join Glenn Berry, Mike Fal, Carlos Bossy, and Doug Lane in an interactive discussion about how to deal with the challenges of being the only SQL person on staff. Whether you’re one of five employees or five hundred, you’ll learn tips and techniques for how to survive and thrive as a solo DBA/developer. Topics will include managing time and expectations amid frequent interruptions, how and when to automate and delegate tasks, maintaining data quality, and getting help when you’re stuck.
Speaker(s):
- Doug Lane
Track and Room: Professional Development - N/A
Title: Reverse Engineering The Database
Abstract: Ever gotten stuck with a vendor application? Ever wanted to gleam some information from that database? It’s happened to many of us. Whether it be a ticketing or a call system, sometimes you just want to get more information out of it. In this talk, we’ll discuss what methods are available to you to try and discover where the data resides and how it flows through the database.
Speaker(s):
- Brandon Tucker
Track and Room: DB Developer/DBA - N/A
Title: Tabular Models
Abstract: Tabular modules allow developers to create models based upon different data sources; create hierarchies, perspectives, partitions and roles similar to traditional OLAP cubes. In this session will highlight the differences between traditional OLAP and tabular models and reasons for selecting one approach over another. I will demonstrate how to create a data model first in power pivot model and then import into an Analysis Services Tabular Project. Working with the imported data I will then create measures, KPIs, perspectives, and implement security. Finally I will deploy the model to an Analysis Server.
Speaker(s):
- Jeff Renz
Track and Room: Business Intelligence - N/A
Title: Data Warehouse Best Practices
Abstract: This session will describe the best practices for designing a data warehouse to get the most out of SQL Server. Raphael has worked in data warehousing for 12 years and will blend experience, with best practices and recommendations from Microsoft’s Fast Track program. Each version of SQL Server introduces new features specifically for data warehousing - by applying the correct technique, feature, hint, modelling approach and layout the data warehouse will be faster and more scalable.
Speaker(s):
- Doug Barrett
Track and Room: Business Intelligence - N/A
Title: New T-SQL 2012 features
Abstract: SQL Server 2012 has many new T-SQL features and enhancements that will simplify your code and life. We’ll roll up our sleeves and dive in head first to take a look at some of the new features.
Speaker(s):
- Marc Beacom
Track and Room: SQL Server 2012 Roundup - N/A
Title: Largest SQL Azure projects in the world
Abstract: See the architecture of the largest Azure projects in the world. Find out why most use a combination of SQL Azure and NoSQL.
Speaker(s):
- Kevin Cox
Track and Room: Big Data/Cloud - N/A
Title: Branding Yourself for a Dream Job
Abstract: Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker(s):
- Steve Jones
Track and Room: Professional Development - N/A
Title: Women in Technology: Career Roundtable
Abstract: Whether you are searching for a new job or already well established, you need the right tools and strategy to make your career great! Men and women both should come and join the discussion to share their experiences with job hunting, interviewing, professional development, and on-the-job issues.
Speaker(s):
- Jennifer McCown
Track and Room: Professional Development - N/A
Title: Dimension Modeling Design Patterns: Beyond Basics
Abstract: This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
Speaker(s):
- Jason Horner
Track and Room: Business Intelligence - N/A
Title: A Lap Around Data Quality Services 2012
Abstract: We will explore data quality issues that face today’s business and how Data Quality Services 2012 can help IT Pros and Data Stewards meet those challenges. We will start from zero, build a knowledge base, profile data to train our knowledge base and then use that knowledge to highlight both the cleansing and matching capabilities of DQS. This session will also cover the DQS SSIS component that’s available in SQL Server 2012.
Speaker(s):
- Christopher Price
Track and Room: SQL Server 2012 Roundup - N/A
Title: Unstructured Data in SQL Server
Abstract: A look at the Filestream and Filetable features in SQL Server that can allow you to handle unstructured data inside your SQL Server database.
Speaker(s):
- Steve Jones
Track and Room: Big Data/Cloud - N/A
Title: Exploring your Data with Power View
Abstract: Exploring your data has never been easier with Power View included in SQL Server 2012. Learn how to quickly analyze and discover new trends in your information by using the intuitive, easy to use, and business-friendly tool. This session will not walk through installation of the tool, but will instead describe the different visualizations provided and when you would use each one.
Speaker(s):
- Jessica Moss
Track and Room: SQL Server 2012 Roundup - 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.
Glenn Berry
Twitter: - GlennAlanBerry
LinkedIn: Glenn Berry
Contact: https://glennsqlperformance.com/
Glenn works as a Principal Consultant for Dr. DMV, LLC in Elizabeth, CO. He was a Data Platform MVP from 2007-2017, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, performance tuning, and Azure SQL Database. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at Denver University - University College. He is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQLSaturdays, and the PASS Community Summit.
Jennifer McCown
Twitter: - http://www.Twitter.com/MidnightDBA
LinkedIn: Jennifer McCown
Contact: http://www.MidnightDBA.com/Jen
Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.
Chris Schmidt
Twitter: - @sqlbischmidt
LinkedIn: Chris Schmidt
Contact: http://intelligentsql.wordpress.com/
Chris Schmidt is a data architect with Centric Consulting and has experience designing business intelligence solutions for a wide variety of companies in multiple industries. He is very passionate about the entire Microsoft BI stack, with a special emphasis on SSIS and SSAS.
Doug Lane
Contact: http://www.douglane.net
Doug Lane (MCITP, MCTS) is a consultant with Brent Ozar Unlimited and has over 14 years’ experience with SQL Server. He blogs about SQL Server with emphasis on Reporting Services and professional development.
Jeff Renz
Twitter: - jeff_renz
LinkedIn: Jeff Renz
Contact: http://www.revgen.com
Jeff Renz is a Senior Architect at RevGen Partners, currently working as the design architect and implementation lead on several projects for a Fortune Top 50 company. Jeff has worked with SQL Server and BI for 15+ years and has 10 years’ experience with data warehouse design and implementation. In addition to consulting, he is joining the University of Denver adjunct faculty and is expected to begin teaching in the ICT program starting in June. He received his bachelor’s degree in Computer Science, his master’s degree in Operations Research from Colorado School of Mines, and will be graduating from the Harvard Business Analytics Program in December.
Steve Jones
Twitter: - way0utwest
LinkedIn: Steve Jones
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
Joe Salvatore
LinkedIn: Joe Salvatore
Contact: http://joethebusinessintelligenceguy.wordpress.com/
Joe Salvatore, MCITP/MCTS SQL Server Business Intelligence 2005/2008, is a Business Intelligence Architect for Pragmatic Works where he designs and implements world class Business Intelligence solutions using Microsoft technologies such as SQL Server, Integration Services, Analysis Services, Reporting Services, PerformancePoint Services, PowerPivot, PowerView, Excel, and SharePoint. For over 15 years, Joe has passionately assisted companies of all sizes and all industries to better understand, and implement Microsoft solutions. Additionally, Joe gives back to the community by contributing as an author or editor to five Wiley/Wrox books, blogging about technology discoveries, and speaking at local user groups, SQLSaturdays, and Professional Association for SQL Server (PASS) events.
Sean McCown
Twitter: - @KenpoDBA
Contact: http://www.midnightdba.com/dbarant
Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
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.
Christopher Price
Contact: http://bluewatersql.wordpress.com/
Chris Price is a Sr. BI Consultant with Pragmatic Works based in Tampa, FL. He has a B.S. in MIS and a MBA, both from the Univ. of South Florida. He previously worked as a software architect before being bitten by the BI bug. His current focus is on ETL and Data Integration, Data Quality and MDM, SSAS, SharePoint and Big Data. He regularly speaks at SQLSaturdays, Code Camps and other community events. He has authored multiple whitepapers and books and served as technical editor.
Chris Shaw
Twitter: - @SQLShaw
LinkedIn: Chris Shaw
Contact: http://chrisshaw.wordpress.com/
Chris Shaw started his database career in 1993. Following the Marines, Chris continued working with databases for companies such as Wells Fargo, Pulte Mortgage, and Yellow Pages Inc. Chris has been writing and speaking about SQL Server for over 15 years at events such as SQL Connections, PASS Summit, and SSWUG Ultimate conferences. Chris received his 5th Microsoft MVP award.
Mike Davis
Twitter: - @mikedavisSQL
LinkedIn: Mike Davis
Contact: http://MikeDavisSQL.com
Mike Davis, MCITP, is a Consulting Team Lead at Pragmatic Works. He is an author with books covering Business Intelligence and SSIS. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, SQLSaturday, and SQL Rally. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.
John Morehouse
Contact: http://sqlrus.com
John Morehouse is currently a Database Architect/Engineer with Farm Credit Services of America in Omaha, Nebraska. He is one of the leaders of the Omaha SQL/BI User group and and a frequent speaker at SQLSaturday’s as well as other conferences. In his spare time, you can find John running after one of his two sons or working on his 113 year old house.
Carlos Bossy
Twitter: - @carlosbossy
LinkedIn: Carlos Bossy
Contact: http://www.carlosbossy.com
Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.
Mike Davis
Twitter: - @mikedavisSQL
LinkedIn: Mike Davis
Contact: http://MikeDavisSQL.com
Mike Davis, MCITP, is a Consulting Team Lead at Pragmatic Works. He is an author with books covering Business Intelligence and SSIS. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, SQLSaturday, and SQL Rally. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.
Michael Fal
Twitter: - @Mike_Fal
LinkedIn: Michael Fal
Contact: http://mikefal.net
Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently.
Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He has been caught playing trombone in public on more than one occasion.
Sean McCown
Twitter: - @KenpoDBA
Contact: http://www.midnightdba.com/dbarant
Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
Gabriel Villa
Twitter: - @extofer
LinkedIn: Gabriel Villa
Contact: https://extofer.wordpress.com/
Gabriel is a skilled leader, architect, and technical expert focusing primarily on Microsoft technologies and is passionate about open-source technologies for integration, automation, and development. Gabriel’s versatility extends from systems, data and development and leverages hybrid/SaaS/Cloud integration, proven software engineering platforms, and best-of-breed data management and business intelligence solutions.
Originally from El Paso, Texas, Gabriel lives in Colorado Springs with his wife and kids, where he is an Architect for RevGen Partners, volunteers in the tech community and enjoys the Colorado outdoors.
Jessica Moss
Twitter: - @jessicammoss
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
Carlos Bossy
Twitter: - @carlosbossy
LinkedIn: Carlos Bossy
Contact: http://www.carlosbossy.com
Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.
Steve Jones
Twitter: - way0utwest
LinkedIn: Steve Jones
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
Mike Byrd
Twitter: - ByrdNest_TX
LinkedIn: Mike Byrd
Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com
Former rocket scientist and USAF Fighter Pilot – now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies.
Presenter at many SQLSaturdays over last 6 years in United States, Europe, and Australia.
Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).
Video presentations (for local SQL Server user groups or SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd
Todd Kleinhans
Twitter: - @toddkleinhans
LinkedIn: Todd Kleinhans
Contact: https://toddkleinhans.wordpress.com/
Todd Kleinhans has been using SQL Server since the last millennium. He has served in different roles across many industries but he’s mainly been a DBA. When not in virtual reality, he likes to speak at PASS sponsored events and volunteers in various groups like PASS, DSSUG, Colorado Virtual Reality and is the President of Denver/Boulder Unreal Engine group. He is on Twitter: @toddkleinhans and blogs at https://toddkleinhans.wordpress.com/
Kevin Cox
Twitter: - @kevincoxsql
Kevin Cox has been working with databases for over 35 years and with SQL Server for more than 25 years. He is an author, lecturer, and mentor in database subjects. Kevin is currently with the Microsoft Azure Engineering product group in the Customer Advisory Team and feels fortunate to be able to work on the largest projects around the world.
Jennifer McCown
Twitter: - http://www.Twitter.com/MidnightDBA
LinkedIn: Jennifer McCown
Contact: http://www.MidnightDBA.com/Jen
Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.
Thomas Norman
Twitter: - ArmorDba
LinkedIn: Thomas Norman
Contact: https://armordba.com/
Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.
Marc Beacom
Contact: http://dawabi.com/blog.aspx
Marc Beacom is President of DawaBI, a Data Warehouse and Business Intelligence Consultancy firm focusing on Making Data-Driven Decisions Possible. He has been working with SQL Server for over a decade delivering scalable solutions for organizations of all sizes. He has earned several industry certifications and degrees. Marc is an active member of the community and has volunteered for many organizations such as PASS, Denver SQL, Colorado GiveCamp, Camp To Belong, to name a few.
Kellyn Pot’Vin-Gorman
Twitter: - DBAKevlar
LinkedIn: Kellyn Pot’Vin-Gorman
Contact: http://dbakevlar.com
Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and an Idera ACE and Oracle ACE Director alumnus. She is a Data Platform Architect in Power BI with AI in the EdTech group at Microsoft. Kellyn is known for her extensive work with multi-database platforms, DevOps, cloud migrations, virtualization, visualizations, scripting, environment optimization tuning, automation, and architecture design.
Kellyn has spoken at numerous technical conferences for Oracle, Big Data, DevOps, testing, and SQL Server. Her blog (http://dbakevlar.com) and social media activity under her handle, DBAKevlar, is well respected for her insight and content.
Michael Fal
Twitter: - @Mike_Fal
LinkedIn: Michael Fal
Contact: http://mikefal.net
Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently.
Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He has been caught playing trombone in public on more than one occasion.
Doug Barrett
Douglas Barrett draws on 15 years of data warehouse experience, including 10 years as a Consultant and solution specialist for Microsoft and WhereScape, delivering data warehouse projects using agile tools and techniques. Major data warehouse projects have included Basel II Credit Risk for a Retail Bank, Airline Travel Agent, Hospital Episode of Care, Hotel Occupancy and Utility companies.
Scott Berkley
Scott Berkley is the Regional Practice Director of BI/SQL Server for Neudesic and is a Microsoft certified BI professional and V-TSP. He has spent the last 13 years developing database-driven solutions for both large and small organizations across a variety of industries. Over the past year, Scott has participated in the SQL Server 2012 and Excel 15 TAP programs and spends a lot of his time demonstrating and evangelizing the Microsoft BI platform.
Jessica Moss
Twitter: - @jessicammoss
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
Jason Horner
Twitter: - jasonhorner
LinkedIn: Jason Horner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.
I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.
In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
Brandon Tucker
LinkedIn: Brandon Tucker
Over the past 7 years, Brandon has explored SQL Server as a developer, admin, and consultant. After graduating school, he has translated his academic knowledge base into real-world scenarios in the financial, health insurance, and education industries. Brandon has presented at Code Camps/User Groups in multiple states and was elected as VP, Events for DSSUG in 2010. When not pounding away on a keyboard, Brandon can be found wandering the globe in search of great music, beers, and experiences.
Sponsors
The following is a list of sponsors that helped fund the event: