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

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, 172 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, 129 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, 140 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, 820 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, 178 reads

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

Monday Coffee: Should I learn powershell?

This month’s T-SQL Tuesday’s topic was set by Rob Sewell (b|t) and entitled Let’s all get PoSH

It had a massive response with loads of people writing about how they use powershell to automate tasks in their day to day work.

(Shameless self promotion – I… Read more

0 comments, 504 reads

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

Friday Reading 2017-09-15

Excited for next week as I’m heading down to Cork to speak at the User Group there. Over 3 years in Ireland and I haven’t been yet, it’s about time.

This week I’ve been reading…

What does this little check box do?
Monica Rathbun (t) explains what checking… Read more

0 comments, 199 reads

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

Creating Hyper-V VMs with Powershell

This month’s T-SQL Tuesday is hosted by Rob Sewell (b|t) and surprise, surprise, it focuses on Powershell so I thought I’d write a quick post on how I’ve streamlined a pretty much weekly task that I perform, creating VMs.

I’m constantly spinning up VMs and then… Read more

1 comments, 154 reads

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

Friday Reading 2017-09-08

It’s going to be a fun weekend as it’s SQLSaturday Cambridge tomorrow! Haven’t been to this event before, it looks like it’s kinda big. I’ve got the slot just after lunch so hopefully everyone will manage to stay awake during my presentation

This week I’ve been reading…

Please Don’t Do… Read more

0 comments, 227 reads

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

Exploring the Kubernetes dashboard in Azure Container Services

Last week I went through how to run SQL Server in Kubernetes on Azure Container Services (ACS)

This week I want to explore the built-in Kubernetes dashboard which is available in ACS by default. (N.B. – You will need to have run through the steps in my last post to… Read more

0 comments, 213 reads

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

Upcoming speaking events

Back in March I did my first “feature length” presentation at SQL Saturday Iceland

At that point I’d done a few lightening talks and wanted to see if I could move into hour long presentations. I was really nervous doing it but after the first 10 minutes I settled down… Read more

0 comments, 133 reads

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

Friday Reading 2017-09-01

Going to be a busy few weeks as conference season gets into full swing. Really looking forward to the next couple of months, lots to do and lots of places to visit.

Anyway this week I’ve been reading/watching…

HASSP-2 Has Returned to Earth!
The second launch of the really cool… Read more

0 comments, 157 reads

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

Running SQL Server in Kubernetes on Azure Container Services

I’ve been meaning to get to grips with Kubernetes for a while now but I have to admit, I was completely overwhelmed when I first approached the subject. There’s so much information and documentation out there, it’s difficult to know where to start.

What really helped was James Anderson’s ( Read more

0 comments, 244 reads

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

Monday Coffee: Follow the instructions

Last week I was working on an upgrade and ran into a few issues. Whilst waiting for the company’s support team to come back to me I had a few attempts on my own to resolve the problem but had no luck.

When the support team came back it didn’t… Read more

0 comments, 129 reads

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

Friday Reading 2017-08-25

Great week this week as I’ve been selected to speak at 4 of the SQL Relay events in October! Really chuffed with that as it’s a whole week of talking about SQL Server & Containers! Anyway this week I’ve been reading…

The Trillion Row Table
What happens when you load… Read more

0 comments, 192 reads

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

Monday Coffee: Posting error messages

I posted a couple of messages on twitter over the weekend giving any new bloggers advice that was given to me when I was starting out writing and struggling to find topics: –

William Durkin (b|t) then added: –

This is a really really good tip.… Read more

0 comments, 146 reads

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

Query Store functionality in earlier versions of SQL Server

One of the best features introduced in SQL Server 2016 was the Query Store. Having the ability to see which queries had regressed (gotten bad plans) over a period of time was pretty much a game changer imho. But many of us are still labouring away on earlier versions… Read more

1 comments, 141 reads

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

Friday Reading 2017-08-18

Cool week, I’ve been selected to present at SQL Saturday Holland & SQL Saturday Denmark this year. September and October are going to be busy months!

Anyway, this week I’ve been reading…

Open Query Store v1.1 has landed!
v1.1 of the very cool project to enable Query Store functionality in… Read more

0 comments, 184 reads

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

Attaching databases via a dockerfile

Last week I presented my session on SQL Server & Containers for the PASS Virtualization Group and during my prep I noticed that there’s some functionality available to Windows containers and not Linux containers.

One of the (if not the) main benefits of working with SQL in a container… Read more

0 comments, 1,336 reads

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

Monday Coffee: Time Off

Nice to be back after a week off. I’ve been writing three posts a week (sometimes more) since the beginning of the year so decided last week that I’d take a (albeit short) break.

It got me thinking about actual time off and how different people deal with taking a… Read more

0 comments, 206 reads

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

Older posts