Drew Skwiers-Koballa
Program Manager at Microsoft
Seattle, Washington, United States
Actions
Drew Skwiers-Koballa is a Principal Program Manager at Microsoft, focusing on building tools that make databases more accessible and powerful for developers. Before joining Microsoft in 2020, he spent nearly a decade as a developer, database administrator, and team lead. Drew immensely enjoyed being a technical reviewer for the book "Practical Azure SQL Database for Modern Developers." As a relentless learner and occasional developer, his work spreads across several blogs, videos, and samples linked from https://github.com/dzsquared. He has an MS in computer science from Georgia Tech and an MS in chemistry from the University of Minnesota.
Area of Expertise
Topics
Unified DevOps for Microsoft Fabric, Azure SQL, and SQL Server with next-gen SQL projects
With Microsoft.Build.Sql SDK-style SQL projects, your database objects are stored as code for seamless development in Microsoft Fabric and client tools like VS Code and Visual Studio, but the advantages don’t stop there. The modernized SQL projects format backs Fabric’s git integration and deployment pipelines for Data Warehouse and SQL database, providing interoperability with extended CI/CD capabilities and your existing DevOps investments for SQL Server, Azure SQL Database, and Synapse Data Warehouse. SQL project’s code analysis and other build-time tests validate database code quality and correctness during continuous integration of code changes. With SQL projects delivering database object updates is easier and more reliable whether you're managing one database or a fleet of databases because the deployment plan is dynamically calculated through the SqlPackage CLI. In this session we’ll learn how to leverage the Fabric experiences for database DevOps in addition to the depth of capabilities from SQL projects such that we can efficiently develop and deploy database changes with source control integration, all with the tools you love.
SQL Projects and Source Control Integration for SQL in Fabric, Azure SQL, and SQL Server
This workshop is a deep dive on database DevOps centered on the SQL database projects format, where you will learn practical techniques for managing database changes whether your workload is operational, analytical, or somewhere in between. Our exploration begins with the foundational CI/CD capabilities for SQL projects, where you can ensure no matter how a database is developed it is in source control and can be verified before deployments to one or more environments. The same shared SQL projects format applies to the whole Microsoft SQL family, so we'll examine the advantages and special capabilities to understand when implementing DevOps practices for Fabric SQL, Azure SQL, or SQL Server. We conclude our workshop with some special topics at the core of good data DevOps practices, including security management, static data management, and coordinating changes with other workloads.
10 Visual Studio Hidden Gems for Database Development
Visual Studio is well-known as a C# and C++ developer tool, but its depth of capabilities around SQL Server features is rarely discussed. These components benefit developers by providing tools to implement SQL Server databases or maintain analytics solutions with SQL Server Integration Services and Reporting Services. The SQL database functionality in Visual Studio can make ongoing development easier and enable better integration of your database components with existing CI/CD pipelines. This session will highlight 10 features that can improve your database development experience in Visual Studio.
Next-gen SQL projects with Microsoft.Build.Sql
Your database objects are stored as code for development in Visual Studio or VS Code with Microsoft.Build.Sql SDK-style SQL projects, but the advantages don’t stop there. SQL code analysis and other build-time tests can validate database code quality and correctness during continuous integration of code changes. With SQL projects delivering database object updates is easier and more reliable whether you're managing one database or a fleet of databases because the deployment plan is dynamically calculated through the SqlPackage CLI. In this session we’ll learn how to develop and deploy your database alongside your app components with SQL projects from the IDE to CI/CD.
Dac Eff What? Customize your database DevOps practices with SqlPackage and DacFx
In this session we’ll learn how to augment your DevOps practice for databases and open the door to more advanced scenarios with the Data-Tier Application Framework (DacFx). Your “database as code,” SDK-style SQL projects bring new options to development processes through declarative database schema definition. A baseline knowledge of DacFx will enable you to unleash the power of database DevOps in your environment. Through a focus on demos, we will apply SQL projects and the DacFx namespace such that you are ready to take full control of your development process.
Live! 360 Tech Con Orlando 2024 Sessionize Event
.NET Conf 2024 Sessionize Event
SQLBits 2024 - General Sessions Sessionize Event
#DataWeekender #TheSQL Sessionize Event
dataMinds Connect 2020 (Virtual Edition) Sessionize Event
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top