Export/Import Data using BCP - SQL Server on Linux
In this article you will learn how to use BCP for SQL Server on Linux to export and import data using the BCP command line utility.
2020-01-30
1,586 reads
Containers
ASP.NET Core with GitOps: Dockerizing an API on AWS EC2
As more shops begin automating build and deployment pipelines, it’s critical to learn about containerization. In this article, Mircea Oprea walks you through deploying an ASP.NET Core API in a Docker container.
2019-11-12
Managing SQL Server containers using Docker SDK for Python - Part 2
There are multiple ways to interact with the Docker daemon, as command line client API or GUI based tools like Kitematic. Docker also provides a SDK for Go and Python, this SDK can be used to create and manage Docker containers the same way it works with the Docker engine API.
2019-09-16 (first published: 2019-09-10)
1,458 reads
Creating Your First SQL Server Docker Container in macOS
The use of macOS by developers and IT professionals has gained popularity the past few years. Running a sandboxed SQL Server, however, has been difficult. That changed when Microsoft made SQL Server images on Docker available. In this article, Carlos Robles explains how to get started with Docker when running macOS.
2019-06-20
Managing SQL Server containers using Docker SDK for Python - Part 1
There are multiple ways to interact with the Docke...
2019-06-13
3,351 reads
Ordering T-SQL Scripts with Git and PowerShell
Learn how you can ensure that scripts are executed in a specific order with Git and PowerShell for use in a Docker container.
2019-05-28
4,198 reads
Creating Aliases for Docker Commands in Linux
In this article you will learn how to create and use alias commands for Docker, to make Docker's command line experience easier and more productive.
2019-05-20
2,424 reads
Creating Your First SQL Server Docker Container in macOS
The use of macOS by developers and IT professionals has gained popularity the past few years. Running a sandboxed SQL Server, however, has been difficult. That changed when Microsoft...
2019-05-13
Creating a custom kubectl plugin to connect to SQL Server in Kubernetes
One of the really cool things about kubectl (pronounced cube control) is the ability to extend it’s functionality with custom plugins. These plugins are simply files named kubectl-xxx dropped...
2019-04-17
Getting Started with Docker
Achilleus has a brief primer on Docker: Now that we know, some basic definitions. It’s time we ask the main question! Why do I care? There are many reasons...
2019-04-15
Blogs
Join me at SQLBits 2020
The SQLBits conference is taking place in London again this year, between March 31st...
DBA, a job, a vital job
DBA, a job, a vital job. T-SQL a language that is fun. Select, a...
SOS_SCHEDULER_YIELD – What is it really telling us?
I decided to write this off the back of a conversation I was having...
Forums
SMO Certificate Export - FailedOperationException
Greetings, Given this Powershell SMO method call... $_cert.Export("$CertificateLocation\$_cert_name.cer", ` "$PrivateKeyLocation\$_cert_name.pvk", ` $_secret) where $_cert...
Resultset in a format
I have the following tables: create table #EmployeeSystemsMaster(EmployeeSystemID int, EmployeeSystemName nvarchar(150)) insert into #EmployeeSystemsMaster...
SQL Server data masking
Can you able to mask data in sql server 2012? If yes, would it...
Ask SSC