-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

The DBA Who Came In From The Cold

I’m Andrew Pruski and I am a SQL Server DBA with 5 years experience in database development and administration.

The online SQL Server community has helped me out immensely throughout my career, whether from providing reference material in blog posts, or answering my (sometimes obscure) questions on forums. So, to try and say thank you, I would like to contribute my own experiences in the hope that they could benefit someone out there.

So here’s my general ramblings and thoughts about working as a SQL Server DBA.

You can find me on twitter @DBAFromTheCold

If you have any feedback on my blog please send me an email to dbafromthecold@gmail.com.

SQL Saturday Cork 2018

This coming weekend (9th of June) is SQL Saturday Cork!

I’ve been really looking forward to this SQL Sat as there’s only one in Ireland each year. I’m not from Ireland but have been here for over 4 years now and the User Group in Dublin is where I… Read more

0 comments, 102 reads

Posted in The DBA Who Came In From The Cold on 4 June 2018

Deploying Azure Container Instances

In a previous post I went through how to Push an image to the Azure Container Registry

Now let’s look at using that image to create an Azure Container Image instance.

Azure Container Instances (ACI) are Microsoft’s serverless container technology. They allow us to spin up a container without having… Read more

0 comments, 1,550 reads

Posted in The DBA Who Came In From The Cold on 23 May 2018

Pushing SQL Server images to the Azure Container Registry

The Azure Container Registry is an online repository for storing Docker images (think the Docker Hub).

What’s cool about this is that we can store our images in the same data centre as our deployments, so spinning up containers from the images should be pretty quick. Let’s run through setting… Read more

2 comments, 1,255 reads

Posted in The DBA Who Came In From The Cold on 9 May 2018

Loopback available for Windows Containers

The April 2018 update for Windows brought a few cool things but the best one (imho) is that now we can now connect to Windows containers locally using ‘localhost’ and the port specified upon container runtime.

Let’s have a look at how this works.

First, spin up a container:-

docker…

Read more

0 comments, 1,515 reads

Posted in The DBA Who Came In From The Cold on 7 May 2018

Friday Reading 2018-05-04

Phew, busy week. In the middle of updating presentations and making sure demos work!

Here’s a few of the articles that I’ve managed to read this week…

Containers: The Future of Database Infrastructure?
Joey D’Antoni (b|t) takes a look at containers

Open-sourcing gVisor, a sandboxed container… Read more

0 comments, 129 reads

Posted in The DBA Who Came In From The Cold on 4 May 2018

Changing the location of docker named volumes

A few weeks ago I was presenting at SQL Saturday Raleigh and was asked a question that I didn’t know the answer to.

The question was, “can you change the location of named volumes in docker?”

This is one of the things that I love about presenting, being asked questions… Read more

0 comments, 1,450 reads

Posted in The DBA Who Came In From The Cold on 2 May 2018

Shiny Tech Syndrome

This is the name I give to anyone who, whilst learning a new technology, suddenly thinks it’s the best thing since sliced bread and consequently wants to shoehorn it in to everything.

(think that person who just started learning NoSql)

I’m not singling anyone out here as we are all… Read more

1 comments, 151 reads

Posted in The DBA Who Came In From The Cold on 30 April 2018

T-SQL Tuesday #101: My Essential SQL Server Tools


This month’s T-SQL Tuesday topic comes from Jens Vestergaard (b|t) who is asking us about our essential SQL Server Tools.

I’ve previously written about my Tools of the Trade but that was waaaay back in April 2016 and just after I published that blog, the tool… Read more

0 comments, 167 reads

Posted in The DBA Who Came In From The Cold on 10 April 2018

Friday Reading 2018-04-06

Feels like an age since I posted some links. So busy these days!

I’m really excited today as tomorrow I head to North Carolina for two weeks. My company’s HQ is out there and I’m also presenting at SQL Saturday Raleigh next weekend. My first American SQL Sat!

Recently, when… Read more

0 comments, 173 reads

Posted in The DBA Who Came In From The Cold on 6 April 2018

Changing the port for SQL Server in Azure Container Services

I got asked this question last week and it’s a very good one. After all, running Sql Server in Azure Container Services (AKS) does mean exposing a port to the internet to allow connections.

So leaving SQL Server listening on the default port can be risky.

Now I know there’s… Read more

0 comments, 1,338 reads

Posted in The DBA Who Came In From The Cold on 4 April 2018

Imposter syndrome

Last week I posted the following “joke” on twitter: –

I’ve called it a “joke” but I wasn’t really joking. This is a subject that I’ve wanted to talk about for a while but have really stalled on it because I don’t think that I can tackle it sufficiently, but… Read more

3 comments, 154 reads

Posted in The DBA Who Came In From The Cold on 2 April 2018

How I became a Data Platform MVP

As I spent last week attending my first MVP Summit in Seattle I thought I’d write this post about how I became an MVP.

It’s not atypical but I want to share how I went from really not having any direction in my career to becoming a DBA; starting to… Read more

0 comments, 272 reads

Posted in The DBA Who Came In From The Cold on 14 March 2018

A gotcha when switching partitions

When working with partitioning the SWITCH operation has to be my favourite. The ability to move a large amount of data from one table to another as a META DATA ONLY operation is absolutely fantastic.

What’s also cool is that we can switch data into a non-partitioned table. Makes life… Read more

0 comments, 1,196 reads

Posted in The DBA Who Came In From The Cold on 28 February 2018

Indexing and Partitioning

Partitioning tables is a great tool to increase the manageability of your data. Being able to move large amounts of data in and out of a table quickly is incredibly helpful.

However, partitioning comes with a whole bunch of caveats and we need to be aware of what’s going on.… Read more

0 comments, 1,341 reads

Posted in The DBA Who Came In From The Cold on 21 February 2018

Dealing with stress

Anyone who knows me will know that I’m something of a stress head. I tend to worry about things and have, in the past, let it get the better of me.

But I feel that over the last few years I’ve managed to get a handle of dealing with stress.… Read more

0 comments, 294 reads

Posted in The DBA Who Came In From The Cold on 19 February 2018

Friday Reading – Speaking Mentors

A new project underway is Speaking Mentors. I think this is an amazing idea and the response that it’s had already seems to have proved me right

There’s so many talented people involved I thought I’d put together a quick list of those who have written about the project… Read more

0 comments, 270 reads

Posted in The DBA Who Came In From The Cold on 9 February 2018

SQL Server in Kubernetes on Docker for Windows

Last week Docker announced a feature that I’ve been looking forward to for a while: –

And sure enough, when I opened Docker for Windows, there was the update: –

Let’s run through the steps to get this setup. First of all, enable the feature in settings: –

Once installed,… Read more

0 comments, 449 reads

Posted in The DBA Who Came In From The Cold on 7 February 2018

Giving back – Speaking Mentors

I’ve been incredibly lucky in my career. I’ve somehow managed to meet and become friends with highly talented people who are all experts in their respective fields.

They have (almost literally) dragged me into at first blogging, and then eventually speaking. I could not have done any of it without… Read more

0 comments, 228 reads

Posted in The DBA Who Came In From The Cold on 5 February 2018

Friday Reading 2018-01-26

It’s moving weekend! Hopefully two hard days and then I’ll be all settled in my new place. Cannot wait.

Inbetween packing all my belongings into cardboard boxes, I’ve been reading…

Linux Containers on Windows (LCOW)
Stefan Scherer (b|t) shows us how to run Linux containers side-by-side… Read more

2 comments, 175 reads

Posted in The DBA Who Came In From The Cold on 26 January 2018

Older posts