SQLSaturday #246 - Salt Lake City 2013
Event Date: 09/07/2013 00:00:00
Event Location:
- 3900 Adobe Way
- lehi, Utah
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: SMO Internals for High Performance PowerShell
Abstract: Ever wanted to know what happens in SQL Server when you use PowerShell and SMO to manage a SQL Server? How fast can your automation really go? I will take you through the most common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. We will dive deep through the collections that make SMO the powerful tool it is. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come peek behing the curtain and squeeze the speed out of your automation scripts using PowerShell and SMO. You’ll be glad you did.
Speaker(s):
- Ben Miller
Track and Room: Lucas - N/A
Title: A Couple of Oracle Security Tricks
Abstract: Trick #1: Password Security - Strong passwords, impossible passwords and password safes; how to protect your accounts. Trick #2: How to encrypt a column so effectively that not even a SYS level user can read it. Michael McLaughlin’s method for utilizing User Defined Types (UDT) and DBMS_ENCRYPT to create keyed functions for encrypting and decrypting column values. This does require a SYS level user to grant your target schema user EXECUTE on the DBMS_ENCRYPT package. Some code will be provided. To follow along with this presentation, it will help if the class participant has a working knowledge of Oracle 11g’s object types and a basic knowledge of Oracle’s encryption technology.
Speaker(s):
- David Gonzalez
Track and Room: Michelangelo - N/A
Title: Introduction to ElasticSearch
Abstract: ElasticSearch is based on a Lucene core and is an easily and highly scalable search engine. We’ll start with an introduction and overview of what ElasticSearch is and how it works. We’ll cover the ElasticSearch query language, it’s architecture and scalability model. We’ll talk about some of the different roles that ElasticSearch can play in a Big Data architecture. We’ll wrap up by starting a couple of ElasticSearch nodes and showing how easy it is to startup, cluster, and run queries against ElasticSearch.
Speaker(s):
- David Gonzalez
Track and Room: Lucas - N/A
Title: Oracle Transportable Tablespaces
Abstract: Show how to move data between oracle databases at the tablespace level in place of doing a table rebuilds. Moved a 15TB EDW from AIX to Linux Oracle Database in one day. Overview of the tools,concepts and methodology used for this project.
Speaker(s):
- David Gonzalez
Track and Room: Rodin - N/A
Title: Essentails of a Big Data Architecture
Abstract: This presentation discusses the essentials of a Big Data architecture and how technologies are being used to influence different decisions. Scott will also discuss the skills and processes required to make a successful implementation work.
Speaker(s):
- David Gonzalez
Track and Room: Gym 1 - N/A
Title: Big Data in Sports
Abstract: Big Data has arrived within elite sports organizations. Similar to what has been observed outside of the sports industry, the typical organization struggles to make sense of how it can take advantage of Big Data and more generally, Analytics. In addition, similar to what researchers have found, top-performing organizations are gaining a disproportionate competitive advantage from their analytics projects relative to low-performing organizations. Using examples from his Sports Analytics consulting experiences, Mike provide insights into the use of Big Data and Analytics in the sports industry. In addition, he will present a framework that his clients use to increase the likelihood of success with their analytics programs.
Speaker(s):
- David Gonzalez
Track and Room: Atrium - N/A
Title: Scaling DNA Data Processing with HBase and Hadoop
Abstract: The problem with most academic algorithms is they work well at 5, 10, or even 1000 samples, but when scaling that algorithm to handle tens of thousands of samples they simply fall apart. Ancestry.com faced this challenge after the launch of the Company’s new AncestryDNA test in 2012, which measures 700,000 markers of a users’ DNA to predict ethnicity and provide living cousin matches. To match 700,000 markers in a users’ DNA to every new 700,000 marker sample that enters the database on a weekly basis quickly creates an N-squared problem. Ancestry.com’s scientists and engineers, ran up against the limitations of the academic algorithm GERMLINE which finds hidden family relationships within a reservoir of DNA. Because the reference implementation of GERMLINE didn’t scale, the teams worked closely together to re-conceptualize the algorithm to make it scale for hundreds of thousands of samples using Hadoop and HBase.
Speaker(s):
- David Gonzalez
Track and Room: Atrium - 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: Michelangelo - N/A
Title: Getting to Step 1: Automatic Installation of Big Data, Cloud, Web and HPC Cluster
Abstract: Abstract: Every major big data, cloud and HPC application vendors’s documentation says the same thing: “First install a cluster…” It turns out “first install a cluster,” or Step 0, is a harder problem than most people expect or consider at the beginning of a big data or cloud project. Getting a consistently configured OS and applications on sometimes heterogeneous hardware can be a tedious long drawn out affair, even with Devops tools. StackIQ Rocks is based on the HPC Open Source Rocks project. It has been adapted to deploy large scale big data systems as it does for large scale HPC systems. Stackiq Rocks enables a fast efficient deployment of the entire or partial big data or cloud stack of software for RedHat variants.
Speaker(s):
- David Gonzalez
Track and Room: Michelangelo - N/A
Title: A travelers’ guide to Vertica
Abstract: In which I share my experience using the Community Vertica Analytics database. I’ll explore the following questions as my experience and research has informed me: • Overview of the Vertica DB analytical system, and some reasons to consider it (columnar, compression, rich SQL, R integration, distributed DBs, community version free up to 1TB). • Strengths of Vertica, weaknesses. • What are Vertica projections? My success and lack of success using them to make queries run more efficiently. • R integration overview: how to use R in Vertica SQL queries.
Speaker(s):
- David Gonzalez
Track and Room: Atrium - N/A
Title: Getting Down on the CouchDB
Abstract: CouchDB is a beautiful creation. It is a versioned document database with live updating map reduce indexing. It’s ACID, Multi-master, and sports a clean JavaScript/JSON REST interface. Because of some of it’s low level differences it really shines. This talk will show you why. We’ll cover: - CouchDB core fundamentals - Illustrate CouchDB’s strengths - Cover iCouchDB’s weaknesses and how to deal with them - Walkthrough simple steps to integrate CouchDB into an application - Walkthrough using CouchDB in a disconnected peer scenario
Speaker(s):
- David Gonzalez
Track and Room: Lucas - N/A
Title: Bulletproof Database Deployments
Abstract: Have you watched a DBA’s facial expression when a developer says I’m giving you an automated deployment script? How can you assure your DBA that it won’t fail? Deployment scripts a DBA runs may also be a risk. Saying “it worked on my machine” doesn’t cut it.
Learn strategies to ensure your schema deployment goes smooth as silk. Including how and when to test deployment scripts, how to keep in sync with production schema changes, how to write transactional deployment scripts, how to back out schema changes with minimal data loss, and other great tips.
You’ll leave with a better understanding of these techniques and how a botched database deployment can be avoided.
Speaker(s):
- Stacey Glossner
Track and Room: Spielberg - N/A
Title: Introduction to Cassandra
Abstract: Apache Cassandra is a massively scalable NoSQL database. Cassandra is in use at Netflix, eBay, Twitter, Urban Airship, Constant Contact, Reddit, Cisco, OpenX, Digg, CloudKick, Ooyala, and more companies that have large, active data sets. The largest known Cassandra cluster has over 300 TB of data in over 400 machines. Cassandra is fault tolerant with no single point of failure, performant, fully-decentralized, durable and gives the developer control over the desired consistency, availability and partitioning (CAP) tradeoffs. This presentation provides a brief overview and introduction to Cassandra for those wishing to understand if Cassandra is right for them.
Speaker(s):
- David Gonzalez
Track and Room: Gym 1 - N/A
Title: Hadoop Shuffle - the Magic Behind Map Reduce
Abstract: There are numerous blogs and talks about the map reduce paradigm which explain how map reduce works at an abstract level; you’ve likely seen how to write a word count application in map reduce more than once. But to understand how a map reduce job will perform, you also need to know how Hadoop feeds data from the mappers to the reducers. The shuffle phase provides the glue between mappers and reducers running on different nodes, and ensures that reducers get their data in a sorted fashion. In this session, we will explain how Hadoop shuffles and sorts data. We will also talk about some practical implications this has for the performance of certain common map reduce operations, such as joins, and some of the tuning parameters that can help your map reduce applications run faster.
Speaker(s):
- David Gonzalez
Track and Room: Gym 1 - N/A
Title: You Can Do That? Using Predictive Analytics To Improve Graduation Rates
Abstract: Western Governors University (ranked 28th on the 2013 Fast Company 50 Most Innovative Companies list) has a unique educational model that creates a unique challenge. WGU pioneered competency-based, self-paced higher education. But, in a self-paced model, how can WGU know which students are struggling? If a student has done nothing in two weeks, is the student on vacation or thinking of dropping out? In order to determine which students need help and when they need the help, WGU developed unique data capture technologies and utilized “big data” architectures and tools and a bleeding edge predictive analytics product. As a result of this work, WGU can not only identify at-risk students but also personalize the entire higher education experience for its students. In this session, Niel Nickolaisen, CIO at WGU, explains the opportunity and the specific things WGU has done to deploy accurate predictive analytics. He also explains the future of predictive analytics at WGU.
Speaker(s):
- David Gonzalez
Track and Room: Gym 1 - N/A
Title: Classification and Regression in Clojure
Abstract: Starting with a set of data how can we go about importing, cleaning, understanding, and modeling a predictive system using the Clojure language and JVM platform libraries? We’ll cover some of the topics relating to data transformation, feature extraction, cross-validation, and model reuse applied to a real world problem. Though we’ll be presenting examples in Clojure, many of the concepts and ideas can be applied to any platform or language.
Speaker(s):
- David Gonzalez
Track and Room: Rodin - N/A
Title: AWSDynamo Lessons Learned:
Abstract: Learn about how we are saving two orders-of-magnitude in cost implementing a global time-series datastore for devices in ad-hoc networks. Minimum requirements: receive 50 sensor values per device every minute and store them for 10 years. |- Objectives and rationale for selecting AWS |- Developing a data lifecycle and API (hot and cold) |- Projecting costs and ROI |- Datamodel (keystore anti-patterns): (a.) AWS’ affinity for Availability over C P. (b.) Avoid scans! write-time materialized views. (c.) Read/write-through caching: update-if-same consistency. (d.) Secondary indexes and CAP tradeoffs: AWSDynamo LSI vs. Cassandra and Riak, no silver bullet: cross-shard queries (“locals only”). (e.) Details about designing a smart hash strategy.
Speaker(s):
- David Gonzalez
Track and Room: Lucas - N/A
Title: Big Data Lambda Architecture Overview
Abstract: When most people think of processing terabytes and even petabytes of information, they often think of batch processing. After all, processing platforms like Hadoop or Cassandra are batch-oriented. While adding processing nodes can reduce processing latency, it does not address desired “real-time” processing requirements. How can you process big data sets in real-time while leveraging batch-oriented Big Data infrastructure? By example, how do services like Twitter consider the vast quantities of tweets, past and present, to provide real-time trending analytics? The answer lies within the architectural patterns of what is called Big Data Lambda Architecture. In this session we will establish the context of the Lambda Architecture and explore the architectural patterns and practices of implementing it to provide both a low and high latency Big Data processing capability to your business.
Speaker(s):
- David Gonzalez
Track and Room: Gym 1 - N/A
Title: Open Design and Discussion session
Abstract: We are leaving the room open and staffing it with various data professionals at different times. The goal will be to allow discussion of any data topic that the group would like to talk about. At registration the day of the event we will have a list of various people and topics that will be in the room at different times and you can choose to attend at various times.
Speaker(s):
- David Gonzalez
Track and Room: Rodin - N/A
Title: Database Monitoring : Trying To Keep Sane
Abstract: Each of our database systems has its complexities, its idiosyncrasies, its touchy points. Digging into each of these, understanding them, baselining them and monitoring them is an essential part of a DBA’s job. Doing these simple tasks in such a way that allows you to sleep at night while your systems churn away safely and gracefully is an art that we all attempt to accomplish. We will discuss various ideas, tools, approaches, and solutions to how to monitor different pieces of our systems. Examples, code, tools, will all be shown off and shared so we can all do better.
Speaker(s):
- TJay Belt
Track and Room: Michelangelo - N/A
Title: Introduction to Machine Learning.
Abstract: Can a computer learn? Machine learning is all the craze in the industry. But what is it that machine learning can do? This session we will pull back the covers on machine learning and examine how a machine can actually “learn”.
Speaker(s):
- David Gonzalez
Track and Room: Michelangelo - N/A
Title: SSIS Metric Performance Collection (Case Study)
Abstract: When architecting a data integration solution, the design decisions not only determine how successfully the solution meets functional requirements, but also how well the solution meets performance requirements. To make the right performance design decisions, you need to understand the performance architecture of the integration tool and, just as importantly, the techniques that enable you to maximize the tool’s utilization of system resources.
This presentation will discuss how we created the storage area for the metrics and how capturing metrics was implemented.
Speaker(s):
- Scott Heffron
Track and Room: Rodin - N/A
Title: Getting to visualizations from Big Data fast
Abstract: Learn about the familiar tools for sampling data from HDFS and MongoDB using Excel 2013 and the Hive, and Power Query add-ins. Our focus is on quickly getting to insights derived from NoSQL and Big Data solutions by using one of the most commonly used BI tools. We will provide an end-to-end example while providing best practices for accomplishing one of the following. -Move a metric -Change a behavior or process -Change a product By way of the tools we will demo, we will demonstrate how to simplify information discovery and retrieval, making it possible for decision-makers at all levels of an organization to more easily access, understand, analyze, share, and act on information quickly.
Speaker(s):
- David Gonzalez
Track and Room: Gym 1 - N/A
Title: “Big Data” - Utah’s Strong Position for Building a Big Data Cluster
Abstract: Utah has one of the most advanced high tech sectors of any state in the United States that has grown for the last thirty years with key strengths in enterprise software, networking software, cloud technologies, and data centers. All of these are key components to developing a strong “big data” cluster and with the right positioning and collaboration, Utah can build on its core cluster strengths to become a place with deep competencies and strong differentiation in the “big data” world.
Speaker(s):
- David Gonzalez
Track and Room: Gym 1 - N/A
Title: Master Data Services – 101
Abstract: Master Data Services (MDS) is a Master Data Management solution on the Microsoft Platform. This solution enables the management of non-transactional data (nouns) within the enterprise. Get a good business and technical understanding of how MDS can help your organization obtain better data governance. The demo will walk through the basics of getting started with Master Data Services 2012, including the Excel Add-in for Master Data Services.
Speaker(s):
- Reeves Smith
Track and Room: Michelangelo - N/A
Title: Cure for Data Impetancy
Abstract: Whether you have small data, massive data, clean data or wild data you need a strategy in order to see a return on investment. This session will cover how to clearly define a data related business problem, obtain tools and skill sets and follow through with how to track and present a data project’s R.O.I.
Speaker(s):
- David Gonzalez
Track and Room: Spielberg - N/A
Title: What secrets does your database schema hold?
Abstract: Flaws in database design can hurt you in many ways. This session will look into one of the most basic building blocks, using the correct data type when designing a table. We will look at different databases with best practices in mind to uncover any underlying design flaws in their design. Having a solid foundation can help eliminate data integrity and performance issues that could be lurking. Inconsistent field lengths and data types are examples of secrets that will be unveiled.
Speaker(s):
- Andre DuBois
Track and Room: Spielberg - N/A
Title: Locks, Blocks and Isolation Oh My!
Abstract: Have you ever seen or used “WITH (NOLOCK)” in T-SQL? Do you know what it does and its side effects? Is SQL Server optimistic or pessimistic when it comes to locking? Can it be both? In this session we will cover these questions and discuss how and why SQL Server takes locks and how that affects other users. We will go over alternatives for using NOLOCK and discuss when it is appropriate to use. In addition, we will discuss what are the ACID properties and how to monitor locks and blocks.
Speaker(s):
- Keith Tate
Track and Room: Lucas - N/A
Title: Troubleshooting SQL Server with SysInternals Tools
Abstract: In this demo-packed session we will explore the use of SysInternals tools like Process Monitor, Process Explorer, and many others to troubleshoot various problem scenarios with SQL Server. This session is not for the faint of heart and is tailored toward those adventurous DBAs who often like to step out of their comfort zone. A fair knowledge of Windows OS internals is recommended.
Speaker(s):
- Argenis Fernandez
Track and Room: Spielberg - N/A
Title: Unleash the Power of PowerPivot
Abstract: Are your Excel Pivot tables a little out of hand? Do you want something more powerful, but not more difficult? PowerPivot is the answer! Tame your data and impress your co-workers with this simple to use new tool that is a free add on to Excel.
Speaker(s):
- Andrea Allred
Track and Room: Lucas - N/A
Title: SSIS 2012 - Best Practices and Design Patterns
Abstract: Unsure of how to use new SSIS 2012 features productively? Need to ensure you are using best practice configuration options? This session will be a deep dive into proven best practice ways of using SSIS 2012 including Parameters, Variables, Environments, Source Control, Connection Managers, and much more.
Speaker(s):
- Joe Salvatore
Track and Room: Atrium - N/A
Title: SQL Server 2012 Column Store Index
Abstract: Take your relational data warehouse query performance all the way to ELEVEN!! The Column Store Index is a new feature that allows for stunning performance. We will cover how it works, why it is so fast as well as the v1.0 limitations and gotchas.
Speaker(s):
- Kevin Boles
Track and Room: Spielberg - N/A
Title: T-SQL Tips Tricks Part 2
Abstract: Do you ever wonder how you can make T-SQL do what you really want? Do you want to know how to make it jump through loops, perform amazing twists and turns, and execute other wondrous performances? In this session you’ll learn even more tricks about various features such as the ever complex CTE, query windowing, and other great features that will enable you to make your T-SQL queries and stored procedures more efficient and give you the results you really want.
Speaker(s):
- Aaron Cutshall
Track and Room: Atrium - N/A
Title: A simple framework for presenting complex data.
Abstract: Your data is spring-loaded with possibilities. How you present your data can build — or break — relationships. You have 2 choices; either, develop a strategy to make your big data meaningful, or bury your audience with boring data and trust that the gods will clean up the mess. The choice is yours; eyes open or closed.
Speaker(s):
- David Gonzalez
Track and Room: Spielberg - N/A
Title: Getting Started with Execution Plans
Abstract: You just received a phone call from your boss 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, the first thing 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: Spielberg - N/A
Title: SQL 2012 Extended Events
Abstract: Extended Events were introduced in SQL Server 2008. With SQL 2012, we have seen a significant upgrade to this feature. Join me for a little adventure into what extended events are. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events.
Speaker(s):
- Jason Brimhall
Track and Room: Lucas - N/A
Title: Becoming Certified In Microsoft SQL Server
Abstract: Becoming certified in SQL Server is a great career enhancement for a database professional. This session will provide you with an overview of the SQL Server Certification program, including the numerous changes made to the program for SQL 2012. You’ll discover several reasons why you should become certified, and some of the best ways in which to do so. You’ll also leave the session armed with some tips and tricks for passing the exams that the presenter has used over the last twelve years.
Speaker(s):
- Chris Hyde
Track and Room: Michelangelo - N/A
Title: SQL Server 2012: To NAS or not to NAS, that is the question
Abstract: With the release of SQL Server 2012, Microsoft introduced full support for SMB offering the ability to install SQL Server 2012 with both system and user databases on SMB file shares. This allows you to build end-to-end NAS solutions with much more flexibility than SAN storage, and enables new scenarios such as volume auto grow and shrink. In this session we will review the benefits of NAS storage and demystify SMB - and show you how to easily install and configure SQL Server over SMB and VMware NFS on NetApp storage as well as best practices, caveats, and performance.
Speaker(s):
- Pat Sinthusan
Track and Room: Atrium - 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.
Argenis Fernandez
Twitter: - DBArgenis
LinkedIn: Argenis Fernandez
Contact: http://blog.purestorage.com/author/argenisfernandez/
Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.
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.
Stacey Glossner
I’ve been working with databases in some capacity the last 20 years. I grew up in network and database administration, followed by web and C# application development. I am currently a database architect is the Salt Lake City area. I love my job and I’m passionate about databases.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
Ben Miller
Twitter: - DBAduck
LinkedIn: Ben Miller
Contact: https://dbaduck.com
Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
Keith Tate
Contact: http://www.thesqlchef.com
Keith Tate is a Senior Database Administrator with over 14 years of experience as a data professional. During Keith’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.
Jason Brimhall
Twitter: - sqlrnnr
LinkedIn: Jason Brimhall
Contact: http://jasonbrimhall.info
Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
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.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
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.
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.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
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.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
Pat Sinthusan
Contact: https://communities.netapp.com/
Pat Sinthusan is currently working for NetApp as a Reference Architect responsible for validating new SQL Server Solutions on the NetApp storage platform. In the past, he worked as a Sr. Database Administrator for 15 years with Hasbro and the City of Seattle. Pat has designed and implemented database infrastructures for the entire range of environments (development and production) using various storage technologies, and he#39;s been working with SQL Server since 4.21B.
Andrea Allred
Twitter: - @RoyalSQL
LinkedIn: Andrea Allred
Contact: http://www.RoyalSQL.com
Once upon a time in a kingdom not far away, Andrea was sick of answering phones and filing forms. Her kingdom was running low on gold and the wise wizard told her to find work that she loved and she would never truly work a day in her life. When she found the magical SQL Server, she knew it was the calling for her. She is passionate about SQL Server, “works” as a Database Administrator, loves her #SQLFamily and finds joy in helping others find their passion too. She is celebrating her 15th year with SQL Server this year.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
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
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
Joe Salvatore
Contact: http://datadesignpro.com/
Joe is an accomplished Business Intelligence Architect with Pragmatic Works. For over 15 years, Joe, has designed complex business intelligence solutions for customers throughout all of North America. His focus on architecting the right hardware and software solution along with implementing best practice dimensional models has earned him high praise from customers.
Scott Heffron
Contact: http://www.CTR-SQL.com
Scott Heffron has been developing database integration processes for 20+ years. His initial project was a GIS project that transferred data between Oracle, SQL Server, and Sybase. He has been working in the integration area ever since. He is currently working on integration project that analyzes data across multiple carriers.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
David Gonzalez
Contact: http://boapw.com
David Gonzalez is working with some of the brightest minds in the local market to marry data science, storytelling, and software with a project called Ziff.
Aaron Cutshall
Twitter: - sqlrv
LinkedIn: Aaron Cutshall
Contact: http://sqlrv.com
Aaron N. Cutshall is an Enterprise Data Architect with 20 years of experience in analysis, design and development for applications and databases in manufacturing and warehousing plus over 15 years in the Healthcare Informatics field. His primary focus is in designing and developing solutions for extremely large data sets that perform quite well in SQL Server. He is active in the SQL Server community and speaks at SQLSaturday sessions across the country.
Sponsors
The following is a list of sponsors that helped fund the event: