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

Versions of Stored Procedures

I never knew this, but stored procedures have versions.

I was browsing the CREATE PROCEDURE doc page, and stumbled upon this item. In the beginning part of a stored procedure definition, after the name, there is a section that starts with

; number

Hmmm, I read the entry and it… Read more

4 comments, 755 reads

Posted in The Voice of the DBA on 6 February 2019

Learning for Feb

By the time you read this, I’ll have decided, but I just finished the first book and need to pick another. This post is more for me than anyone else, helping me to sit down and think for a minute.

I don’t have any pressing need to work on any… Read more

0 comments, 667 reads

Posted in The Voice of the DBA on 4 February 2019

Financial Advice for Techies

I’m not writing a post here on how to manage your money, but I will point you to Troy Hunt’s post. He wrote a great one called 10 Personal Finance Lessons for Technology Professionals.

Read it.

I was lucky enough to be born with lots of advantages, not the… Read more

0 comments, 2,871 reads

Posted in The Voice of the DBA on 1 February 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, 781 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, 260 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,902 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,343 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

Testing SQL in the Advent of Code

I like participating in the Advent of Code each year, though my participation often varies wildly as life gets in the way. Still, trying to solve some programming challenges is a good way of practicing your skills. If you’re competitive, you can try and see how quickly you can solve… Read more

0 comments, 2,121 reads

Posted in The Voice of the DBA on 28 December 2018

My SQL Server Travels in 2018

It’s the end of the year, and I’m looking back at the events and travels I’ve had this year. I keep a list of travels on my blog for speaking as a kind of Speaking CV, and United (my primary airline) provides me with a summary of travel each… Read more

1 comments, 282 reads

Posted in The Voice of the DBA on 27 December 2018

Identity Gaps–#SQLNewBlogger

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

Many people think that that an identity property will ensure a consistent, increasing numerical value. I ran across this tweet that indicates that situation.

This isn’t really true,… Read more

6 comments, 2,294 reads

Posted in The Voice of the DBA on 26 December 2018

2018 Advent of Code–Day 1

I enjoy when the Avent of Code comes around each year. I seem to make this a December (or sometimes New Year’s) resolution to get through them all, but life usually gets in the way. In any case, I decided to at least start this year and see how far… Read more

0 comments, 321 reads

Posted in The Voice of the DBA on 24 December 2018

Restarting a Sequence–#SQLNewBlogger

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

As part of my experiments with the sequence object, I wanted to see what allows me to restart a sequence at a new value. This is useful in… Read more

0 comments, 1,038 reads

Posted in The Voice of the DBA on 20 December 2018

Newer posts

Older posts