• Modern T-SQL for Better Performance by Kathi Kellenberger

    Once you learn how to write queries, it’s easy to fall back on the same old patterns. You need to get the job done, and using old techniques is often quicker than learning something new. Over the past decade, Microsoft has released several versions of SQL Server with T-SQL enhancements, and many of these enhancements not only let you write queries easier, the queries also run faster.

    Join this session to learn how this “new” T-SQL functionality can save you time when writing queries that also perform great.

    Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server since 1998 and has authored, co-authored, or tech edited over twenty technical books. Kathi is the co-leader of the Data Platform 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.

    1
  • SQL Sever Data Compression: The Deeper Dive by Bob Pusateri

    Abstract:
    Data compression may be best-known for reducing a database's size on disk, but it's also an effective tool for increasing query performance. Come see how reduced disk usage and increased performance mean that with compression, less really can be more! This session will arm you with the knowledge and understanding to capitalize on both of these aspects of SQL Server's row and page compression features, as well as columnstore and updateable columnstore indexes. We'll combine a lesson on the internals of compression with real-world scenarios to show you how to determine the most appropriate compression type for any situation.

    Bio:
    Bob Pusateri is a Microsoft Data Platform MVP, Microsoft Certified Master, and systems architect with over 15 years experience on SQL Server and the Microsoft Data Platform. His interests involve internals, performance optimization, and cloud technologies. He is very active in the Chicago data platform community, and a frequent speaker at local, national, and international events.

    4
  • Shop Talk

    Online event

    Do you have a question about SQL Server or the data platform space? Are you running into technical problems in the office and want a second opinion? Do you have an urge to stump our panel with arcane or weird scenarios--or watch others do just that to us? Then Shop Talk is for you.

    Shop Talk is a Q&A-driven broadcast featuring Mala Mahadevan, Tracy Boggiano, Mike Chrestensen, and Kevin Feasel. Each week, we will dedicate one hour to answering your questions, including live questions with no prep (and I can't see how that could possibly go wrong!). Send questions to us on the air at https://www.twitch.tv/trianglessug or get them to us early by e-mailing [masked] and give us a fighting chance to come up with the right answer.

    Prior episodes' show notes are available at https://shoptalk.tripass.org .

  • Shop Talk

    Online event

    Do you have a question about SQL Server or the data platform space? Are you running into technical problems in the office and want a second opinion? Do you have an urge to stump our panel with arcane or weird scenarios--or watch others do just that to us? Then Shop Talk is for you.

    Shop Talk is a Q&A-driven broadcast featuring Mala Mahadevan, Tracy Boggiano, Mike Chrestensen, and Kevin Feasel. Each week, we will dedicate one hour to answering your questions, including live questions with no prep (and I can't see how that could possibly go wrong!). Send questions to us on the air at https://www.twitch.tv/trianglessug or get them to us early by e-mailing [masked] and give us a fighting chance to come up with the right answer.

    Prior episodes' show notes are available at https://shoptalk.tripass.org .

  • Introduction to Azure Synapse Analytics - Jamey Johnston

    Azure Synapse Analytics is a cloud hosted analytics service in Azure that unifies data ingestion, data warehousing and data analytics at extreme scale. Basically, it’s a one-stop shop for all your data and analytics needs no matter how much data! It offers ways to consume data in dedicated SQL resources or serverless SQL resources in data lakes as well as analyze data in Apache Spark.

    Using demos, we will learn how to setup and start using Azure Synapse Analytics and understand why you want to use Azure Synapse Analytics. We will see how to take data and bring it in to Synapse and consume it in Synapse and in tools like Power BI and Apache Spark.

    Jamey is a Senior Data Scientist/Engineer for a large O&G company. For 30 years, he has worked for Fortune 500 companies architecting successful platforms in the cloud, on the edge and on-premises for BI reporting, statistical analysis, ML and AI in Azure, Python, R, Power BI, MS SQL and SAS JMP. He holds a BS in Spatial Analysis from LSU and a Masters of Science in Analytics from Texas A&M. He is a professor at Texas A&M in the MS Analytics program. He is a Microsoft Data Platform MVP.

    3
  • Data Engineering Brick-by-Brick: An Intro To Azure Databricks by Chris Hyde

    Do you want to be a Data Engineer in the next step on your career path? Maybe you're just getting started in the rapidly-growing Data Science and Analytics space? Or perhaps you're already doing on-premises analytics and want to take things to the cloud? Then come to this introductory session and see what Azure Databricks can do for you!

    Azure Databricks provides a cloud-based Apache Spark environment that can be scaled up and out to tackle your big data analytics needs. We'll look at how to set up your first Azure Databricks cluster, how to use shared notebooks in a collaborative environment, and how to leverage the integrated Azure Machine Learning capabilities. We'll also discuss where Azure Databricks fits in the modern cloud data warehouse.

    Chris Hyde is a Microsoft Data Platform MVP based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.

    4
  • Shop Talk

    Online event

    Do you have a question about SQL Server or the data platform space? Are you running into technical problems in the office and want a second opinion? Do you have an urge to stump our panel with arcane or weird scenarios--or watch others do just that to us? Then Shop Talk is for you.

    Shop Talk is a Q&A-driven broadcast featuring Mala Mahadevan, Tracy Boggiano, Mike Chrestensen, and Kevin Feasel. Each week, we will dedicate one hour to answering your questions, including live questions with no prep (and I can't see how that could possibly go wrong!). Send questions to us on the air at https://www.twitch.tv/trianglessug or get them to us early by e-mailing [masked] and give us a fighting chance to come up with the right answer.

    Prior episodes' show notes are available at https://shoptalk.tripass.org .

  • Selecting the Correct Size Azure Virtual Machine by Tim Radney

    When considering a migration of your SQL Server workloads to the cloud. It is critical to consider the performance characteristics of your existing workloads and understand any current pain points that you may have. This is important regardless of if it’s a migration to Azure SQL Database, Azure SQL Managed Instance, or Azure SQL Virtual Machines.

    In this session, Tim Radney will cover various performance metrics to collect and show how to use those metrics to determine what size Azure Virtual Machine that you’ll need to support that workload. In addition to the size of the virtual machine, we’ll dive into storage and discuss the various disk configuration options that are available.

    At the end of this session, you’ll have a much deeper understanding of Azure Virtual Machine sizing, Azure disk configurations, and ultimately how to monitor disk throughput.

    Tim is a principal consultant for SQLskills.com, author, and trainer. Over the past 19 years he has had roles from systems administrator working on Windows, Netware, Citrix and SQL Server to eventually focusing strictly on Microsoft SQL Server.

    Tim holds certifications across many aspects of IT and is dedicated to paying it forward within the SQL Server community. He serves as the chapter leader for the Columbus GA SQL Users Group, is a PASS regional mentor for the Southeast USA and is a regular speaker at SQL user groups, SQL Saturday's, and other SQL conferences. Tim blogs at http://www.timradney.com

    1
  • Shop Talk

    Online event

    Do you have a question about SQL Server or the data platform space? Are you running into technical problems in the office and want a second opinion? Do you have an urge to stump our panel with arcane or weird scenarios--or watch others do just that to us? Then Shop Talk is for you.

    Shop Talk is a Q&A-driven broadcast featuring Mala Mahadevan, Tracy Boggiano, Mike Chrestensen, and Kevin Feasel. Each week, we will dedicate one hour to answering your questions, including live questions with no prep (and I can't see how that could possibly go wrong!). Send questions to us on the air at https://www.twitch.tv/trianglessug or get them to us early by e-mailing [masked] and give us a fighting chance to come up with the right answer.

    Prior episodes' show notes are available at https://shoptalk.tripass.org .

  • Alteryx Spatial: Zip Codes and Random Forests by Rick Pack

    This talk will use the spatial tools of the data science software, Alteryx, to explore challenges and easy but imperfect solutions for performing demographics analyses using ZIP codes. Use of the Random Forrest prediction algorithm will be included.

    A ZCTA (zip code tabulation area) maps to census blocks whereas a ZIP (zone improvement plan) code expresses less geographically predictable mail delivery routes. A business such as a hospital or prison can receive enough mail to have its own zip code. This presents a problem in demographic analyses because the population in such cases will be zero even though there may be analyzed incidents such as diseases that are counted in that zip.

    ZIP codes, also unlike ZCTAs, can overlap state and county boundaries, which presents challenges to aggregating zip-code level data. A ZIP code can also correspond to a PO Box and therefore not be associated with a population.

    ***
    Rick Pack is a Data Scientist in Raleigh / Durham, NC who uses R, SAS, SQL, and Alteryx to perform a variety of business and population health analyses. He has a Master’s of Applied Statistics from Penn State University and over 10 years of professional data science experience. For fun, he runs in master's (adult) track meets, and most enjoys the 400m sprint.

    14