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

Adding Performance Counters back for SQL Server

I had a strange situation the other day, where a number of things went wrong with my instance. First, I lost permissions to detached databases. The SID was listed in the file permissions, but apparently unlinked to an account.

Next, I went to add an alert, and I only had… Read more

0 comments, 107 reads

Posted in The Voice of the DBA on 26 June 2017

Loading All CSV Files with PowerShell

I ran across Denis Gobo’s post about working with names from Social Security cards and wanted to play with the dataset. However, rather than use xp_cmdshell, which I might have, I decided to use PowerShell. I need to repeat this with Python, but for now, this worked.

There is a… Read more

2 comments, 166 reads

Posted in The Voice of the DBA on 23 June 2017

Move a Stored Procedure to a New Schema–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 things I needed to do recently was move an object. I was testing the WideWorldImporters database and created an object in the dbo schema.… Read more

0 comments, 167 reads

Posted in The Voice of the DBA on 22 June 2017

Using OPENROWSET in SQL Server on Linux

I wanted to import the million song dataset in SQL Server on Linux. There’s a github repo that has the SQL to allow you to use this with the graph database features. However, it’s built for Windows.

Linux is a slightly different beast. Once I started down this path, I… Read more

2 comments, 338 reads

Posted in The Voice of the DBA on 21 June 2017

Speaking at the Data Platform Summit 2017

I am honored to be speaking at the Data Platform Summit 2017. The event takes place August 17-19, 2017 in Bangalore, India. This will be my first trip to India, and I’m excited to be traveling halfway around the world (literally 12:30 hours difference) to speak at this event. Read more

0 comments, 197 reads

Posted in The Voice of the DBA on 20 June 2017

DevOps – Downloading a File from the Internet with PoSh

One of the things we need to do as data professionals is move data files around. Often we’ll get a local path, but in looking for public data sets, I wanted to get a file from the Internet. In this case, a rather large file.

I could have put the… Read more

2 comments, 180 reads

Posted in The Voice of the DBA on 19 June 2017

Renaming MDF/LDF Files–SQLNewBlogger

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

I would guess many people would run into this situation at some point. A developer or DBA creates a database, then decides to rename it, but the… Read more

0 comments, 277 reads

Posted in The Voice of the DBA on 15 June 2017

T-SQL Tuesday #91–Early DevOps

This month the T-SQL Tuesday invitation is from Grant Fritchey, my colleague at Redgate Software. Surprise, surprise, the topic is DevOps.

I write and talk about this a lot, but for this month I’ll look back at DevOps for me in 2001.

If you want to participate… Read more

1 comments, 190 reads

Posted in The Voice of the DBA on 13 June 2017

VSTS–Changing the Default Build Queue

I wrote recently about the Release agent using the hosted queue as the default, which is sometimes a problem. The Build process has the same issue, though the way you change things is different.

In a build, you see a set of tasks with various menu items across the top,… Read more

0 comments, 249 reads

Posted in The Voice of the DBA on 12 June 2017

VSTS– Hosted Agent is the Default for Releases

In keeping with the idea I don’t want this to get out of date, this is VSTS as of Jun 1, 2017. If your screen looks different, find a different article.

I was setting up a test the other day using VSTS (Visual Studio Team Services) and once had something… Read more

0 comments, 221 reads

Posted in The Voice of the DBA on 5 June 2017

Restore a BACPAC–#SQLNewBlogger

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

I needed to get the WideWorldImporters sample database for a project and noticed that there was a BACPAC available. I downloaded it and needed to restore this… Read more

2 comments, 1,037 reads

Posted in The Voice of the DBA on 1 June 2017

Quitting VIM

I saw this post from Joel Spolsky lately, noting that Stack Overflow has been helping 1 million developers exit VIM. It’s a funny post, but one that has some truth in it. I’ve gotten into VIM, almost always from git, but sometimes in Linux, and I often Google the… Read more

2 comments, 275 reads

Posted in The Voice of the DBA on 29 May 2017

Save on IT/DevConnections this fall

For the first time in many years, I won’t be at IT/DevConnections this fall.  I’m disappointed to miss the event, but I had other commitments around this time when I heard about being chosen as a speaker and this would be the fourth event in four weeks. That’s a bit… Read more

0 comments, 284 reads

Posted in The Voice of the DBA on 25 May 2017

Restore to a point in time–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it.

One of the things I had to show recently was a restore… Read more

1 comments, 330 reads

Posted in The Voice of the DBA on 25 May 2017

Looking Back at Build–CosmosDB

Part of a series looking back at Build 2017, going over the 20+ pages of notes I took.

One of the big announcements at Build 2017 was the release of CosmosDB. This is a rebranding of DocumentDB, the document store in Azure, with some additional capabilities. You can also… Read more

0 comments, 1,190 reads

Posted in The Voice of the DBA on 24 May 2017

A Busy Few Years

Last week on Twitter, a friend mentioned they were submitting to the PASS Summit and went through their previous speaking engagements. This person noted they had done over 40 talks in the last few years, which is a lot. I do more, but it’s part of my job. Ten talks… Read more

2 comments, 232 reads

Posted in The Voice of the DBA on 22 May 2017

La La Land Speaking at SQL Saturday #640

I love LA. In many ways, it’s a fun city to visit, and I love taking a few minutes, even just a 10-20 minute walk along the boardwalk on some beach. I’ve looked forward to quite a few trips to LA in my life, and I often take advantage of… Read more

2 comments, 470 reads

Posted in The Voice of the DBA on 19 May 2017

DevOps Basics – Connecting to a Git Remote

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it.

As I work more and more with Git, I find myself learning… Read more

0 comments, 305 reads

Posted in The Voice of the DBA on 18 May 2017

A (mostly) Unwired Week at #MSBuild

Part of a series looking back at Build 2017, going over the 20+ pages of notes I took.

Last week I had the opportunity to attend Microsoft’s Build conference, and as I wrote, I planned to use a notebook and not my PC. For the most part, that… Read more

0 comments, 398 reads

Posted in The Voice of the DBA on 15 May 2017

Trying GO with SQL Server

Not the batch separator, but the GO language.

I’m always interested in learning new things, and GO has been one of those items that I’ve wanted to look at and see how it works. This is a big language at Google and

I saw a new blog from Mat Hayward-Hill… Read more

0 comments, 718 reads

Posted in The Voice of the DBA on 15 May 2017

Older posts