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 firstname.lastname@example.org.
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:-
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
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…
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
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
SQLBits is only a week away! But before that I’ve been reading…
Backing up SQL Server on Linux using Ola Hallengrens Maintenance Solution
Rob goes through how to use Ola Hallengren’s scripts to back up databases in SQL Server on Linux (now that the agent is supported)
One of the problems that we ran into when moving to using containers was how to get the applications to… Read more
Hey all, I’m back after attending SQL Saturday in Iceland. This week’s going to be busy!
I’ve said before that SQL Saturday Iceland was the first time that I presented a full hour session. It seemed to go well although having it start at 14:50 wasn’t the best as I… Read more
As this is being posted I’m on my way up to Dublin Airport to catch my flight to Iceland ready for SQL Saturday Iceland tomorrow! Been looking forward to this for a while now, my first opportunity to give a full session on a subject that I’ve become quite involved… Read more
I’ve written a few articles on containers so I thought it’d be a good idea to have a page that listed them for easy reference. So here’s all the posts: –
Less than a week to go until SQLSaturday Iceland now, it’s going to be a busy couple of months for me but am looking forward to it. I’ll get my slides and demos uploaded here at some point.
I’ve been debating whether or not to do demos live when I’m… Read more
Just over a week to go until SQL Saturday Iceland! Really looking forward to presenting my session and then I have four days to explore!
Building the Terminator Vision HUD in HoloLens
Because why not?
I’ve already covered how to push images to the Docker hub here but what if we only want to share a custom image in-house?
What I’ve done is created a custom… Read more
Last week Docker announced the availablity of Docker Enterprise Edition. The existing version of Docker that I’ve been using has now been renamed to the Docker Community Edition.
So what does this mean for us Windows people hacking around with Docker on our local Windows 10 boxes? Very little… Read more
Fun week, lot’s of things going on and throughout I’ve been reading…
Windows Server Premium Assurance and SQL Server Premium Assurance
Microsoft announce Premium Assurance, an additional six years of support
SQL VNext sp_configure on Windows and Linux with dbatools
Rob explores the SpConfigure commands in dbatools in SQL instances… Read more
I’ve been working with containers for a while now and one of the questions that always gets asked when I demo the technology to people is, is there a graphical user interface out there that can be used to manage containers?
Now, I’m happy with working on the command line… Read more
Ergh, not a fun weekend rugby wise. But anyway…
Last week Microsoft released an image for SQL Server 2016 SP1 Developer Edition in containers. Previously the only edition available was vNext Enterprise Evaluation which was a real problem in making containers a viable option for many businesses.
There’s no… Read more
Wow that week absolutely flew by! Here’s what I’ve been reading…
Seatbelt learning with Uncle Buck
Buck Woody goes through how he learns on the move (great article)
Continuing on my series in working with Docker on Windows, I noticed that I always open up a remote powershell window when working with Docker on servers. Nothing wrong with this, if you want to know how to do that you can follow my instructions here.
However what if… Read more
No rugby on last weekend so I didn’t have anything to distract me from working. On another note, my flat has never been cleaner!
So last week Microsoft announced Availability Groups for SQL Server on Linux.
This is a big announcement as one of the first things I noticed… Read more