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-17
63 reads
Blog Posts
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)
429 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)
256 reads
My 2024 in Data: Travels
This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...
2024-12-16
7 reads
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the Basic SQL Practice: A Store course – it's totally free for the entire month! This...
2024-12-14
39 reads
A New Word: Dolonia
dolonia – n. a state of unease prompted by people who seem to like you too much, which makes you wonder if they must have you confused with someone...
2024-12-13
44 reads
Cloudbrew 2024 – Slides
You can find the slides for the session Building the €100 data warehouse with the Azure Data Platform in this GitHub repo.
The post Cloudbrew 2024 – Slides first appeared...
2024-12-13
17 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)
691 reads
Trace Flag 3625 Follow Up
Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since that time, we have observed an intriguing phenomenon when encountering a login failure. To demonstrate...
2024-12-13 (first published: 2024-12-10)
480 reads
AI Helping with an API
Can an AI help me with some database API work? Let’s see. This is part of a series of experiments with AI systems. The Scenario One of the things...
2024-12-11
121 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Tables with a SPARSE Column and Consumption
Comments posted to this topic are about the item Tables with a SPARSE Column...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers