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

Backup Log to Nul– #SQLNewBlogger

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.

There are times when you might be working on your demo/lab system… Read more

4 comments, 1,280 reads

Posted in The Voice of the DBA on 31 July 2017

Using Test-DbaOptimizeForAdHoc

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions.

One of the cmdlets is Dba-OptimizeForadHoc, which is designed to help you determine if this… Read more

0 comments, 265 reads

Posted in The Voice of the DBA on 28 July 2017

Azure Labs–Minor Cluster Issues for SQL Server Setup

During the process of building an Azure lab, I ran into a place where my cluster was not completely validated. I think this happened when a node failed and was re-provisioned, but in any case, when I ran SQL Server setup, the program failed cluster validation and would not install. Read more

0 comments, 275 reads

Posted in The Voice of the DBA on 27 July 2017

DevOps–Fixing Poorly Named Constraints

I was building some code the other day and kept getting problems in my deployment for a change. The deployment was having issues, and this came down to this statement.

ALTER TABLE EventLogger DROP CONSTRAINT [PK__EventLog__5E548648B043C0BC]

The problem was that this was the constraint on one developer’s workstation, but on… Read more

2 comments, 1,542 reads

Posted in The Voice of the DBA on 26 July 2017

SSoL: Where are my data and log files?

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

0 comments, 419 reads

Posted in The Voice of the DBA on 25 July 2017

FizzBuzz–#SQLNewBlogger

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.

There’s been a programmer test that was used for awhile to see… Read more

3 comments, 304 reads

Posted in The Voice of the DBA on 24 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, 289 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, 225 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, 1,481 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, 1,655 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, 1,661 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, 299 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, 524 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, 296 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, 380 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, 303 reads

Posted in The Voice of the DBA on 3 July 2017