T-SQL Tuesday 145 – Answers about events and Costa Rica

For this months T-SQL Tuesday contribution I intend to provide some answers about events and Costa Rica. Xavier Morera hosts this months T-SQL Tuesday. Xavier has invited us to answer some questions relating to events and Costa Rica. More specifically, the answer to the below questions: You can find out more about the invite by … Read more

Common questions about migrating to Azure DevOps for SQL Server deployments

In this post I want to cover common questions about migrating to Azure DevOps for SQL Server deployments. Because I got asked a fair few at SQLBits last week. In fact, some people in the DevOps & PowerShell chat room kept me busy with their questions. Of course, I don’t mind because I enjoy sharing … Read more

Interesting Azure DevOps Extension workaround

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

Personal 2019 review

Since I’ve officially stopped working for the year now I thought it would be a good time to do a personal 2019 review. Technology As far as technology is concerned it’s being an interesting year. As usual, there were a large number of announcements at this year’s Ignite. To save reinventing the wheel you can … Read more

Beautiful Azure Boards query

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

Maintaining larger SQL Server databases recap

Last year I did some posts about maintaining larger SQL Server databases better. Since then I have had to answer some questions on the SQLHelp hashtag on Twitter about information which is in these posts. So, I have decided to do this post as a quick recap about them to help others. Reading these posts … Read more