-->
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: 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, 164 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, 119 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, 35 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, 1,072 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, 143 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, 29 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, 35 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, 155 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, 139 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, 28 reads

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

Friday Reading 2017-04-07

As this is being published I’m on my way up to Dublin airport to head on over to the UK for SQLBits. I’ve never been before and it’s always being mentioned as people’s favourite SQL event so I’m really looking forward to it.

Anyway, this week I’ve been reading…

How… Read more

0 comments, 26 reads

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

Friday Reading 2017-04-07

As this is being published I’m on my way up to Dublin airport to head on over to the UK for SQLBits. I’ve never been before and it’s always being mentioned as people’s favourite SQL event so I’m really looking forward to it.

Anyway, this week I’ve been reading…

How… Read more

0 comments, 194 reads

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

Connecting a powershell session to a container

One of the questions that I was asked at SQL Saturday Iceland was “how can I view the filesystem within a container?”.

This is a great question as one of the things that people find off-putting about containers is their opaqueness. It’s not obvious where everything lives within the container… Read more

2 comments, 166 reads

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

Connecting a powershell session to a container

One of the questions that I was asked at SQL Saturday Iceland was “how can I view the filesystem within a container?”.

This is a great question as one of the things that people find off-putting about containers is their opaqueness. It’s not obvious where everything lives within the container… Read more

2 comments, 22 reads

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

Monday Coffee 2017-04-03

Last week Pass announced changes to how speakers are going to be selected for their annual conference (you can read the announcement here.

There’s been a bit of a debate about the changes but as far as I can tell, these seem to be for the better (right?).

Inviting… Read more

0 comments, 20 reads

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

Monday Coffee 2017-04-03

Last week Pass announced changes to how speakers are going to be selected for their annual conference (you can read the announcement here.

There’s been a bit of a debate about the changes but as far as I can tell, these seem to be for the better (right?).

Inviting… Read more

0 comments, 106 reads

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