SQL in 2025: Still the King of Data
Data's the new oil, and SQL is your refinery. It's still the go-to language for shaping, analyzing, and making sense of the data that fuels our businesses. In 2025,...
2025-01-28
170 reads
Blog Posts
15 Characters or Less: The Challenge of SQL Server Listeners Name
15 Characters or Less: The Challenge of SQL Server Listeners Name
There is a hard limit on how long your AlwaysOn listener name can be. That...
2025-01-27 (first published: 2025-01-14)
350 reads
Removing the REST Endpoint in the Data API Builder
The more I work with the Data API Builder (DAB), the more I lean towards GraphQL instead of REST. Rest isn’t bad, but it’s tough. This is part of...
2025-01-27 (first published: 2025-01-15)
357 reads
The Local OLLAMA Gui
I ran a small ollama model in a container and have been doing some experiments. One of the things I wanted to do was get a GUI so I...
2025-01-27
156 reads
A New Word: Amoransia
amoransia – n. the melodramatic thrill of unrequited love; the longing to pine for someone you can never have, wallowing in devotion to some impossible person who could give...
2025-01-24
38 reads
Data Masking with Azure Databricks
“Alice: Would you tell me, please, which way I ought to go from here?The Cheshire Cat: That depends a good deal on where you want to get to.”— Lewis...
2025-01-24 (first published: 2025-01-13)
353 reads
Challenges Enterprises Face When Adopting AI
The post Challenges Enterprises Face When Adopting AI appeared first on Joyful Craftsmen.
2025-01-22 (first published: 2025-01-14)
303 reads
PASS Summit 2024 – A new experience
I attended the PASS Data Community Summit held in Seattle in person this year after a long gap of 4 years and after RedGate software took over running the...
2025-01-22 (first published: 2025-01-13)
295 reads
The Data API Builder Start and Add Extensions in VS Code
One of the things that I like about the Data API Builder (DAB) is that there is a lot of CLI work that can be done. However, lots of...
2025-01-22
111 reads
Implement a RAG Solution Using Azure SQL Database
AI and ChatGPT are all the rage these days. Seems like around every corner is another break-through in how we interact with data, regardless of if that data is...
2025-01-20 (first published: 2024-11-01)
827 reads
Blogs
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers