Database Administration DevOps & Automation DevOps Transformation
Cambridge, England, United Kingdom
Kendra Little (she/her) has specialized in relational database performance and automation for 20 years. Kendra worked as a database administrator in both startup environments and for a Fortune 100 corporation. As a consultant and trainer, Kendra focused on performance tuning and database internals. Kendra joined Redgate as a Developer Advocate in 2018. She is currently a Product Manager at Redgate focusing on Database DevOps.
You're writing code for a SQL Server -- but you don't have any practical experience keeping SQL Servers alive and healthy in a production environment. In this session you will learn the essentials of database administration for a developer. We'll cover the essentials of what you need to know about locking and isolation levels, indexing and general performance, and practices that help you write and maintain code that behaves well with your production databases.
Making schema changes in SQL Server databases seems relatively simple -- at first. If you're a developer or DBA who needs to write or deploy scripts to upgrade SQL Server schema, you need to know about all the little gotchas where things go wrong. In this session, we'll cover issues from deferred name resolution to collation to the unique behavior of different SQL Server Editions. You'll take away a handy checklist to make sure that your deployment processes are up to the challenge.
Every IT professional should learn the basics of Git. Git is the industry standard for version control and is a powerful way to store, share, and collaboratively evolve database schema, operational scripts, configuration files, and more.
In this session, we will cover the following, using free tools:
* The basics of different Git implementations
* How to create a Git repo in Azure DevOps
* Essential Git commands for managing and sharing changes
* Tips for learning the Git CLI and using Git in Azure Data Studio and/or VS Code
* An overview of options for managing database-schema in Git