-->
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: November 2017

Hit Refresh

I read Satya Nadella’s Hit Refresh recently, and it was a very enjoyable book. He’s had an interesting journey and I do think he’s dramatically transformed Microsoft. The book is recommended.

Anyway, the Microsoft MVP Program asked is MVPs would share a refresh moment from their lives, so here’s… Read more

1 comments, 485 reads

Posted in The Voice of the DBA on 30 November 2017

SQL in the City 2017

It’s almost time for SQL in the City 2017, coming Dec 13, live from Cambridge, UK. I’ll be traveling over to England for the event, and you can stream it to your office live. Once again, we’ll be presenting the conference twice, 11am and 6pm (both GMT), and you… Read more

0 comments, 1,031 reads

Posted in The Voice of the DBA on 30 November 2017

Pluralsight for Another Year

One of the ways that I try to keep current and learn is through Pluralsight. I’m lucky to get a subscription as a Data Platform MVP, but I’m sure Redgate would pay for one if I didn’t.

My subscription ran out last week, but the support staff at… Read more

1 comments, 1,027 reads

Posted in The Voice of the DBA on 29 November 2017

Installing Pester

One of the things that I believe strongly in is that we need better testing of software. Actually, what we really need is better habits and understanding of how to test our software. I don’t think we need to test everything, but we do need to know how to test… Read more

2 comments, 553 reads

Posted in The Voice of the DBA on 27 November 2017

Watch Out for Automap in SQL Compare

I wrote a piece on SQL Compare and customizing the Automap feature. This was handy for me in a small project where I encountered drift and needed to fix the production side.

In the article, I don’t map one of the columns in the target. In this case, I’d… Read more

1 comments, 1,131 reads

Posted in The Voice of the DBA on 27 November 2017

Hardware Wrestling

A few weeks back I had some issues. They were related to this:

My standing desk was down and as you can see, the power button for my machine is on the front, just above ankle level. In a few years of working, this hasn’t been an issue. However, my… Read more

1 comments, 364 reads

Posted in The Voice of the DBA on 24 November 2017

Thankful

It’s been a long career for me. In fact, I’ve been a SQL Server data professional for 17 years, just over half my life and almost the entire lifetime of the product.

In that time, I’ve worked for a number of companies in different positions. Some were good jobs, some… Read more

0 comments, 966 reads

Posted in The Voice of the DBA on 23 November 2017

Finding #dbatools #PowerShell commands

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these items.

I was reading about Pester from Rob Sewell… Read more

0 comments, 929 reads

Posted in The Voice of the DBA on 22 November 2017

One More Trip and Down for the Count

The last month has been a rough one for me, with lots of travel. I was on trips for 4 out of the last 5 weeks, and the week I was home I had a remote presentation to do. Travel can be hard enough, but add in the need to… Read more

2 comments, 919 reads

Posted in The Voice of the DBA on 17 November 2017

Adding a Format SQL Button to the Redgate Toolbar

I’ve gotten used to CTRL+K,Y to format SQL with SQL Prompt, but a customer wanted a button on the toolbar. It’s fairly easy to do, but I thought I should document the process for others.

First, if you click the small area on the right of a toolbar in SSMS,… Read more

0 comments, 388 reads

Posted in The Voice of the DBA on 14 November 2017

In a basement, a long, long time ago… #tsql2sday

It’s T-SQL Tuesday time and this is a good one. Read the invitation and proceed.

Who Influenced Me?

I’ve been working SQL Server for a long time. Since 1991, in fact, and had held 4 jobs as a DBA or developer by 1999. I was comfortable with the platform, and… Read more

2 comments, 392 reads

Posted in The Voice of the DBA on 14 November 2017

Changing the Default DB for a Login–#SQLNewBlogger

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

Recently I got into a bit of a pickle. I was detaching some databases for a demo, which is something I do periodically to make it easier for… Read more

0 comments, 942 reads

Posted in The Voice of the DBA on 13 November 2017

ROLLing UP Totals–#SQLNewBlogger

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

I was editing an article recently that talked about ROLLUP, and I wanted to play with this a bit more. I hadn’t used this much in my career,… Read more

2 comments, 1,597 reads

Posted in The Voice of the DBA on 6 November 2017