-->
Click here to monitor SSC
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: August 2016

Filtering Objects with DLM Dashboard

I’ve been looking at some of the features of DLM Dashboard as I go through work building database development pipelines. In this post I wanted to cover one of the lesser used features, filtering objects.

Note: DLM Dashboard is a free tool from Redgate Software. Use it to monitor the… Read more

0 comments, 330 reads

Posted in The Voice of the DBA on 31 August 2016

Finding out Who’s Touching Your Database at DevConnections

I’ve got a session this fall at the IT/DevConnections conference (Oct 10-13, 2016) called “Who’s Touching My Database?” This is something I’ve worked on for a few years, but never really gotten it to the point where I was ready to deliver it.

Earlier this year, with all the security… Read more

0 comments, 364 reads

Posted in The Voice of the DBA on 30 August 2016

SQL Saturday–Viking Edition

I’m off to the Viking Ship Museum for SQL Saturday #532. Actually, the Viking Museum will (hopefully) be a side trip on Friday before the actual event. The actual training will be at the Noroff campus in Oslo.

This is my first trip to Norway, and while it… Read more

0 comments, 946 reads

Posted in The Voice of the DBA on 25 August 2016

Output into a Table–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I often see people struggling to use triggers for auditing, or having issues with building them to handle multi row updates. However, there’s another choice: the OUTPUT… Read more

0 comments, 930 reads

Posted in The Voice of the DBA on 24 August 2016

Everki Versa Long Term Review

A couple years I was looking for a new laptop bag. I settled on the Everki Versa, which I’ve been using on my travels for 2015/2016. It’s been quite a few, which you can see on my speaking CV.

I decided to write a long term review… Read more

1 comments, 321 reads

Posted in The Voice of the DBA on 23 August 2016

PoSh on Ubuntu

I heard about the PowerShell announcement recently where the platform is porting over to Linux and OSX. I think this is part of the SQL Server on Linux project, where I assume we’ll start to see the functionality that we have on Windows appear on Linux platforms. OSX is a… Read more

1 comments, 1,095 reads

Posted in The Voice of the DBA on 19 August 2016

Rounding Challenges–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

Rounding is an interesting activity, and one that I think people sometimes don’t pay enough attention to. Recently I saw a problem that intrigued me and I… Read more

4 comments, 370 reads

Posted in The Voice of the DBA on 18 August 2016

Remember the Alamo (with a SQL Saturday nearby)

This past weekend was the first SQL Saturday in San Antonio, TX. I was lucky enough to get the chance to go, and I was happy to do so. I like to support new events in new cities, and hopefully I can help keep them going in the future.

I… Read more

2 comments, 293 reads

Posted in The Voice of the DBA on 15 August 2016

Opening .SQL Files in SSMS 2016 by Default #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

This is an easy one, but you’ll want to try this yourself.

As I’ve been trying to move off the various SSMS versions I have installed to… Read more

0 comments, 442 reads

Posted in The Voice of the DBA on 11 August 2016

What’s a Database Pipeline?

One of the things I ran into a few years ago was the idea of a software pipeline. A set journey across machines and stages that your software takes. In modern, DevOps style development shops, this usually means:

  • A development machine(s)
  • A Version Control System (VCS)
  • A CI/Build server/system
  • An…

Read more

2 comments, 1,905 reads

Posted in The Voice of the DBA on 10 August 2016

T-SQL Tuesday #81–Sharpening Skills

This is an interesting month for T-SQL Tuesday. The challenge is from Jason Brimhall to Sharpen Something, and learn something new. However, his challenge isn’t just a simple “learn something.” Instead, he writes:

“This month I am asking you to not only write a post but to do a… Read more

2 comments, 743 reads

Posted in The Voice of the DBA on 9 August 2016

SQL Saturday and the Alamo

I’ll be traveling this week to SQL Saturday #550 in San Antonio. This is my first time traveling to this part of Texas and I’m looking forward to getting a few minutes to swing by The Alamo and see a piece of history. The Riverwalk is also on my… Read more

0 comments, 239 reads

Posted in The Voice of the DBA on 8 August 2016

Visual Studio Live!–Washington DC–Save with me

I’m going to be speaking this fall at Visual Studio Live, Washington D.C. edition on Oct 3-6. This is my first time attending the event, and I’m looking forward to speaking in DC.

This is a three day conference, with a day of pre-cons, and if you’re on the East… Read more

2 comments, 243 reads

Posted in The Voice of the DBA on 5 August 2016

Dropping Masking from a Column–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

This is a quick one. As I experimented with Dynamic Data Masking for the Stairway to Dynamic Data Masking, and writing my Using SQL Compare with… Read more

0 comments, 1,407 reads

Posted in The Voice of the DBA on 4 August 2016

Dreaming of SQL Saturday

I’m truly stunned at the responses I received to my post asking how far people have traveled for a SQL Saturday. I posted here, and at SQLServerCentral. In addition, I got plenty of emails from people, detailing their travels.

Early warning, this gets a little long.

I am…

Read more

10 comments, 1,164 reads

Posted in The Voice of the DBA on 3 August 2016

Did My Dev Changes Get to Production?

One of the things that people don’t think about often is whether the changes made in development actually get to production. Usually this is because most changes go, and unless it’s a big change that causes a problem for a large number of customers (or a large customer), we often… Read more

0 comments, 451 reads

Posted in The Voice of the DBA on 2 August 2016