T-SQL Tuesday 159 – Azure Synapse Link and certifications

For this months T-SQL Tuesday contribution I want to cover Azure Synapse Link and certifications. In addition, this post contains plenty of links. Community superhero Deepthi Goguri hosts this months T-SQL Tuesday. Deepthi invites us to blog about two topics this month. You can read the original invitation by clicking on this link for the … Read more

T-SQL Tuesday 151 – T-SQL consistency and comments

For this months T-SQL Tuesday contribution I am going to cover T-SQL consistency and comments. Mala Mahadevan hosts this months T-SQL Tuesday. Mala invites us to share details about our T-SQL coding rules. You can read the original invitation to decide for yourself. By clicking on this link for the T-SQL Tuesday 151 invitation or … Read more

T-SQL Tuesday 138 – How I keep on top of technology changes

My T-SQL Tuesday contribution for this month is about how I keep on top of technology changes. Which is hosted this month by Andy Leonard. Andy has invited us all to talk about how we have responded, or plan to respond to, changes in technology. You can find out more about the invite by clicking … Read more

Five minute crash course about Synapse Studio

In this post I want to do a five minute crash course about Synapse Studio. Because I have recently been asked to do this by colleagues. In addition, I want to clear up some confusion about what you need to do before you can access Synapse Studio. For those who are not aware, Synapse Studio … Read more

Set up your laptop as an Azure DevOps agent to test SQL Server deployments

In this post I want to cover how you can set up your laptop as an Azure DevOps agent to test SQL Server deployments. Because I have been asked about this this a lot. In reality, a lot of this post applies if you are looking to setup your computer as an Azure DevOps agent … Read more

Personal SQL Server 2019 Lab review

I have written this personal SQL Server 2019 Lab review. Because last week I saw the new lab based on CTP 3.1 and I decided to go through it. In addition, I thought I would give you some useful tips along the way. SQL Server 2019 Lab introduction Now this lab is a recent addition … Read more

SQL Server related Services available with top four cloud providers

Introduction In this post I thought I would talk about SQL Server related services available with the top four providers. Because in my previous post I talked about cloud infrastructure options when looking at providers. As I mentioned in my last post those providers are Amazon Web Services (AWS), Microsoft Azure, Google Cloud Platform (GCP) … Read more

Building a test lab to use outside work

Introduction I’ve decided to post about building a test lab to use outside of work. Because it’s something most data platform professionals deal with at one stage or another. Some of you can also consider this a primer for future posts. Now if you’re lucky your workplace already has a test environment where you can … Read more

Fixing some of the problems caused when you introduce Columnstore indexes

In this post I will cover fixing some of the problems caused when you first introduce Columnstore indexes to a SQL Server database. Because in my last post I talked about fixing some of the problems caused when you introduce rowstore filtered indexes. Before we start I’d just like to point out I’m not going … Read more