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

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, 115 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, 155 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

1 comments, 331 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, 228 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

1 comments, 209 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, 517 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,240 reads

Posted in The Voice of the DBA on 6 November 2017