T-SQL Tuesday 147 – Thoughts about SQL Server upgrades

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

T-SQL Tuesday 140 – Easy demos using containers

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

Connect a local SQL Server database to Azure Synapse

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

T-SQL Tuesday 137 – Using Notebooks more with Azure Data Engineering services

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

Deploying to multiple SQL Server database types using Azure DevOps faster

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

Update both SQL Server 2019 and Azure SQL Database objects using one commit

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

Updates about what Linux distributions you can install SQL Server on

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

Looking back at the last decade

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