Introduction to Advanced Analytics
The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.
2024-11-06 (first published: 2024-10-27)
416 reads
Blog Posts
PASS Summit 2024 – A Very Different World
The last data centric conference I attended was the PASS Summit in 2019. A few months later, much of the world went on lockdown due to COVID. Since then,...
2024-11-06
26 reads
Using Copilot to help me update SQL Saturday
An interesting AI experiment here with Copilot from GitHub in handling some code I don’t work with that often. Read on and watch. This is part of a series...
2024-11-06 (first published: 2024-10-16)
357 reads
T-SQL Tuesday #180: Good enough is perfect
How can you achieve good enough without compromising the process/product? In the world of database technology, striving for perfection is a double-edged sword. While high standards are important for...
2024-11-05
30 reads
Off to the PASS Data Community Summit 2024
As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and flying to Seattle for the PASS Data Community Summit 2024. I’m very lucky that I...
2024-11-04
12 reads
SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow
Want to build a data analytics foundation that transforms raw data into valuable business insights? Look no further than SQL! It's the perfect tool for creating powerful data pipelines...
2024-11-04 (first published: 2024-10-21)
679 reads
Why is fn_xe_file_target_read_file the worst SQL function?
I haven’t had a rant post in a while. There is a saying: “Anything before the word ‘but’ is ignored”. I love Extended Events, but …
reading the extended event...
2024-11-04 (first published: 2024-10-18)
422 reads
2024 PASS Data Community Summit Prep
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling Monday to the event to see a few thousand fellow data professionals, developers, managers, and...
2024-11-01
26 reads
A New Word: Bye-over
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional farewell but then unexpectedly have a little extra time together, wordlessly agreeing to pretend that...
2024-11-01
104 reads
Migrate to Azure PostgreSQL Flexible Server
I need to migrate from a single server to a flex server. Instead of doing a dump and restore, I’m going to try out the migration service that Azure provides. Single...
2024-11-01 (first published: 2024-10-17)
220 reads
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers