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

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

1 comments, 557 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, 1,485 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, 396 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, 330 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, 889 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, 876 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, 411 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,005 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, 274 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, 830 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, 773 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, 847 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, 299 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, 284 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, 790 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,414 reads

Posted in The Voice of the DBA on 6 November 2017

DevOps Basics – Ignoring Files in Git

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it.

One of the things you’ll run into at times is the need… Read more

1 comments, 1,111 reads

Posted in The Voice of the DBA on 30 October 2017

Basic FORMATting– #SQLNewBlogger

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

I saw the addition of FORMAT() to the T-SQL language, but didn’t play with it much. Recently it appeared in some code, and decided to experiment a bit.… Read more

0 comments, 979 reads

Posted in The Voice of the DBA on 25 October 2017

Redgate at Summit 2017

I’ll be heading out to the PASS Summit next week, spending Halloween in a conference center with a lot of other geeks. I know some of you won’t make it, and we’ll miss you, but I understand.

I’m meeting my colleagues from Redgate there, including the new editor of Simple… Read more

1 comments, 1,009 reads

Posted in The Voice of the DBA on 24 October 2017

SQL Clone Server Service Permissions

SQL Clone is amazing, and it can really save time and disk space for many organizations. I’ve got a series posted here on various little things I’ve learned about the product. There are also a number of articles on the Redgate Community Hub.

I was working on helping a… Read more

0 comments, 843 reads

Posted in The Voice of the DBA on 23 October 2017

Newer posts

Older posts