Voice of the DBA

Tag: Redgate

Strategies for Compliant Development Down Under

I’m doing a tour of Australia and New Zealand with our SQL in the City crew. We’re going to be in Brisbane, Christchurch, and Melbourne on three consecutive weeks.

Register today for Brisbane, Christchurch, and Melbourne. You can some see me talk about compliant development strategies. Privacy legislation is increasing around the world, and Australia is one of the countries leading the way.

New Zealand is thinking of passing more laws, so the ideas will be applicable there, but really, these are just good ideas. While we have solutions from Redgate, and I’d love you to use our tools, I also want more compliant development taking place everywhere.

I’ve heard wonderful things about Melbourne as a vibrant, high tech city, and I know that privacy and security are important topics to people there. I hope to see lots of you coming out to see how your SQL Server development can go faster, while avoiding any potential issues with data breaches.

May 21, 2019
Keynotes in Australia and New Zealand
I get to do the SQL in the City Summit keynotes in Australia and New Zealand. I’m excited, following the footsteps of Kendra Little and Donovan Brown, who have done them in the US.

Register today for Brisbane, Christchurch, and Melbourne.

The talk is on the State of Database DevOps in 2019. It’s likely some things many of you think about, but I’m hoping to inspire you to start adopting better development practices, give you reasons it’s a good idea, and providing some information that might help you get support from your management.

It’s going to be an exciting tour, and some long days. I’ve got four sessions at each Summit, as well as a session or two the next day at SQL Saturday in each city. Join me for a packed weekend of learning in one of our locations.

Come see me and register today for one of our Summits:
May 20, 2019
SQL in the City in Melbourne on June 14

As a part of our down under tour, SQL in the City comes to Melbourne on June 14. It’s a day before SQL Saturday #865 – Melbourne. If you’re anywhere close, and I know there’s not a lot of cities close by, but come take two days and get lots of Database DevOps and SQL Server training for a very low cost. I’m hoping for a good turnout and the chance to come back again next year.

Register today for a full day of training, including a catered lunch, and listen to talks about DevOps and Redgate products on Friday, then come back to SQL Saturday 24 hours later.

I’m excited for the event. We completed our London Summit a few weeks ago and it went very well. I’m taking over the keynote from Kendra and also doing a Monitoring session as well as covering privacy and the panel.

It’s going to be an exciting day, so if you want to improve your Database DevOps process, in a Compliant way, sign up and come on June 14.

May 16, 2019
A Clean Values Clause with SQL Prompt

I’ve had this code in a snippet for a long time:

I appreciate the markup to prevent SQL Prompt from doing this, which used to always happen.

I can’t tell you how many times I’ve used CTRL+Z to undo that format, add the markup, and format again.

A few months back. I was talking with someone and noticed this:

A new option for formatting called “INSERT”. This allows you to specify how you want to insert column list to appear. What’s even better, is at the bottom it says “Values”. Scroll down and you see options for separately formatting the VALUES clause, which I use all the time.

Now I can format easily without worrying my VALUES clause will get spread all over the page.

SQL Prompt is amazing. If you haven’t given it a try, download an eval today. If you have the Toolbelt, you ought to be using this every day.

May 13, 2019