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

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, 225 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, 210 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, 241 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, 250 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, 623 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, 268 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, 737 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, 682 reads

Posted in The Voice of the DBA on 14 October 2016

Why I Practice Presentations

I had a new presentation to give this week at IT/DevConnections. This is a paid for conference, and I want to be well prepared and ready for the events. It’s the least I can do for people who have spent money to attend an event.

I enjoy IT/DevConnections, and… Read more

3 comments, 456 reads

Posted in The Voice of the DBA on 13 October 2016

The Snippet Manager in SQL Prompt

I love SQL Prompt, since it makes T-SQL coding quicker and easier. One of the handiest things is the Snippet Manager. I’ll show you how this works.

When I type something, like “cl”, I get a list of things, as shown below..

I see CLOSE, which has “cl” in it,… Read more

0 comments, 268 reads

Posted in The Voice of the DBA on 12 October 2016

T-SQL Tuesday #83–The Same Old Issues

This month is an interesting T-SQL Tuesday topic, and it’s brought to us by Andy Mallon, with the topic of the same old issues we’re still dealing with. I think that’s an interesting issue, since I do find myself answering the same old questions over and over.

If… Read more

0 comments, 237 reads

Posted in The Voice of the DBA on 11 October 2016

The Free-Con Returns to Seattle

On Monday, October 24, 2016, there will be a Free-Con in Seattle for those that might not be attending a pre-con before the Pass Summit. Put on by Jason Brimhall and Wayne Sheffield, there’s a set of 6 sessions you can attend for free that day.

Register now to come. Read more

0 comments, 198 reads

Posted in The Voice of the DBA on 11 October 2016

Monday Night Networking at Summit 2016

It’s PASS Summit time and that means Andy Warren and I are doing another Monday Night Networking Dinner.

For those of you that haven’t come in the past, Andy and I aren’t buying you dinner. What we are doing is setting up a time and location for people to come…

Read more

2 comments, 207 reads

Posted in The Voice of the DBA on 10 October 2016

Back for a Day

I hope everyone is well in Florida, but the hurricane caused a postponement of SQL Saturday Orlando. Fortunately I caught the note early enough on Wednesday and spent about an hour at lunch cancelling travel plans and moving my flight from DC to Orlando to Denver to an early… Read more

0 comments, 226 reads

Posted in The Voice of the DBA on 7 October 2016

Off Again

It’s another week of travel for me, starting early this morning. This is another crazy trip, and yes, I did this to myself. However, I am taking note this time and I’ve already declined and refused a few things for 2017 to try and avoid these trips.

My week:

  • Tues…

Read more

2 comments, 228 reads

Posted in The Voice of the DBA on 4 October 2016

My SQL Prompt GitHub Repo

Last year I published an article on SQLServerCentral from Guarab Vohra on using SQL Prompt with a VCS. I really like the article, and had been meaning to get my own SQL Prompt Snippet library into a repo, but kept putting it off.

If you don’t have a SQL… Read more

1 comments, 271 reads

Posted in The Voice of the DBA on 4 October 2016

Rename a Server with PowerShell

I’m sure many people are experimenting with VMs and SQL Server. If you’re like me, many of you just default to installing Windows 7/10 or Windows Server xx Standard for your testing. Those systems work fine, but I’ve been trying to build slimmer systems, which means looking at Server Core.… Read more

2 comments, 404 reads

Posted in The Voice of the DBA on 3 October 2016

Finding the Attribute

I was playing with some Extended Events recently. If you haven’t tried, I’d encourage you to do so. However, working with XML is not my favorite. I know I can get the GUI in SSMS 16.x to show me events, but I sometimes want to query.

Here was my quick… Read more

0 comments, 428 reads

Posted in The Voice of the DBA on 29 September 2016

Quick Tips–Using ii in #SQLPrompt

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 when inserting data into tables. Read more

0 comments, 1,404 reads

Posted in The Voice of the DBA on 27 September 2016

More Azure Database Creation in Powershell

I wrote about Azure SQL Database for T-SQL Tuesday #82, but I had a few mistakes in my process, at least from a cost standpoint. Since I’ll probably use this a bit more as I flesh out some CI/CD, I decided to document a bit more about the database… Read more

3 comments, 262 reads

Posted in The Voice of the DBA on 22 September 2016

Newer posts

Older posts