-->
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.

Friday Reading 2017-08-04

It’s a bank holiday weekend here in Ireland so I’m looking forward to having the extra day off. Bought a new computer this week so am going to spend a bit of time setting that up (one of my favourite things to do).

One thing to mention is that next… Read more

0 comments, 181 reads

Posted in The DBA Who Came In From The Cold on 4 August 2017

Automating installation of Docker & SQL command line tools on Linux

I’ve been getting to grips with Docker SQL Containers on Linux (specifically Ubuntu 16.04) and have found that I’ve been running the same commands over and over when I’m configuring a new server.

The old adage goes that if you run anything more than once it should be automated, right? Read more

0 comments, 287 reads

Posted in The DBA Who Came In From The Cold on 3 August 2017

SELECT…INTO in SQL Server 2017

One of the new options available in SQL Server 2017 is the ability to specify a filegroup when using SELECT..INTO to create a table.

Previous versions would create the new table on the PRIMARY filegroup which isn’t ideal so this is a pretty nifty option imho. Let’s run through a… Read more

1 comments, 2,867 reads

Posted in The DBA Who Came In From The Cold on 2 August 2017

Monday Coffee: The evolving DBA

Over the weekend I saw a few tweets about the role of the DBA. These tweets (and corresponding blog posts) come around once every so often and are generally along the lines of “Is the DBA role dead?” (or something to that ilk).

Here’s my two cents on the matter,… Read more

1 comments, 190 reads

Posted in The DBA Who Came In From The Cold on 31 July 2017

Friday Reading 2017-07-28

Hope you all had a good week. Been pretty chilled out here so I’ve been reading…

Announcing Azure Container Instances
Microsoft blog about a new Azure service allowing us to deploy containers from the Azure CLI

sp_WhoIsActive Documentation
All of the supporting docs for Adam Machanic’s excellent sp_WhoIsActive

13 things… Read more

0 comments, 240 reads

Posted in The DBA Who Came In From The Cold on 28 July 2017

Automatically restarting Docker containers

One of the problems that I’ve encountered since moving my Dev/QA departments to using SQL Server within containers is that the host machine is now a single point of failure.

Now there’s a whole bunch of posts I could write about this but the one point I want to bring… Read more

0 comments, 1,194 reads

Posted in The DBA Who Came In From The Cold on 26 July 2017

Monday Coffee: SQL Services in Containers

I had an interesting question on twitter last week when I published my post on Running Linux Container on Windows: –

“Does that container support Microsoft ML yet?”

I have absolutely no experience with Machine Learning so really had no clue. But as I had the container up and… Read more

0 comments, 186 reads

Posted in The DBA Who Came In From The Cold on 24 July 2017

Friday Reading 2017-07-21

Fun week! I moderated a couple of great sessions for 24 Hours of PASS: Summit Preview. As someone getting into presenting, watching the Pros do it is invaluable.

Here’s the sessions that I moderated: –

PowerShell for DBAs, What’s in it For Me?
Ben Miller gave a great overview of… Read more

0 comments, 192 reads

Posted in The DBA Who Came In From The Cold on 21 July 2017

Running Linux Containers on Windows

Microsoft have announced the availability of SQL Server 2017 RC1 and I wanted to check it out in a container however it seems that the Windows image hasn’t been updated on the Docker Hub: –

But no matter, running Docker on Windows 10 gives me the option to run Linux… Read more

2 comments, 1,813 reads

Posted in The DBA Who Came In From The Cold on 18 July 2017

Monday Coffee: 24 Hours of Pass – Summit Preview

Starting at 12pm (UTC) this Wednesday is the online event 24 Hours of PASS – Summit Preview

For anyone out there who doesn’t know, PASS is the world’s largest community for professional who work with SQL Server. PASS is the organisation which all SQL Saturdays are affiliated too and they… Read more

0 comments, 190 reads

Posted in The DBA Who Came In From The Cold on 17 July 2017

Friday Reading 2017-07-14

Fun week, and what a Lions final test last weekend. Still can’t believe it!

Here’s what I’ve been reading…

STOPAT And Date Formats
Dave Mason tests if different date formats are compatible with point-in-time database restores

How the SQLCAT Customer Lab is Monitoring SQL on Linux
Post on the SQLCAT… Read more

0 comments, 162 reads

Posted in The DBA Who Came In From The Cold on 14 July 2017

Creating SQL Server containers with docker compose

Up until now my posts about containers have been talking about working with one container only. In the real world this will never be the case, at any one time there will be multiple containers (I have over 30) running on a host.

I need a way to get multiple… Read more

0 comments, 1,629 reads

Posted in The DBA Who Came In From The Cold on 12 July 2017

Monday Coffee: Database Deployments

I’ve always been particularly cautious when it comes to deploying code to databases, some would say overly cautious.

Because of this I’ve always performed manual deployments. Checking the code, testing the code and then manually running it in production. I’m responsible for the availability, resilience and performance of these databases… Read more

2 comments, 362 reads

Posted in The DBA Who Came In From The Cold on 10 July 2017

Running dbatools commands with VS Code tasks

I’ve started to look at the excellent dbatools.io to automate some of the checks that I routinely perform on my SQL instances.

But before I go into this post, I want to say a thank you to Cláudio Silva (t). The powershell commands that are below are based… Read more

0 comments, 340 reads

Posted in The DBA Who Came In From The Cold on 7 July 2017

Friday Reading 2017-07-07

Final Lions Test tomorrow! The win last week sets up a thrilling series decider, if they win they’ll be the first Lions Team to win a series against New Zealand for 46 years! In the build up I’ve been reading…

Setting up Visual Studio Code Tasks
I’ve been using VS… Read more

0 comments, 311 reads

Posted in The DBA Who Came In From The Cold on 7 July 2017

Persisting data in docker containers – Part Three

Last week in Part Two I went through how to create named volumes and map them to containers in order to persist data.

However, there is also another option available in the form of data volume containers.

The idea here is that create we a volume in a container and… Read more

0 comments, 1,187 reads

Posted in The DBA Who Came In From The Cold on 5 July 2017

Monday Coffee: Alerts & Checks

Hope you all had a good weekend, the Lions won so I’m pretty happy.

Over the weekend I was thinking about the alert system that I have in place at my current position. A good alerting system is (obviously) essential for any DBA to have in place but we all… Read more

0 comments, 204 reads

Posted in The DBA Who Came In From The Cold on 3 July 2017

Friday Reading 2017-06-30

Second test for the British & Irish Lions tomorrow, they need this one to keep the series alive. I’ll be up early to watch it tomorrow, the team selection is here.

But anyway, this week I’ve been reading…

Using SQL Server Diagnostics
Arun Sirpal goes through how to use… Read more

0 comments, 204 reads

Posted in The DBA Who Came In From The Cold on 30 June 2017

Persisting data in docker containers – Part Two

Last week in Part One I went through how to mount directories from the host server into a docker container in order to persist data.

However, you don’t have to do this in order to share volumes between containers. Another method is to create named volumes within the docker ecosystem… Read more

1 comments, 1,186 reads

Posted in The DBA Who Came In From The Cold on 28 June 2017

Monday Coffee: Attending Conferences

Last week I asked the following question on Twitter: –

I was interested to see the responses as I wanted to know how more experienced presenters get the time off to speak at so many events. Up until now I’ve been using annual leave and this was a way of… Read more

4 comments, 214 reads

Posted in The DBA Who Came In From The Cold on 26 June 2017

Newer posts

Older posts