A New Word: Wellium
wellium – n. an excuse you come up with to rationalize a disappointing outcome – telling yourself that you weren’t in the mood for that sold-out show anyway, that...
2024-02-09
21 reads
Blog Posts
Friday Flyway Tips–Dark Mode
I saw a post that Flyway Desktop has a dark mode and I had to try it out. I’ve been working with Flyway Desktop for work more and more...
2024-02-09
22 reads
Moving SQL Prompt History to Another Machine
A customer was asking about SQL Prompt recently and how their history is stored and if it can be moved to another machine. This post shows how this works,...
2024-02-09 (first published: 2024-01-22)
236 reads
Search for queries with Query Store GUI
Hey folks, long time no write!
Today I want to bring a tip that I use every week but I found that most SSMS users are unaware it exists.
I can...
2024-02-09 (first published: 2024-01-29)
626 reads
My data architecture book is published!
I’m thrilled to share that after 15 months of dedicated effort, my book, “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh,”...
2024-02-08
139 reads
How to Call REST API using VS Code
Sometimes you need a fast way to test your API call and responses, and for that VS code is the perfect tool to do that. For today’s demo, we...
2024-02-07 (first published: 2024-01-24)
918 reads
Your gradient fill bar charts in Power BI have poor color contrast, but you can fix them
Since conditional formatting was released for Power BI, I have seen countless examples of bar charts that have a gradient color fill. If you aren’t careful about the gradient...
2024-02-07 (first published: 2024-01-23)
176 reads
David Kahn, legendary author, has passed away
I first saw this at Schneier on Security. David Kahn, author of The Codebreakers, has passed away at 93. The Codebreakers was considered the best book on the history...
2024-02-05
39 reads
Digging up undiscovered savings
You might be able to shave off thousands – or more – in your monthly cloud bills for your critical SQL Servers, all while maintaining or even improving performance....
2024-02-05 (first published: 2024-01-21)
196 reads
Moving towards the DataFrame API using the Spark Connect gRPC API in .NET
All Spark Connect Posts
Code
Goal of this post So there are two goals of this post, the first is to take a look at Apache Arrow and how we can...
2024-02-05
64 reads
Blogs
My 2024 in Data: Health and Workouts
By Steve Jones
This is my last week of the year working (I guess I come back...
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...
Forums
Windows could not start the SQL server (SQLEXPRESS) service (macOS)
I have a common problem that I just cannot figure out after scrolling through...
Adventureworks data does not load
Hello, I am a new member here so forgive me if I am not...
Restore Procedure not working
I created a small procedure that reads the backup file and restores the DB...
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