Dockerizing an MSSQL Server (header image)

Dockerizing an MSSQL Server: Unlocking Flexibility

Alex Cassells Articles, Databases, Development Technologies & Tools, Docker, SQL, SQL Server, Tutorial Leave a Comment

Docker is a pretty magical tool that streamlines server and environment setup while helping to eliminate the operating system and software version variables. It’s one of the best ways to mitigate the classic ‘Works on my machine!’ obstacle many developers run into when sharing or promoting their code.

When a lot of people think of Docker, the last thing they think of is Microsoft or Windows. It took many years for Docker to even officially support Windows. As a .NET developer, I always wanted the stability that Docker offers, and today, I can have it. In the post below, I’ll dive into how to dockerize an MSSQL Server.

SQL Server Agent Jobs with Spring Batch

Monitoring SQL Server Agent Jobs with Spring Batch

Josh Green Articles, Development Technologies & Tools, Java, Modernization, Spring Batch, SQL, SQL Server Leave a Comment

In this blog post, I will demonstrate a technique to query the status of a SQL Server Agent job that executes the SSIS package. SQL Server Agent scripts are asynchronous in nature. This can make it difficult to make code decisions based on the execution status of a script of this type.

Parameterizing Queries in SQL

Parameterizing Queries for SQL Server

Clayton Neff Articles, Databases, Programming, SQL, SQL Server 2 Comments

This is just a short article (more of a blog-ette than a full blog) about some things we as developers need to consider when sending queries to Microsoft’s SQL Server. While some of this information may also be true for other flavors of database servers, these things are known to be true for SQL Server.