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

Archives: August 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, 216 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, 113 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, 178 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, 130 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, 123 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, 167 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,252 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, 192 reads

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

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, 168 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, 272 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,807 reads

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