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

The Reader’s Choice Awards are Taking Nominations

If you’re using products, you might want to nominate a vendor or product for a database tool that helps you. The Database Trends and Applications Reader’s Choice Awards is taking nominations for the next few weeks.

At Redgate Software, we try to build useful products that help you solve… Read more

0 comments, 702 reads

Posted in The Voice of the DBA on 26 February 2019

Git, GitHub, GitLab, BitBucket, What’s the difference?

I was watching Brent’s webcast session on GitHub recently. I’ve struggled to explain this to users in the past, and it’s always good to see what others do when they do similar sessions.

You can watch Brent’s session, and I’ve got some content on git. Need to do… Read more

3 comments, 3,585 reads

Posted in The Voice of the DBA on 25 February 2019

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, 751 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, 697 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, 156 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, 1,362 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, 219 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

1 comments, 2,631 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, 2,705 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, 194 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,345 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, 753 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,868 reads

Posted in The Voice of the DBA on 1 February 2019