When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a company? appeared first on Joyful Craftsmen.
2024-12-04 (first published: 2024-11-25)
303 reads
Blog Posts
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file would be. In QA, I have (relatively) large dbs (compared to prod). Enter the pgstattuple...
2024-12-02 (first published: 2024-11-21)
192 reads
SQL Server Distributed Availability Groups and Kubernetes
A while back I wrote about how to use a Cross Platform (or Clusterless) Availability Group to seed a database from a Windows SQL instance into a pod in...
2024-12-02 (first published: 2024-11-19)
248 reads
AI Step 1
As this is an Artificial Intelligence (AI) World, things are changing. We can see that everywhere you look, even now, when writing a blog, I could feel it today :)....
2024-12-01
33 reads
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user interface, while Rust delivers performance and safety on the backend.A Dockerized todo app is a to-do...
2024-11-30
68 reads
A New Word: Nachlophobia
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty shallow, that although your relationships feel congenial in the moment, an audit of your life...
2024-11-29
136 reads
Book Review – Microsoft Power BI Performance Best Practices
I was asked to do a review of the book Microsoft Power BI Performance Best Practices (Amazon link), which means I got a copy for free. The book is...
2024-11-29 (first published: 2024-11-19)
206 reads
Using SQL Compare with Read-only Access
Recently a customer asked if SQL Compare and SQL Data Compare can be used with a read-only database as a source. It’s a good questions as I’ve seen some...
2024-11-29 (first published: 2024-11-20)
345 reads
Finding fields used in a Power BI report in PBIR format with Semantic Link Labs
Have you ever wondered where a certain field is used in a report? Or maybe you need an easy way to find broken field references in a report? Certain...
2024-11-27
20 reads
Finding fields used in a Power BI report in PBIR format with Semantic Link Labs
Have you ever wondered where a certain field is used in a report? Or maybe you need an easy way to find broken field references in a report? Certain...
2024-11-27
25 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers