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
181 reads
Blog Posts
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)
619 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)
402 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)
200 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)
315 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
39 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
56 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)
202 reads
Power BI: Refreshable Excel Files in PBI Service
Ever since Excel made its debut in the 1980’s, it has been used as a quick way for end users to input and manipulate data on their own without...
2024-06-03 (first published: 2024-05-14)
338 reads
Sharpen Your SQL Skills: June’s Challenge Awaits!
This June, LearnSQL is throwing down the gauntlet with a fresh SQL Practice challenge. Dive into a real-world gym database and help Christine, the gym's manager, wrangle her data....
2024-06-01
48 reads
Blogs
My 2024 in Data: Reading
By Steve Jones
This is my last week of the year working (I guess I come back...
Book Review – Agile Data Warehouse Design
I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from...
My 2024 in Data: Speaking
By Steve Jones
This is my last week of the year working (I guess I come back...
Forums
Need ADF pipeline suggestion to copy 1 million files
I have an ADF pipeline that copies Files from source to destination. Both Source...
Function Defaults
Comments posted to this topic are about the item Function Defaults
Question of the Day
Function Defaults
I have created this function in SQL Server 2022:
CREATE FUNCTION dbo.AddInt (@one INT, @two INT = 1) RETURNS INT
AS
BEGIN
RETURN @one + @two
END
How can I call this and invoke the default value for @two? See possible answers