Tag Archives: software development

Disabling #sqlprompt Formatting

I love SQL Prompt, especially the new formatting engine. However, it’s not perfect, and there are times I don’t want code reformatted. One great example is when I write INSERT statements. Here’s what I might write: INSERT dbo.Payments_A   ( … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

How Much Code Can You Review?

When I was in college, I mostly wrote my own code for assignments (and fun), turning it in when I thought it was done. At some point I had a class that started to adopt more software engineering practices, and … Continue reading

Posted in Editorial | Tagged | Leave a comment

The Top 20 SQL Toolbelt Tips

Redgate produces some great software, and I’m glad that I get to use all of them as a developer and DBA. I use many of the tools each week, some daily, but I constantly find that there are plenty of … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Better Coding, More Savings

This editorial was originally published on May 13, 2013. It is being re-run as Steve is on holiday. I’m sure most of us would like to think that we write fairly efficient code. However the reality for many of us … Continue reading

Posted in Editorial | Tagged | Leave a comment

DBAs Need to Learn to Develop

This editorial was originally published on Jan 7, 2014. It is being re-run as Steve is at SQL in the City today. My first exposure to computers was as a child, learning to program in BASIC, Assembler, and Pascal. From … Continue reading

Posted in Editorial | Tagged | Leave a comment

DLM Automation–Making a Database Connection

One of the things I’ve been wanting to do is dig more into the command line automation cmdlets from the Redgate DLM Automation suite. While there are plugins for many build and release systems, I should be able to customize, … Continue reading

Posted in Blog | Tagged , , , , | 1 Comment

Held Hostage by the Database

Your database platform will constrain and limit the flexibility you have in evolving your software. It doesn’t matter which platform you choose, which type of database, or even the format for your data. At some point, you will be dealing … Continue reading

Posted in Editorial | Tagged , , ,

Server Hardware or Coffee?

I actually chuckled out loud in my office recently. I was reading a piece about Expensify and how they learned some lessons from their database architecture over time. It’s a good piece, but at one point the author talks about … Continue reading

Posted in Editorial | Tagged , ,

Developer Deployment Frustrations

This editorial was originally published on Sept 7, 2012. It is being re-published as Steve is at DevConnections. Why don’t developers like SQL Server? Probably a few reasons, but I’m sure this is one that really frustrates them. I found … Continue reading

Posted in Editorial | Tagged ,

A Software Warranty

This editorial was originally released on Oct 21, 2012. It is being re-published as Steve is traveling. Years ago I worked in a large company on the operations team. We were responsible for all production issues for the 6,000 people … Continue reading

Posted in Editorial | Tagged