SQL development is evolving fast, and Microsoft.Build.Sql is leading the charge. This next-generation SDK brings flexible project structures, better source control integration, automated build-time validation, and streamlined deployments with Azure DevOps and GitHub Actions -- helping teams manage database changes as seamlessly as application code.
To help developers get up to speed, Microsoft's Drew Skwiers-Koballa will present "Next-gen SQL Projects with Microsoft.Build.Sql" at the big Visual Studio Live! @ Microsoft HQ happening Aug. 4-8 at the company's campus in Redmond, Wash. His session will show how to modernize database workflows, improve code quality, and integrate database updates into full DevOps pipelines.
Ahead of the conference, we caught up with Skwiers-Koballa to learn more about Microsoft.Build.Sql, migration strategies, and what's coming next.
VisualStudioMagazine: What inspired you to present a session on this topic?
Skwiers-Koballa: The SQL projects capabilities for interacting with database deployments aren't new as a concept, but we just released the v1 of a project SDK that introduces improvements and simply, we're not done.
With more updates to the Visual Studio interface for SQL projects coming up and an immediate iteration to v2 of the Microsoft.Build.Sql SDK, there's new ways to increase your confidence in database changes.
How does Microsoft.Build.Sql enhance the management and deployment of SQL projects compared to traditional methods?
The Microsoft.Build.Sql SDK v1 introduces package references and a more flexible project format to SQL projects, meaning that you can quickly generate a SQL project from any source through automation and manage relationships in complex environments more easily.
Creating database objects and being able to deploy them is common functionality for a library with ORM functionality like EF Core, but being able to provide a dynamic script and analysis of the impact of the deployment specific to an environment is part of the SqlPackage CLI for SQL projects. You can continue with active EF Core development while benefiting from the deployment management through SQL projects by including the automatic generation of a SQL project as part of continuous integration for your app components.
What are the key benefits of using Microsoft.Build.Sql for version control in SQL development?
In addition to the deployment benefits from SQL projects, Microsoft.Build.Sql projects represent each database object as an individual SQL script. Your database is now a human-readable definition in source control, just like your application code. In your source control system the advantages of branching, commit history, and PR reviews now also apply to your database code by increasing the visibility to what is being changed, when it is being changed, and why it was changed.
What considerations should be taken into account when migrating existing SQL projects to utilize Microsoft.Build.Sql?
To convert an existing SQL project to Microsoft.Build.Sql, you should absolutely create a backup of the project file -- this is the only file that's changed during the migration. If you're migrating in either direction, you should know about a command-line tool called "DacpacVerify." This dotnet tool compares two dacpacs to confirm that the SQL project build artifacts match, a sign that the conversion was completed correctly.
If you're migrating an existing SQL project to the Microsoft.Build.Sql SDK you will benefit from the better compatibility of the project between VS Code and Visual Studio, but you need to be aware that the Visual Studio components are in preview. Each Visual Studio release brings new features and we're excited to complete the support for Microsoft.Build.Sql in Visual Studio soon.
Can you discuss any performance improvements observed when using Microsoft.Build.Sql in large-scale SQL projects?
As a piece of a DevOps toolkit, Microsoft.Build.Sql projects enable database and people efficiencies. Visibility to database changes in a pull request review enables a team to catch database design issues before they land in active environments, protecting the database workload from issues that can be quickly noticed like a table without indexes. You aren't on your own with SQL projects, because code analysis in SQL projects has access to the entire object model and can point out issues like inserting a 100-character variable into a 75-character column.
Concretely, Microsoft.Build.Sql projects support building with .NET 8+, so your database component can be built with the same Linux pipeline hosts as the rest of your app with the usual performance gain of a Linux pipeline. If you deconstruct a large database into multiple SQL projects, each piece can be updated on different cadences and made available on package feeds instead of built as a single project monolith. The build time varies based on the pieces to be updated and can significantly reduce the amount of time a developer waits for their changes to validate as part of code check-in.
Can you discuss any new features or planned improvements for Microsoft.Build.Sql that developers should watch for?
Watch for improvements in the Azure DevOps and GitHub integration for Microsoft.Build.Sql as well as the introduction of support for SQL Server 2025 with JSON and VECTOR types.
What resources can attendees use to learn more about this topic and prepare for your session?
Head over to aka.ms/sqlprojects for documentation that spans from getting started tutorials to in-depth reference information.
Note: Those wishing to attend the session can save money by registering early, according to the event's pricing page. "Save $400 when you register by the June 6 Super Early Bird deadline" said the organizer of the event, which is presented by the parent company of Visual Studio Magazine.
About the Author
David Ramel is an editor and writer at Converge360.
Posted by David Ramel on 04/29/20250 comments
Change-bringer and 21-time Microsoft MVP Robert Bogue studies employee burnout, but he doesn't believe in work-life balance. He believes in work-life harmony. It's an interesting difference.
Long hours, shifting priorities, and the relentless pressure to deliver clean code under tight deadlines -- these are just a few of the stressors that define life in modern software development. While the work can be deeply fulfilling, it can also take a mental and emotional toll, leading many developers down the path of burnout. It's a phenomenon most in the industry have either experienced firsthand or witnessed in colleagues: the creeping exhaustion, rising cynicism, and sense of ineffectiveness that can sap motivation and stifle innovation.
At the Visual Studio Live! developer education conference taking place at Microsoft headquarters in Redmond in August, the veteran consultant and developer advocate returns to the community to tackle this issue head-on with his session, Burnout in Software Development. Drawing on more than two decades of experience and research -- including his co-authored book "Extinguish Burnout: A Practical Guide to Prevention and Recovery" -- Bogue offers both personal perspective and practical tools to help developers and organizations spot the warning signs, intervene early, and create healthier, more sustainable work environments.
The session is designed for attendees at an introductory to intermediate level and will explore the root causes of burnout in technical roles, outline effective strategies for recovery, and provide insights into building cultures that promote efficacy and resilience. Whether you're an individual contributor feeling stretched thin or a team leader looking to better support your developers, this session promises actionable advice grounded in both science and lived experience.
In the following Q&A, Bogue discusses what inspired his return to this important topic, how developers can recognize burnout in themselves and others, and why organizations need to rethink their approach to culture, productivity, and learning.
VSLive! What inspired you to present a session on this topic?
Bogue: I first encountered burnout with my development team in 2003. I wrote about it, then largely forgot about it. In 2018 we were struggling with one of our children and burnout impacted both my wife and me. The result of that was more research and work which culminated in the book "Extinguish Burnout: A Practical Guide to Prevention and Recovery," that we wrote for the Society for Human Resource Management (SHRM).
"I felt like I needed to return to my roots and share how burnout works and what can be done about it with my fellow developers"
Robert Bogue, President, Thor Projects LLC
While we've been doing these presentations to all types and sizes of organizations, I felt like I needed to return to my roots and share how burnout works and what can be done about it with my fellow developers. It's such an issue for us as we often don't get to see the results of our hard work.
What are the early signs of burnout that developers should be aware of to take proactive measures?
Burnout is defined by exhaustion, cynicism, and lack of efficacy. If these things are becoming central to who you are and how you show up, there's a problem or potential problem. For me, I first experienced it as a lack of care. I just didn't care about my work, my craft, as a developer any longer. I felt like I was losing a part of who I was -- and I didn't know where I had lost it.
Can you share effective strategies for maintaining a healthy work-life balance in the software development industry?
I don't believe in work-life balance. I believe in work-life harmony. The difference is that balance is something that you can't achieve in a permanent sense. There will always be the big project. There will always be the things at home that disrupt your ability to work. When I'm looking for harmony, I'm trying to make things fit together and realizing that sometimes one part is in the front and other times there are other parts of my life that need to take precedence. I think that one of the great things about our work is that we get to spend so much time in flow. That can be powerful and addicting. We need to find ways to value and invest in other parts of our life as well.
What role does company culture play in preventing or contributing to developer burnout?
Most corporate cultures belong in a petri dish. I've got 30+ years of consulting experience and it's rare to find a universal positive culture. For organizations that want the benefits of burnout proofing, they'll want to help people feel more effective. In the session, I'll give direct advice to leaders about how to recognize results, ensure support, prioritize self-care, and how to carefully manage demands. To the extent that organizations don't encourage people to feel effective, they're encouraging burnout.
How can team leaders identify and address burnout within their development teams?
Identification is most visible with cynicism. They just don't believe they can make a change anymore. Addressing burnout is often as simple as focusing on how to help developers be -- and feel -- more productive.
How can organizations support continuous learning without overwhelming their developers?
Learning is so important as a developer. We must find ways to learn what we need to learn to be productive. One of the things that I love about the VSLive! Events is the way that we can all come together and learn new things that are both practical and relevant to what we're doing. Organizations have defaulted to older mechanisms of training that don't have the richness of conversation. I think that learning how to identify which types of learning are simply skill acquisition and which ones are craft enhancement is key to organizations enabling developers to have the right experiences and achieve the right results.
What resources can attendees use to learn more about this topic and prepare for your session?
Attendees are encouraged to look at the over 60 articles and other resources we have on the http://ExtinguishBurnout.com site. It's a good primer for what they can do to start preventing and recovering from burnout today. And, they're always welcome to reach out via one of my web sites or via LinkedIn.
Posted by David Ramel on 04/15/20250 comments
In today's rapidly evolving development landscape, the need for creating high-performance, responsive business applications is more crucial than ever. Blazor, a cutting-edge web framework from Microsoft, empowers developers to build sophisticated business applications with a unique blend of .NET and web technologies.
By using Blazor's server-side capabilities, developers can create modern Single Page Applications (SPAs) while minimizing the need for JavaScript. This approach not only speeds up the development process but also enhances the debugging experience and leverages existing .NET skills and libraries.
Expert Blazor programmer Michael Washington will help developers get a handle on this tech in his upcoming session at the big Visual Studio Live! developer conference coming to Microsoft headquarters in August. In a session titled, "Creating Business Applications Using Blazor," he will guide attendees through the core concepts of Blazor, such as binding, routing, and JavaScript interoperability.
With a hands-on demonstration, attendees will see how to create a complete business application that integrates data, implements Google and Microsoft authentication, and incorporates a custom chatbot. Whether you're a newcomer to Blazor or looking to deepen your expertise, this session promises invaluable insights into building secure, high-performance business applications using Blazor's powerful ecosystem.
Ahead of the session, we had the opportunity to sit down with Michael to discuss what attendees can expect and the latest trends in Blazor development. Here's what he had to share.
VisualStudioMagazine: What inspired you to present a session on this topic?
Washington: Blazor is constantly evolving, and there's always something new and exciting to discuss. It's the technology I use daily, both professionally and in my personal open-source projects.
How does Blazor's component-based architecture enhance the development of business applications?
Blazor has a vast ecosystem of components, covering everything from data grids to themes and even full application frameworks like CMS solutions.
"Blazor has a vast ecosystem of components, covering everything from data grids to themes and even full application frameworks like CMS solutions."
Michael Washington, Programmer
This enables companies and developers to achieve a significant return on investment when using Blazor for their business applications.
Can you provide examples of how Blazor facilitates seamless integration with existing .NET libraries in business applications?
Blazor is built on .NET, so anything designed for .NET works seamlessly with it. For example, I have several projects integrating Azure OpenAI and Azure Authentication. Additionally, many of Microsoft's sample applications, which were previously built with MVC, are now written in Blazor.
What are the key performance optimization techniques recommended when developing business applications with Blazor?
I have developed over 100 applications with Blazor, and 99% of them use Blazor Server. That's my first recommendation. The only times I've used Blazor WebAssembly are when the application needs to function without internet connectivity.
How does Blazor's support for WebAssembly impact the scalability and responsiveness of business applications?
I built an application called aistorybuilders.com that allows users to create AI-generated stories. This free application serves thousands of users worldwide, and using WebAssembly enables me to distribute and maintain it at no cost. However, for typical business applications, I only use WebAssembly when users may not have consistent internet access but still need to use the application.
What best practices should be followed to ensure secure authentication and authorization in Blazor business applications?
For all new applications, I use Microsoft Entra and Azure B2C because multi-factor authentication, threat analysis, and security protections are essential for business applications.
What resources can attendees use to learn more about this topic and prepare for your session?
My website, blazorhelpwebsite.com, is where I blog about Blazor topics, provide examples, and share in-depth insights.
Note: Those wishing to attend the session can save money by registering early, according to the event's pricing page. "Save $400 when you register by the June 6 deadline," said the organizer of the event, which is presented by the parent company of Visual Studio Magazine.
About the Author
David Ramel is an editor and writer at Converge 360.
Posted by David Ramel on 04/08/20250 comments