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: July 2017

Lots of Resources

I’ve got a small Azure subscription, but there are a lot of resources in my mini lab. Forty seven, to be exact right now.

When I look at my bill, it’s got lots of details, but not always easy to understand.I get a breakdown and burn rate.

I can also… Read more

2 comments, 136 reads

Posted in The Voice of the DBA on 20 July 2017

Back to the Big Easy and SQL Saturday #628 in Baton Rouge

I’ve been fortunate enough to get to the Baton Rouge SQL Saturday a number of times. I think I’ve been 3 times and am heading back in a week for my fourth.

This is an amazing event, one of the largest in the country. I’ve met people from Texas to… Read more

2 comments, 111 reads

Posted in The Voice of the DBA on 20 July 2017

DevOps Basics–Git log

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it.

In a few previous posts I’ve looked at getting going with git,… Read more

2 comments, 224 reads

Posted in The Voice of the DBA on 19 July 2017

SQL Server 2017 RC1 is Here

And I’ve got it.

Glenn Berry posted a a link to the MSDN blog and almost immediately a note that the link was still the CTP. I decided to fire up my Ubuntu install and check. No updates there, though a few people reported Docker had the new bits.

A… Read more

2 comments, 135 reads

Posted in The Voice of the DBA on 18 July 2017

PowerShell $env Variables

I was playing with containers the other day, reading a Simple Talk article on the topic, and noticed the code in PowerShell (PoSh) used the $env:xx syntax for variables. I know I’ve seen this before, but for some reason this struck me as something I knew little about.

I decided… Read more

0 comments, 244 reads

Posted in The Voice of the DBA on 17 July 2017

T-SQL Tuesday #92–Hard Lessons

A quick post, written last week as I’m relaxing in the mountains.

This month the topic is lessons learned the hard way, from Raul Gonzalez. It’s interesting, and certainly one where I have experience. I make mistakes regularly, though I tend to fix them.

You can read more… Read more

0 comments, 209 reads

Posted in The Voice of the DBA on 11 July 2017

Bash on Windows

With SQL Server coming on Linux, some people will want to learn a bit of Linux. Or perhaps they need to get re-acquainted with the OS, which is my situation. I grew up on DOS, but moved to Unix in university. I’ve dabbled in Linux over the years, but with… Read more

0 comments, 267 reads

Posted in The Voice of the DBA on 7 July 2017

Becoming an MVP

“Climb the mountain to see the world, not be seen by the world.”from Tim Ford.

This past July 1 was the renewal date for a number of Microsoft MVPs. The program has changed in the last year, moving from a quarterly nomination/renewal to a monthly award. The… Read more

0 comments, 207 reads

Posted in The Voice of the DBA on 6 July 2017

SSoL–Exiting Root

I don’t think most of us need to know Linux, but if you end up managing a system, it’s good to have a little idea of how to get around. This is a short series of posts as I remember the skills I used to have back in university. Read more

2 comments, 266 reads

Posted in The Voice of the DBA on 5 July 2017

Database Mirroring Needs FQDNs

A quick basic post, and one that I’ve forgotten. Since blogging is a good way to remind myself of things, here goes.

I was testing Database Mirroring (DBM) recently for an upgrade situation. I’ve set up it up in the past, but since it’s deprecated, I’ve moved on to… Read more

0 comments, 198 reads

Posted in The Voice of the DBA on 3 July 2017