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.
Another week almost over so here’s a random selection of articles that I’ve been reading…
Changing the SQL Server port on Linux
Denis Gobo goes through the process of changing the port that an instance of SQL Server running on Linux is listening on
This post follows on from Part Two in which we created a custom docker image. We’ll now look at pushing that custom image up to the Docker repository.
Let’s quickly check that we have our custom image, so run (in an admin powershell session):-
The new SQL 2016 MCSA exams are out and joy of joys, the DBA path no longer requires the Data Warehouse exam! I say this as a DBA who has had limited practical exposure to the topics covered by that exam so it’s always put me… Read more
Friday again so before I spend a weekend watching sci-fi movies, I’ll be reading:-
Virtue in the Virtual
Tony Davies discusses containerisation and virtualisation technologies and how they could be used to benefit processes within RedGate
Query wait stats in SQL 2016 SP1 Execution Plans
What a cool feature!
This post follows on from SQL Server & Containers – Part 1 and will go through how to build custom container images.
Since Part 1 came out Microsoft has released SQL Server vNext which is available in the Docker repository. I used the SQL 2016 Express image in Part 1… Read more
Well there were quite a few announcements in the SQL Server world last week.
SQL Server vNext CTP was made available for download, the big news there is that that version will be available either on Windows or Linux. The Linux version of SQL has been in private preview for… Read more
Another week almost over so in-between daydreaming about relaxing this weekend I’ll be reading…
SQL Server 2016 SP1 has been released. If you haven’t read this blog post yet, have a look at the first point when it details what new in SP1
SQL Server vNext is out… Read more
Containers are a hot topic at the moment, there seems to be a new article about them on Hacker News every day and now that Microsoft is supporting containers on Windows Server 2016 I thought it was time to have a look for what that means for us DBAs.
The… Read more
Communication in the workplace.
With the release of Microsoft Teams we now have a dazzlingly array of software designed to increase communication between workers and departments in the workplace. There’s the old staple that is email, instant messengers such as Skype for Business and now relatively new systems such as… Read more
It’s Friday so no releases to Production today (ha!) which means in-between my code reviews, server audits and other tasks I’ll be reading the following…
Speaking? You? Go on.
Rob Sewell talks about why you should be presenting and gives his tips.
I was working with a developer the other day and he was typing out each table name and all the column names he needed when working in Management Studio. He didn’t know that you can drag a table or column from object explorer into the query window and thinking about… Read more
Tired of typing out the same queries day after day? Well query shortcuts in SSMS are for you!
Following on from my last post Changing connection colours in SSMS I thought I’d write another quick about this cool but also often unused feature in SSMS.
These shortcuts allow you to… Read more
A simple but effective setting in SQL Server Management Studio is using custom colours to identify which server you are about to execute a query on. It’s simple to setup but not everyone who uses SSMS is aware of it so I thought I’d quickly run through the steps here. Read more
This command creates a “clone” of a specified user (not supported for the system databases) database that contains all objects and statistics of the specified database. Hmm, could be useful, but, how does it work? Let’s… Read more
One of the server settings that I always enable when configuring a new instance of SQL is database instant file initialisation
In case you don’t know what this is, it is a setting that can be granted to the service account that the SQL database engine runs under that prevents… Read more
SQL Server 2016 CU1 has been released and one thing I noticed was: –
That’s pretty nasty, when I originally clicked on the link I was expecting to see detailed a pretty precise set of circumstances in which that… Read more
Ok, so this is old news I know, but I’ve had a busy couple of months and am only getting around to writing this now. SSMS is now a separate release from SQL itself. The latest release is here.
Monthly releases and no longer having to download GBs to… Read more
Hey guys, differing from usual this is a quick post on setting up powershell remote sessions. I know you can remotely connect to powershell sessions using the Server Manager that comes with Windows Remote Administration Tools but it’s a bit of a clicky process and I like to eliminate using… Read more
One of the new features that’s coming with SQL Server 2016 is Dynamic Data Masking. DDM is designed to allow DBAs to limit exposure of sensitive data within a database with minimal (if any) changes required to existing queries.
How often have you seen a column in a database…in… Read more
I’ve been meaning to write this post for a while now, nice and simple, just want to list the tools that I use on a day-to-day basis and hopefully a couple of them may be new to someone out there. Btw – if anyone uses anything else regularly and thinks… Read more