Gone Dark
This afternoon was quite interesting around the office. A strong thunderstorm moved through the area, a common occurrence in Texas...
2009-03-25
1,400 reads
Tim Mitchell
- Interests: SQL Server, Data Warehousing, ETL, Data Architecture, Python, Dbt
- Website: https://www.TimMitchell.net
- Bluesky: tmitch.net
Building Reports, 2.0 Style
I’m getting my first taste of the new SQL Report Builder 2.0, and so far I’m enjoying the upgrade. Report Builder 2.0 is a standalone product, shipped as separate download from the SQL Server and Visual Studio suites. It allows users to develop and run reports locally, in addition to permitting the publication of these reports to SQL Server Reporting Services.
2009-03-10
5,694 reads
Building Reports, 2.0 Style
I’m getting my first taste of the new SQL Report Builder 2.0, and so far I’m enjoying the upgrade. Report...
2009-03-08
2,388 reads
Finding a Work-Life Balance
Like most everyone who works hard in our industry, I’ve run into more than a few conflicts trying to balance work and life. Personally, the further I progress in my career, the blurrier the lines become between work time, family/me time, and just plain lazy downtime. It’s quite easy to say that you’re going to spend X hours at work, and the rest of the time is mine, but the reality is ...
2009-03-06
1,308 reads
[Off Topic] Get Fit in February – Wrap Up
During the month of February, I participated in the Get Fit in February challenge last month. Along with a few...
2009-03-04
628 reads
Finding a Work-Life Balance
Like most everyone who works hard in our industry, I’ve run into more than a few conflicts trying to balance...
2009-02-25
1,592 reads
Your Local User Group
When I talk to other SQL Server professionals, I’m often surprised at how many do not have any involvement in...
2009-02-17
1,228 reads
Things I Wish I Had Known
I was tagged by Grant Fritchey (aka Scary DBA) in the latest get-to-know-you question. This one asks, “What do you wish you had known when you started?” I could go on for hours about the things I wish I hadn’t had to learn the hard way, but..
2009-02-16
2,038 reads
Things I Wish I Had Known
I was tagged by Grant Fritchey (aka Scary DBA) in the latest get-to-know-you question. This one asks, “What do you...
2009-02-11
2,242 reads
[Off Topic] Get Fit in February Developer Challenge
I’m on Day Two of the Get Fit in February Developer Challenge. This month-long competition boasts around 200 participants who...
2009-02-02
650 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
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