There are several Microsoft SQL Server container images available for download. These consists of SQL Server 2017 and now SQL Server 2019 CTP2.1. Most of those can be found here. However, what if you need to customize an image by adding additional features? Docker provides a command line utility to build new images using Dockerfiles. […]
Microsoft SQL Server Containers
I’m a Database Administrator, why am I learning about containers? So, it seems containers are here to stay. Before the release of SQL Server 2017, I really hadn’t paid attention to this space. The thinking was I’d never need to know about any other OS except Windows Server. This all changed when Microsoft decided to […]
Adding an Integration Services Catalog to Always On Availability Groups – Subquery Error
This month’s T-SQL Tuesday topic by Wayne Sheffield (t) is “Tell me about your Brick Wall and how you overcame it.” I hadn’t originally planned this post for this reason, but it’s right on topic. I recently discovered an issue while adding an Integration Services Catalog to a SQL Server 2016 Availability Group. SQL […]
Script databases and objects using Powershell
As a DBA, one of the requests I commonly get is to provide database scripts to developers from environments in which they may not have access to. These scripts are then used to setup dev environments, comparisons, etc. This is an easy enough request using SQL Server Management Studio, or if you’re lucky, using other […]