Webcast Tomorrow on SQL Server Disaster Recovery
Tomorrow, November 19, 2024, at 1 PM EST, I'm giving a webcast on SQL Server Disaster Recovery. It'll cover all the typical methods built-in to SQL Server, with a...
2024-11-18
18 reads
Blog Posts
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
Spark Connect Dotnet November 2024 Where are we?
All Spark Connect Posts
Introduction There have been quite a few changes in the last couple of months and I just wanted to give a quick update on the current...
2024-11-16
78 reads
A New Word: Ochisia
ochisia – n. the fear that the role you once occupied in someone’s life could be refilled without a second thought, which makes you wish that every breakup would...
2024-11-15
18 reads
Counting Groups with Window Functions: #SQLNewBlogger
I looked at row_number() in a previous post. Now I want to build on that and do some counting of rows with COUNT() and the OVER clause. I’ll show...
2024-11-15 (first published: 2024-10-30)
475 reads
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC. The topic is about window functions, something that really interests me and that should...
2024-11-15 (first published: 2024-10-31)
375 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)
248 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
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
146 reads
Extending a SQL Server Failover Cluster Across Regions in Google Cloud Platform (GCP)
I was the principal author of this SIOS whitepaper, which describes how to build a 2-node SQL Server cluster in Google Cloud Platform (GCP) spanning multiple zones. Today, I’ll...
2024-11-13 (first published: 2024-10-29)
186 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers