Practical guides and insights for modern data practitioners
My T-SQL Tuesday contribution for this month is about unit testing database changes. This month’s T-SQL Tuesday is hosted by Hamish Watson. You can read more about the invite by either clicking on the T-SQL Tuesday logo in this post or the link below. If you read Hamish’s invitation in detail here he explains very … Read more
I thought I would cover an interesting Azure DevOps Extension workaround I did recently. Because I was due to speak about Azure Boards at SQLBits this week. A while ago I was using a virtualized desktop provided by a client to test various things. For instance, different ways to query SQL Server related backlog items … Read more
In this post I thought I would talk about using version control for SQL Server Management Studio templates. In addition, I will mention other applications you can do the same with towards the end. I wanted to write this post because in a previous post I discussed how SQL Server Professionals can benefit from using … Read more
In this post I thought I would talk about how SQL Server Professionals can benefit from using version control systems. Mostly because I have been involved in some discussions about it recently. I say SQL Server Professionals here because I want it to be all inclusive. Due to the fact this applies to database administrators … Read more
In this post I thought I would share some SQL Server Product Owner advice based on actual experience. Because I am aware that is still fairly new for a lot of people compared to the more traditional SQL Server roles. In fact, I have been asked about it a lot recently whilst at conferences. Because … Read more
To try something new, I thought for a few blog posts I would write a fictional tale about lessons learned by a time travelling SQL Server DBA. Because at the start of a new year people tend to look into the past and the future. I decided it would be a good idea to cover … Read more
In this post I’d like to discuss using 2020 vision with SQL Server. For those wondering what I mean by that I will explain shortly. Before I do that, I’d just like to wish everybody reading this a Happy New Year. Anyway, just to clarify what I mean by using 2020 vision with SQL Server. … Read more
In this post I want to cover a beautiful Azure Boards query that I created. Because a while ago I mentioned that I had logged a feedback item to Microsoft about Azure DevOps. In particular, with them adding a ‘Not’ option when filtering tags. You can read the feedback item with Microsoft in detail here. … Read more
I thought I would share my experiences of being SQL Server Product Owner since I have been doing it for a client’s team for nearly six months now. In fact, I’ve been the Product Owner of the SQL Engineering team for a four-figure number of SQL Server instances for a client six months this week. … Read more
Recently I’ve been going through different Azure DevOps test environment options. In order for people to perform changes without interfering with the existing business environment. In addition, I’ve had to help some people sort out test environments for Azure DevOps as well. So, I thought I better do a post about the options that I … Read more