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

Configuring Persistent Storage for SQL Server in Azure Container Services

I’ve been playing around with SQL Server running in Kubernetes in Azure Container Services (AKS) for a while now and I think that the technology is really cool.

You can get a highly available instance of SQL Server up and running with a few lines of code! Ok, there’s a… Read more

0 comments, 1,087 reads

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

Perfecting my presentations

After a considerable amount of “umming and ahhing” last year I decided to start presenting full hour long sessions. Well, I decided to start submitting sessions to events and see what happened.

I’d presented a few lightening talks at SQL Saturdays and my local user group so I wanted to… Read more

0 comments, 176 reads

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

Friday Reading 2018-01-19

It’s been absolutely freezing here in Dublin this week. Been spending pretty much all time wrapped up indoors reading…

Discussing PASS Linux Content with OVA Winner Tracy Boggiano
Tracy Boggiano (b|t) talks to PASS about Linux content in the PASS Virtual Groups

Best newish SSMS feature Read more

0 comments, 219 reads

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

Using Windows stored credentials to connect to SQL in containers

I work with SQL Server in containers pretty much exclusively when testing code and one of my real bug bears is that SQL Server in containers does not support Windows authentication (unless you’re using Windocks).

So when I’m working I find it quite annoying to have to specify a… Read more

2 comments, 240 reads

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

Time to find a new place to live

Over the last couple of weeks I’ve been looking at various different locations around Dublin as my tenancy in the current flat that I’m in has run out.

There’s a bit of a housing problem in Dublin at the moment so it really hasn’t been easy but I’ve managed to… Read more

2 comments, 195 reads

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

Friday Reading 2018-01-11

Phew, what a week! Have been looking for a new flat to live so it’s been a bit mad. Have hopefully found a place, let the paperwork begin!

In between running around like a madman, I’ve been reading…

Free SQL Server Quizzes
Kendra Little (t) has written a… Read more

0 comments, 229 reads

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

Comparing two SQL instances

Last week I was working on a couple of SQL instances that contained databases which were part of an Always On availability group, with one server being the primary and the other the secondary.

I needed to make sure that the secondary had all the databases that were on the… Read more

0 comments, 261 reads

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

Roll on 2018!

Hey everyone, hope you all had a great Christmas and New Year!

I took December off from blogging as had started a new job and wanted to focus on getting to grips with my new role. But back now and have a load of ideas for new blogs!

Going to… Read more

0 comments, 249 reads

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

Checking SQL Configuration with Pester & Dbatools

I know, I know, there’s loads of different ways to test the configuration of SQL Server but I’ve started playing around with Pester recently and it’s pretty cool!

The script I’ve written here will use Pester & Dbatools to check all settings in sys.configurations against values stored in a .csv… Read more

0 comments, 1,418 reads

Posted in The DBA Who Came In From The Cold on 29 November 2017

Friday Reading 2017-11-17

Fun week, lots of stuff to organise and prepare for! Whilst I’ve had some downtime I’ve been reading…

Write your first Pester test today
Rob (t) takes us through the steps to write a Pester test (something I’ve been meaning to do for ages)

How To Enlarge Your… Read more

0 comments, 223 reads

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

Running SQL Server in Kubernetes on Azure Container Services (AKS) II

I’ve previously blogged about running SQL Server in ACS but Microsoft has now released a new version still called Azure Container Services (AKS instead of ACS however) but now specifically tailored to building Kubernetes clusters.

There are some differences to the original ACS (making the process simpler) so let’s run… Read more

10 comments, 551 reads

Posted in The DBA Who Came In From The Cold on 15 November 2017

Blogging for four years!

I find it absolutely amazing that I’ve been writing this blog for four years. My first ever post My 5 pieces of advice for new DBAs was published way back in November 2013.

I started out writing one post per month, just on areas that I was working on or… Read more

6 comments, 176 reads

Posted in The DBA Who Came In From The Cold on 13 November 2017

Friday Reading 2017-10-27

Morning all! PASS Summit is coming next week but unfortunately I can’t make it this year. I hope everyone who is going has a blast, learns some cool stuff, and meets great people.

Instead I’ll be presenting at the Southampton SQL User Group next Wednesday. Looking forward to this as… Read more

0 comments, 192 reads

Posted in The DBA Who Came In From The Cold on 27 October 2017

Enabling the SQL Server Agent in Linux Containers

At SQL Saturday Holland a few weeks ago I was (surprise, surprise) chatting about containers and mentioned that I hadn’t been able to get the SQL Agent working.

Now, one of the benefits of attending SQL Saturdays is that you get to pick the brains of a lot of very… Read more

2 comments, 1,463 reads

Posted in The DBA Who Came In From The Cold on 25 October 2017

Event Organisers

Over the last few weeks I’ve spoken at a few conferences, the last of those being SQL Relay.

For those of you who aren’t familiar with SQL Relay, it’s unique in that it’s not one event. SQL Relay is five events starting on Monday in one location and then a… Read more

0 comments, 211 reads

Posted in The DBA Who Came In From The Cold on 23 October 2017

Limiting resources available to containers

One question that I get asked regularly is, “can you limit the host resources to individual containers?”

This is a great question as you don’t want one container consuming all the resources on your host, starving all the other containers.

It’s actually really simple to limit the resources available to… Read more

0 comments, 337 reads

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

Monday Coffee: Long hours worked

Last week I asked the following question on twitter: –

I had a load of responses from a lot of DBAs out there who have worked some crazy shifts, you can see all the responses here

My personal record is due to a data centre migration. We moved all our… Read more

0 comments, 207 reads

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

Friday Reading 2017-09-29

Another busy week almost over and today I’m heading to Utrecht for SQL Saturday Holland! Never been to Utrecht before so am going to spend some time exploring

This week I’ve been reading…

Ask HN: Would you run SQL Server on Linux?
James Anderson (t) asks Hacker… Read more

0 comments, 295 reads

Posted in The DBA Who Came In From The Cold on 29 September 2017

The docker kill command

When running demos and experimenting with containers I always clear down my environment. It’s good practice to leave a clean environment once you’ve finished working.

To do this I blow all my containers away, usually by running the docker stop command.

But there’s a quicker way to stop containers, the… Read more

0 comments, 1,129 reads

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

An analytical mind

Last week I was reading this article in which a Professor argues that students should be allowed to take smartphones and laptops into exams: –

Professor Mazur urged academics to take the next leap allowing students to use their laptops and phones in exams. He himself encourages students to bring…

Read more

1 comments, 293 reads

Posted in The DBA Who Came In From The Cold on 25 September 2017

Newer posts

Older posts