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-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, 238 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,143 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, 101 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, 89 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

12 comments, 483 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, 135 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, 118 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, 121 reads

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

Presenting with SQL Server Management Studio

Short one this week as it’s the usual madness on the lead up to Xmas!

One of the cool things that was mentioned in the AMA that the SQL Server Team did back in November was a quick and easy way to setup SSMS for presenting.

N.B. – This only… Read more

3 comments, 310 reads

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

Monday Coffee 2016-12-12

Speaking and presenting

One of my biggest fears is public speaking and judging by this article, I’m not alone.

However it’s something that I’ve always wanted to do and as such this year I’ve done a few lightening talk sessions at various events. For those that don’t know, a… Read more

0 comments, 100 reads

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

Friday Reading 2016-12-09

One week nearer to Xmas! Before I spend the weekend braving the centre of town desperately wondering what presents to get my family, I’ll be reading…

Mr Robot killed the Hollywood hacker
Article on MIT Tech Review about how hacking is depicted in Mr Robot.

Understanding Scan Count 0, Logical… Read more

0 comments, 148 reads

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

SQL Server & Containers – Part Four

In this final part of my series on SQL Server & Containers I’ll detail an option to run earlier versions of SQL Server in containers.

This post follows on from Part Three in which we uploaded a custom image to the docker repository.

The three previous posts have all been… Read more

1 comments, 1,537 reads

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

Monday Coffee 2016-12-05

You are the DBA your company makes you. Aren’t you?

SQL Server has such a wide range of features that no DBA role will implement all of them. So, you use a certain subset in each role that you occupy throughout your career. What those features are depends on the… Read more

0 comments, 131 reads

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

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, 148 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

3 comments, 1,322 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, 173 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, 213 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, 249 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, 150 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, 157 reads

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

Older posts