Create a Numbers Table in Power Query
This is a quick blog post, mainly so I have the code available if I need it somewhere in the future 🙂 Sometimes you need a numbers table (also...
2024-11-16 (first published: 2024-11-15)
360 reads
Microsoft finally adds Tenant Switcher for Fabric / Power BI
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for Microsoft Fabric (which includes Power BI). A what? Let me explain. When you have a...
2024-11-15 (first published: 2024-11-14)
250 reads
Microsoft Releases Windows 11 ARM ISO – A Game Changer for ARM-Powered Devices
Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major milestone for ARM-powered devices. This new release opens the door for users to install Windows...
2024-11-14
150 reads
Building Effective Data Governance Framework: Top Areas to Focus On
The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first on Joyful Craftsmen.
2024-11-14
40 reads
Master the Foundational Basics
It tells us to take the time to master the foundational basics of whatever technology we're working with. If we have mastered the basics in the past, it behooves...
2024-11-13
170 reads
Simple Talks Episode 9–Data masking and subsetting
The episode on data masking and subetting is out. You can see it here: Youtube Spotify Watch and check this out. This is especially close to my heart as...
2024-11-12
45 reads
T-SQL Tuesday #180: Avoid Perfect for Good Enough
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He points out that often times, a quest for perfection means we don't move forward. We...
2024-11-22 (first published: 2024-11-12)
461 reads
Book Review – Humanizing Data Strategy by Tiankai Feng
This book was making its rounds on social media, and the concept seems interesting enough to make me want to read it. It’s a very short book (only 106...
2024-11-22 (first published: 2024-11-12)
158 reads
Posting to Bluesky via PowerShell on macOS
The week of PASS Data Community Summit 2024 (November 4-8), Bluesky seemed to reach critical mass with the data community as well as the tech community writ large. Over...
2024-11-12
5 reads
Monday Monitor Tips: Tracking The Cost of Instances
One of the things that I’ve been asked in every operations situation is what licenses do we need for our servers. This is a rare request, often once a...
2024-11-25 (first published: 2024-11-11)
439 reads
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers