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 2016-12-02

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

Reload a table quickly
Kenneth Fisher… Read more

0 comments, 77 reads

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

SQL Server & Containers – Part Three

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):-

docker images

If you’ve followed Part… Read more

2 comments, 85 reads

Posted in The DBA Who Came In From The Cold on 30 November 2016

Monday Coffee 2016-11-28

MCSA SQL Server 2016

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

0 comments, 112 reads

Posted in The DBA Who Came In From The Cold on 28 November 2016

Friday Reading 2016-11-25

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!

Source… Read more

0 comments, 166 reads

Posted in The DBA Who Came In From The Cold on 25 November 2016

SQL Server & Containers – Part Two

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

3 comments, 168 reads

Posted in The DBA Who Came In From The Cold on 23 November 2016

Monday Coffee 2016-11-21

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

0 comments, 103 reads

Posted in The DBA Who Came In From The Cold on 21 November 2016

Friday Reading 2016-11-18

Another week almost over so in-between daydreaming about relaxing this weekend I’ll be reading…

https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/
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

https://www.microsoft.com/en-us/sql-server/sql-server-vnext-including-Linux#resources
SQL Server vNext is out… Read more

0 comments, 113 reads

Posted in The DBA Who Came In From The Cold on 18 November 2016

SQL Server & Containers – Part One

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

4 comments, 186 reads

Posted in The DBA Who Came In From The Cold on 16 November 2016

Monday Coffee 2016-11-14

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

0 comments, 91 reads

Posted in The DBA Who Came In From The Cold on 14 November 2016

Friday Reading 2016-11-11

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.

Public Speaking: A Primer
Paul Randal with a… Read more

0 comments, 100 reads

Posted in The DBA Who Came In From The Cold on 11 November 2016

Drag & Drop Table & Column Names in SSMS

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

0 comments, 342 reads

Posted in The DBA Who Came In From The Cold on 9 November 2016

Query shortcuts in SQL Server Management Studio

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

2 comments, 3,089 reads

Posted in The DBA Who Came In From The Cold on 28 September 2016

Changing connection colours in SQL Server Management Studio

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

3 comments, 299 reads

Posted in The DBA Who Came In From The Cold on 22 September 2016

DBCC CLONEDATABASE in SQL Server 2014

In SQL Server 2014 SP2 an interesting new DBCC command was included, DBCC CLONEDATABASE

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

3 comments, 2,197 reads

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

SQL Server 2016 – Perform Volume Maintenance

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

1 comments, 174 reads

Posted in The DBA Who Came In From The Cold on 3 August 2016

Bug fixes in SQL Server

SQL Server 2016 CU1 has been released and one thing I noticed was: –

FIX: Canceling a backup task crashes SQL Server 2014 or 2016

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

1 comments, 231 reads

Posted in The DBA Who Came In From The Cold on 27 July 2016

The new SQL Server Management Studio

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

0 comments, 720 reads

Posted in The DBA Who Came In From The Cold on 20 July 2016

Setting up powershell remote sessions

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

0 comments, 1,368 reads

Posted in The DBA Who Came In From The Cold on 22 April 2016

SQL 2016 – Dynamic Data Masking

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

0 comments, 1,541 reads

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

Tools of the trade

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

0 comments, 297 reads

Posted in The DBA Who Came In From The Cold on 6 April 2016

Older posts