What we're about

Training and support for individuals interested in a solid DBA foundation. We present a variety of topics but with the beginner to intermediate users in mind.

Upcoming events (4+)

GIT For DBAs - Justin Dearing

Online event

In 2005, Linus Torvalds developed the version control system (VCS) git. Since then, it has become as platform-agnostic and ubiquitous as the internet. Microsoft has fully embraced Git. It powers modern on-premise and cloud versions of TFS (now known as Azure DevOps) as well GitHub, which Microsoft recently acquired.
What does this mean to a DBA? Whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in version control.

In my session. We'll cover:

How do I use SSDT to help prevent developers from using code first ORMs? What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I set up git for internal use in my company? How do I host public and private repositories on GitHub? How do pull requests work? We will be covering using git from both the command line and Visual Studio.

ABOUT THE SPEAKER

Justin Dearing has been serving in IT capacities in various companies and industries since 2002. While mostly a Microsoft focused developer he has also been a PHP developer, a unit admin and an IBMi (AS/400) operator. Justin currently is a Senior consultant for Neudesic, and Microsft focused consulting shop.

1
SQL Assessment - Microsoft's Best Practices Checker - Taiob Ali

Online event

Do you want to get the current 232 suggested best practices from the SQL Server Team and evaluate your environments? These best practices are available for all instances, from your Data Center to the cloud.

In this all demo session (Yes, no slides), I will show you both the “what” and “how” to use the SQL assessment API. How to customize your checks and create your own rules that fit your environments? You will learn to identify a setting change after your initial review. The demo will use SQL assessment API, PowerShell cmdlets, and the new ‘SQL Assessment’ extension in Azure Data Studio to export assessment results in a SQL table and create an HTML report.

At the end of this session, you will be equipped with the toolset to set up and run your assessment, create customized rules, and determine your compliance score against suggested best practices.

Taiob Ali
Taiob Ali, Microsoft Data Platform MVP, is an accomplished technical leader with a proven record of success. During his last 16 years, he has worked with the Microsoft Data Platform and MongoDB, both on-premises and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare.

Taiob is currently working at “GMO LLC” as Database Solutions Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual chapters, Data Saturdays, and Azure conferences. He is a board member of New England SQL Server User Group, founder of 'Database Professionals Virtual Meetup Group', and organizer of Boston SQL Saturday.

Performance Tuning Azure SQL Database - Monica Rathbun

Online event

Have you moved to a cloud database like Azure SQL Database and are having performance issues? While the Azure SQL services running in Azure are similar to SQL Server, they are key differences in performance tuning methodologies. In this session, you will learn about monitoring options, changes in cloud DMVs, and additional cloud tuning tools like Azure SQL Analytics and Performance Insights that can allow you quickly get to performance data across a number of instances. You will learn about what you need to keep in mind when choosing between scaling-out to readable secondaries and scaling-up to higher tier solutions. Discuss with Microsoft MVP Monica Rathbun the challenges and benefits of tuning, what to keep in mind, and what to expect in the cloud.

Speaker: Monica Rathbun
Monica Rathbun lives in Virginia, is a Microsoft MVP for Data Platform, Microsoft Certified Solutions Expert and VMWare vExpert. She has nearly two decades of experience working with a wide variety of database platforms with a focus on SQL Server and the Microsoft Data Platform. She is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group, on the Microsoft Azure Data Community Board and the Data Saturdays Board. She is passionate about SQL Server and the SQL Server community, doing anything she can to give back. Monica can always be found on Twitter (@sqlespresso) handing out helpful tips. You can find Monica blogging at sqlespresso.com

Memory Optimized TempDB - Torsten Strauß

Online event

Metadata contention in tempdb has historically been a bottleneck to scalability for some workloads running on SQL Server. SQL Server 2019 introduces a feature named memory-optimized tempdb metadata which effectively removes metadata contention for tempdb-heavy workloads. In this session, we will understand how this feature works, how it is implemented, and when it is beneficial to use. We will also compare it to other techniques such as in-memory OLTP to decide which approach performs best for a given workload.

Speaker:
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 database engineer for over two decades and collaborates closely with Sarpedon Quality Lab as a Principal Microsoft SQL Server Consultant. Torsten is the founder of inside-sqlserver.com and has given more than 170 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.

Photos (5)