Category Archives: Blog

AutoMap in SQL Compare

SQL Compare is a core product from Redgate and I’ve got a series on some of the interesting things I’ve found. Download a trial today if you haven’t tried it. SQL Compare does a great job of trying to help … Continue reading

Posted in Blog | Tagged , , | Leave a comment

T-SQL Tuesday #098–2018 Goals

A great topic for T-SQL Tuesday this time from @sqlmal. It’s Setting Learning Goals for 2018, and it’s a topic I both loathe and love. I hate making commitments that I can’t keep, and I constantly find that a chaotic … Continue reading

Posted in Blog | Tagged , , | Leave a comment

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 … Continue reading

Posted in Blog | Tagged , , | Leave a comment

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 … Continue reading

Posted in Blog | Tagged , | Leave a comment

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/

Posted in Blog | Tagged , | 2 Comments

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

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

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 … Continue reading

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

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 … Continue reading

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

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 … Continue reading

Posted in Blog | Tagged , , | Leave a comment

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. … Continue reading

Posted in Blog | Tagged , , | Leave a comment