-->
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: January 2019

Webinar next week on Database DevOps

Next week is my webinar on why the database is the heart of DevOps. You can still register today to discuss and debate why we need to ensure that database development is integrated into any DevOps work we do for other software.

Register: https://attendee.gotowebinar.com/register/3005019550714731265?source=KB

Read more

0 comments, 746 reads

Posted in The Voice of the DBA on 30 January 2019

Pro SQL Server Linux–Connecting and Building an App

As part of my learning goals for 2018, I wanted to work through various books. This is part of my series on Pro SQL Server on Linux from Bob Ward.

I set up my Red Hat server as a command line only instance, so installing VSCode or Azure Data Studio… Read more

0 comments, 846 reads

Posted in The Voice of the DBA on 28 January 2019

Careful with Session_Context()–#SQLNewBlogger

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

A quick note, which is more of a reminder to myself. I find writing things down helps me remember, and I need to remember this.

I was working… Read more

8 comments, 2,202 reads

Posted in The Voice of the DBA on 24 January 2019

The Heart of DevOps Webinar

One of the things that I think about DevOps is that it’s really hard to focus on the hard things that create friction in your process. Most of us want to move faster, and tackle the easy things to automate, the easy things to fix. We want to trust developers… Read more

0 comments, 249 reads

Posted in The Voice of the DBA on 23 January 2019

Starting a Proof of Concept with SQL Change Automation

One of the ways that you can more easily perform database development tasks is with SQL Change Automation (SCA). This is a plug-in from Redgate that works with Visual Studio, and while there are tutorials on Setting up SCA and starting in VS, I wanted to add my own… Read more

0 comments, 1,880 reads

Posted in The Voice of the DBA on 22 January 2019

Getting Parameters Out From a Stored Procedure–#SQLNewBlogger

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

One of the lesser used and known features of T-SQL are the output parameters from a stored procedure. I used one of these recently, so I wanted to… Read more

5 comments, 3,742 reads

Posted in The Voice of the DBA on 16 January 2019

Pro SQL Server on Linux- More Installs

As part of my learning goals for 2018, I wanted to work through various books. This is part of my series on Pro SQL Server on Linux from Bob Ward.

After my last post, I decided to try and install the SQL Server 2019 preview version and see how that… Read more

0 comments, 782 reads

Posted in The Voice of the DBA on 14 January 2019

Sorting Values in a Column

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

This was a post that caught my eye, since I’d just written a piece on STRING_SPLIT(). Someone had this data:

DECLARE @Names VARCHAR(8000) = 'Steve, Grant, Kathi,…

Read more

0 comments, 261 reads

Posted in The Voice of the DBA on 10 January 2019

Pro SQL Server on Linux–Install

As part of my learning goals for 2018, I wanted to work through various books. This is part of my series on Pro SQL Server on Linux from Bob Ward.

I had an Ubuntu VM setup at home, but it started to flake and eventually stopped responding as a desktop.… Read more

2 comments, 346 reads

Posted in The Voice of the DBA on 9 January 2019

Pro SQL Server on Linux–Getting Started

As part of my learning goals for 2018, I wanted to work through various books. This is part of my series on Pro SQL Server on Linux from Bob Ward.

I purchased Pro SQL Server on Linux and started reading it in December. I’ve been playing with the Linux version… Read more

0 comments, 1,903 reads

Posted in The Voice of the DBA on 4 January 2019

A New PiHole in the Sky

Last year I set up a PiHole server on my RaspberryPi to help block some ads and malicious stuff (tracking, malware, etc) on my home network. It’s not perfect, but it’s a layer.

Unfortunately the Raspberry Pi was unstable and would die or lag or restart fairly often. I’d end… Read more

1 comments, 2,344 reads

Posted in The Voice of the DBA on 3 January 2019

Versions and Patches in SQL Monitor

SQL Monitor has grown from a basic alerting system to an amazing product over the years. From it’s early days as SQL Response, where Brad and I weren’t sure this was a good idea to the current version that has two teams and releases change almost every week. In… Read more

0 comments, 263 reads

Posted in The Voice of the DBA on 2 January 2019