Skip to content
  • About
  • Courses
  • Contact

Scaling Out Singleton Insert Workloads Using Containers: Part 1

  • by datatake
  • Posted on January 1, 2018January 4, 2018
  • Uncategorized

I will forewarn readers of this blog post that this is ‘Conceptual’ in nature, due to the fact in my tests I was spinning up containers which then fell over with core dumps. Nonetheless, I […]

Read More

Automated T-SQL Unit Testing With Jenkins, Docker, tSQLt and The JUnit Plugin

  • by datatake
  • Posted on December 13, 2017December 13, 2017
  • Uncategorized

To date I have almost exclusively focused on building and deploying DACPACs to conventional and container-ised SQL Server environments without any testing. This post extends the one on multi-branch pipelines and dockerĀ  by adding two […]

Read More

Good Practices For Spinning Up SQL Server Containers In Jenkins Build Pipeline As Code

  • by datatake
  • Posted on December 4, 2017
  • Uncategorized

Spinning up containers should generally be very rapid, however some container images, in particular those for SQL Server may take of the order of seconds to spin up. Take the following Jenkins pipeline groovy script […]

Read More

Creating A Docker Containerised Environment For SQL Server and Continuous Integration

  • by datatake
  • Posted on October 19, 2017
  • Uncategorized

This post covers building a simple continuous integration environment using Jenkins and SQL Server data tools which is fully containerised. There are two github repositories associated with this post, the first contains the files for […]

Read More

Jenkins Hybrid Windows Linux Build Pipelines For Docker and SQL Server

  • by datatake
  • Posted on September 8, 2017
  • Uncategorized

Consider a scenario in which you wish to use DACPACs, but you want to spin up SQL Server in a container on Linux (say Ubuntu) because you wish to forgo the cost of having to […]

Read More

Jenkins Multi-Branch Pipeline Builds Using Docker Containers and SQL Server

  • by datatake
  • Posted on August 31, 2017
  • Uncategorized

In this post I am going to demonstrate how to use one of Jenkins more powerful features ; its ability to create multi-branch build pipelines. Source Code Control and Branching 101 The very first step […]

Read More

Scale-able Windows Aggregate Functions With Row Store Objects

  • by datatake
  • Posted on July 24, 2017July 26, 2017
  • Uncategorized

In this post I will demonstrate how a neat trick brought to my attention by Niko Neugebauer can turn the processing of windowing functions from “Anti-scale” to scale-ability. First of all we need to create […]

Read More

Creating Continuous Integration Build Pipelines With Jenkins, Docker and SQL Server

  • by datatake
  • Posted on July 18, 2017July 20, 2017
  • Uncategorized

In the world of continuous integration and delivery where we might want to perform numerous builds a day. Docker is ideally suited for spinning up environments and then tearing them down afterwards in use cases […]

Read More

In-Memory Engine DURABILITY = SCHEMA_ONLY And Transaction Rollback

  • by datatake
  • Posted on July 17, 2017
  • Uncategorized

I was fortunate enough to be selected to speak at SQL Saturday Dublin, the talk I gave was on leveraging the in-memory engine, the basic flow of the presentation is thus: I ask the audience […]

Read More

The Fundamentals Of Processing A SQL Server Workload In A Scale-able Manner

  • by datatake
  • Posted on July 16, 2017October 18, 2017
  • Uncategorized

In this blog post I wanted to distill down the most fundamental points to consider when attempting to process a SQL Server workload in a scale-able manner. However, many of the principles I will outline […]

Read More

Posts navigation

Older posts
Newer posts

Archives

  • April 2022
  • March 2022
  • February 2022
  • April 2021
  • March 2021
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • September 2019
  • April 2019
  • February 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • June 2018
  • March 2018
  • January 2018
  • December 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • April 2017
  • July 2016
  • May 2016
  • April 2016
  • January 2016
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • October 2014
  • September 2014
  • July 2014
  • June 2014
  • May 2014
  • December 2013
  • June 2013

Meta

  • Register
  • Log in
Blog at WordPress.com.
Blog at WordPress.com.
  • Follow Following
    • chrisadkin.io
    • Join 45 other followers
    • Already have a WordPress.com account? Log in now.
    • chrisadkin.io
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...