Jason Brimhall


Blog Post

TSQL Sudoku II

Learn how to solve Sudoku puzzles quickly with a TSQL Script.
Related Posts:

Puzzles and Daily Trivia May 14, 2019

Summiting that Technical Challenge Part II July 6, 2018

Passion, Challenges,...

2011-08-23

7 reads

Blog Post

SQL Saturday 94

SQL Saturday 94 in Salt Lake City is fast approaching.  Will you be there?  I submitted three sessions in hopes of maybe getting one selected.  Last year, I only...

2011-08-22

6 reads

Blog Post

Bitwise Operations

Some time ago, I wrote an introductory post about bitwise operations in SQL Server.  I had fully intended on writing a follow-up to that.  Alas the opportunity has passed...

2011-08-19

4 reads

Blog Post

TSQL Sudoku

I am a big Sudoku fan.  Typically if I need a break, I will break out a Sudoku puzzle from any of a number of different sources (Websudoku, Android...

2011-08-17

9 reads

Blogs

SQL Server Journey till 2025 (brief)

By

Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...

Building Power BI Reports: Desktop vs Fabric

By

Why this comparison feels confusing If you’re a Power BI report author who’s just...

Identity Columns Can’t Be Updated: #SQLNewBlogger

By

I’m not sure I knew identity column values could not be updated. I ran...

Read the latest Blogs

Forums

Can someone please explain what happens?

By skeleton567

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

By tim8w

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

By John Miner

Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...

Visit the forum

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
8Kirin
I run this code:
SELECT JSON_OBJECTAGG(
    BeerID: BeerName )
FROM beer;
What are the results?

See possible answers