SQL Server database backup to Azure Blob Storage
A guide to automating SQL Server database backups as BACPAC files and uploading them to Azure Blob Storage using SqlPackage and AzCopy.
Gunnar Peipman is an experienced software developer and long-time Microsoft MVP from Tallinn, specializing in .NET and Microsoft technologies. He actively shares knowledge through blogs, forums, and developer communities.
25 articles from this blog
A guide to automating SQL Server database backups as BACPAC files and uploading them to Azure Blob Storage using SqlPackage and AzCopy.
Explains how to use C# 10's global usings feature to simplify namespace imports across .NET 6 projects, including ASP.NET Core applications.
Analyzes the performance cost of exceptions in .NET, showing how they slow down loops and offering optimization advice.
Explains C# 9.0's top-level programs feature, simplifying code structure for beginners and utility applications.
A guide to translating NHibernate LINQ queries to SQL without executing them, using a custom ToSql() extension method for debugging.
A technical guide on configuring NHibernate to log generated SQL statements to ASP.NET Core's built-in logging system using interceptors.
A guide to implementing dependency injection using StructureMap in legacy ASP.NET MVC applications, covering controllers and non-DI components.
A guide to setting up and using Visual Studio Codespaces with Visual Studio Code for developing ASP.NET Core web applications in the cloud.
A review of the Surface Go 2 hybrid tablet/laptop, focusing on its portability, always-connected LTE, and full Windows 10 experience for mobile productivity.
Fixes an IIS Express port conflict error caused by reserved Windows port ranges, providing a solution to change the application port.
A humorous guide to logging ASP.NET Core application messages directly to a Notepad window using a custom NuGet package.
Microsoft's Azure Static Web App service for hosting static JavaScript apps with GitHub integration and Azure Functions support.
Microsoft announces .NET MAUI, the evolution of Xamarin.Forms, enabling single-project, cross-platform app development for desktop and mobile.
A technical guide exploring the setup and benefits of hosting a WordPress blog behind Azure Front Door for global traffic routing and performance.
A brief introduction to using Dapper, a popular micro-ORM, for database operations in ASP.NET Core applications.
Explains how to use NHibernate's future results feature to batch database queries, reducing network traffic and improving performance.
A guide on displaying enum values as select lists in ASP.NET Core, including custom names and translations using DisplayAttribute.
Explains how to use EF Core 5.0's ToQueryString() method to translate LINQ queries to SQL without executing them against the database.
A guide on building and testing complex query strings in ASP.NET Core controller unit tests, covering encoding and multiple values.
A guide to automating SQL Azure database updates using Visual Studio database projects and Azure DevOps pipelines.