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

How Mature are you in Database DevOps?

I remember seeing the Carnegie Mellon Software Capability  Maturity Model (CMM) when I was in university. It was fascinating, and I was sure this was the way to write software. Across many jobs and many years, I realized that few organizations even try to become more efficient and capable in… Read more

0 comments, 95 reads

Posted in The Voice of the DBA on 22 September 2017

What’s a SQL Compare Snapshot?

I saw a short video from Grant Fritchey on the Redgate channel that shows how to cerate a snapshot in SQL Compare. I think snapshots are great, and there are lots of uses (more on that later), but I do find sometimes I use the term and people are confused. Read more

0 comments, 153 reads

Posted in The Voice of the DBA on 21 September 2017

Test Database Compatability with dbatools

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

One of the items that few DBAs think… Read more

0 comments, 211 reads

Posted in The Voice of the DBA on 20 September 2017

Join me at VS Live – Anaheim

We’re just a month away from Visual Studio Live in Anaheim where I’ll be speaking along with many others. Join me today, register with ANSPK14 and save $400. This gives you the 4-day, all access conference package for a reduced rate.

California coding, with experts in DevOps, Cloud Computing,… Read more

0 comments, 187 reads

Posted in The Voice of the DBA on 19 September 2017

Experimenting with VSCode instead of the ISE

I’ve been playing with PowerShell here and there, learning a few things. As I use the dbatools project, or

I saw a tweet from Rob Sewell on using VS Code for PoSh, which I’ve tried, but it felt cumbersome and hard. I didn’t spend much time on it before dropping… Read more

0 comments, 184 reads

Posted in The Voice of the DBA on 18 September 2017

I want a new gadget with less features

Years ago I bought a Pebble smartwatch. I didn’t back the Kickstarter, but a few friends did and I liked the product. I wore mine for almost two years before it started to die. I can be rough on gadgets, so it’s possible I banged it and caused my own… Read more

3 comments, 339 reads

Posted in The Voice of the DBA on 15 September 2017

The Code Coverage Report

I had someone that told me recently that they needed to find a way to get code coverage in T-SQL. Not for them, not to improve quality, but because their manager wanted a report.

OK, here it is.

First, build a nice SSRS report that displays your company logo, a… Read more

1 comments, 319 reads

Posted in The Voice of the DBA on 15 September 2017

Multi Script Removes 25 Database Limit

I woke up to a Slack message that alerted me to a post in one of our channels. An engineer noted that SQL Multi Script was being upgraded today, releasing to all channels with v 1.3.3. The post alerted me to not the release, but the fact that the… Read more

2 comments, 1,345 reads

Posted in The Voice of the DBA on 14 September 2017

Data Governance Survey–Still Time

Just a reminder. Redgate is doing research into data governance, and we have a small survey we’d love to get some answers to about how you view the process inside your company.

Take the Survey and be entered to win $100 gift card.

If you want to read some thoughts… Read more

0 comments, 400 reads

Posted in The Voice of the DBA on 13 September 2017

Remove an Active Lease on a Blob in Azure

I was creating and dropping VMs in Azure, and found myself charged money for disks that I thought I’d deleted. I found later that deleting a VM doesn’t necessarily remove the disk blob. Here was one way that I removed some of those blobs.

First, go to the classic portal.… Read more

0 comments, 176 reads

Posted in The Voice of the DBA on 12 September 2017

Automate Migrations–T-SQL Tuesday #94

It’s T-SQL Tuesday time again, and I’m slightly pressed for time, which is sad. This is a great topic.

Rob Sewell hosts this month with his question about what we are going to automate? He’s a PowerShell advocate, so I’m not surprised here. As much as I enjoy working… Read more

0 comments, 196 reads

Posted in The Voice of the DBA on 12 September 2017

DevOps Basics–Git Clients

This is also a part of a basic series on git and how to use it.

There are lots of git clients. If you look at the top list for this year, you’ll see quite a few. I’ve used a couple of these, but they all give you roughly… Read more

2 comments, 1,369 reads

Posted in The Voice of the DBA on 7 September 2017

Game Night is Back at the Summit

Last year Andy Warren and I worked out a deal with the PASS organization to sponsor a game night on Thursday evening since there were no official events. The event went well, with way more attendance than we expected. I was actually amazed at the number of people that… Read more

0 comments, 538 reads

Posted in The Voice of the DBA on 5 September 2017

A Trip Across the Pond for the Community Hub

The Redgate Community Hub is out, and people are starting to use it. It’s a an idea that we think will provide our customers, and potential customers, a better way to learn about our products, get information, and learn from Redgate.

Annabel Bradford and I are going to be introducing… Read more

0 comments, 575 reads

Posted in The Voice of the DBA on 4 September 2017

Livestreaming the Redgate Hub for the US

The Livestream launch for the Redgate Community Hub is next Wednesday, Sept 6, 2017. To ensure that our customers and friends in the US and the rest of the this hemisphere can enjoy the festivities, we are broadcasting at 8pm GMT.

Register today and watch us live.

I’m flying to… Read more

0 comments, 213 reads

Posted in The Voice of the DBA on 1 September 2017