Month: August 2024

Event link at our Meetup page.

• 5:30 Networking
• 6:00 Meeting

Mastering Dynamic SQL

Dynamic SQL has a bad reputation. Some of it is even deserved. However, dynamic SQL can be a great tool to have in your toolbox when used correctly.

In this session, we’ll dive into creating and troubleshooting dynamic SQL syntax. We will start by examining various scenarios that would be good candidates for implementation. Then we’ll take a look at how it executes under the covers. We’ll discuss ways of smarter and safer ways of crafting our SQL statements. And of course, we will discuss various ways to debug the statements as well as add error handling.

You will leave this session with a better understanding and appreciation for how dynamic SQL works as well as why and when to use it.

Deborah Melkin

Deborah Melkin has been working as a database professional with SQL Server for over 20 years. She spends her days helping coworkers with all aspects of database design, queries, performance, documentation, and deployment. In 2016, she began her blog, Deb the DBA. Soon after that, she began speaking at SQL Saturdays and user groups. Deborah is a board member of the New England SQL Server User group (NESQL) and a member of the Azure Data Community Advisory Council. She was named “One To Watch” as part of the #Redgate100 and won Speaker Idol at PASS Summit 2019. Deborah is also a Microsoft MVP for the Data Platform.

In her spare time, Deborah can usually be found doing something musical or doing something geeky with her husband, Andy, and dog, Sebastian.

---

Event link at our Meeting page.

• 5:30 Networking
• 6:00 Meeting

5 Critical Considerations When Moving Your Database to the Cloud

Migrating an existing on-premises SQL Server application to the cloud can be a daunting task that consists of many complicated steps. In this webinar, we will focus on what is perhaps the MOST important step of the process – those that lead up to the actual move to the cloud.

We will dive deep into the most critical considerations for moving your data and databases into the cloud, whether you use Microsoft Azure, Amazon, or another cloud provider.

We will cover:

• Forecasting how much migration will cost
• The importance of cleansing your data before a major migration
• Fully documenting your data sources and metadata
• Choosing from many different tools and techniques to actually move data
• How to test data for fidelity
• How to maintain parallel systems during transitional phases

Attend this session with one of the industry’s database top experts!

Kevin Kline

Kevin Kline is a noted database expert and software industry veteran. A 20-year Microsoft Data Platform MVP and noted community leader in the IT industry, Kevin is a founder and former president of the Professional Association for SQL Server (PASS.ORG), as well as the author of popular IT books including the bestseller “SQL in a Nutshell”. Kevin is a top-rated speaker at industry trade shows worldwide and has a monthly column at Database Trends & Applications magazine (DBTA.com). His product designs for database tools have won numerous awards at industry trade shows and from a variety of trade magazines. He is on social media as @kekline and blogs regularly.

---

Event link at our Meetup page.

• 5:30 pm Networking
• 6:00 pm Meeting

Parallelism in Azure SQL

SQL Server can execute queries in parallel which can sometimes improve the performance of your queries. However, parallelism has its own challenges; therefore, we will look at the concept of parallel executions to understand when it makes sense to run a query on more than one thread. We deal with topics such as CXPacket, threads, workers, execution context, branches, MAXDOP, Cost threshold for parallelism, NUMA nodes and the iterators that SQL Server can implement in the execution plan to enable parallelism.

Torsten Strauss

Torsten (MVP, MCSE, MCT) has been working with Microsoft SQL Server since the turn of the millennium and is specialized in performance optimization for large SQL Server environments.

He has been with bp as a Senior Software Engineer for over two decades and collaborates closely with Sarpedon Quality Lab as a Principal Microsoft SQL Server Consultant.

Torsten has given more than 200 presentations on Microsoft SQL Server performance optimization at national and international conferences and user groups.

Torsten has been recognized as a Microsoft Most Valuable Professional for Data Platform since 2018.

---