- 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.
- 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
- Shawn Cannon, Empowering Agile Data Architects; Osei May, PASS 2018 Highlights
MAIN PRESENTATION (60 min) All too often data architects are brought in to address technical debt after a project has begun to show signs of failure. We’ll look at ways for a data architect to be a proactive, contributing member of an Agile team working towards a common goal using the combination of validDB and erwin DM. Shawn has spent the last twenty years developing the platform that powers validDB.com and has built hundreds of database centric applications on the platform across a wide range of domains for organizations large and small. ------------------------------------- FIRST PRESENTATION (30 min) In this brief session we'll be covering some of the major highlights from the SQL PASS conference that occurred in November 2018 in Seattle, WA. Topics will include features from the roadmap for SQL Server 2019, Azure, and Power BI. There are amazing things in store. Osei does BI and Big Data Engineering with Azure, Analysis Services and Power BI. He likes building analytical pipelines to provide new insights. Previously, he developed reporting for mortgage services and a local university and he's vice president of Boulder SQL. ------------------------------------------------------------ 5:30 Pizza and networking 6:00 Meeting starts, introductions, announcements 6:15 First Presentation 6:45 Main Presentation 7:45 Wrap-up, Q/A, address technical issue of the group 8 - 8:15 Meeting ends
- 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
- 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.
- 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.
- 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
- 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.