The nice people from Packt Publishing sent me a digital copy of Benjamin Nevarez new book to review: SQL Server Query Tuning and Optimization – Optimize Microsoft SQL Server...
2022-12-26 (first published: 2022-12-02)
323 reads
This Monday (the 5th of December 2022), my employer AE hosts a user group meeting for dataminds. There will be two sessions: It’ll be a very interesting evening, and...
2022-11-30
13 reads
The title of this blog post is a bit misleading, because what we actually want to do is to install the SSIS development functionality in Visual Studio 2022. SSAS...
2022-12-12 (first published: 2022-11-25)
800 reads
We have some data we can query using the serverless SQL pools in Azure Synapse Analytics. For this blog post, I’m querying data that is stored in Azure Cosmos...
2022-12-09 (first published: 2022-11-23)
239 reads
Recently I got a hold of my Untappd data. For those who don’t know the app, it’s a rating app for beers. You can check-in a beer each time...
2022-12-05 (first published: 2022-11-21)
249 reads
You can find the slides and demo scripts for my sessions at Cloudbrew (Snowflake) and PASS Data Community Summit (Migrate SSIS skills to ADF) in my Github repo. If...
2022-11-19
9 reads
SQL Server 2022 has been released! In this blog post, I’ll walk you through how you can install the latest version of SQL Server on your machine. I’ll be...
2022-11-28 (first published: 2022-11-17)
1,807 reads
At Tuesday the 13th of December, I give a webinar about Unison, a self-service online data quality tool of Melissa Data. This is a 30-minute webinar, sponsored by Melissa...
2022-11-10
7 reads
A new feature has been launched that allows you to have more granular control over the execution costs of your pipelines. By enabling the feature, you have a cost...
2022-10-31 (first published: 2022-10-19)
374 reads
You can find the slides and the demo scripts (.sql files) in my Github repo. You can use the materials as you like, attribution would be nice 🙂
The post...
2022-10-10
19 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...