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

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, 91 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, 131 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, 186 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, 128 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, 124 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, 152 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, 116 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, 213 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, 677 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, 106 reads

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

Friday Reading 2017-04-28

Nearly May! Although it’s been snowing this week in Dublin so summer still appears to be a while off…

Community driven Enhancements in SQL Server 2017
The MS Tiger Team list the new features in SQL 2017 that have been built based on feedback from the community

SQL Server 2017… Read more

0 comments, 128 reads

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

Friday Reading 2017-04-28

Nearly May! Although it’s been snowing this week in Dublin so summer still appears to be a while off…

Community driven Enhancements in SQL Server 2017
The MS Tiger Team list the new features in SQL 2017 that have been built based on feedback from the community

SQL Server 2017… Read more

0 comments, 93 reads

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

Pausing index rebuilds in SQL Server 2017

Last week Microsoft confirmed that the name of SQL vNext will indeed be SQL Server 2017. I was looking through the documentation for more info on Adaptive Query Processing as I wanted to write a post on adaptive joins but then I saw: –

To see the new Adaptive Join… Read more

1 comments, 22 reads

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

Pausing index rebuilds in SQL Server 2017

Last week Microsoft confirmed that the name of SQL vNext will indeed be SQL Server 2017. I was looking through the documentation for more info on Adaptive Query Processing as I wanted to write a post on adaptive joins but then I saw: –

To see the new Adaptive Join… Read more

1 comments, 906 reads

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

Monday Coffee 2017-04-24

Back after a couple of busy weeks, kinda looking forward to getting back into the old work routine (ah, well maybe )

Last week was a big week, I had my first article published on SQLShack.com and there were a couple of small events going on called Docker Con 2017… Read more

0 comments, 121 reads

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

Monday Coffee 2017-04-24

Back after a couple of busy weeks, kinda looking forward to getting back into the old work routine (ah, well maybe )

Last week was a big week, I had my first article published on SQLShack.com and there were a couple of small events going on called Docker Con 2017… Read more

0 comments, 21 reads

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

Thursday Reading 2017-04-13

Morning all, it’s been a busy week so I haven’t had a chance to write a post. Instead I’ve seen some great posts written about SQLBits 2017 so I thought I’d link to three of my favourites:-

Why Volunteer at SQLBits ?
Rob talks about his experiences volunteering at SQLBits… Read more

0 comments, 25 reads

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

Thursday Reading 2017-04-13

Morning all, it’s been a busy week so I haven’t had a chance to write a post. Instead I’ve seen some great posts written about SQLBits 2017 so I thought I’d link to three of my favourites:-

Why Volunteer at SQLBits ?
Rob talks about his experiences volunteering at SQLBits… Read more

0 comments, 141 reads

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

Monday Coffee 2017-04-10

So SQLBits is over and I have to say that I really enjoyed attending on the Saturday, hopefully next year I’ll be able to go for the whole event.

Highlights for me included chatting to the RedGate people about their new product SQL Clone, attending Denny Cherry’s “What not to… Read more

0 comments, 122 reads

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

Monday Coffee 2017-04-10

So SQLBits is over and I have to say that I really enjoyed attending on the Saturday, hopefully next year I’ll be able to go for the whole event.

Highlights for me included chatting to the RedGate people about their new product SQL Clone, attending Denny Cherry’s “What not to… Read more

0 comments, 21 reads

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

Older posts