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

SQL in the City 2019 in London

We’ve started setting up our SQL in the City Summits for 2019 and the first one is London on April 30. I’m going to start making my plans now and hope to see some of you there.

We’re still finalizing agendas and getting some speakers lined up, but if… Read more

0 comments, 197 reads

Posted in The Voice of the DBA on 20 February 2019

Do You Have a SQL Server Estate?

At Redgate, we do a lot of research. Maybe not as much as Microsoft Research, but we are always trying to investigate more about customer problems and challenges before we build or change software.

Take our survey on SQL Server Configuration Management and you could win prizes. Or a prize. Read more

2 comments, 214 reads

Posted in The Voice of the DBA on 19 February 2019

Don’t Leave the Database Behind…Or Win If You Do

If you’ve had struggles with database development and had a real world disaster, you could win in a new Redgate contest. We’re looking for the places where old style, waterfall, traditional database development has been a problem. Especially when application software developers have been adopting DevOps, small, rapid release… Read more

0 comments, 129 reads

Posted in The Voice of the DBA on 18 February 2019

Practical Web Scraping–Getting Started

As part of my learning goals for 2018, I wanted to work through various books. This is part of  my work with Python.

After going through a few first chapters, I decided to start my February learning with Practice Web Scraping for Data Science, which looks at data… Read more

1 comments, 939 reads

Posted in The Voice of the DBA on 15 February 2019

Learn about the State of Database DevOps Next Week

It’s a week to my webinar with Donovan Brown (b t, y g), leader of the League of Extraordinary Cloud DevOps Advocates, Principal DevOps Manager at Microsoft, and the guy that wants to Rub DevOps on Everything. He’s a passionate, intelligent, exciting guy whose enthusiasm… Read more

0 comments, 198 reads

Posted in The Voice of the DBA on 14 February 2019

Adding Objects to our SCA Project

In my last post, I started out with a new SCA project, getting a connection to my database up and running. Now, let’s start the new project by adding some objects.

Adding Objects

I’m going to start with a couple objects to make this simple, but we’ll move on from… Read more

0 comments, 876 reads

Posted in The Voice of the DBA on 13 February 2019

What is my why?–T-SQL Tuesday #111

This is an interesting question from Andy Leonard for T-SQL Tuesday: What Is Your “Why”? He is this month’s host and asks us to talk about our motivation, our passion. The question is: Why do you do what you do?

Why I Do What I Do?

I have had a… Read more

1 comments, 710 reads

Posted in The Voice of the DBA on 12 February 2019

Looking for More Storage

I got a new cell phone. Not big news, but it’s primarily because I need want more storage. It’s a little indulgence, but it doesn’t change my budget much, so I decided to just upgrade.

A couple years ago I moved to Google Fi. If you haven’t heard of… Read more

0 comments, 167 reads

Posted in The Voice of the DBA on 11 February 2019

Pro SQL Server Linux–Moving to Linux

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.

It’s not until Chapter 10 that we get back to Linux specifics. Most of the chapters in the middle are… Read more

0 comments, 1,085 reads

Posted in The Voice of the DBA on 8 February 2019

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, 542 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, 537 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,492 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, 667 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, 804 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,140 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, 233 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,824 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,663 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, 755 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, 238 reads

Posted in The Voice of the DBA on 10 January 2019

Older posts