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-02
13 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
7 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-11-28 (first published: 2022-11-25)
134 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-11-24 (first published: 2022-11-23)
25 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)
185 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
6 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)
405 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
5 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)
292 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
9 reads
There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...
By Steve Jones
Today’s coping tip is to find a new way to tell someone you appreciate...
I was given 4.5 months notice this past June and was fortunate to find...
Comments posted to this topic are about the item Stairways to ScriptDOM Level 4...
Comments posted to this topic are about the item The Availability Group Secondary Connection
I am getting the following error when I try to use the Expression below....
Ask SSC