-->
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: May 2017

Parsing Docker Commands

Bit of a powershell themed post this week as I haven’t had that much time to research so this one falls firmly into the “what I’ve been doing this week” category.

My company moved to using containers a while ago now, it’s been really fun setting up and I’ve written… Read more

0 comments, 626 reads

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

Monday Coffee 2017-05-29

I’ve always said that this blog is my way of giving back to the SQL Server community but there is also another reason I write, to learn.

I was chatting with a friend the other day who was thinking about start to write a blog and he was asking me… Read more

0 comments, 121 reads

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

Friday Reading 2017-05-26

The weather in Dublin is absolutely gorgeous at the moment so I’m not planning on spending much time inside this weekend! Hope the weather is the same wherever you are, here’s some reading (to be done outside )…

Experienced DBA: Rookie Mistake
John Morehouse tells us about a mistake he… Read more

0 comments, 237 reads

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

Disabling the identity cache in SQL Server 2017

One of the changes that’s been brought into the database engine in SQL Server 2017 is the ability to disable the cache that SQL keeps on identity values by using the ALTER DATABASE SCOPED CONFIGURATION command.

What disabling the cache will do is prevent any gaps in the IDs happening… Read more

2 comments, 1,385 reads

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

Monday Coffee 2017-05-22

I hope everyone had a good weekend. I spent mine watching probably the most dismal performance of rugby I’ve seen for a long time but there’s still a bunch of matches on before the end of the season so fingers crossed for the next one (not to mention the Lions… Read more

0 comments, 204 reads

Posted in The DBA Who Came In From The Cold on 22 May 2017

Friday Reading 2017-05-19

Everyone finished patching all their servers? In-between patching this week I’ve been reading…

Why VS Code Increases my Productivity
Rob talks about how using Visual Studio Code as his primary IDE increases his output

The Setup
Jessie Frazelle talks about her hardware, OS and software configs.

Try new SQL Server… Read more

0 comments, 188 reads

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

Update to DBCC LOGINFO in SQL Server 2017

One of the new features included in SQL Server 2017 that Microsoft has detailed here is a new DMF called sys.dm_db_log_info

This new DMF is intended to replace the (not so) undocumented DBCC LOGINFO command. I say undocumented as I’ve seen tonnes of blog posts about it but never an… Read more

0 comments, 281 reads

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

Monday Coffee 2017-05-15

After the latest cyber attack I’ve had a fun weekend making sure all my devices are fully up-to-date with the latest patches. If you’re unaware of what’s been happening, you can read about it here.

I took this as an opportunity to go over all my backups as well.… Read more

0 comments, 199 reads

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

Friday Reading 2017-05-12

The weather this week in Dublin has been absolutely fantastic, please hold out for the weekend. Anyway, whilst I’ve been stuck inside this week I’ve been reading…

Why PowerShell?
Why indeed? Anthony Nocentino talks about why he got into powershell

Thoughts on public speaking / presenting / teaching
Erin Stellato… Read more

0 comments, 162 reads

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

Copying files from/to a container

Last week I was having an issue with a SQL install within a container and to fix I needed to copy the setup log files out of the container onto the host so that I could review.

But how do you copy files out of a container?

Well, thankfully there’s… Read more

1 comments, 217 reads

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

Monday Coffee 2017-05-08

Asking stupid questions

Oh boy have I asked some stupid questions in my time. Most recent was this question that I asked on #sqlhelp last week: –

I was struggling with installing SQL in a container via a dockerfile and couldn’t work out what was going wrong, so I asked… Read more

1 comments, 158 reads

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

Friday Reading 2017-05-05

Into May and a big couple of events this week in SQL Nexus and the Powershell Conference EU 2017, looking forward to more blog posts coming out about those events. This week I’ve been reading: –

SQL Nexus 2017 Conference Recap
Sam Lester recaps his experience at SQL Nexus and… Read more

0 comments, 255 reads

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

Building a container running SQL Server 2014 SP2 Developer

One of the things about working with SQL in Docker is that you kinda have to use the images that are on the Docker Hub. Now this is great if you want SQL Server 2016 or 2017 but what about earlier versions?

Now, this is a bit involved so I… Read more

1 comments, 791 reads

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

Monday Coffee 2017-05-01

Morning all, I know it’s a bank holiday in the UK & Ireland today but some of us still have to work.

Ha, only joking. I wrote this yesterday and am probably still in bed at this very moment!

Couple of cool things have happened over the weekend. The first… Read more

0 comments, 134 reads

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