What we're about

Welcome! We are a community of professionals interested in Microsoft SQL Server database products. Monthly meetings are usually the 3rd Wednesday at 5:30pm. (On occasion they are on Tue or Thu at 5:30)

We cover all topics related to SQL Server, including T-SQL, Production DBA, SQL Development, Business Intelligence, OLAP, SSIS, SSRS, and Service Broker.

This group is for you if you want to network and meet other SQL professionals whose abilities are between beginner to well-seasoned, ask SQL-related questions to other members, learn about job opportunities, and basically give your career a boost.

No cost to attend monthly meetings!

However, please consider making a donation (https://secure.meetup.com/BoulderSql/contribute/) to defray costs.

This is NOT a group for recruiters - unless you are interested in being a sponsor. This means helping with some of the basic costs for running this group. In return you meet some great people who are passionate about their careers. Please contact me if you are interested in sponsoring in some capacity. Some possibilities: paying for appetizers/drinks at SQL Lunch events, paying for the annual SQL Holiday Networking Social, and paying for pizza at our monthly meetings. In return you are given a 2 minute spotlight to say what you want to the group, meet and chat with people before and after events, and hand out your business cards. THIS IS NOT A GROUP FOR POSTING JOBs - there are plenty of over venues for that. This is a technical group with the promise of being free from job postings.

Paul Paiva

Paul@BoulderSql.org

President

Osei@BoulderSql.org

Vice President

Upcoming events (4)

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

Raj Tandel, Query Tuning; 1st presentation TBD

Datavail Corporation

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 (TBD)

Glenn Berry, High Availability/Disaster Recovery 101. 1st Presentation TBD

1st PRESENTATION - TBD 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

Carlos Bossy, Data Science Tips and Tricks using Python and SQL

MAIN PRESENTATION The practice of Data Science has arrived and as data professionals we're on the forefront of this change. The data we collect can now be used in new and exciting ways, providing more value than ever before. To get started in this field, a number of tools and methodologies must be employed to help you achieve predictive analytics success with your data. In this session, we will start by providing an introduction to Python, quickly becoming the defacto programming language for data scientists who want to create enterprise-ready solutions. Carlos will then cover predictive analytics using T-SQL and Python, providing a practical understanding of what it takes to develop your own predictive models making the most of the expertise you already have. The session includes an overview of definitions, concepts and terminology, successful applications of predictive analytics, and how predictive analytics fits into an analytics environment. Prerequisites: Working knowledge of SQL Server, T-SQL and data integration and transformation concepts. MAIN PRESENTER 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. ------------------------------------------------------------ 5:30 Pizza and networking 6:00 Meeting starts, introductions, announcements (punctual start) 6:15 First Presentation (TBD) 6:45 Main Presentation 8:00 Wrap-up, Q/A, address technical issue of the group 8:15 Meeting ends

Photos (20)