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

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, 313 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, 256 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, 211 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, 584 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,203 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, 239 reads

Posted in The Voice of the DBA on 28 October 2016

#RedgateRocks Tonight at #sqlsummit

Tonight is the #RedgateRocks party at 1927 Events in Seattle. You’ll need to get a wristband from the Redgate Software booth in the exhibition hall to gain admission, so stop by.

Today’s your last chance.

And if you’re looking for someone to go to dinner with, come to our #sqldinner… Read more

0 comments, 196 reads

Posted in The Voice of the DBA on 27 October 2016

Summit 2016–Setup

Tuesday was the first real day of the Summit for me, and a long, all day event. First, a lovely breakfast with Micky Steuwe, during which she presented me with a lovely glass art piece she made herself.

I’ll treasure this, as personal, thoughtful gifts are touching. Thanks, Mickey.

Then… Read more

0 comments, 158 reads

Posted in The Voice of the DBA on 26 October 2016

Win a Year of Death Wish Coffee at the #sqlsummit

One of the promotions this week at the PASS Summit from Redgate Software is a chance to run a year’s supply of coffee. This isn’t just any coffee, but the Death Wish Coffee, full of extra caffeine. Grant Fritchey loves this stuff, and that’s what one lucky attendee will… Read more

0 comments, 177 reads

Posted in The Voice of the DBA on 26 October 2016

Getting dbatools in Powershell

I had the chance to watch dbatools in action recently at SQL Saturday Cambridge. I watched a presentation from Chrissy LeMaire (@cl) that was impressive in how easy she made a number of DDL type changes between instances.

I decided to give some of these new cmdlets a… Read more

1 comments, 514 reads

Posted in The Voice of the DBA on 25 October 2016

Using TRY..CATCH in SQL Prompt

I learned something new recently about SQL Prompt. I was working on documenting and experimenting with snippets and found a quicker way to write code.

One of the things I think is great is to use the TRY..CATCH structure. I don’t do it enough, but I want to do this… Read more

1 comments, 767 reads

Posted in The Voice of the DBA on 24 October 2016

Monday Night Networking Dinner Tonight

If you are attending the  PASS Summit, or even in the Seattle area, we have a SQL Server pro networking dinner tonight. This is at The Yardhouse on 4th Avenue. This is a buy your own event, but you’ll have the chance to meet with and network with other professionals. Read more

0 comments, 205 reads

Posted in The Voice of the DBA on 24 October 2016

Meet and Greet Data Pros at #sqlsummit

Next Monday night is the networking dinner that Andy Warren and I have put together for the last 6 years. Once again, we’ve arranged for everyone in Seattle to come join in.

If you don’t have plans for Monday night, pick a time, and join us at the Yardhouse. We’ve… Read more

0 comments, 203 reads

Posted in The Voice of the DBA on 21 October 2016

#RedgateRocks at the PASS Summit

If you are attending the PASS Summit next week in Seattle, and want to attend a fun party on Thursday night, come by the Redgate Software booth in the expo hall for your #RedgateRocks bracelet. This is your ticket to admission Thursday night.

Walk down to 1927 3rd Ave between… Read more

0 comments, 183 reads

Posted in The Voice of the DBA on 21 October 2016

Creating a Logon Trigger–#SQLNewBlogger

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

Suppose you want to audit logins for your SQL Server instance. There are multiple ways to do this, but Logon Triggers have a few advantages. First, they… Read more

2 comments, 205 reads

Posted in The Voice of the DBA on 20 October 2016

Fun and Contests at Summit 2016

I’ll be attending the 2016 Pass Summit as a part of the Redgate Software crew. I’m not speaking this year, so most of my time will be at the Redgate booth, showing you a few tricks and tips with products and maybe convincing you that we can help your company… Read more

3 comments, 225 reads

Posted in The Voice of the DBA on 19 October 2016

DB CI: Getting Test Results in VSTS

One of the things I struggled with a bit was getting test results to appear in VSTS from my builds.

Here’s my original Build flow:

However, when I’d run a build, I got this in the Build summary:

That’s not great, and I knew this could work better, so I… Read more

0 comments, 588 reads

Posted in The Voice of the DBA on 18 October 2016

Webinar: Database Deployment with Git, Jenkins, and Octopus Deploy

I’ve got a webinar later today that looks at how Redgate Software’s DLM Automation and other SQL Toolbelt tools can be used to smoothly move development changes from one database to another.

Sign up and spend an hour with me this morning.

This is part of a monthly… Read more

0 comments, 236 reads

Posted in The Voice of the DBA on 18 October 2016

Thursday Game Night at PASS Summit

On Thursday night, Oct 27, 2016, Andy Warren and I are hosting a game night event at the Washington State Convention Center. This is a low-key, alternative fun event for those of you that might not be attending another party elsewhere.

If you’re interested, please purchase a ticket. We… Read more

3 comments, 704 reads

Posted in The Voice of the DBA on 17 October 2016

Thursday Night Networking Dinner Meetup at Summit 2016

This year PASS announced that Thursday night would be an open night at the PASS Summit, with no events scheduled. Typically Microsoft has sponsored a party at Gameworks, but not this year. PASS has a list of events at the Summit, if you want to browse. Many of these… Read more

4 comments, 651 reads

Posted in The Voice of the DBA on 14 October 2016

Newer posts

Older posts