• SQL Saturday #774 - Denver 9/15/18 (placeholder)
    This is just a placeholder so members can RSVP here and know who else might be going. Lots of great events for almost free! I plan to be there - please tap me on the shoulder if you notice me. To sign up for this event, you must go here: http://www.sqlsaturday.com/774/eventhome.aspx SQLSaturday.com is now under the umbrella of SQL Pass, the Professional Association of SQL Server. Great organization to have affiliation with - it's free to join. (I'm still waiting for them to offer this on a Monday so I can get out of work for the day). 8-8:45am - Opening Remarks/Keynote: Bob Ward - Transform Your Data Estate with Cloud, Data and AI 9-5:30pm - 6 presentations with 9 tracks to choose from for each one. Paul

    Needs a location

  • Steve Jones - Bringing DevOps to the Database; Jason Horner - Azure Data Factory
    Main Presentation DevOps is a hot topic in today’s software development world. However most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can be applied to database development by looking at both automated comparison analysis as well as migration script management. Automated building, testing, and deployment of database changes will be shown. Main Presenter Bio Steve Jones has been working with SQL Server since 1991 and been a DBA in a variety of large and small companies and industries. In 2001 Steve founded SQLServerCentral with two partners and has been publishing technical articles and facilitating discussions among SQL Server professionals ever since. He currently is the full time editor of SQLServerCentral, owned by Red Gate Software. Steve is a Microsoft SQL Server MVP and a D&B MVP. First Presentation Azure Data Factory (ADF) We will start with an overview of Azure Data Factory V2 concepts. Then, we go through some common design patterns for moving and orchestrating data, including incremental and metadata-driven pipelines. Along the way, we highlight common data engineering best practices for building scalable and high-performing ELT / ETL solutions. First Presentation Bio Jason Horner is a Microsoft Certified Master of SQL Server and has worked with it for more than 20 years. He began work as a DBA/Application Developer in 1999. He made the transition to delivering BI solutions in 2002. Jason’s latest focus has been architecting large-scale Modern Data Warehouse / Big Data solutions in the Azure Cloud.

    Datavail Corporation

    11800 Ridge Parkway · Broomfield

  • Janis Griffin - Welcome to the 2016 Query Store
    Presentation Description One of my favorite new features in SQL Server 2016 is the Query Store. The Query Store houses valuable information on performance of your queries as well as gives you great insights into your query workload. This presentation will take a look at the Query Store, how it works and the type information it holds and how you can use it to analyze performance issues. New DMVs will be introduced and the performance impact of enabling the Query Store will be discussed. Both DBAs and developers can increase their performance tuning skills by attending this session. Main Presenter Bio Janis Griffin has over 25 years of DBA experience including design, development and implementation of many critical database applications. Before coming to SolarWinds, Janis held DBA positions working with both real-time network routing databases and OLTP business to business applications. As a Principal Architect and Senior Manager, Janis has mentored many other DBAs on best practices in database performance tuning.

    Datavail Corporation

    11800 Ridge Parkway · Broomfield

  • Todd Kleinhans, VLDB Tips and Migration Tactics
    Main Presentation - Todd Kleinhans VLDB Tips and Migration Tactics Are your databases growing? Most likely they are but what do you have to do differently when they reach VLDB (>1TB) in size? I currently manage and have recently migrated terabyte sized databases (~30TB) to SQL Server 2016. In this session, people will learn how they need to change their thinking when it comes to bread and butter DBA tasks like daily and weekly maintenance, patching, restores and monitoring. I will also share many lessons learned and strategies from migrating from an older version of SQL Server to a newer version like SQL Server 2016. Afterwards people will have a greater sense of confidence that they too can manage and migrate VLDB(s). Bio for Todd Kleinhans Todd Kleinhans has been working with SQL Server since 1999. He has worked mainly as a dba, but also as a developer, data architect, manager, and consultant. He is currently a Senior SQL Server DBA at BAE Systems. Todd has served in the past on the board of the Denver SQL Server User Group and is the VP of Marketing. He enjoys presenting at user groups, virtual groups, and SQL Saturday events. Todd also recently participated in the second annual Speaker Idol contest at the PASS Summit this year. He can be found on Twitter @toddkleinhans and maintains a blog at http://toddkleinhans.com

    Datavail Corporation

    11800 Ridge Parkway · Broomfield

  • Mark Beacom - Cloud Analytics; William Andrus - Creating effective dashboards
    30 minute (1st) Presentation: Creating effective dashboards and pitfalls to avoid SPEAKER William Andrus ABSTRACT Having an efficient dashboard with comprehensive visualizations is vital for users to quickly assess the status and performance of the situation so that they can achieve their objective and analysis more quickly. Creating dashboards is not something that should haphazardly be created, and should be planned out with specific objectives and metrics in mind. This presentation will go over many of the potential pitfalls and problems with designing dashboards and visualizations that need to be avoided. BIO William is a Data Engineering Consultant for Datalere where he leverages his experience to craft effective visualizations and dashboards. In addition to developing dashboards that tell a story, he is deeply involved in wrangling data and developing scalable applications. ___________________________ 60 minute (2nd) presentation: Implementing a Cloud Analytics Solution: Options, costs and more SPEAKER Marc Beacom ABSTRACT If you've looked at the cloud, you've realized the large number of options you have, to implement a complete cloud analytics solution. You can deploy dashboards, data ingestion and integration and advanced analytics to the cloud that will empower data-driven decisions for your organizations. This talk will discuss and review options you have, to run Cloud Analytic Solutions from the three major cloud providers: AWS, Azure and Google Cloud Platform. BIO Marc Beacom, Managing Partner at Datalere, leverages over two decades of experience to better the data landscape for clients, along with nearly a decade of building and managing productive teams. Marc has led architecture and developed data integration strategies for dozens of Colorado based companies and organizations. Marc maintains an active presence in the Colorado community by volunteering and serving on nonprofit boards, speaking and running user groups. He is a former president of the Denver SQL User Group.

    Datavail Corporation

    11800 Ridge Parkway · Broomfield

  • Manguirish Sardesai, SQL Migration to AWS Cloud; Paul Paiva, Consultant vs. Emp
    MAIN (second) PRESENTATION - Manguirish Sardesai Accelerate SQL Server Migration to AWS Cloud TARGET AUDIENCE SQL Server Cloud Community and all the SQL Server DBAs who have Migrated or in process of migration their SQL Servers from On-Premise to the Public Cloud DESCRIPTION With the current adoption of the Public Cloud framework by SQL Server community, more and more enterprises are planning to move from their on-premises servers to the public Cloud. In this presentation, we will discuss different methods and the advantages and disadvantages of using each method. Look out for the surprises and pitfalls to avoid as we venture into the process. BIO Manguirish is a AWS Professional Cloud Certified DBA with 12 years’ experience in IT Industry specializing in Web Development, Database Development /Administration and Data Reporting. He also undertakes business assessments and does project planning to deliver high-end pragmatic solutions for each client environment. He is currently working as Senior SQL Server DBA at Datavail corporation. When he’s not looking to play with databases, he enjoys traveling to new places and reading fiction literature. You can reach him at [masked] ----------------------------------------- FIRST PRESENTATION - Paul Paiva Consultant vs. Employee Which is better - to be an employee or an independent consultant/contractor? Most have worked as a direct hire for a company. At some point you might have been offered a short or long-term contract. This can bring up mixed feelings - it may entail a greater salary, but without benefits and stability. You can learn more skills quickly doing many contracts - but you are perpetually in "job seeking" mode. This presentation will compare the pros and cons of being an independent consultant versus working for a company as their employee. Paul Paiva has been working with SQL Server since version 6.0 in various roles, especially as Production DBA and SQL Developer. He is also the current president of the Boulder SQL group. 90% of his past 20 years as a database professional has been as an independent consultant doing contracts.

    Datavail Corporation

    11800 Ridge Parkway · Broomfield

  • Matt Smith - SQL on Red Hat Linux in Azure, Andy McDermid - High Availbty Groups
    1st PRESENTATION DESCRIPTION SQL Server 2017 on Red Hat in Azure. Let’s get things up and running. Hands-on. Pre-req's (if you want to follow along in class): Azure account (portal.azure.com (http://portal.azure.com/)) Git for Windows: https://git-for-windows.github.io/ BIO for Matt Smith Matt is a dba and developer, and enjoys data engineering and software development. ------------------------------ He has delivered excellent presentations at our group two or three times in the past. - Paul ---------------------------------------------------------- 2nd PRESENTATION DESCRIPTION (rescheduled from 2/22 due to snow) Distributed Availability Group: An Availability Group of Availability Groups... ( very meta ) We'll review the basics to build and operate a couple of "standard" SQL Availability Groups then we'll bridge them to create a Distributed Availability Group. These can work great for scaling out reads, system migrations, and implementing geo-HADR. I recently helped build a cloud-ground-hybrid Distributed Availability Group in production so I'll share a few tips and tricks from the trenches. BIO for Andy McDermid Andy's a long time MS SQL DBA in the Denver area. He likes pretty much everything about being a DBA and especially enjoys designing and implementing high availability and disaster recovery solutions. Andy has presented to our Boulder group several times in the past. ------------------------------ Andy, too, has delivered excellent presentations at our group two or three times in the past. - Paul

    Datavail Corporation

    11800 Ridge Parkway · Broomfield

  • Andy McDermid, Distributed High Availability Groups
    (note we are meeting on Thursday, rather than our usual Wednesday) Presentation Description Distributed Availability Group: An Availability Group of Availability Groups... ( very meta ) We'll review the basics to build and operate a couple of "standard" SQL Availability Groups then we'll bridge them to create a Distributed Availability Group. These can work great for scaling out reads, system migrations, and implementing geo-HADR. I recently helped build a cloud-ground-hybrid Distributed Availability Group in production so I'll share a few tips and tricks from the trenches. Presenter Bio Andy's a long time MS SQL DBA in the Denver area. He likes pretty much everything about being a DBA and especially enjoys designing and implementing high availability and disaster recovery solutions. Andy has presented to our Boulder group several times in the past.

    Datavail Corporation

    11800 Ridge Parkway · Broomfield

  • SQL Holiday Networking Social
    Come on down and get to know some of the other SQL professionals in the area. Free appetizers and maybe more! • Hobnob with others and get insights on your career development. • Learn about job opportunities that someone might know about. • Get to know your SQL colleagues over the beverage of your choice in a relaxing atmosphere, far away from the server room, management, and the dev team. David Zahner of Anchor Staffing Group (http://www.anchorstaffinggroup.com/) will be sponsoring by providing appetizers. Check out his site. David is a DBA and member of our group. Therefore his staffing firm is unique and refreshing. He will be present as well. Hope you can make it! Paul

    Bar Louie

    10661 Westminster Boulevard #900 · Westminster

    5 comments
  • SQL PASS Summit
    Seattle, WA This is just a placeholder Register here (http://www.pass.org/summit/2017/Home.aspx)

    Needs a location

    1 comment