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

Renaming a Column–#SQLNewBlogger

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

One of the things I rarely do is rename objects. There are good reasons to do so, but often the changes required in other objects and applications isn’t… Read more

0 comments, 99 reads

Posted in The Voice of the DBA on 11 December 2017

SSMS Updates in 17.4

SSMS 17.4 is out, and if you haven’t upgraded from SQL 204, 2012, 2008, etc., you should do so. You can run your bundled SSMS side by side with the new versions, but it seems that the 17x versions are improving andbecoming more stable.

You can download the new version Read more

0 comments, 242 reads

Posted in The Voice of the DBA on 8 December 2017

Interviewed

I got sent an interview by Mohammad Darab, a fellow SQL Server professional in Northern Virginia. I thought the questions were interesting, and spent a bit of time on them. You can read the interview here: https://mohammaddarab.com/interview-steve-jones/


Filed under: Blog Tagged: misc, syndicated

Read more

2 comments, 249 reads

Posted in The Voice of the DBA on 8 December 2017

Live on Channel 9 with ReadyRoll

I was interviewed in Redmond a couple months ago and the video was just published. I show and demo some database migration work with ReadyRoll in this video:

https://channel9.msdn.com/Shows/Visual-Studio-Toolbox/Database-DevOps-with-RedGate-ReadyRoll/player


Filed under: Blog Tagged: DevOps, ReadyRoll, Redgate, syndicated

Read more

0 comments, 269 reads

Posted in The Voice of the DBA on 7 December 2017

My Second Pester Test

I should write about my first one, but I just copied Rob’s test, so that’s not so exciting. Instead, I decided to take his advice and write some code, then decide how I test it. This isn’t really TDD, but I need to understand how Posh returns things, so… Read more

0 comments, 337 reads

Posted in The Voice of the DBA on 7 December 2017

Join Me Online Next Week for SQL in the City

It’s one week to SQL in the City 2017, once again streamed. I’ll be traveling this weekend to the Redgate office and getting setup. After two days of rehearsing, I’ll be ready for the live broadcast Dec 13.

Here’s a quick promo video as well:

Once again, we’ll be… Read more

0 comments, 289 reads

Posted in The Voice of the DBA on 6 December 2017

SQL Prompt Gets Even Better

SQL Prompt v9 came out recently, and just when you thought they couldn’t make it better, they found a way. If you click the menu for SQL Prompt, you’ll see a couple new items.

Code Analysis!!! Finally, a first step towards some sort of better analysis of code. These are… Read more

0 comments, 417 reads

Posted in The Voice of the DBA on 5 December 2017

Testing a Birthday Month Query

I ran across a post from a tester, wondering  how to write a query for birthday months. This makes sense, as I’m sure some businesses want to notify or track customers that have birthdays this month and give them something.

The post was good, with DDL and test data, and… Read more

0 comments, 447 reads

Posted in The Voice of the DBA on 4 December 2017

Automating SQL Clone Creation with PoSh

I think SQL Clone is one of the game changing products from Redgate. This product really fits into a DevOps mindset, allowing me to quickly and easily build (and rebuild) a dev database.

While the agent web pages make this easy, they’re slightly cumbersome and the PowerShell cmdlets fit better… Read more

0 comments, 340 reads

Posted in The Voice of the DBA on 1 December 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, 290 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, 464 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, 526 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, 354 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, 903 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, 240 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, 643 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, 649 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, 791 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, 276 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, 256 reads

Posted in The Voice of the DBA on 14 November 2017

Older posts