Re-blog – March 9 – March 15
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-16
701 reads
Blog Posts
SQL Roundup – 03/16-2012
Howdy! I was flying last week, and for the first time i sat facing a flight attendant. You don’t actually...
2012-03-16
844 reads
SQL Server 2012: New Certification Info
As a follow-up to my posts SQL Server “Denali”: New Certifications and SQL Server 2012: New Certifications, there are now final details coming...
2012-03-16
1,932 reads
SQL Skills IE3 #sqlskills
I attended my first SQL Skills event in December 2011. Due to a big project at work I was able...
2012-03-16
708 reads
Why I don’t like maintenance plans
If you create a maintenance plan (SQL 9.0.3042) to backup databases and select All databases as below;
Then at some point...
2012-03-16
894 reads
#Meme15: On Facebook
This will be my first Meme15 (here’s Jason Strate’s original Meme15 post), and today we’re talking Facebook. The question is:
How...
2012-03-15
813 reads
Agent Jobs Using SSIS
This is a short script to help the DBA with documentation purposes. This would come in handy especially in those...
2012-03-15
850 reads
Agent Jobs Using SSIS
This is a short script to help the DBA with documentation purposes. This would come in handy especially in those cases where you are consulting or you have taken...
2012-03-15
2 reads
Cached blocking history with sys.dm_db_index_operational_stats
Transactions generate IO, latching and locking on tables and indexes , while attempting to access data. The sys.dm_db_index_operational_stats DMV returns aggregated data...
2012-03-15
1,349 reads
ColoradoSQL for March 2012
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-03-15
644 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