SQLSaturday #680 - Kansas City 2017
Event Date: 10/07/2017 00:00:00
Event Location:
- Rockhurst University
- 1100 Rockhurst Road
- Kansas City, Missouri
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: Make Power BI Your Own with the Power BI APIs
Abstract: Power BI makes accessing data from various sources and building advanced visualizations for analytics easy to do. Behind the scenes Power BI is built on standard technologies and APIs that allow it to be customized in multiple ways to fit in with your environment the way you need it to. In this session we will walk though samples and demos that show how you can extend Power BI with custom visualizations, access custom data sources, embed various Power BI elements in your applications, and be able to push your data into a Power BI report/dashboard. Each of these items take advantage of the Power BI APIs in different ways and we will discuss each and provide the code samples for you to take back and get a head start. This session will be showing code to access the Power BI REST API using C# and NodeJS along with some M for accessing and manipulating custom data sources.
Speaker(s):
- Steve Wake
Track and Room: BI Platform Architecture, Development Administration - ARP 210
Title: Working with Temporal Data in SQL Server
Abstract: In many industries, it is necessary for data professionals to be able to show what a data set looked like at a previous point in time. Whether it’s calculating tax or insurance rates based on a contract date, quickly comparing data changes over time for trend analysis or just recovering from an accidental data change, it’s useful to be able to look back in time through our data. SQL Server has long offered solutions like Change Data Capture or trigger-based audit tables, though those aren’t always the best solutions for each situation. SQL Server 2016 introduces system-versioned tables, which track data through time with far less overhead than other solutions. In this session, you’ll learn how to work with tables for each kind of solution, how SQL Server manages data within those tables, and how to query data at a specific point in time using several real-world examples. Attendees will leave with a fundamental understanding of practical use cases for different types of temporal tables.
Speaker(s):
- David Maxwell
Track and Room: Application Database Development - ARP 114
Title: Data Modeling for the Modern Enterprise
Abstract: This session is theoretical with a focus on the many ways that we can model data. We will discuss why we select one modeling technique over the other in different user scenarios. These different scenarios will vary by industry and company, two main scenarios include: purchasing a product and storing the data related to the sales transaction, or visualizing the total sales for a product, month over month, for the calendar year 2016. Diagrams will be used to explain these different models and try to bring a more tangible aspect to the theoretical aspects of the discussion. Demos using IDERA ER/Studio Data Architect will be used to conclude the presentation.
Why Model Data • Business Benefits and Value
Different Model Types • Enterprise Model • Conceptual Model • Logical Model • Physical Model • Dimensional Model
Different Modeling Techniques • Normal Form Modeling • Star Snow Flake Schema • Slowly Changing Dimensions • Many to Many Relationships
Speaker(s):
- Ryan Casey
Track and Room: BI Platform Architecture, Development Administration - ARP 218
Title: Remote SQL Server Troubleshooting and Monitoring Using SSIS
Abstract: We have over 3500 remote installations of SQL Server and only 3 DBAs to find and resolve issues. While some installations need daily examination others operate for months without any attention at all. We needed a system to keep a light, revolving set of data that we could quickly pull back and analyze when issues were escalated to us. This system also had to be modular so we could add or remove queries, as needed, while always keeping the data fresh. In this session I’ll use Glenn Berry’s diagnostic queries and SSIS to show how we collect and store data on our remote systems. When problems arise we download the data and use Powershell to digest it into a simple report.
Speaker(s):
- Don St. Cyr
Track and Room: BI Platform Architecture, Development Administration - ARP 224
Title: Don’t just code it—Generate It
Abstract: Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates provide by SSMS for views, stored procedures, functions. Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code.
- Source to Target mapping documents can be used to generate the code to effect the mapping.
- Service Broker activation stored procedures have a clearly defined structure. They can be mass-produced.
- Standard CRUD stored procedures can be stamped out cookie-cutter fashion.
- Business rules can be encoded in data and the code to implement them manufactured. Generated code has systematic errors. Fix the errors at the generator. All the code now works. If the code is so boring that a computer can produce it, why not spend your talent doing something interesting?
Speaker(s):
- Kevin Mackey
Track and Room: Application Database Development - ARP 210
Title: How to Keep Your Databases Secure in Just Minutes a Day
Abstract: You’re busy. You don’t have time to check the security of your systems all the time, right? It’s not like anyone has added a user that you don’t know about. And no one would create a database and add all logins to the db_owner role. And of course, no one would ever think of setting the TRUSTWORTHY property on a database… right?
Things like that happen on a daily basis, poking holes in even the most well-secured database. Those holes are just waiting for someone to find them. That someone could be you, or it could be an attacker probing for a way to get data from your company.
In this session, we will explore how to create reports that are quick to review so you can find the holes before someone else does - without interfering with the rest of your day. Along the way, you’ll also learn where to find security-related information in SQL Server’s metadata and logs to allow you to customize and extend the reports to meet your company’s unique needs.
Speaker(s):
- Ed Leighton-Dick
Track and Room: Enterprise Database Administration Deployment - ARP 218
Title: Dynamic SQL: Tables, Pivots, Parameters
Abstract: Dynamic SQL is a scripting language that helps you design flexibility into your code. It allows you to design solutions, pass parameters and allows you build a single query on values passed. Dynamic SQL has both pros and cons to it’s design, but can also be a helpful tool. This presentation will walk through the steps of building dynamic tables, aggregating data in a pivot format and give you the first steps of writing a Dynamic Query. There are hundreds of task that will benefit from the use of Dynamic SQL. From parameter based searches to building dynamic SELECT statements at run time.
Speaker(s):
- Steven Tidwell
Track and Room: Application Database Development - ARP 210
Title: Hidden Power: Service Broker
Abstract: Service Broker is a robust asynchronous programming model that provides reliable messaging between SQL Server instances. Making life easier for developers creating sophisticated applications to communicate between databases and servers.
With focusing on your basic database to database asynchronous messaging to more advance messaging across multiple servers, we are positive you will walk away with new knowledge about Service Broker. And just as positive we will learn something new with you. As some of you may know, Service Broker never ceases to surprise.
Speaker(s):
- Ankit Baria
Track and Room: Other - ARP 210
Title: Data Mining Techniques with R and Azure Batch Services
Abstract: One the unique challenges Data Science teams face is provisioning compute resources. High core counts are required for only short bursts and sit idle for long periods thereafter. A demonstration will show how one can overcome this using Azure Batch Services. After attending the session one will be familiar with the data mining workflow, data mining packages in R, as well as how to configure and use Azure VMs directly from an R session.
Speaker(s):
- Matthew Sharkey
Track and Room: Advanced Analysis Techniques - ARP 212
Title: ORMs and the DBA: How to Make Both Happy
Abstract: Talk to any DBA about ORMs and you’ll quickly find out all the things you like about ORMs are what DBAs don’t like. Interestingly enough, most developers I’ve talked to have issues with their ORMs, too. In this session, we’ll explore why ORMs cause such trouble, some strategies for mitigating those troubles, and I’ll introduce some tools (and even yet another ORM) that help solve some of the worst of the problems we see in the database when using ORMs.
Speaker(s):
- Dan Mallott
Track and Room: Application Database Development - ARP 224
Title: Source Control and Database Projects - Just Do It
Abstract: If you aren’t using database projects you should be and if you aren’t using any source control well….. NOW IS THE TIME. We’ll review basic functionality and purpose of both and walk through how they work together. Let’s talk about the type of foundation pieces you need to pay attention to and how to organize this into team and agile work. Lots of tips and tricks to remove the often experienced headaches that developers have experienced with implementing both of these items.
Speaker(s):
- Leslie Weed
Track and Room: BI Platform Architecture, Development Administration - ARP 116
Title: Introduction to R
Abstract: You will learn R data structures such as vectors, matrices, lists and data frames; how to work with variables; common data transformations; and lastly how to leverage R’s graphical capabilities.
Speaker(s):
- Jeff Renz
Track and Room: Analytics and Visualization - ARP 212
Title: SQL Unit Testing with T-SQLt
Abstract: Unit testing is an important part of application development and maintenance. Knowing that your latest change is not only providing the desired results but also is free from side-effects is critical to the rapid pace expected by your customers. This session will provide an introduction in to how you can easily create a library of unit tests around your database and its programmable objects.
Speaker(s):
- Kevin Trojanowski
Track and Room: Application Database Development - ARP 114
Title: Continuous Deployments using SSDT
Abstract: Many of us feel pressure to deploy changes to our database more often and more reliably. SSDT gives us a number of options to set up continuous integration and eventually, continuous deployment. Learn how to create and customize DACPACs, Published Profiles, and SQLPackage.exe to automate your deployment process. Whether you want to update QA or smoothly get changes to production, this session will give you the tips and tricks you need to get started.
Speaker(s):
- Christopher Wolff
Track and Room: Enterprise Database Administration Deployment - ARP 116
Title: The Junior Developer’s Handbook
Abstract: Boy Scouts, Role-Playing Gamers, Human Resources…they all have handbooks to help them navigate their roles. Now database developers have one too! In this session, we’ll cover the essentials for any T-SQL developer to succeed. Topics include a method for writing new queries, measuring query performance, the importance of date tables and window functions, and time-saving tricks you never knew were possible in Management Studio. In addition to these quick wins, we’ll cover some longer-term strategies to set you up for faster career growth. If you’re looking for the missing manual for developers in their first two years, this session is for you.
Speaker(s):
- Doug Lane
Track and Room: Application Database Development - ARP 114
Title: Index Speed Demons - How To Turbo-Charge Your Text Based Queries Using Full-Text Indexing
Abstract: We all want to improve the speed of our databases to make sure they run optimally. In this session we will explore relational and full-text indexes, their internals and uses. We’ll take a look at some alternatives to full-text indexes and their pitfalls. We’ll also explore turbo-charging the performance of your text-based search criteria using full-text indexes.
Speaker(s):
- Adam Koehler
Track and Room: Enterprise Database Administration Deployment - ARP 218
Title: Security Developers Need To Know
Abstract: In this session I will list the things that developers need to do to minimize the risk that a hacker can gain access to a database. I will discuss each in depth and provide examples of a good code and practices to keep hackers out. The list includes: protecting connection strings, using minimal database permissions, funneling all database code through central logging and injection testing filters, proper use of stored procedures, hashing passwords, and SQL injection prevention. I believe that when developers write a properly architected application, they can be confident that risks of database injection through the application is minimized.
Speaker(s):
- Rob Kraft
Track and Room: Application Database Development - ARP 114
Title: Azure Machine Learning 101
Abstract: You have probably heard the buzz about Azure Machine Learning, aka Azure ML, over the past few years. It is a surprisingly easy to use predictive analytic tool that you can learn for free. Attend this session to learn how to get started with Azure ML.
Speaker(s):
- Kathi Kellenberger
Track and Room: Analytics and Visualization - ARP 212
Title: Service Broker Empowering near Real-time Mainframe Analytics
Abstract: If you’ve learned the basics of Service Broker, this discussion will help you understand how to design a Service Broker architecture that allows for near real time message processing from external sources. In this case, see a system designed to handle 5 million varied messages an hour in less than 750 milliseconds across multiple, distributed commodity SQL Servers. Discussion of service broker design and optimization, conversation management, error handling and logging, and operational metrics.
Speaker(s):
- Brendon Collier
Track and Room: Application Database Development - ARP 210
Title: Set Me Up: How to Think in Sets
Abstract: SQL Server is optimized to work in sets, but this is certainly a paradigm shift for someone accustomed to row-by-row operations.
We will look at T-SQL features that can break set-based processing – generally meaning poor performance – and gather empirical evidence to support that assertion. We’ll also look at some constructs to overcome these issues and make your T-SQL scripts run faster and use fewer resources.
Speaker(s):
- Brian Hansen
Track and Room: Application Database Development - ARP 212
Title: LIVE SQL Server 2017 LINUX Availability Group buildout!
Abstract: Full LIVE buildout of an 2-node SQL Server 2017 CTP 2 Availability Group, on Linux! We’re going to start from scratch, and cover allocating VMs in Hyper-V, loading the OS, general configuration of the operating system, installing SQL Server, and finish with an controlled failover of SQL Server using native Linux utilities. We’ll talk about each step along the way
Speaker(s):
- Dave Walden
Track and Room: Enterprise Database Administration Deployment - ARP 116
Title: Preparing to be Hacked
Abstract: They are going to get in. This session talks briefly about how they get in. But they are going to get in. It talks a little about security best practices. But one little mistake by anyone and they are in. How will you know they’re in? How will you know how they got in? What do they want? How will you know what they’re doing? How will you know if you’ve kicked them out? This session will focus on the type of logging and tripwires you’ll need to respond to a breach of your SQL Servers. It includes a mix of technical solution and process recommendations based on actual incidents.
Speaker(s):
- Bill Graziano
Track and Room: Advanced Analysis Techniques - ARP 218
Title: Performance Monitoring AlwaysOn Availability Groups
Abstract: Have you deployed Availability Groups in your data center? Are you monitoring your Availability Groups to ensure you can meet your recovery objectives? If you haven’t this is the session for you. We will discuss the importance of monitoring and trending Availability Group Replication, how AGs move data between replicas and the impact replication latency can have on the availability of your systems. We’ll also give you the tools and techniques to go back to the office and get started monitoring and trending right away!
Speaker(s):
- Anthony Nocentino
Track and Room: Enterprise Database Administration Deployment - ARP 116
Title: Cohesity
Abstract: Learn how Cohesity can help tame your data sprawl
Speaker(s):
- KC SQLSaturday
Track and Room: Other - ARP 210
Title: Datrium
Abstract: Learn more about how Datrium is revolutionizing data storage
Speaker(s):
- KC SQLSaturday
Track and Room: Other - ARP 212
Title: Quest
Abstract: Quest Software Update
- Commitment to SQL Server Market
- Solutions Overview
- Monitoring and Workload Analysis
- Historical Trending
- Ensure Coordination From DEV to TEST to PROD
- Backup, Compression, and Recovery
Speaker(s):
- KC SQLSaturday
Track and Room: Other - ARP 218
Title: Tallgrass Consulting
Abstract: Learn more about how Tallgrass is your partner in achieving success. We provide expertise and ingenuity to solve your business challenges and enable execution for impactful results
Speaker(s):
- KC SQLSaturday
Track and Room: Other - ARP 116
Title: SQL and BI Business Value
Abstract: Determining business value for SQL and BI in the enterprise. Establishing a business case, purpose of a business case, business case components, SQL and BI Value, value in the Cloud.
Have you been challenged determining value? Identifying the basic problem? Communicating the business benefit? This session is a great business introduction to these concepts! Helping IT leaders bridge the gap between IT and business!
Participants will learn about the basics of determining business value for a solution.
Speaker(s):
- Matthew Bowers
Track and Room: Professional Development - ARP 224
Title: Transitioning from Integration Services to Azure Data Factory
Abstract: Although SQL Server Integration Services (SSIS) and Azure Data Factory (ADF) are both used for data management processes in the Microsoft Data Platform, they are rather different tools. SSIS performs data transformation and requires a SQL Agent job or another application to schedule and execute it. ADF is an orchestration tool rather than a data transformation tool, and it has built-in scheduling capabilities. I’ll explain the basics of Azure Data Factory, show how it is and isn’t like SSIS, and share lessons learned from ADF projects I have completed.
Speaker(s):
- Meagan Longoria
Track and Room: BI Platform Architecture, Development Administration - ARP 116
Title: Rockhurst University – Business Intelligence Analytics Programs
Abstract: Rockhurst University – Business Intelligence Analytics Programs Come learn about Rockhurst University’s unique certificate and master’s degree programs in Business Intelligence and Analytics. Certain courses are now being offered online for the Spring semester.
Speaker(s):
- KC SQLSaturday
Track and Room: Other - ARP 114
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Rob Kraft
Twitter: - @robkraft
LinkedIn: Rob Kraft
Contact: http://csharpdeveloper.wordpress.com
Rob Kraft is an independent software architect, project manager, and developer from Lee#39;s Summit, MO. He was a certified trainer on SQL Server and co-authored a few books about SQL Server and network security. He has been a full or part-time SQL Server DBA since version 4.2. He runs www.KansasCityUserGroups.com and he blogs occasionally at http://csharpdeveloper.wordpress.com/.
Ryan Casey
Twitter: - @AimYourData
LinkedIn: Ryan Casey
Contact: https://www.AimYourData.com/
Microsoft Data Platform MVP, Public Speaker, and Group Moderator
SQLSaturday Speaker @ • Houston, TX 2018 • Dallas, TX 2018, 2017 (BI), 2016, 2015 • Phoenix, AZ 2018, 2017 (BI) • Kansas City, MO 2017 • Baton Rouge, LA 2017 • Oklahoma City, OK 2016 • San Antonio, TX 2016
SQL User Group Speaker @ • NTSSUG, Dallas, TX • CACTUSS, Austin, TX • OKCSQL, Oklahoma City, OK • MSBIC, Dallas, TX • SALSSA, San Antonio, TX • FWSSUG, Fort Worth, TX
AIM Business Driven Data Solutions combines the collaborative and creative arts included in Technical Communication, the business acumen of a Harvard MBA program, and the technical discipline of object-oriented programming and business intelligence (data warehouses).
Ankit Baria
LinkedIn: Ankit Baria
Ankit has over 8 years of experience in Application Developer, Database, Database management, Business Systems Analyst and Software development which includes analysis, design, implementation and testing of web/windows based applications, client/server and relational database design using Oracle, Sybase, MySQL and MS-SQL Server with a Master’s degree focused in Computer Information Systems. He has designed and developed a SQL Server Broker Service for real time data movement between multiple SQL Server’s for maintaining reliability and improving the performance by keeping the data in sync across multiple platforms at the same time reducing the load on the servers.
Brendon Collier
LinkedIn: Brendon Collier
Spent the last couple years building out a high speed, low latency SQL Server code base to capture every transaction from a mainframe supporting 24/7 national operations (with a few other good teammates). @BillinKC says I should tell you… so here I am! Hope to see you there.
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.
Kevin Mackey
Twitter: - @kevinjmackey
LinkedIn: Kevin Mackey
Contact: https://kjmackey.wordpress.com
Kevin a software architect with a track record of creative and effective delivery of results for organizations who want to translate data into information.
With a background as a trainer Kevin can explain complex technologies and concepts in easy to understand language. By the same token, he can take complex business problems and express them in terms technology teams can use to derive solutions.
Kevin has a focus on automation of data movement, analysis, information delivery, and of the code to accomplish this.
Kathi Kellenberger
Twitter: - auntkathi
LinkedIn: Kathi Kellenberger
Contact: http://auntkathisql.com
Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.
Anthony Nocentino
Twitter: - nocentino
LinkedIn: Anthony Nocentino
Contact: http://www.centinosystems.com/blog/
Anthony Nocentino is the founder and President of Centino Systems as well as a Pluralsight author, Microsoft Data Platform MVP, Linux expert, and corporate problem solver. Anthony designs solutions, deploys the technology, and provides expertise on business system performance, architecture, and security. Anthony has a Bachelors and Masters in Computer Science with research publications in high performance/low latency data access algorithms and spatial database systems.
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.
Dan Mallott
Twitter: - https://twitter.com/DanielMallott
LinkedIn: Dan Mallott
Contact: https://www.danielmallott.com
Dan Mallott is a Chicago-based consultant for West Monroe Partners in their Technology Practice. His passion is for service-layer development, particularly database technologies, including Microsoft SQL Server and Apache Cassandra.
Recent projects have included designing a new integration architecture for a mid-sized health insurer, designing a full technical architecture for a large health insurer, building a new member portal for a healthcare-related association, and developing threat hunting software for use by West Monroe.
In his spare time, Dan can be found writing his own libraries instead of using package solutions, or on the ice as a hockey player and referee.
Ed Leighton-Dick
Twitter: - eleightondick
LinkedIn: Ed Leighton-Dick
Contact: http://www.edleightondick.com
Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.
Matthew Sharkey
LinkedIn: Matthew Sharkey
Contact: http://www.hinttank.com/
Matthew has ten years of IT experience, primarily working in IT Operations and Analytics. His specialties include T-SQL querying, performance optimization, data analysis, and data visualization. Matt has worked with all major features of the SQL Server Data Platform. Matt holds a Data Platform MCSE and two masters degrees.
Christopher Wolff
Twitter: - @tickytong
LinkedIn: Christopher Wolff
Contact: http://sqlred.blogspot.com/
Chris Wolff has been a developer, report writer, and an admin in Microsoft and SQL Server Space since SQL Server 2000 in industries such as telecommunications, green energy, money transfers, and online accounting. He has been an active member of the Denver SQL User Group since 2011 and enjoys learning new things about computers. His interests includes video games, movies, and enjoying time with his wife and 2 kids.
Adam Koehler
Twitter: - sql_geek
LinkedIn: Adam Koehler
Adam Koehler is the Senior Database Administrator for ScriptPro, LLC. He has worked with SQL Server from 7.0 to 2017 in various roles throughout his career with the last 14 years in a DBA role.
Brian Hansen
Twitter: - tf3604
Contact: http://www.tf3604.com
Brian is a database administrator at Children International in Kansas City. He has been working with SQL Server technologies since 1998, including roles in report development, application development and database administration.
Matthew Bowers
Twitter: - @mbowersmailctp
LinkedIn: Matthew Bowers
Partner, Senior Business Solutions Consultant, Client Engagement Manager and Senior Business Development Executive. Mr. Bowers specializes in applying contemporary technologies to solve business problems. Focus on helping businesses realize return on investment and value from their technology investments, as well as the application of disruptive technologies to achieve digital transformation Passionate about helping organizations make the connection between technology and realized business value. Passionate about helping IT leaders bridge the gaps between IT and business through enhanced business discussions. 12 years CTO / CIO Level experience in small to medium sized businesses.
MSFT VTSP / P-Seller
Steven Tidwell
Twitter: - @SQLCodeMonkey
LinkedIn: Steven Tidwell
Contact: https://www.sqlcodemonkey.com
I am currently the Technical Lead for Client custom projects. I have been writing SQL Code starting in SQL 7. Over the years I have put on many hats, DBA, Developer, Web Developer, C#, VB.NET, Cold Fusion and Java. But at the end of the day, I prefer to write SQL. Local Chapter Leader for the South Montgomery County SQL Server User Group in Montgomery County, Texas.
Kevin Trojanowski
IT Professional with over 25 years experience across a range of technologies, specializing in data and databases including SQL Server and Redis.
Dave Walden
With over 20 years of experience in large, high performance, mission critical environments, Dave brings a wealth of knowledge and experience. While his primary focus is the data platform, Dave has deep expertise in other fields, including Cloud (Private/Public/Hybrid), Storage, Virtualization, Compute and Networking. Dave also has deep experience in the Big Data space, having worked in technologies such as Hadoop, Data Lake, Cosmos DB and MongoDB. Dave is a international speaker on SQL Server related topics, most recently on SQL Server on Linux.
KC SQLSaturday
test
KC SQLSaturday
test
KC SQLSaturday
test
Bill Graziano
Twitter: - @billgraziano
LinkedIn: Bill Graziano
Contact: http://billg.sqlteam.com/
Bill is a SQL Server consultant focusing on availability, performance, security, and developer support. He has nearly 20 years for experience supporting a wide variety of SQL Server installations.
He is a former President of PASS where he served on the Board for ten years. Bill was a SQL Server MVP for the previous thirteen years. He is the publisher of SQLTeam.com where his SQL Server articles have been read by DBA’s and developers all around the globe.
Bill is the author of two popular free SQL Server utilities: ClearTrace for analyzing SQL Server performance traces and Is It SQL? that provides simple SQL Server monitoring.
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).
KC SQLSaturday
test
Don St. Cyr
Twitter: - @Machiavelli_too
LinkedIn: Don St. Cyr
I am originally from Maine but I have lived in the Midwest since ‘95. I am married with a son and daughter, 3 dogs, 2 bunnies and a horse. I have worked in IT for the last 20+ years in various roles such as technical trainer, computer tech, systems administrator and database administrator. I have worked in numerous fields such as education (for K-12 and post secondary), the military (for the U.S. Army and the Dept of Defense) and in healthcare. I am also a U.S. Army and Desert Storm veteran.
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.
KC SQLSaturday
test
Doug Lane
Twitter: - @thedouglane
LinkedIn: Doug Lane
Contact: http://www.sqltheater.com
Doug Lane is the founder of SQL Theater, a company specializing in helping junior developers and public speakers. Doug has over 15 years#39; experience in IT and holds a Bachelor of Arts degree in Media Production. In addition to presenting at conferences, SQLSaturdays, and user group meetings, Doug also blogs and produces video training courses.
Christopher Wolff
Twitter: - @tickytong
LinkedIn: Christopher Wolff
Contact: http://sqlred.blogspot.com/
Chris Wolff has been a developer, report writer, and an admin in Microsoft and SQL Server Space since SQL Server 2000 in industries such as telecommunications, green energy, money transfers, and online accounting. He has been an active member of the Denver SQL User Group since 2011 and enjoys learning new things about computers. His interests includes video games, movies, and enjoying time with his wife and 2 kids.
David Maxwell
Twitter: - https://twitter.com/dmmaxwell
LinkedIn: David Maxwell
Contact: https://dmmaxwell.wordpress.com/
David Maxwell has almost 20 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQLSaturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals Virtual Group, the Performance Virtual Group, 24 Hours of PASS, and the annual PASS Summit. David participates in his local Columbus Ohio PASS Local Group, where he serves on the board of directors as SQLSaturday coordinator.
Sponsors
The following is a list of sponsors that helped fund the event: