SQLSaturday #441 - Denver 2015

Event Date: 09/19/2015 00:00:00

Event Location:

  • The Summit Event Center
  • 411 N. Sable Blvd.
  • Denver, Colorado

PDF of Schedule

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: An Unexpected Journey: SQL Server 2000 to 2014

Abstract: As a DBA yourself, I’m sure you’ve encountered instances where the SQL Server has been running fine, there’ve been no changes for ages, everything is stable, there’s no exposure to the outside world, and the last time anyone updated or applied a patch to the server was in February 2004… …and then the world intruded, and all of a sudden you’ve been given a directive to “bring that system up to date!” Now what? You’re faced with upgrading not only the SQL Server, but the Windows server as well (and a bunch of other applications), because Microsoft has announced that ALL support for Windows Server 2003 will be going away (far away!) this summer! And some clever person upstairs decided that it would be A GOOD THING to have this SQL Server exposed to the outside…and has commissioned the web dev team to build a whole suite of apps that WILL MAKE THE COMPANY MILLIONS! Where to start…

Speaker(s):

  • Michelle Poolet

Track and Room: Enterprise Database Administration Deployment - Nuggets


Title: Dimensional Modeling Design Patterns: Beyond Basics

Abstract: Dimensional modeling is arguably one of the most important fundamentals of business intelligence. It is still relevant even as new technologies like PowerPivot and SSAS Tabular Models are becoming more popular. Correctly modeling your organization’s data not only protects the most important asset your company has but ensures that your data mart or data warehouse will be responsive and capable of accommodating emerging requirements.

This session provides 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. Finally we will cover physical design choices.This case study and demo based session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.

Speaker(s):

  • Jason Horner

Track and Room: BI Platform Architecture, Development Administration - Avs


Title: Abstraction Techniques for SQL Server Reporting Services

Abstract: As enterprise Reporting Services solutions mature, maintenance and change requests of existing reports often result in environment inconsistencies and bottleneck new development. Establishing proper abstraction between data and presentation layers can greatly reduce maintenance tasks and ensure development consistency.

In this session we’ll review the following abstraction techniques and how they can ease maintenance burden and promote consistency across your reporting infrastructure. • Keep SQL within the Database not SSRS • One size fits all for parameter aliases • Combine available and default data sets into one procedure

Speaker(s):

  • Justin Hudnall

Track and Room: BI Information Delivery - Nuggets


Title: Getting started with Dimensional Modeling

Abstract: Technology has revolutionized the way organizations run today. Rather than a few file cabinets, organizations use many different software packages and applications that are mission critical to running their business. These systems gather a large amount of valuable data that must be used in decision making to maintain a competitive advantage. However, we’ve all heard and likely been around when mission critical systems have been rendered useless due to long running reports. To solve this and a host of other source system reporting issues we have proven Data Warehousing techniques to store the data in a report friendly way. Dimensional modeling is one of the most widely used set of techniques that will provide source system relief for reporting. In this session, we will take a look at what Dimensional Modeling is along with some key terms and techniques.

Speaker(s):

  • Marc Beacom

Track and Room: BI Platform Architecture, Development Administration - Outlaws


Title: Profiler is Dead! Long Live Extended Events!

Abstract: Did you know that Profiler and SQL Trace are deprecated? I know it still works (even in SQL Server 2016 CTP2), but it will never be updated with the latest features. In fact it will never be updated at all! That means if you want to capture information about any new feature, from version SQL Server 2012 and beyond, you need to use another tool. That new tool is Extended Events (XE). Not only has it replaced Profiler, and can be used to capture information on all new features, but it is a substantially better tool! In this session we will discuss the architecture of Extended Events, how to setup a new trace from scratch or convert an existing Profiler trace, and the new abilities that never existed in Profiler. We will also cover the difference in overhead cost of Profiler and Extended Events.
Profiler was a friend of mine, but it is time to embrace the new king!

Speaker(s):

  • Keith Tate

Track and Room: Enterprise Database Administration Deployment - Outlaws


Title: Tips for SQL Server Performance and Resiliency

Abstract: After working 20 years in the industry on hundreds of SQL Servers clear patterns emerge. These observations of patterns and best practices directly relate to the health of the server.#160; During this session we will review the patterns of healthy SQL Servers and identify unhealthy behavior that clearly shows servers that are at risk.#160; We will review shared patterns, configuration and practices.#160;#160; Which of these repeating patterns represent healthy Servers and which of these patterns are#160; shared with servers that are having issues daily.#160; These patterns are so clear in fact that I many SQL Servers will benefit from the application of at least one if not more of the tips we will cover.#160; At the end of this session attendees will have the tools to identify and correct common issues that impact SQL Servers Performance and Resiliency.

Speaker(s):

  • Chris Shaw

Track and Room: Enterprise Database Administration Deployment - Broncos


Title: SQL Server Security Basics

Abstract: The past few years seem to have had more than their fair share of high-profile data breaches, not all of which were caused by sophisticated hacking attempts. This session explains basic methods for securing your SQL Server by making sure you’re not leaving the proverbial front door unlocked (or in some cases, wide open). We will discuss the different levels and methods that can be used for granting and restricting rights, and the pros and cons of each. You’ll learn steps you can take to design databases with securability in mind from the beginning so you can better protect your data later on down the road. We’ll also demonstrate scripts that can help audit user rights and make sure logins don’t have any more permissions than they need. Security doesn’t have to be scary! Attend this session and gain a solid foundation to build your DBA career on.

Speaker(s):

  • Bob Pusateri

Track and Room: Enterprise Database Administration Deployment - Avs


Title: The Augean Stables: Data Cleansing in the Modern Enterprise

Abstract: Every database professional knows the database design ideal and we have all seen that ideal on numerous occasions - databases in perfect third normal form; constraints and relational integrity rigorously enforced; elegant error handling in every SQL statement; data so clean you can eat off it.

Unfortunately we’ve only seen this ideal in textbooks and sample databases designed by vendors.

The databases we see in the real world are… less than ideal shall we say. Of course, we use other phrases for what we see but human resources frowns on such terms and this is, after all, a family friendly presentation.
Database professionals in Greece circa 600 BCE may have access to the Alpheus and Peneus rivers to cleanse their particular stables but we modern folks need to rely on the tools on our own computers such as SQL and SSIS. Mike will review various techniques and tools for data cleansing that will help you wash away the muck to get to the data gold standard.

Speaker(s):

  • Michael Sexton

Track and Room: BI Platform Architecture, Development Administration - Outlaws


Title: Achieving Peak Performance from your Virtual SQL Servers

Abstract: Your SQL Servers are probably virtualized by now, but are they running at their absolute peak performance? How can you tell? When properly configured and maintained, a virtualized SQL Server will be at least as fast as the system that it came from, if not better. If not properly configured, silent performance killers can wreck your virtualization experience. This session will give you tips and tricks to maximize performance while giving you talking points so you can convince your infrastructure engineers to design the virtualization stack your way. This session goes deep into the architecture and methodology for squeezing the best possible performance from your virtualized SQL Server, and includes valuable tips on topics such as host-level over-commitment, storage performance, In-memory OLTP, and more!

Speaker(s):

  • David Klee

Track and Room: Enterprise Database Administration Deployment - Broncos


Title: Analyzing I/O Subsystem Performance

Abstract: SQL Server is often I/O bound - but why? Do you feel lost when talking to your storage administrator? Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.

Speaker(s):

  • Glenn Berry

Track and Room: Enterprise Database Administration Deployment - Rapids


Title: Stress Inoculation: Maintaining Performance Under Pressure

Abstract: Stress is a natural reaction to demanding events for which our natural resources to cope or react are low. Initial effects might be increased energy and focus but can quickly give way to inaction and costly mistakes.

This course presents a variety of simple yet highly actionable techniques borrowed from some of the most stressful fields on earth. In this course, you learn to apply the same methods that doctors, military, law enforcement, and paramedics learn to cope and perform under high-stress situations. Discover how easily these techniques translate to almost any career or endeavor.

Whether you regularly support a multi-million dollar data center on a 24-hour on-call rotation or are asked to restore production while three levels of management look over your shoulder, counting the dollars lost per minute, everyone is susceptible to stress. Some people just have a higher immunity. Attend this inoculation session and get caught up on your boosters.

Speaker(s):

  • Russ Thomas

Track and Room: Professional Development - Rockies


Title: 2014 SSIS Project Deployment Model: Deployment and Maintenance

Abstract: The 2014 SQL Server Integration Services (SSIS) Project Deployment Model introduces new opportunities for the delivery of SSIS solutions. Gone are decisions about logging providers, configuration approaches, and deployment targets. Now, you need to focus on the creation of an .ispac, the approaches to deploying the project, and applying configurations to ensure expected behavior.

This session begins by exploring mapping between elements in an SSIS project and their counterparts in the compiled file, the .ispac. The session then covers three approaches for automating the deployment of this unit into SSISDB We then cover the administration side of the SSIS Catalog. You create SSIS environment variables and apply them to configure run-time behaviour. Finally, you work through the native tooling to troubleshoot failed SSIS packages. We’ll cover SQL Server Management Studio (SSMS) reports, Catalog views, and data taps for run-time collection of values.

Speaker(s):

  • Bill Fellows

Track and Room: BI Platform Architecture, Development Administration - Avs


Title: Accelerating DevOps Using Data Virtualization

Abstract: DevOps is the melding of application development, testing, and IT operations. All tasks from infrastructure to coding to testing to transition into production must be automated so that new features and fixes can be continuously delivered.

Constraining DevOps is data. Databases and applications have grown enormous and complex. “Storage is cheap” is a lie. Provisioning a full environment for each developer or tester on each task of each project appears unrealistic, when each might require several terabytes of storage. And so everyone is limited to working in a small handful of shared environments that are refreshed only every few months, and code quality suffers.

Data virtualization is the solution. Virtual databases and file-systems only consume space from deltas, so it is possible to provision multiple terabytes for megabytes. Coders and testers have full environments fast in which to develop and test, improving code quality. Learn about the technical details behind this solution.

Speaker(s):

  • Tim Gorman

Track and Room: Enterprise Database Administration Deployment - Outlaws


Title: Why should I care about the plan cache?

Abstract: SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this first (and hopefully not last) installment of Rick’s “Why should I care” series a case for why working knowledge of how to query the plan cache is critical for performance tuning efforts in real world environments, followed by a review of relevant DMV’s for the newly motivated audience. Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBA is sometimes so moody.

Speaker(s):

  • Rick Lowe

Track and Room: Enterprise Database Administration Deployment - Nuggets


Title: Source Control practices for your BI World

Abstract: Source Control is a critical part of any development effort. For small shop developers tools like TFS can be overwhelming especially for developers that come from organizations with little to no source control experience. Let’s talk about practices and ways to implement source control for SSIS, SSRS and Database Projects in both multi-developer and multi-tiered environments. We will cover when and how to branch, merge and shelve and discuss ideas around process for deployment and continuous integration.

Speaker(s):

  • Leslie Weed

Track and Room: BI Platform Architecture, Development Administration - Broncos


Title: Getting Started with Execution Plans

Abstract: There are times when you are able to be proactive and tune existing queries. Sometimes, you will receive a phone call from your manager telling you that a certain web page or report is timing out and your users are furious. You need to quickly diagnose what the problem is. Where do you turn to first? When a query is underperforming, hogging resources or timing out, one of the first things you want to examine is the query execution plan. An execution plan provides a wealth of information that can help you quickly diagnose what is wrong. In this beginner level session you will learn what an execution plan is, how to find it, and how to interpret it to see what the query optimizer is doing and find the major pain points.

Speaker(s):

  • Jason Kassay

Track and Room: Enterprise Database Administration Deployment - Avs


Title: SQL Server Benchmarking: The Powershell Speedometer

Abstract: How fast do you think you were going? The only way to be sure is to have a reliable way to measure your performance. The challenge with SQL Server is that there are many aspects of your stack that you need to measure and understand. Powershell, with its ability to access and report on all these different levels, can give you a robust tool to benchmark your SQL Server. This session will cover benchmarking methodologies, the tools Powershell offers for capturing performance information, and will demonstrate how you can use them to measure performance statistics. After attending this session, you will understand how to effectively use Powershell to measure your database speed.

Speaker(s):

  • Michael Fal

Track and Room: Enterprise Database Administration Deployment - Broncos


Title: The Life Cycle of a Query in VR

Abstract: Have you ever wondered what really happens behind the scenes when you execute a query? In this unique demonstration, Todd will use a video game engine (Unreal Engine 4) and will dramatically show The Life Cycle of a Query in VR. We will follow a query from beginning to end and “runthrough” the various SQL Server components all queries must use including the Protocol Layer, Relational Engine, Storage Engine, Buffer Pool and then back out to the client. A volunteer at the end will then don an Oculus Rift DK2 Virtual Reality headset and then race through the sections in under a minute to win a prize. Participants will leave with a better understanding of the major components and with a conceptual framework to explore the components more in-depth.

Speaker(s):

  • Todd Kleinhans

Track and Room: Professional Development - Rockies


Title: Row-Based Security in SSRS and SSAS

Abstract: It is relatively straight-forward to grant a user access to a particular SSRS report, multi-dimensional cube, or tabular model table, but what happens when the user needs access to the object but should be denied access to view certain rows of data? In this session we’ll investigate a real-world solution to this common BI problem.

Speaker(s):

  • Chris Hyde

Track and Room: BI Information Delivery - Nuggets


Title: Data Integration with Master Data Services

Abstract: Master Data Services (MDS) enables the management of non-transactional data that defines business entities within the enterprise. Get a good business and technical understanding of how MDS can help obtain better business clarity across the organization through a Data Governance strategy. Data Governance is a methodology that represents quality, policies, and process management, in relation to handling your enterprise data. The session will demonstrate the architecture of a Master Data Management solution and the data integration required to implement it within the enterprise. In this session, you will learn:

  • A brief introduction to Master Data Management and Data Governance
  • Master Data Management staging architecture
  • Data integration with the entity-based staging tables
  • Batch processing to move data in the MDS specific tables
  • Publishing data to external systems with subscription views and web services

Speaker(s):

  • Reeves Smith

Track and Room: BI Platform Architecture, Development Administration - Broncos


Title: Don’t Rely on Magic - Tabular Performance Troubleshooting

Abstract: Many times you’ll hear that one of the major advantages of using the tabular model is ease of use and implementation. So that must mean that it will run like a super fast dream all the time out of the box, forever and ever right? Not exactly. There are many things to consider at the time of modeling and implementation for performance. And later if you run into trouble with reports and queries, what do you do then? In this session we’ll go through the process to troubleshoot performance of your tabular models and queries to keep things running as fast as possible. Just because tabular is easy to use doesn’t mean you have a magical black box that you can’t tune when it doesn’t run as fast as you want. In this session, we will focus on building a methodology for troubleshooting tabular performance so you can get that super fast dream machine.

Speaker(s):

  • Hope Foley

Track and Room: BI Platform Architecture, Development Administration - Broncos


Title: Use Hive and Hadoop for High Performance Data Warehousing

Abstract: Big Data has moved beyond the hype and entered the mainstream as a tool for managing large and unstructured data sets, giving data architects more options for managing data. The Hadoop ecosystem has become the tool of choice and Microsoft has entered this arena with HDInsight in the cloud. For DBAs this means having a place to store data that can be accessed using a highly parallel framework. In this session you’ll see how to use the numerous tools available to store data in Hadoop, process it, manage it, and retrieve it. We’ll explore Sqoop and how its many options can be configured to import data by taking advantage of Hadoop’s massive parallelism. We will develop and run Map\Reduce code, with an emphasis on understanding what belongs in a mapper function versus what belongs in a reducer function, while demonstrating Hadoop Streaming with languages such as R and C#. Finally, Hive will be shown to exhibit the use of a high-level query language in Hadoop for those who prefer SQL.

Speaker(s):

  • Carlos Bossy

Track and Room: BI Information Delivery - Rapids


Title: Introduction to Microsoft Azure DocumentDB

Abstract: In this session I will demonstrate how to create a DocumentDB instance in Azure, how to work with JSON documents, create Ad hoc queries with familiar SQL syntax, create application logic as stored procedures, triggers and user defined functions (UDFs) using standard JavaScript. Goals: #1 Show how to create validate JSON strings using Notepad++, validate the JSON against a schema using C# Newtonsoft dll. Demonstrate how to work with JSON in SQL Server as a reference on how hard it is to work with JSON when it is not natively stored. #2 Demo the basics of DocumentDB - Create the database, collections and documents using the web interface. Demo how to perform basic selects, joins and filtering. Review java script basics as java script is fundamental in creating stored procedures #3 Demo of how to work with DocumentDB in a C# by creating collections, documents and querying the database using lync and SQL syntax.

Speaker(s):

  • Jeff Renz

Track and Room: Application Database Development - Rockies


Title: Accelerate SQL Server Master Data Services with Profisee Maestro

Abstract: Grab your lunch and join John McAllister in the Profisee room for an informative presentation while you eat!

Accelerate SQL Server Master Data Services with Profisee Maestro

SQL Server Master Data Services (MDS) is a robust platform for master data and hierarchy management that provides master data capabilities such as business rules, a managed schema, hierarchies, versioning, workflow, and Excel Integration. Profisee Maestro slashes your time to deployment on MDS by providing an alternate UI for data Stewards and Application owners. Maestro adds data modeling, a first-rate user experience, ER-Win Integration, Simplified Import/Export to simplify getting MDM in the hands of your users. Maestro also adds data quality, matching, harmonization, address corrections, an API, web parts and CRM integration.
Come see how Profisee Maestro can take your MDS implementation from the department to the enterprise.

Speaker(s):

  • John McAllister

Track and Room: BI Platform Architecture, Development Administration - Nuggets


Title: Distributed Replay: Testing With Your Data, Your Way!

Abstract: Do you want to test hardware upgrades, index tuning or multi-client applications? Would you like to do this with data specific to your organization? Distributed Replay, introduced in SQL Server 2012, is a tool that will allow you to accomplish exactly that. In this session, we will cover why you should use it, how to set it up, and what types of data to collect for testing and replay. This session will demonstrate tangible methods and undocumented tidbits, that you can take back to your environment to create immediate, and measurable tests.

Speaker(s):

  • Melody Zacharias

Track and Room: Application Database Development - Rockies


Title: 15 Things to ensure survivability of your database

Abstract: Survivability of data should be the #1 priority for any database administrator. Corruption can happen to any database at any time. How soon corruption is detected and a quick response is key to minimize lost data and recovery in a timely manner. Have a plan ready when it happens, as this is one time you don’t want to “learn on the job”. In addition to daily and monthly maintenance that should be performed, other topics discussed will include e-mail notification when data becomes corrupt and Service Level Agreements.

Speaker(s):

  • Andre DuBois

Track and Room: Enterprise Database Administration Deployment - Nuggets


Title: Exploring the BI Universe

Abstract: Business Intelligence has received a great deal of attention over the last few years and there are numerous, often confusing products, strategies and offerings. With so many technologies to choose from it can be very difficult to decide where to start and what technology is the right fit(or more importantly, the wrong fit). Join Phillip as he guides you through the rapidly expanding BI universe. This session is intended for those curious about BI technology who have limited or no experience with it.

Speaker(s):

  • Phillip Labry

Track and Room: BI Information Delivery - Rapids


Title: Very Large Databases in your future

Abstract: Your databases may not be terabyte-sized yet, but they’re probably growing every day. We’ll look at lessons learned

from working with multi-terabyte, very large databases (VLDBs) in the real world. Topics include storage layout

decisions, unique tuning challenges, HA/DR implications, and database restores, along with shoehorning backups, re-

indexing and DBCC checks into itty-bitty maintenance windows. As a bonus, many of the techniques also apply to smaller databases and consolidated servers that run hundreds of databases.

Speaker(s):

  • Eric Peterson

Track and Room: Enterprise Database Administration Deployment - Avs


Title: Parameter Sniffing the Good and the Bad

Abstract: Parameter sniffing is something that more than often helps performance on your servers; however, there are times when it can hinder performance as well. In this session we will define exactly what parameter sniffing is, and examine when it is good and when it is bad. Lastly, we will explore the different options available to fix bad parameter sniffing. After this session, you will be able to locate and fix bad parameter sniffing when it occurs on your servers.

Speaker(s):

  • Lance Tidwell

Track and Room: Application Database Development - Rapids


Title: Keeping Your SQL Under Control: Version Controlling Your Database

Abstract: Source control isn’t just for application development anymore; your database code needs it just as much!

This session will cover the fundamentals of source control systems and how getting your database under version control is an excellent way to collaborate with team members, communicate changes, and keep an audit trail. You’ll see how Redgate SQL Source Control makes it incredibly easy and intuitive to maintain your database in nearly any source control system, and how the universe of development pipelines and continuous integration is easily accessible from there.

Speaker(s):

  • Bob Pusateri

Track and Room: Application Database Development - Avs


Title: Predicting the future with Machine Learning

Abstract: Machine Learning is Microsoft’s big entry in to the predictive analytics arena. . In this introductory session we will discuss the growing new field of predictive analytics and how Machine Learning is used to predict future results. Instead of staring into crystal balls, Machine Learning provides the ability to experiment to determine which algorithm or R code best analyzes the data to determine if past performance is indicative of the future or use scoring to find a more appropriate model.

Speaker(s):

  • Ginger Grant

Track and Room: BI Information Delivery - Avs


Title: Develop your Database using “Database Projects” from SQL Server Data Tools

Abstract: SQL Server Data Tools changes traditional database development by introducing a declarative, model-based experience that supports both online and offline (project-based) database development. In this presentation you will learn how to use this tool for either a new or existing database project. We will also highlight and demonstrate key built-in features like refactoring, pre and post deployment scripts, publish, and schema compare.

Speaker(s):

  • Andy Vold

Track and Room: Application Database Development - Outlaws


Title: Performance Tuning: Index Optimization

Abstract: As our data size grows larger the need for optimal indexing within our databases becomes even more important than before. This session will help you understand how choose appropriate indexes to streamline our DML operations in our enterprise. You will learn the optimal strategy for selecting both clustered and non-clustered indexes in your database. Along the way, we will discuss how column and index statistics can affect the performance in your queries. Finally, we will take a look at the benefits and pitfalls of using filtered, full-text search and composite indexes, their best practices, and exceptions to the rules.

Speaker(s):

  • Konstantin Melamud

Track and Room: Enterprise Database Administration Deployment - Rockies


Title: Modern BI Solutions based on Lambda Architecture

Abstract: Techniques and Tools for doing BI projects have improved over the past several years. Learn about what is available. Take some of these thoughts back to your work and apply them to your current projects.

Speaker(s):

  • Kevin Cox

Track and Room: BI Platform Architecture, Development Administration - Outlaws


Title: Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Abstract: While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.

Speaker(s):

  • Amy Herold

Track and Room: Enterprise Database Administration Deployment - Rapids


Title: Advanced Performance Tuning Tips with Database Performance Analyz

Abstract: SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path.

Speaker(s):

  • Trent Sherman

Track and Room: Enterprise Database Administration Deployment - Rapids


Title: Hadoop, and Hive, and Json and Data! Oh my!

Abstract: Tips and Tricks and Painful lessons learned as I have ventured into the world of Hadoop, JSon and Hive. Our data has made the move from a relational database to a JSon structure, and reporting across the entire enterprise of data has changed. We have introduced Hadoop batch processing to our ETL processes to collect and process data from various locations, depositing them in various other locations. Along the way, various brick walls were surmounted. We will discuss some of these brick walls. Some of the oddities encountered in this journey. and hopefully prepare you for a similar trip, without all the pain we suffered.

Speaker(s):

  • TJay Belt

Track and Room: Application Database Development - Rockies


Title: Transactional Replication 101

Abstract: Replication simplified! Learn the basic parts that make up replication, what tools are included to help you along plus a look into monitoring. We will cover the players in the game: Pubishers, Subscribers and Distributors, then delve into the data delivery process with Publications, Subscriptions and Articles, finishing up with the Log Reader and how to make sure everything is working and running smoothly.

Speaker(s):

  • Wendy Pastrick

Track and Room: Enterprise Database Administration Deployment - Outlaws


Title: Power BI Desktop - Intro

Abstract: Power BI is the latest tool for delivering data visually to your end users. Come learn some basics and get started creating your own dashboard today!

Speaker(s):

  • Shannon Holck

Track and Room: BI Information Delivery - Nuggets


Title: Light up your SQL investment with Pyramid Analytics

Abstract: Come see how Pyramid Analytics delivers a powerful, business user friendly platform that empowers organizations to make the most of their Business Intelligence. A demonstration will show you how to leverage your SQL environment to make Business Intelligence available to all within your organization. See how all levels of users can access, understand and present the right information to the right people at the right time.

Speaker(s):

  • Matt White

Track and Room: BI Information Delivery - Rockies


Title: Building your ETL Framework with BIML

Abstract: BIML makes SSIS development faster and creates reusable modules that help you apply a consistent ETL framework across solutions. In this session, we will write BIML and use it to build an SSIS package. You’ll see how BIML allows you to avoid corrupted metadata and the tedious repetition of implementing simple SSIS patterns, freeing you up to take on new and interesting ETL challenges. Then we will review how to use it to create an extensible ETL framework.

Speaker(s):

  • Meagan Longoria

Track and Room: BI Platform Architecture, Development Administration - Rapids


Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Konstantin Melamud

Twitter: - @kmelamud

Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQLSaturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.

Melody Zacharias

Twitter: - SQLMelody

LinkedIn: Melody Zacharias

Contact: http://sqlmelody.com

Melody is the Sr. Microsoft Solutions Manager at Pure and has been in love with data since 1991. She has been sharing her passion with the community in technical sessions and blogs since 2014. She has been a Microsoft MVP since 2016, including winning Rookie of the year for Canada that year. This last year, she was elected to the board of directors for PASS.org, the professional association for SQL Server and was awarded Regional Director by Microsoft. She has co-authored 3 books, including, SQL Server 2019 Administration inside out by Microsoft Press.

Matt White

LinkedIn: Matt White

Matt has been working with the Microsoft BI stack for over a decade. As an Account Manager for Pyramid Analytics he works with organizations to leverage their investment in SQL Server to create Business Intelligence solutions for IT and Business end users.

Bob Pusateri

Twitter: - @SQLBob

LinkedIn: Bob Pusateri

Contact: http://www.BobPusateri.com

Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years of experience on SQL Server. His interests involve internals, performance optimization, and cloud technologies. He is an active member of two Chicago-area PASS Local Groups, a community speaker, and maintains a web presence through both Twitter (@SQLBob) and his blog (bobpusateri.com).

Rick Lowe

Twitter: - DataFLowe

LinkedIn: Rick Lowe

Contact: http://dataflowe.wordpress.com/

Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated… eventually specializing more on performance issues than code.

Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

Bob Pusateri

Twitter: - @SQLBob

LinkedIn: Bob Pusateri

Contact: http://www.BobPusateri.com

Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years of experience on SQL Server. His interests involve internals, performance optimization, and cloud technologies. He is an active member of two Chicago-area PASS Local Groups, a community speaker, and maintains a web presence through both Twitter (@SQLBob) and his blog (bobpusateri.com).

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.

Ginger Grant

Twitter: - desertislesql

LinkedIn: Ginger Grant

Contact: http://www.DesertIsleSQL.com

Ginger Grant manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.

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

Bill Fellows

Twitter: - @billinkc

LinkedIn: Bill Fellows

Contact: http://blog.billfellows.net

Bill Fellows is a SQL Server MVP and has been a database developer for most of his career, with the past 15 years focused on ETL. He is the organizer of Kansas City’s eight SQLSaturdays and a speaker at many other SQLSaturdays, User Groups and the PASS Summit. Bill is the owner of Sterling Data Consulting where he gets to solve interesting data problems.

Leslie Weed

Twitter: - @weederbug

Leslie Weed is currently a Data and BI Architect with RevGen Partners in Denver, CO. She has been a SQL Professional specializing in Business Intelligence, data analytics, systems implementation, integration, and solutions delivery for the last 20ish years, including a variety of Enterprise Data Warehouses in various industries.

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.

Meagan Longoria

Twitter: - mmarie

LinkedIn: Meagan Longoria

Contact: http://datasavvy.me

Meagan Longoria is a business intelligence consultant with Denny Cherry Associates, and lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).

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.

Keith Tate

Twitter: - https://twitter.com/keith_tate

LinkedIn: Keith Tate

Contact: http://thesqlchef.com

Keith Tate is a Senior Database Administrator with over 17 years of experience as a data professional. During Keith#39;s professional career he has been a developer, DBA and data architect. Keith is also active in the SQL Server community and is currently the chapter leader of the Albuquerque SQL Server User Group.

Reeves Smith

Twitter: - SQLReeves

LinkedIn: Reeves Smith

Contact: http://reevessmith.wordpress.com

Reeves Smith, owner and principal architect of Macer Consulting, is passionate about applying data technologies that empower organizations. Reeves wields his knowledge and experience to lead, design, architect, and teach, working with both data center and business project teams. He approaches every project by first understanding the organization’s business challenges, and then developing a unique approach that targets those business needs accurately and effectively.

Reeves Smith has more than 20 years of experience working on the SQL Server stack. He is a Microsoft Data Platform MVP and Microsoft Certified Master, and regularly delivers technical presentations at international, regional, and local conferences and user groups.

Michelle Poolet

Twitter: - #SQLinTheCloud

LinkedIn: Michelle Poolet

Contact: http://mountvernondatasystems.com/blog.html

Michelle Poolet, MCIS and Zachman Certified Enterprise Architect(tm), has been working with Microsoft SQL Server(tm) since version 6.0. She has authored many articles for SQLMag(tm). She created and delivered classes in Database Design, Theory amp; Programming at University of Denver. A founder of Mount Vernon Data Systems, Michelle is currently focusing on SQL Server database administration, OLTP engine performance/tuning, database architecture, and data modeling.

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.

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.

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.

Phillip Labry

Twitter: - @philliplabry

Contact: http://phillip.labry.com

Phillip Labry is a Senior BI Consultant and Trainer with over 20 years experience in SQL Server and over 30 in IT. He has been lucky enough to work on data projects spanning telecom, banking, retail, law enforcement, health care, insurance, financial services and energy sectors. As a national consultant he provides training and builds solutions utilizing the full MS BI stack. He is an active member of the Madison, WI PASS chapter and speaks at events in the USA and Canada.

Chris Hyde

Twitter: - ChrisHyde325

LinkedIn: Chris Hyde

Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.

Andy Vold

Twitter: - @volda2000

LinkedIn: Andy Vold

Andy Vold, a SQL Server MCSA, MCTS and MCITP, is an Architect with RevGen Partners working primarily in business intelligence, SSIS/ETL, and database development. He enjoys helping clients by building database and business intelligence solutions to solve their complex business needs. Andy is a past board member of the Denver SQL Server Users Group.

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.

Trent Sherman

Twitter: - @dbatrent

Trent Sherman has over 25 years of overall IT experience and over 20 years of DBA experience primarily in the telecommunications amp; software industries using Oracle amp; SQL Server. He is currently an Engineer/DBA with Confio Corporation, recently acquired by Solarwinds. Prior to Solarwinds, Trent worked as a Senior Infrastructure Architect, Technical Manager, DBA, Developer and Design architect in several OLTP amp; VLDB/Data Warehouse database environments.

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.

Hope Foley

Twitter: - hope_foley

LinkedIn: Hope Foley

Contact: http://www.hopefoley.com

Hope Foley, a former Data Platform MVP, has worked across many industries as a DBA and Business Intelligence consultant. She joined team at Microsoft and is a Data AI Technology Solutions Professional. She has worked with enterprise customers but now focuses on education. Hope is an active member in the SQL Server and PASS communities speaking at events and organizing the SQLSaturday event in Indianapolis.

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.

David Klee

Twitter: - kleegeek

LinkedIn: David Klee

Contact: http://davidklee.net

David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.

Andre DuBois

Twitter: - @MtnDBA

Contact: http://MtnDBA.wordpress.com

Andre has been in the IT industry for over 25 years in various positions with the majority working as database administrator, designer and programmer. His experience has been in the financial, travel and education industries.

Tim Gorman

Twitter: - @TimGormanTech

LinkedIn: Tim Gorman

Contact: http://evdbt.com

Tim Gorman is a senior technical consultant for Delphix who securely enables masked data virtualization to increase the agility of IT development and testing while ending decades of security risk in SDLC.

Tim has co-authored six books on data warehousing and database administration, has performed technical review on eight more books, and has an author#39;s page on Amazon.com (http://www.amazon.com/Tim-Gorman/e/B00BKCTO5E).

Shannon Holck

Twitter: - SqlShannon

LinkedIn: Shannon Holck

Contact: http://biwarewolf.blogspot.com/

Master Certified Data Management Professional, former Microsoft Certified Trainer and Microsoft Certified Solution Developer, Shannon traveled the world teaching C#, VB.NET, VB6, Java, amp; Web dev. Now managing the BI/DW team for National Cinemedia in Denver, CO leveraging the Microsoft BI and Azure stacks. Experienced in advertising, insurance, health care, emergency medical software, GIS, and B2B. Occasional attendee at Denver SQL User Group because too busy killing it on competitive sand volleyball courts. Little time to blog but a few morsels @ http://biwarewolf.blogspot.com. Follow on Twitter @SQLShannon

Marc Beacom

Twitter: - MarcBeacom

LinkedIn: Marc Beacom

Contact: https://datalere.com/author/marc-beacom/

Marc Beacom, Managing Partner at Datalere, leverages over two decades of experience to better the data landscape for clients, along with nearly a decade of building and managing productive teams. Marc has led architecture and developed data integration strategies for dozens of Colorado based companies and organizations. Marc maintains an active presence in the Colorado community by volunteering and serving on nonprofit boards, speaking and running user groups.

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/

Michael Sexton

Twitter: - @sqlmountain

Contact: http://datamountain.sqlmountain.com/

Stunningly handsome, yet surprisingly humble, Mike Sexton spent the first ten years of his career as a public defender in New York. Upon learning the discrepancies between his salary and the salary of newly minted college graduates working in IT, he had an epiphany and immediately learned how to program database applications. He has designed and built database applications for 12 years in both SQL Server and Oracle based systems, he has been published in SQL Server Magazine and is one of the aut

Eric Peterson

Eric Peterson is a consultant specializing in database architecture with experience in demanding Fortune 100 company environments. He has a Computer Science degree complemented with an MBA, which meshes well with his jobs integrating business information with the systems that process it. He has worked with SQL Server since its inception and was an instructor of SQL courses at a national technical training company. He also speaks are regional SQLSaturday events.

John McAllister

Twitter: - @jmcallis64

LinkedIn: John McAllister

Contact: http://www.profisee.com

John McAllister co-founded Stratature, an Independent MDM software vendor, in 2001. Following Microsoft’s acquisition of Stratature in 2007 John served as Group Program Manager for MDS and oversaw the incorporation of MDM into SQL Server. John now serves as the Regional Sales Director for Profisee, Inc. which provides enterprise-class MDM Solutions built on top of Microsoft’s MDS offering. John has worked with 100’s of organizations around the world in all phases of MDM projects.

Russ Thomas

Twitter: - @SQLJudo

LinkedIn: Russ Thomas

Contact: http://www.sqljudo.com

Prior to focusing full time on IT Management and Database Administration in the Denver Colorado financial sector, Russ spent several years in law enforcement including four as a training Sergeant and Washington CJTC Instructor specializing in Emergency Vehicle Driving at Portland Intl Raceway. An experienced public speaker and trainer, Russ also has two decades of hands on IT work and leadership experience. Russ is a SQL Server Data Platform MCSE and is active in the SQLSaturday community.

Lance Tidwell

Twitter: - @Lance_LT

Contact: http://lancetidwell.com

Lance Tidwell, from the Austin, TX, area, has worked as a SQL Server DBA for the last 11 years. During his time as a DBA he has found his passion for all things SQL, but specifically for performance tuning. He has a life-long quest to always be learning new things; currently this quest has lead him to explore more about the Data Analytics/ Data Science areas.

Amy Herold

Twitter: - @texasamy

LinkedIn: Amy Herold

Contact: http://www.sqlkitten.com/

Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQLSaturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.

Justin Hudnall

LinkedIn: Justin Hudnall

Justin Hudnall is a Senior Consultant with RevGen Partners specializing in design and implementation of Microsoft’s Business Intelligence products. Justin has worked with SQL Server and BI for 10 years and has successfully delivered BI solutions for multiple clients across varying industries. He received a Bachelor’s in Management Information Systems from Colorado Christian University.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page