Thoughts on Mentoring - Part 3
I think sometimes a lot of what we call mentoring might be appropriately called coaching. Before you go trying to...
2008-04-15
479 reads
SQLAndy
Thoughts on Mentoring - Part 2
It's always good to find a book or two on a subject when you want to be good at something....
2008-04-14
511 reads
Thoughts on Mentoring - Part 1
Mentoring is something I think a lot of us wish for and that few of us find. Few businesses encourage...
2008-04-13
518 reads
Forty Percent Discount on SQL 2008 Exams
Saw this in the MCP Flash today, if you register to be notified when the exams are live you get...
2008-04-11
318 reads
How to Improve MS Connect
If you haven't visited yet, MS Connect replaces the old sqlwish email alias and provides - in theory! - a better way...
2008-04-09
441 reads
Partitioning Gotcha
Well, it got me at least! Not long ago someone asked me about partitioned views and as I'm apt to...
2008-04-08
412 reads
Thoughts on Database Mail
I suspect few would argue that database mail in SQL 2005 is a huge improvement over the mail system in...
2008-04-07
305 reads
Link: April Fools Joke on Jonathan Schwarz of Sun
Absolutely worth watching.
http://blogs.sun.com/jonathan/entry/the_video
2008-04-07
517 reads
After Event Party Location Announced for SQLSaturday#3 in Jacksonville
From the SQLSaturday event site:
AFTER EVENT PARTY ANNOUNCED! Our after event party will be held at 7 Bridges Grille beginning...
2008-04-07
564 reads
A Note on sp_updatestats
In SQL 2000 when you run sp_updatestats it's the equivalent of running UPDATE STATISTICS on each table, forcing the update...
2008-04-06
417 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