Click here to monitor SSC
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

Moving Tasks with Copy-SqlJob

More dbatools experimentation for me. This is a great set of Powershell cmdlets that solve simple, handy problems. In this post, I want to look at Copy-SqlJob, which will allow me to easily move jobs from one instance to another.

The Job Subsystem

Jobs in SQL Server are part… Read more

0 comments, 75 reads

Posted in The Voice of the DBA on 2 December 2016

Hey Posh, Are My Services Running?–#SQLNewBlogger

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

In a previous post, I looked at escaping strings. The reason I needed to do this was that I was trying to do some automatic work… Read more

0 comments, 112 reads

Posted in The Voice of the DBA on 1 December 2016

What’s the little popup window in #SQLPrompt?

Awhile back I was working in SSMS and saw this window.

It threw me off since I was trying to write some code and hadn’t expected it. I clicked Escape, Enter, a few things and was getting frustrated when it disappeared.

I ignored it until I saw the window again… Read more

0 comments, 118 reads

Posted in The Voice of the DBA on 30 November 2016

Rate a Session for GroupBy

One of the things that I struggle with is understanding whether a session at a conference like a SQL Saturday is worth watching. I also struggle writing abstracts and attracting people to my own sessions, so I think the idea of GroupBy allowing rating and reviewing of abstracts in advance… Read more

2 comments, 147 reads

Posted in The Voice of the DBA on 29 November 2016

Validating a Set of Database Scripts using DLM Automation

The basis of all the DLM Automation from Redgate is a series of PowerShell cmdlets. They might look intimidating or confusing, but they aren’t. This is part of a series of posts that examine how you use each one.

Previously I looked at New-DatabaseConnection. In this post, I’ll go through… Read more

0 comments, 143 reads

Posted in The Voice of the DBA on 28 November 2016

Quick PoSh Kills with Stop-DbaProcess

I’ve been trying to get used to using the dbatools cmdlets in PoSh. They help me learn some PowerShell, but they also make some things easier. As a part of my practice, I’m documenting the various items I’ve played with. This post looks at Stop-DbaProcess.

Killing Spids

At first I… Read more

0 comments, 817 reads

Posted in The Voice of the DBA on 25 November 2016

Escaping a Dollar Sign in PoSh–#SQLNewBlogger

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

I’ve been working more with PowerShell lately and ran into a problem I thought would be easy, but it wasn’t. So I decided to blog what I… Read more

10 comments, 194 reads

Posted in The Voice of the DBA on 23 November 2016

Getting Team City working with BitBucket

As a part of building a CI/CD home lab, I set up TeamCity in the past. I plan on using this for multiple projects, and in fact, I’d built a basic Hello, World C# application as my first build.

Now it is time to work on something more complex. As… Read more

0 comments, 177 reads

Posted in The Voice of the DBA on 22 November 2016

Two Weeks to Live! 360 and VSLive Orlando

A short break in speaking, as I haven’t been on stage since Oct 11.

Now it’s two weeks to Live! 360 in Orlando and VS Live, both happening in Orlando on Dec 5-9. You can still register, and save $500 with my link.

This is my first time at… Read more

0 comments, 477 reads

Posted in The Voice of the DBA on 21 November 2016

#SQLNewBlogger – T-SQL ESCAPE for Wildcards

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

I ran into a really interesting issue recently. I was working with a table and wanted to determine if the first character of a string was a… Read more

1 comments, 154 reads

Posted in The Voice of the DBA on 17 November 2016

DLM Automation–Making a Database Connection

One of the things I’ve been wanting to do is dig more into the command line automation cmdlets from the Redgate DLM Automation suite. While there are plugins for many build and release systems, I should be able to customize, or fall back, to the command line if necessary.

Plus,… Read more

1 comments, 176 reads

Posted in The Voice of the DBA on 16 November 2016

More dbatools–Get-DbaTcpPort

After the MVP Summit, I was excited to check out more code and features in all aspects of SQL Server, but since I’d had a quick conversation with Aaron Nelson and Chrissy LeMaire, I decided to tackle another part of dbatools.

BTW, they gave me a cool sticker. Read more

5 comments, 1,290 reads

Posted in The Voice of the DBA on 14 November 2016

A Good Deed After Game Night

When we set up Game Night, we decided to sell tickets to reduce our risk. However, we didn’t have a good way to easily match up the ticket price with the costs of drinks. As a result, we ended up with about $105 extra from our ticket sales over… Read more

0 comments, 182 reads

Posted in The Voice of the DBA on 8 November 2016

Growing Speakers for T-SQL Tuesday #84

It’s T-SQL Tuesday again, and for $#84, we have a non-technical topic. Hopefully this will then let us produce more technical content by growing new speakers. That’s the topic from Andy Yun, and it’s a good one.

This is the monthly blog party, and you should feel to participate… Read more

2 comments, 201 reads

Posted in The Voice of the DBA on 8 November 2016

The GUI Helps Build SQL Prompt Snippets

SQL Prompt is an amazing tool for writing T-SQL. It helps you to concentrate on your code, without having to go off and examine Books Online or other documentation, or even worry about formatting.

One of the keys to making Prompt efficient for you, in your environment, is… Read more

0 comments, 302 reads

Posted in The Voice of the DBA on 8 November 2016

Looking Back–Game Night at the 2016 #sqlsummit

I’m trying to look back at some of the events of the recent Summit, and Game Night was one of these. You can read the announcement, but here’s a few thoughts on how this went.

First, the day started out fine on Thursday. Throughout the week I’d had people come… Read more

10 comments, 245 reads

Posted in The Voice of the DBA on 4 November 2016

Looking Back: #sqldinner at #sqlsummit 2016

Last week was the 2016 Pass Summit, and this was one of the few times that PASS did not provide a large party for the attendees on the Thursday night. That brought back memories as my wife and infant son attended the first summit with me in 1999. We… Read more

10 comments, 201 reads

Posted in The Voice of the DBA on 2 November 2016

Live 360–SQL in Orlando

I’ll be at the last big SQL Server conference in the US for 2016 this December. VS Live is a part of Live 360, and on Dec 5-9, it’s in Orlando, FL. There are lots of sessions, pre and post cons learning to take advantage of.

I’ll be part… Read more

0 comments, 574 reads

Posted in The Voice of the DBA on 2 November 2016

Creating Custom Databases with SQL Prompt

SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself to use a few of these and not just start to type with your old habits. This quick tip looks at one of those areas where a little customization can… Read more

1 comments, 1,191 reads

Posted in The Voice of the DBA on 1 November 2016

Selfies at Summit

Not all selfies, and not enough, but lots of changes to meet people at the Summit this week.

The other Steve Jones (not sure who’s other)

 

And, of course, one from the Redgate SQL Clone party


Filed under: Blog Tagged: PASS, syndicated

Read more

0 comments, 231 reads

Posted in The Voice of the DBA on 28 October 2016

Older posts