2025-12-22
9,492 reads
GitHub
Introduction to GitHub Actions Part 2: GitHub-hosted runners
In this article, you’ll learn about the many options for using a GitHub-hosted runner, including Docker.
2025-05-23
Introduction to GitHub Actions Part 1: Getting Started
This article series will teach you what you need to know to take advantage of GitHub Actions, especially for deploying database code.
2025-04-07
2024-10-21
2,004 reads
2024-09-09
4,306 reads
Git, GitHub and Visual Studio Code for SQL Server
Learn how to get started with Git and Visual Studio Code.
2024-08-05
6,040 reads
GitHub Copilot - Our Best Ally for T-SQL
This article examines how GitHub Copilot might be used when working with T-SQL Code.
2023-12-05
7,476 reads
2023-04-29
137 reads
2022-07-30
328 reads
Basic Git for DBAs: Managing PowerShell Scripts
This next article in the git series looks at managing powershell code in Git.
2022-04-11 (first published: 2020-08-27)
5,037 reads
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers