-->
Click here to monitor SSC
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.

Friday Reading 2017-02-17

Is it me or is February dragging? Anyway, mixed in with this crazy week I’ve been reading: –

SQL Server vs SQL Server vNext
Henrico Bekker runs through a performance comparison of SQL Server against SQL Server on Linux

What Are FeFETs?
Article about a new memory type (FeFETs) that… Read more

0 comments, 88 reads

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

Viewing container logs

I’ve been going over some demos for a presentation that I’ll be giving this year and I thought I’d write this quick post about something that keeps catching me out…


…but first, a bit of shameless self promotion. I’ll be giving my session on an Introduction to SQL Server &… Read more

1 comments, 137 reads

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

Monday Coffee 2017-02-13

Man, if there was an award for procrastinating I’d definitely be in with a shout for today (I write these posts on the weekend). 

So I’m half writing this sitting on my balcony with a beer, one eye on the Italy v Ireland Six Nations game and trying not to… Read more

0 comments, 104 reads

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

Friday Reading 2017-02-10

Fun week, performed some RAM upgrades for my production SQL boxes which for one server, somehow fried its motherboard, hard drive AND backup drive, huh?? Meh, I like rebuilding servers…Also got a whole load of writing done so quite pleased with myself!

In-between all that, I’ve been reading…

Why databases… Read more

2 comments, 121 reads

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

Creating SQL Containers from a Dockerfile

I’ve been playing around with SQL containers on Windows Sever 2016 a lot recently and well, building empty SQL containers is all fine and dandy but it’s kinda missing the point. What containerization allows you to do is build custom images that are designed for your environment, say with a… Read more

3 comments, 1,185 reads

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

Monday Coffee 2017-02-06

A lot’s been said about last week’s Gitlab outage so I’m not going to go over the details here but I do want to talk about one point that was when I was watching the guys fix the issue live on youtube.

A lot of the people making comments kept… Read more

1 comments, 110 reads

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

Friday Reading 2017-02-03

2017 is trundling along now, this week I’ve been reading…

The GitLab incident report
We’ve all had that moment of “what did I just do??” Here’s how the guys at Gitlab responded to such a moment.

Linux OS Fundamentals for the SQL Admin
I don’t know how I missed this… Read more

0 comments, 141 reads

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

SQL Containers and Networking

I recently talked with the guys over at SQL Data Partners on their podcast about SQL Server and containers. It was real good fun and I enjoyed chatting with Carlos Chacon (b|t) and Steve Stedman (b|t)about container technology and my experiences with… Read more

1 comments, 1,140 reads

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

Monday Coffee 2017-01-30

Wow, what a week last week was.

The biggest thing that happened was that I got a session at SQL Saturday Iceland! They had loads of submissions and could only pick around 20 so very chuffed to have been one of those selected, cue smug face.

The event is… Read more

0 comments, 85 reads

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

Friday Reading 2017-01-26

Is it really still January? It seems like this month is dragging on a bit. Anyway, this week I’ve been reading…

Nearly everything has changed for SQL Server Powershell
The Scripting Guys at Technet go over the changes to SQL Server Powershell.

Learning Redis the hard way
Interesting post about… Read more

0 comments, 119 reads

Posted in The DBA Who Came In From The Cold on 27 January 2017

Transaction log shipping in SQL Server on Linux

SQL Server on Linux has been out for a bit now and I’ve played around a little (see here) but haven’t really used it in “anger” nor will I for the foreseeable future if I’m honest. Nevertheless it’s an area that I find very interesting as I know very… Read more

3 comments, 1,096 reads

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

Monday Coffee 2017-01-23

I like to think of myself as a fairly hardworking, motivated person. However I recently met someone who regularly gets up at 5am, works a 12 hour day and then (somehow) works out in the evening. They also ran 18km before 10am last Saturday. You know what I was doing… Read more

0 comments, 114 reads

Posted in The DBA Who Came In From The Cold on 23 January 2017

Friday Reading 2017-01-20

Been an interesting week! My site has had the most views ever (so chuffed) and during all that I’ve been reading…

Microsoft’s Cyber Defense Operations Center shares best practices
Microsoft shares details some of their best practices for how they respond to cyberthreats in real time

CPU Scheduling Basics –… Read more

0 comments, 347 reads

Posted in The DBA Who Came In From The Cold on 20 January 2017

The two types of IT worker

Last week I published this post about something a colleague noticed when playing around with a SQL Server instance running on Linux. Fairly innocuous and I was chuffed when I saw that the guys over at BrentOzar.com had linked to it in their weekly newsletter.

As the day wore on,… Read more

5 comments, 2,519 reads

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

Monday Coffee 2017-01-16

I’ve been a scribbler for as long as I can remember, in fact I’m not sure that I write everything down because I have a bad memory or if I have a bad memory because I write everything down.

About a year ago I stopped using notepads and tried to… Read more

0 comments, 132 reads

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

Friday Reading 2017-01-13

Ahh, is it really Friday the 13th?!! So before Jason gets me, I’ll be reading…

A whole day of PowerShell & SQL
Join Rob Sewell and Chrissey LeMaire at SQL Sat Vienna on the 20th of Jan for a pre-con on PowerShell and SQL Server

Why open offices are bad… Read more

1 comments, 117 reads

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

Killing databases in SQL Server on Linux

Bit of fun this week with something that a colleague of mine noticed when playing around with SQL Server on linux.

The first thing you do when playing with a new technology is see how you can break it right? Always good fun

So I’m going to break a database… Read more

10 comments, 558 reads

Posted in The DBA Who Came In From The Cold on 11 January 2017

Monday Coffee 2017-01-09

I’m almost back into the swing of things now after the Xmas break, that holiday feeling has just about left me.

For most people, there’s a good break over the Xmas period but most IT workers that I know had to be on-call for some or most of the holiday… Read more

0 comments, 185 reads

Posted in The DBA Who Came In From The Cold on 9 January 2017

Friday Reading 2017-01-06

Happy New Year to all of you out there! I know, I know it’s a week late but hey I’ve had a bit of a hectic one plus once again I’ve managed to catch the same bug that I always seem to get this time of year (excuses, excuses).

Well… Read more

0 comments, 137 reads

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

Saturday Reading 2016-12-17

It was my office Xmas party last night so whilst recovering on my settee, I’ll be reading:-

The Most Important Role of a SQL Server DBA
Back to basics, Angela Tidwell talks about what the most important task of a DBA is (can you guess?)

Don’t blink you might READPAST… Read more

0 comments, 140 reads

Posted in The DBA Who Came In From The Cold on 17 December 2016

Older posts