SQL Best Practices
SQL Server has evolved a great deal since I first started working with SQL Server 6.5 in 1998. Unfortunately I continually come across newer systems that are configured with...
2024-12-10
96 reads
Top 5 Advanced SQL Courses for 2025 (Must-Know)
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether you're in data analysis, data science, or any field that uses data. Trust me, it's...
2024-12-10
274 reads
How to Build Data Management for Unstructured Data
The post How to Build Data Management for Unstructured Data appeared first on Joyful Craftsmen.
2024-12-16 (first published: 2024-12-10)
452 reads
Grinding Away: Brent Ozar
Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many of you have likely seen him speak, read his blog, used his sp_Blitz script, or...
2024-12-20 (first published: 2024-12-09)
638 reads
Monday Monitor Tips: Am I Patched?
One of the things that I think is neat is that Redgate Monitor helps you track patching on your systems. This is something that has been challenging in every...
2024-12-16 (first published: 2024-12-09)
285 reads
Big Queries, Big Money
I had been meaning to post this, so as I finished a piece that referenced this, I decided to post the picture. This was from Small Data SF, where...
2024-12-06
46 reads
A New Word: Fardle-dun
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through your issues like a forest fire, which clears out your dry and hollow grievances and...
2024-12-06
39 reads
Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch
The post Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch appeared first on Joyful Craftsmen.
2024-12-11 (first published: 2024-12-05)
1,068 reads
FIRST_VALUE vs. Min: #SQLNewBlogger
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter asked about the difference between Min() and First_value. This post looks at a few cases....
2024-12-13 (first published: 2024-12-04)
717 reads
Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join
This post comes off the back of my last, where I looked at issues caused by explicitly declaring a large number of values in an IN clause. The query...
2024-12-11 (first published: 2024-12-04)
944 reads
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers