SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Archives: June 2018

Cloud Backup Comparison

I used to use Crashplan. This was about $150 a year, but I could to 5 machines. I used to do 5. I had

  • My desktop
  • My wife’s laptop
  • My daughter’s laptop
  • My laptop
  • My son’s laptop

This changed as my boy decided he didn’t like his data with ours.… Read more

9 comments, 2,887 reads

Posted in The Voice of the DBA on 29 June 2018

Learning Goals –June 2018 Update

The June update for T-SQL Tuesday #97. I made a plan and it’s hard to stick to.

tl;dr – Very little done.

I traveled the first three weeks of June here and there. Two short trips from 1-2 and 8-10, then a long trip from 16-22 and holiday from… Read more

0 comments, 774 reads

Posted in The Voice of the DBA on 29 June 2018

Mastering Index Tuning–Day 1

This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses in the past, but I wrote notes and wanted to revisit the way things went. I started with the Mastering Index Tuning class.

I took the class a few… Read more

2 comments, 2,659 reads

Posted in The Voice of the DBA on 28 June 2018

Updating to SQL Change Automation

The SQL Change Automation release was early this week.  This is replacing ReadyRoll and our DLM Automation products, rolling them into a single product and is the first stage of unifying our state and migration based solutions.

When I logged into Visual Studio and checked updates this week, I found… Read more

0 comments, 991 reads

Posted in The Voice of the DBA on 20 June 2018

Docker Challenges

I’ve been trying to get time to play with Docker more. I had it setup on my old laptop and was experimenting with different ways of working with containers and databases before I switched. Since then I’ve been slightly hamstrung as I’ve been a VMWare person for some time. I… Read more

4 comments, 1,078 reads

Posted in The Voice of the DBA on 14 June 2018

DevOps Debugs the Demo

I had my 24 Hours of Pass session today, Database DevOps to Ensure Compliance, and my demo broke. At least, it broke for me. I kept going and talked over things, but I hate that. It would have been impressive if it had worked.


In a live session,… Read more

1 comments, 2,116 reads

Posted in The Voice of the DBA on 12 June 2018

It’s Azure T-SQL Tuesday #103

I’m slightly surprised that there haven’t been more invitations about Azure, with the main development branch of SQL Server being in the Azure cloud, but I’m glad this one came along.

The invitation is from Björn Peters, and he asks us to write about Azure SQL Database or Managed… Read more

2 comments, 310 reads

Posted in The Voice of the DBA on 12 June 2018

Two Types of Performance Counters

I had an issue where an instance of SQL Server was only showing the XTP (In Memory) performance counters. None of the other SQL Server counters were available, so I followed the procedure I’d written about previously. Once that was completed, I restarted SQL Server and looked.

No counters,… Read more

0 comments, 2,685 reads

Posted in The Voice of the DBA on 11 June 2018

Project Euler

I like having problems to practice solving in computer science. It can be a fun hobby, and it exercises your mind. I have enjoyed the Advent of Code, though some of those are complex and hard to focus on in my busy life.

My middle son asked about Project Euler Read more

0 comments, 1,056 reads

Posted in The Voice of the DBA on 8 June 2018

No @@ServerName on Linux

I setup a new instance of SQL Server on Linux some time ago. At the time, the Linux machine didn’t have any Samba running, and no real “name” on the network. As a result, after installing SQL Server I got a NULL when running SELECT @@SERVERNAME.

The fix is easy.… Read more

1 comments, 940 reads

Posted in The Voice of the DBA on 7 June 2018

The June 2018 SQL in the City is coming

We’ve got the schedule up and you can register today. Once again I’m heading to the UK, along with Grant, to broadcast a series of sessions that we hope will help you learn a bit more about building better database software and protecting data.  Kathi’s recording her session as… Read more

0 comments, 1,142 reads

Posted in The Voice of the DBA on 6 June 2018

Prepping for Mastering Index Tuning with Brent Ozar Unlimited

I got the chance to sign up for a few courses from the Brent Ozar Unlimited team and took it. I struggle to find time for training, between work commitments, travel, and family time, it’s hard to fit in a day or two. I’ve almost given up on going to… Read more

6 comments, 2,722 reads

Posted in The Voice of the DBA on 5 June 2018

A Broken Linux VM

I have no idea if this is the best thing, but I went to boot up a Linux VM today and got this:

My Linux skills are rusty, but this looks like a disk error. I rebooted and found this:

A search on Stack showed this page: https://askubuntu.com/questions/697190/fsck-error-on-boot-dev-sda6-unexpected-inconsistency-run-fsck-manually

I ran… Read more

0 comments, 281 reads

Posted in The Voice of the DBA on 4 June 2018