5 Free Data Analysis Books to Kickstart Your Career
Dreaming of a data analyst career but feeling a little lost? Already playing with data at work and craving the bigger picture? Or simply looking for a solid read...
2024-06-08
136 reads
Blog Posts
How I Effortlessly Dockerize Python-Based AWS Lambda Functions
As a Software Engineer, i would like to learn how to dockerize my Python Fast API Framework and use this dockerize application in my lambda function. This will allow...
2024-06-07
87 reads
PostgreSQL error in Fabric Pipelines – No pg_hba.conf Entry for Host
I came across a bit of a weird error when I was trying to connect to a PostGreSQL database (hosted as an Azure DB for PostGreSQL), where “xx.xx.xx.xxx” is...
2024-06-07
234 reads
T-SQL Tuesday #174 – My Favorite Interview Question
This month is a great topic to me. I think growing and improving your career is a skill that most of us could improve, especially in our younger years....
2024-06-07 (first published: 2024-05-14)
636 reads
T-SQL Tuesday #174: Job Interview Questions
Once upon a time, I used to think of difficult technical questions to ask candidates for a DBA position. However, over time I came to understand that in most...
2024-06-07 (first published: 2024-05-14)
419 reads
Are ABORT_AFTER_WAIT's victims logged?
In SQL Server, using the KILL command to terminate a session results in an entry being logged in the error log.
This raises the question: Does the ALTER INDEX REBUILD...
2024-06-05 (first published: 2024-05-18)
211 reads
Part 2: The Modern Azure Data Warehouse – ADF and ADLS
In today’s data-driven world, having the right tools to manage and process large datasets is crucial. That’s where Azure Data Lake Storage (ADLS) and Azure Data Factory (ADF) come...
2024-06-05 (first published: 2024-05-17)
359 reads
Free Advanced SQL Course for June: Don’t Miss Out!
Summer is here, and it's the perfect opportunity to enhance your SQL expertise with LearnSQL's special offer. For the entire month of June 2024, they are giving away their...
2024-06-04
57 reads
Large System Databases on SQL Server
This one is an oldie in my blog drafts, but a goodie! So, I will finally post it after nearly three years of sitting around. Thank you, past self,...
2024-06-04
74 reads
Automating Container Image Builds with Docker Build Cloud and Github Actions
In a previous post we went through how to use Docker Build Cloud to remotely build a Docker container image from a Github repository. In that example, we kicked...
2024-06-03 (first published: 2024-05-17)
232 reads
Blogs
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
Forums
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Doing the Little Things
Comments posted to this topic are about the item Doing the Little Things
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers