• Demystify SQL Server Performance

    Datavail Corporation

    Details
    1st PRESENTATION -SQL PASS Highlights and Key Takeaways

    MAIN PRESENTATION
    Demystify SQL Server Performance

    A key component of overall application performance tuning is query tuning. Writing queries in an efficient manner, and making sure they execute in the most optimal way possible, is always a challenge. This presentation will show few scenarios where some of the SQL features negatively affects performance, discuss and see how these problems can be mitigated and thereby improving performance.

    BY
    MAIN PRESENTER

    Raj is a Microsoft Certified Solution Associate, SQL Server 2014 and has over 15 years of SQL Server DBA experience on relational databases, application development and specializes in performance tuning, scalability and maintainability of large scale SQL Servers. During his DBA carrier, he has worked extensively on performance tuning and query optimization projects.

    ------------------------------------------------------------
    5:30 Pizza and networking
    6:00 Meeting starts, introductions, announcements (punctual start)
    6:15 First Presentation (TBD)
    6:45 Main Presentation(Demystify SQL Server Performance)
    8:00 Wrap-up, Q/A, address technical issue of the group
    8:15 Meeting ends

    Questions? Send an email to [masked].
    Connect with us online:
    Website: BoulderSql.org

  • SQL Server on Linux

    Datavail Corporation

    Details
    1st PRESENTATION -Rattling Tech Talks
    Azure Blob storage
    Blob storage is a feature in Microsoft Azure that lets developers store unstructured data in Microsoft's cloud platform. This data can be accessed from anywhere in the world.In this presentation we will see how to do SQL Native backups to Azure Blob storage.

    By
    Senthuran Subramaniam. Sen has Overall 10 years experience in the I.T field with 4 years as SQL Server developer. He has great expertise in Database Development and Administration.

    MAIN PRESENTATION
    SQL Server on Linux

    In this presentation we will see below :-

    Installing SQL Server on RedHat Linux
    A brief demonstration of installing SQL Server on Linux
    Navigating Linux SQL Server on Linux
    How to Log onto Linux
    Changing your password
    Using ‘sudo’
    Basic Linux Commands
    Information Gathering
    Troubleshooting

    BY
    MAIN PRESENTER

    Jeanne has over 15 years of experience in the Information Technology field starting out as an Analyst Programmer and then becoming a database administrator. I have worked in variety of fields ranging from Higher education, healthcare, energy and telecommunications. As a DBA, I have worked on various database platforms ranging from Oracle, MySQL, Postgres and SQL Server to name a few. I am familiar working in both Windows and Linux operating systems and with the release of SQL Server 2017 on Linux I was excited to try it. I will be sharing with you commands and shortcuts on how to install and navigate through Linux.

    ------------------------------------------------------------
    5:30 Pizza and networking
    6:00 Meeting starts, introductions, announcements (punctual start)
    6:15 First Presentation (TBD)
    6:45 Main Presentation(Demystify SQL Server Performance)
    8:00 Wrap-up, Q/A, address technical issue of the group
    8:15 Meeting ends

    Questions? Send an email to [masked].
    Connect with us online:
    Website: BoulderSql.org

  • SQL Saturday #908 - Denver 10/12/19 (placeholder)

    University of Denver

    This is just a placeholder so members can RSVP here and know who else might be going.

    Lots of great events for 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:
    https://www.sqlsaturday.com/908/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: TBD
    9-5:30pm - 5 presentation time slots, with several tracks to choose from.

    Paul

    3
  • Building the Foundation with Azure Databricks by Stian Ulriksen

    Datavail Corporation

    Details
    1st PRESENTATION -Rattling Tech Talks on Topics. We will have one member present.

    MAIN PRESENTATION
    Building the Foundation with Azure Databrick

    Azure Databricks is a managed Azure service that allows you to easily perform data computations in a cluster. Databricks has multiple use cases including ETL and data science. This presentation will give beginners all of the information necessary to get started in Databricks and will include a demo that implements a fuzzy matching algorithm across a cluster using Python.

    BY
    MAIN PRESENTER
    Stian Ulriksen has half a decade of experience working in data science and data engineering across a variety of fields both professionally and academically. Stian has demonstrated advanced skills in developing and deploying data science models and algorithms to help organizations understand their data. Stian also specializes in developing intuitive visualizations and reports to communicate data and technical terminology in an easy-to-understand manner for clients.

    ------------------------------------------------------------
    5:30 Pizza and networking
    6:00 Meeting starts, introductions, announcements (punctual start)
    6:15 First Presentation (TBD)
    6:45 Main Presentation(Building the Foundation with Azure Databricks by Stian Ulriksen)
    8:00 Wrap-up, Q/A, address technical issue of the group
    8:15 Meeting ends

    Questions? Send an email to [masked].
    Connect with us online:
    Website: BoulderSql.org

  • Azure SQL Database for Fun and Profit - George Young

    Datavail Corporation

    Details
    1st PRESENTATION -Rattling Tech Talks on Topics. We will have one member present.

    MAIN PRESENTATION
    Azure SQL Database for Fun and Profit

    Azure is massive, with just about everything needed to run a full IT department. But what about just deploying and managing the basic database-driven applications that are the bread and butter of corporate life? How difficult is it to wade through the immensity of Azure and do the basic stuff? Quite easy and powerful, it turns out!

    In this talk, we’ll give a tour of the few parts of the Azure portal that are used for database-driven applications, and discuss the pros and cons of SQL Server Virtual Machines versus Azure SQL Database. We’ll deploy a SQL Server database to Azure SQL Database. We’ll then build in real-time both a data-driven Windows Forms application and an ASP.NET web/mobile app, both hitting the same Azure database, and deploy them to Azure. We’ll set up our web app to authenticate against Azure Active directory. Time permitted, we’ll generate a quick Power BI report, and look at analytics both on the data, and on the application itself. You’ll leave this talk ready to get your application up and running in Azure in no time at all!

    BY
    MAIN PRESENTER

    George Young has worked as a software developer for the past twenty-five years, half of that time at Microsoft on projects like MSDN, Windows Live, and Bing. He is the founder and president of Dawson Butte Software, delivering data-driven .NET solutions. George is the President of the Denver Area Access Users Group, and has spoken at a number of events, including the Portland Database Designer International Conference, Global Azure Bootcamp, and Denver Dev Day, as well as for a dozen user groups. George lives in Castle Rock with his wife and five young children. Find him on LinkedIn at https://www.linkedin.com/in/georgecyoung/.

    ------------------------------------------------------------
    5:30 Pizza and networking
    6:00 Meeting starts, introductions, announcements (punctual start)
    6:15 First Presentation (TBD)
    6:45 Main Presentation(Azure SQL Database for Fun and Profit)
    8:00 Wrap-up, Q/A, address technical issue of the group
    8:15 Meeting ends

    Questions? Send an email to [masked].
    Connect with us online:
    Website: BoulderSql.org

  • Rattling Tech Talks & SQL Server on Azure

    Datavail Corporation

    1st PRESENTATION - Rattling Tech Talks on Topics. We will have one member present.

    MAIN PRESENTATION
    SQL Server on Azure

    With the current transformation of technologies, small to enterprise organization are migrating towards cloud. In this presentation, we are going to talk about one of the cloud platform “Microsoft Azure”. This going to be introductory session for few Azure features and services.

    Highlights:
    • Difference between different Azure Offerings
    (IaaS, PaaS, Managed Instance
    • Different Tier levels available in PaaS
    • Login, User and content user for PaaS
    • Automation accounts and runbook for PaaS
    • Geo-Replication
    • Log analytics

    BY
    MAIN PRESENTER:
    Kailash is a MCITP with over 16 years’ experience in IT industry specializing in SQL Server administrator. He also works on assessment project involving implementation of Microsoft best practices, Server and Database migration, performance tuning etc. You can reach on him at [masked]

    ------------------------------------------------------------
    5:30 Pizza and networking
    6:00 Meeting starts, introductions, announcements (punctual start)
    6:15 First Presentation
    6:45 Main Presentation
    8:00 Wrap-up, Q/A, address technical issue of the group
    8:15 Meeting ends

    Questions? Send an email to [masked].
    Connect with us online:
    Website: BoulderSql.org

  • Rattling Tech Talks & Exploring SQL Server containers in Docker & Kubernetes

    Details
    1st PRESENTATION -Rattling Tech Talks on Topics. We will have one member present.

    MAIN PRESENTATION
    Exploring SQL Server containers in Docker & Kubernetes

    In this session we will explore the options we have when working with SQL Server running on Docker containers or Kubernetes. Also, will take a look at some real world scenarios of backing up \ restoring databases in containers, high availability, version upgrades and the most important portability. Join me to discuss further about this interesting topic that is called by some experts as “The Future of Database Infrastructure”.

    BY
    MAIN PRESENTER
    Carlos Robles is Microsoft Data Platform MVP also a very experienced multi platform DBA (MySQL, Oracle, SQL Server, SQL Azure) with over 10 years of experience in the database field. He has worked in database support as primary consultant and DBA manager for larger US based companies and around the work in the healthcare, insurance, retail, food and energy industries.
    He has a few certifications under his belt MCSE, MCSA, MCP, MCTS, ITIL v3, Docker, Kubernetes and RedHat openshift.
    International speaker, blogger, Guatemala SQL community group leader, mentor, he also enjoys to help people using the #SQLHelp hashtag in Twitter during his spare time. Love everything related to technology, sci-fi and video games!

    ------------------------------------------------------------
    5:30 Pizza and networking
    6:00 Meeting starts, introductions, announcements (punctual start)
    6:15 First Presentation (TBD)
    6:45 Main Presentation(Exploring SQL Server containers in Docker & Kubernetes)
    8:00 Wrap-up, Q/A, address technical issue of the group
    8:15 Meeting ends

    Questions? Send an email to [masked].
    Connect with us online:
    Website: BoulderSql.org

  • Glenn Berry, HA/DR 101. George Criaris, Transparent Data Encryption (TDE)

    1st PRESENTATION - Transparent Data Encryption (TDE)

    • What is Transparent Data Encryption (TDE)
    • Benefits and Disadvantages of TDE
    • How TDE Works
    • Considerations when Implementing TDE
    • Implementing TDE

    George Criaris is a DBA at DatAvail, and is the Team Lead for US Tier 2 support. He is working towards certifications for MCSA, Azure, and AWS. Although a "newbie" at SQL with only four years experience, he has a knack for grasping the technical challenges of a DBA, and he enjoys presenting on technical topics.

    MAIN PRESENTATION
    High Availability/Disaster Recovery 101

    How do you design a SQL Server 2017 infrastructure in order to meet specific Recovery Time Objective (RTO) and Recovery Point Objective (RPO) service levels? There are many aspects to consider, from technology choices and licensing, to policies and procedures. This session outlines and compares the various HA/DR technologies available in SQL Server 2017, showing how you can combine them to design and build a solution to help meet your HA/DR goals. This session also teaches you how to formulate policies that enable effective use of technology in your organization.
    ------------------------------------------------------------
    Glenn Berry is a Principal Consultant with SQLskills. He has worked as a SQL Server professional for many years in a variety of roles, most recently as Database Architect for Avalara in Parker, CO. Glenn has been a SQL Server MVP since 2007, and has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves he likes to take tests. His expertise includes DMVs, high availability, hardware selection and configuration, and performance tuning. 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 University College. Glenn is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, and the PASS Community Summit. He is the author of the book SQL Server Hardware, and he wrote chapters for SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2 books. Glenn’s personal blog is at http://sqlserverperformance.wordpress.com, his SQLskills blog is at http://www.SQLskills.com/blogs/glenn, and he can be reached by email at [masked], and on Twitter as GlennAlanBerry.
    ------------------------------------------------------------
    5:30 Pizza and networking
    6:00 Meeting starts, introductions, announcements (punctual start)
    6:15 First Presentation
    6:45 Main Presentation
    8:00 Wrap-up, Q/A, address technical issue of the group
    8:15 Meeting ends

  • Raj Tandel, Query Tuning; Paul Paiva, restore multiple databases via code

    MAIN PRESENTATION (60 min)
    In any given SQL Server instance, there are likely 8 to 10 queries or stored procedures that are responsible for 80 to 90 percent of the poorly tuned activity that you see throughout the day. If you can identify these problem queries and tune them, you can make a significant impact on the overall performance of your server. A key component of overall application performance tuning is query tuning. Writing queries in an efficient manner, and making sure they execute in the most optimal way possible, is always a challenge. This presentation will explain few scenarios of tuning the queries including before and after performance differences. Scenarios such as, use T-SQL new functions like STRING_AGG or TRANSLATE over other old techniques to get better performance or when to use Temp table or table variable.

    Raj is a Microsoft Certified Solution Associate, SQL Server 2014 and has over 15 years of SQL Server DBA experience on relational databases, application development and specializes in performance tuning, scalability and maintainability of large scale SQL Servers. During his DBA carrier, he has worked extensively on performance tuning and query optimization projects.

    ----------------------------
    FIRST PRESENTATION (30 mins)
    Handy Scripts for Restoring Backups
    (Audience: Beginner to Intermediate)

    SCENARIO
    You have already backed up, via script, all 100 databases on your production server. You have a folder with these 100 bak files. You want to restore all of these on your Dev server. It is 11am and you don't want miss your noon lunch appointment. How do you handle this?

    YOU WILL LEARN
    A script to restore all these 100 bak files programmatically. The script will be given the path to the location of the bak files.

    ABOUT PRESENTER
    Paul has been working with SQL Server for way too many years. He prides himself on being a lazy DBA, meaning that he insists on doing everything via a script rather than by right-clicking in SSMS. That allows him to rerun the script the next time the task is required, and he can leave work early.
    He has been the president of Boulder SQL for 10 years. His SQL blog is at http://blog.cocreativesolutions.com.

    1
  • Steve Wake, Data Modeling & Prototyping Power BI Desktop; P Paiva About Backups

    MAIN PRESENTATION (75 mins)
    Data Modeling and Prototyping in Power BI Desktop
    (Audience: Mid-Level)

    Power BI Desktop is often shown as a self-service reporting and analytics tool, but it can also be used earlier in the development cycle for prototyping and data modeling and can do it quicker and easier than other tools made for this purpose. In this session we will go through multiple examples showing how Power BI Desktop is the perfect tool to quickly model data from multiple data sources (including web sites, databases, cubes, online services and even flat files) perform quick actions to cleanse and connect these various sources to each other using M and DAX functions built-in to Power BI Desktop. Once this model has been built it can be used to create some quick reports to show how this will be used to help get a project approved/funded. Best of all using Power BI Desktop to do all of this is completely free to use, no licensing or Power BI login required!

    ABOUT PRESENTER
    Steve is currently the Principal BI Developer at Brown and Caldwell and has experience in advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full Microsoft BI stack. Steve is also very involved in the SQL community, speaking at events around the world, blogging at wakebi.com, and is currently Chapter Leader of the Mile Hi Power BI User Group.

    ------------------------------------------------------------
    FIRST PRESENTATION (30 mins)
    Handy Scripts for Backups
    (Audience: Beginner to Intermediate)

    Are you prepared for a potential disaster? Learn some handy scripts for determining:
    - When was the last FULL backup made for every database
    - Are the backups being compressed?
    - Are log backups happening?
    - List any databases not being backup up
    - Generate backup script for all databases easily
    - Look for irregularities in backup history

    ABOUT PRESENTER
    Paul has been working with SQL Server for way too many years. He prides himself on being a lazy DBA, meaning that he insists on doing everything via a script rather than by right-clicking in SSMS. That allows him to rerun the script the next time the task is required, and he can leave work early.
    He has been the president of Boulder SQL for 10 years. His SQL blog is at http://blog.cocreativesolutions.com.
    ------------------------------------------------------------
    5:30 Pizza and networking
    6:00 Meeting starts, introductions, announcements (punctual start)
    6:15 First Presentation
    6:45 Main Presentation
    8:00 Wrap-up, Q/A, address technical issue of the group
    8:15 Meeting ends

    1