SQLSaturday #297 - Colorado Springs 2014
Event Date: 04/12/2014 00:00:00
Event Location:
- 1628 West Bijou Street
- Colorado Springs, Colorado
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Faster Leaner: Optimize DW Solution Delivery with Power Pivot and AS Tabular
Abstract: You may not see this in the marketing materials, but the reality is PowerPivot and AS Tabular together provide some powerful options for Data Warehousing professionals. This session is for DW dimensional modeling pros interested in streamlining optimizing the design delivery process for enterprise-quality data marts dimensional semantic models.
We’ll touch on Agile Lean disciplines, how they can be applied to DW solution delivery. Then we’ll walk through demos of practical applications in the form of PowerPivot POCs prototypes that can be promoted to AS Tabular models and refitted to the finished DW structures once delivered. We’ll focus on key DW challenges and how these technologies and techniques can be used to speed and improve effectiveness of requirements gathering and user testing, optimize sequencing of deliverables, minimize risk of rework and ultimately deliver quality DW solutions successfully.
Speaker(s):
- Brent Greenwood
Track and Room: Track 3 - N/A
Title: SQL Server Murder Mystery Hour: Dead Reports Don’t Talk
Abstract: SABOTAGE? MURDER?
Before a pivotal meeting to secure venture capital, a key report vanishes from the server without a trace, leaving Cromulent Technologies’ future in jeopardy. Our group must solve the crime. Time is critical as the CEO has promised to explain the matter to investors just sixty minutes from now. Only with your investigative skills, SQL Server knowledge, and teamwork can we find the missing report, bring the perpetrator to justice, and save Cromulent Technologies!
SQL Server Murder Mystery Hour is part technical presentation, part networking event. We’ll focus on Reporting Services administration in areas that are vital to business continuity: security roles, encryption keys, and backups. All attendees have a part to play.
Speaker(s):
- Doug Lane
Track and Room: Track 3 - N/A
Title: Tabular Data Modeling and Visualizations
Abstract: In this session, we will look at Tabular Data modeling, the life cycle of Tabular Models, and visualization tools available in the Microsoft Business Intelligence Stack. We will build a tabular solution from scratch and discuss use cases and differences between Tabular and Multidimensional Data Models. Finally, we will take a look at the data visualization tools in the Microsoft BI Stack including: SharePoint Integration, Excel Services, and Power View. This demo heavy presentation will cover a wide variety of topics and tools equipping attendees with the knowledge to start developing Tabular Data models and understanding how to use Data Visualization tools to effectively empower users with self-service BI and drive efficiency across the organization.
Speaker(s):
- Rob Schafer
Track and Room: Track 4 - N/A
Title: SMO Internals for High Performance PowerShell
Abstract: Ever wanted to know what happens behind the scenes 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 a few common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. We will dive deep through the collections that make SMO the powerful tool it is. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come peek behing the curtain and squeeze the speed out of your automation scripts using PowerShell and SMO. You’ll be glad you did.
Speaker(s):
- Ben Miller
Track and Room: Track 1 - N/A
Title: Capture Change and Apply it With Change Data Capture SSIS
Abstract: Whether you are trying to setup a new data warehouse, keep it updated, audit changes to your databases or quickly load changes to another database Change Data Capture (CDC) is a solution for all of these and can now be setup and supported easily with SQL Server SSIS 2012! Change Data Capture (CDC) has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it is setup on your databases. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes.
Speaker(s):
- Steve Wake
Track and Room: Track 4 - N/A
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: Track 4 - N/A
Title: Tabular Models
Abstract: Tabular modules allow developers to create models based upon different data sources; create hierarchies, perspectives, partitions and roles similar to traditional OLAP cubes. In this session will highlight the differences between traditional OLAP and tabular models and reasons for selecting one approach over another. I will demonstrate how to create a data model first in power pivot model and then import into an Analysis Services Tabular Project. Working with the imported data I will then create measures, KPIs, perspectives, and implement security. Finally I will deploy the model to an Analysis Server.
Speaker(s):
- Jeff Renz
Track and Room: Track 2 - N/A
Title: I Don’t Know Which Queries Are Slow, Just Make All of Them Faster
Abstract: Shortly after learning how to troubleshoot a poorly performing queries it’s not unusual for a DBA to discover a nasty surprise - some (or perhaps most) of your users will not be able to actually tell you what query is performing poorly. The good news is that SQL Server does know! This session covers some of the basics of looking through the plan cache for slow queries, including some tips on spotting potential parameter sniffing issues when you don’t have the luxury of actual execution plans.
Speaker(s):
- Rick Lowe
Track and Room: Track 4 - N/A
Title: Database Design: Size DOES Matter
Abstract: Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency.
Speaker(s):
- Thomas LaRock
Track and Room: Track 4 - N/A
Title: Back the Truck Up
Abstract: Performance tuning backups? Yes. Performance tuning backups. As your data grows, so does your DR profile. In this session we’ll take a look at how different backup configuration options affect both the performance of your backups as well as the performance of your server during the backups. Of course, this is also sneaky way to introduce a real-world use of Extended Events during the process.
Speaker(s):
- Seth Washeck
Track and Room: Track 2 - N/A
Title: Type More, Click Less: Programmatically build SSIS packages
Abstract: Developing repetitive strain injury (RSI) from all those mouse clicks in Business Intelligence Development Studio/SQL Server Data Tools? Longing to automate the tedium in SQL Server Integration Services package creation? In this session, we’ll explore the Integration Services object model and learn how to create rich packages without ever clicking our mouse. You’ll learn about the basic object model, the EzAPI wrapper for it, as well as using BIMLScript to build moderately complex packages.
Speaker(s):
- Bill Fellows
Track and Room: Track 3 - N/A
Title: Dr. DMV’s Troubleshooting Toolkit
Abstract: Dynamic Management Views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates and explains numerous DMV queries that you can quickly and easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases.
Speaker(s):
- Glenn Berry
Track and Room: Track 1 - N/A
Title: Managing Log File Obesity
Abstract: Have your efforts to trim a few pounds off your log file been met with frustration? Are you scratching your head on why that DBCC SHRINKFILE doesn’t seem to do anything? Log file obesity is a problem that can challenge DBAs of any level. This session will help you deal with your overweight database by covering how log files grow, why truncating the log is a bad idea, and what you can do to keep your files trim and fit.
Speaker(s):
- Michael Fal
Track and Room: Track 2 - N/A
Title: Virtualizing our Environment
Abstract: This session will describe our journey to convert our cluttered, underutilized, power draining physical hosts to a sleek virtualized environment. This session will also provide some VMware high level architecture, terms and concepts, and a look at vSphere (VMware admin console). I’ll discuss the differences between virtual and physical host metrics and issues surrounding them. We’ll discuss some virtualization shortcomings and then show a little about Confio’s Ignite and how it can help DBAs achieve virtualization and not lose visibility of their physical layer.
Speaker(s):
- Rob Mandeville
Track and Room: Track 2 - N/A
Title: SQL Server performance management
Abstract: discuss approaches to SQL Server performance management from both Resource and Wait State perspectives, and ways to use these approaches using both native utilities and Dell Software tools
Speaker(s):
- Kat Long
Track and Room: Track 4 - N/A
Title: DBA Survival Guide: Daily Checklist and Server Monitoring
Abstract: You are responsible for the health and welfare of the servers, and the databases under your command. What should you check daily? How about weekly? Should you automate? We will discuss all these things, and how having a Daily Checklist, and monitoring your server will help you maintain balance in the galaxy.
Speaker(s):
- AJ Mendo
Track and Room: Track 1 - N/A
Title: SQL Server Databaseology 201: A Study of Database Internals
Abstract: Did you take apart your Mom’s toaster or your Dad’s alarm clock just to see how it worked? Ever wonder how that database you built or support works behind the scenes at the record level? SQL Server Databaseology 201 is the science concerned with the study of SQL Server databases and their structures down to the very records themselves. This session will explore some of those deep inner workings of a SQL Server databases. The attendee will walk away with a better understanding of how SQL Server databases work which would allow them to build better and faster databases.
Speaker(s):
- John Morehouse
Track and Room: Track 1 - N/A
Title: The Accidental Report Designer: Data Visualization Best Practices in SSRS
Abstract: Whether you are a DBA, a developer, or an analyst, there is a good chance that you will have to create reports for coworkers, company executives, or clients. As with any UI design, careful consideration should be given to your data visualization design to ensure you are effectively communicating the intended message and providing a good user experience. While the principles are applicable across reporting platforms and tools, this session will contain demos and examples implemented in Reporting Services using SQL Server Data Tools. Learn how to make information (not just data) the focus of your report and provide your audience with something better than just shiny!
Speaker(s):
- Meagan Longoria
Track and Room: Track 3 - N/A
Title: Documentation – you know you love it
Abstract: We will discuss some of the most important things that you as a Data Professional can document to make your job much easier, ensure information consistency between groups, and better prepare your organizations for raising the bar on your day to day business. Think of this as a sort of Database Library that allows you to finally detail the processes you follow currently to perform repetitive tasks. This Library will also allow you to simply document your systems for your and others knowledge.
Speaker(s):
- TJay Belt
Track and Room: Track 2 - 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 and some Integration Services packages.
Speaker(s):
- Reeves Smith
Track and Room: Track 3 - N/A
Title: The Curious Case of Isolation Levels
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: Track 1 - N/A
Title: Managing SQL Server Performance with Extended Events
Abstract: One of a DBA’s primary responsibilities is managing the performance of a SQL Server environment. When performance problems arise, DBAs need to have the correct tools in place to be able to dig in and discover the issues that are occurring. Although it’s one of the newer tools in the DBA toolbox, Extended Events is one of the most powerful tools available. In this session, we will discuss performance management responsibilities for DBAs and provide a foundation, through Extended Events, to understand and resolve performance issues.
Speaker(s):
- Jason Strate
Track and Room: Track 1 - N/A
Title: XPath - XQuery; I guess if I HAVE to
Abstract: I don’t know anyone who likes it. But the reality is sooner or later you’ll have to use XML in your database career. It appears in extended events, ring buffer queries, and more and more in stored procedures and columns. Attend this session to find out what you need to know to leverage xpath, xquery, and semi-structured data in administering databases.
Speaker(s):
- Russ Thomas
Track and Room: Track 4 - N/A
Title: Advanced Spatial Analysis: Beyond Bubble Charts
Abstract: Are you finally ready to unlock the power in your spatial data? In this session, we will explore some advanced spatial analysis techniques, including clustering, binning, and the basic use of spatial statistics. We will then discuss several options for visualizing the results in SQL Server Reporting Services and PowerPivot. Get ready to go beyond bars and bubble charts!
Speaker(s):
- Jason Horner
Track and Room: Track 3 - N/A
Title: Native File Streaming with SQL Server 2012
Abstract: In this dynamic session, Lenni will teach you the ins-and-outs of unstructured data storage and native file streaming with FILESTREAM (introduced in SQL Server 2008) and FileTable (new in SQL Server 2012). Learn how to program FILESTREAM using T-SQL and, for maximum performance, using the OpenSqlFileStream API in C#. We’ll also cover the hierarchyid data type, which casts a hierarchical structure over every FileTable, and wrap up with the full-text search improvements and new Statistical Semantic Search in SQL Server 2012 that you can leverage to get the most out of unstructured documents contained in your databases.
Speaker(s):
- Leonard Lobel
Track and Room: Track 2 - N/A
Title: SSIS Logging Reconsidered
Abstract: The advent of SQL Server 2012, SQL Server Data Tools and Integration Services Catalogs have significantly improved out of the box logging. Unfortunately, logging best practices have not evolved with the new logging tools. This talk will outline the logging available “out of the box” with SSIS and discuss the implications for “traditional” ETL logging. Logging best practices will vary by business, industry and regulatory environments. We will review examples from the most basic operational logging to the most sophisticated logging required for auditing and regulatory compliance.
Speaker(s):
- Michael Sexton
Track and Room: Track 3 - N/A
Title: SQL Server Replication in Practice
Abstract: SQL Server Replication is an important tool that I’ve implemented many times for reliable data movement to support Business Intelligence architectures. This includes using replication to create databases that are used as sources for data warehouses, reporting systems, operational data stores, and historical audit trails. The key concepts to consider when setting up replication will be covered, including replication type, table selection, filters, indexing, and more. Live demonstrations will show how to implement transactional replication for high performance in a real-time environment.
Speaker(s):
- Carlos Bossy
Track and Room: Track 1 - N/A
Title: The Encryption Primer
Abstract: Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.
Speaker(s):
- Steve Jones
Track and Room: Track 2 - 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.
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).
Steve Wake
Twitter: - stevewake
LinkedIn: Steve Wake
Contact: http://blog.wakebi.com
Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in consulting, advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full on-premises Microsoft BI stack. Recent experience with the Azure services: Analysis Services, Logic Apps, Data Factory, Databricks, Snowflake and Power BI. Steve is also very involved in the SQL community, speaking at events around the world.
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.
Steve Jones
Twitter: - way0utwest
LinkedIn: Steve Jones
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
Seth Washeck
Twitter: - @swasheck
LinkedIn: Seth Washeck
Contact: http://swasheck.wordpress.com
Seth Washeck, SentryOne senior solutions engineer, is a longtime SQL Server DBA, active member of the Denver SQL Server User Group, and frequent speaker at SentryOne events. He was formerly senior SQL Server DBA at OppenheimerFunds, and DBA of Baxter Healthcare.
John Morehouse
Twitter: - SQLrUs
LinkedIn: John Morehouse
Contact: http://www.sqlrus.com
John Morehouse is currently a Consultant with Denny Cherry Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member Community Ambassador, and 2016 Idera Ace. John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible. He is a user group leader, SQLSaturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQLSaturday’s as well as other conferences.
Leonard Lobel
Twitter: - @lennilobel
LinkedIn: Leonard Lobel
Contact: http://lennilobel.wordpress.com
Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner.
Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences.
Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.
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.
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.
Rick Lowe
Contact: http://www.lanl.gov
Rick is a MCM who has been working with SQL Server for almost 15 years, working with versions from 6.5 through 2012. He is a recovering developer who has transitioned from development towards administration over the course of his career. He is happiest when turning indexes and queries, but enjoys all things SQL.
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
Thomas LaRock
Twitter: - @SQLRockstar
LinkedIn: Thomas LaRock
Contact: http://thomaslarock.com
Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.
Brent Greenwood
Twitter: - @YoungMSQL
LinkedIn: Brent Greenwood
Contact: http://brentgreenwood.blogspot.com/
Brent Greenwood, MS, MCITP, CBIP, is a PowerPivot junkie and long-time Microsoft BI Pro with 13+ years of experience in the data analysis, data warehousing, and business intelligence crafts. He’s delivered solutions and worn lots of different hats in a variety of verticals, including Investment Management, Brokerage, Insurance Services, Healthcare, and Higher Education. Most importantly, Brent is a cycling enthusiast and loves riding and building prototypes with AdventureWorks cycling data.
Rob Mandeville
Twitter: - https://twitter.com/rob_mandeville
LinkedIn: Rob Mandeville
Rob Mandeville is a Senior DBA with over 20 years of broad experience in database technologies.
He’s served in many roles including production DBA, development DBA, and architect/data modeler on a variety of platforms.
Before coming to Solarwinds, Rob worked in the aerospace, global technology, and geospatial industries.
Rob also had the honor of teaching database related master level courses at Regis University.
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.
AJ Mendo
Twitter: - @SQLAJ
Contact: http://sqlaj.wordpress.com/
AJ has over 14 years of experience working with a variety of databases. He has worked for military, civilian, and federal government organizations supporting a wide variety of applications.
AJ is a frequent speaker at user groups, SQLSaturday#39;s, and PASS Virtual Chapters, and is a board member POSSE and CACTUSS. He is a PASS Programs Committee volunteer, and he loves being a part of the SQL Community.
Doug Lane
Contact: http://www.douglane.net
Doug Lane (MCITP, MCTS) is a consultant with Brent Ozar Unlimited and has over 14 years’ experience with SQL Server. He blogs about SQL Server with emphasis on Reporting Services and professional development.
Jason Strate
Twitter: - @stratesql
LinkedIn: Jason Strate
Contact: http://www.jasonstrate.com/
Jason Strate is a SQL Server Solutions Architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. Jason writes, blogs, and presents on SQL Server.
Kat Long
Twitter: - @KatSQL
LinkedIn: Kat Long
Contact: http://blogs.xtivia.com/
Kat has been working with SQL Server since 1998 starting with SQL Server 6.5 up to the latest and greatest. Over the years, Kat has worked in many different environments from manufacturing to dotcoms to military and government institutions, and is now back in the private sector. Currently, as a Senior DBA at Xtivia, she is focused on monitoring SQL Server installations and troubleshooting performance issues.
Rob Schafer
Contact: http://www.emc.com/services/emc-consulting.htm
Rob Schafer is a Senior Consultant for EMC focusing on the SQL Server Business Intelligence stack. For the past several years, Rob has been architecting, developing, and leading complex Business Intelligence projects spanning multiple industries that include: Financial, Insurance, Healthcare, Telecommunications, Aerospace and Defense, Legal, and Hospitality. He holds a Master’s degree from the University of Denver and also has his MCTS in Business Intelligence and Database Development.
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.
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.
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.
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.
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
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.
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.
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.
Sponsors
The following is a list of sponsors that helped fund the event: