Practical guides and insights for modern data practitioners
For this months T-SQL Tuesday contribution I want to share some of my thoughts about SQL Server upgrades. Including ones for SQL Server 2019 and SQL Server 2022 (which is due to be released in near future). This months T-SQL Tuesday is hosted by Steve Jones. Steve has invited us to discuss our thoughts about … Read more
In this post I want to cover how I used Azure as if it was a SQL Server time machine. Because I used Azure like one recently to resolve a Master Data Services issue. By the end of this post, you will see how I used an Azure virtual machine to help resolve a SQL … Read more
My T-SQL Tuesday contribution for this month is about doing easy demos using containers. Which is hosted by Anthony Nocentino this month. Anthony has invited us all to share your experiences using containers, and not just SQL Server in containers. You can find out more about the invite by clicking this link about his T-SQL … Read more
In this post I want to do a crash course on how to connect a local SQL Server database to Azure Synapse Analytics. So that Azure Synapse Analytics can get data from it. I thought I would do this post since I got asked last week in a meeting if this was possible. In reality, … Read more
My T-SQL Tuesday contribution for this month is about the using Notebooks more with Azure Data Engineering services. Which is hosted this month by Steve Jones. Steve has invited us all to talk about how we have used, or would like to use, a Jupyter Notebook. You can find out more about the invite by … Read more
I want to cover deploying to multiple SQL Server database types using Azure DevOps faster. because I have done this recently. In fact, I done it for the pipeline I discussed in a previous post. Which was able to deploy updates to multiple database types after updating one single database project. You can read that … Read more
In this post I will show you how you can update both SQL Server 2019 and Azure SQL Database objects using one commit. Because I tested various ways myself in Azure DevOps the other day. To clarify, what I mean by a commit is when you first save changes to a database project that is … Read more
To add some much-needed humor at the moment I thought I would do a post about ten comments I think every SQL Server DBA wants to say. In addition, a brief explanation about them. To make things easier I have also added links to them below. So, if you want to you can go straight … Read more
I want to cover some updates about what Linux distributions you can install SQL Server on. In reality, these are updates for an older post I did back in August 2019 here. Now that DataWeekender is over I have more time to post about these updates. For those still wondering if there will be another … Read more
I’ve been looking back at last decade since so much has changed in the last ten years. Now I have looked for an official name for the last decade because I was curious. According to the Wikipedia article here it’s the twenty-tens, so I will stick with that for now. As far as technology is … Read more