Practical guides and insights for modern data practitioners
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
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
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
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
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
My T-SQL Tuesday contribution for this month discusses how I want automatic index management levels to be included with SQL Server. T-SQL Tuesday host For those of you who aren’t aware, this month’s T-SQL Tuesday topic was chosen by yours truly. Last week I invited everybody to write about a fantasy SQL service they have. … Read more
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
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
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
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