SQL Saturday #63 – Dallas: Resources
I had the opportunity to present my “What Can You Do With PowerShell?” session in Dallas at SQL Saturday #63....
2011-04-02
643 reads
Blog Posts
SQLSaturday #63, Great Event!
So,
I actually had a early morning sessions and gave my Solid State Storage talk and had a great time. The audience was...
2011-04-02
638 reads
SSMS Tips & Tricks – Scripting Multiple Objects
This is one that I figured most everyone would know, but repeatedly over the past couple weeks in my office,...
2011-04-02
1,349 reads
T-SQL LOWER(): Change an all uppercase string to lower case
The T-SQL LOWER() command allows you to change an uppercase string to a lowercase string.
For example, it will allow you to change the word...
2011-04-02
887 reads
A 22 Hour Layover
I joked about having a 22 hour layover in Denver yesterday and a few people were wondering what airline screwed...
2011-04-01
847 reads
Announcing The Association For SQL Server
Recently there have been a number of PASS members who have become unhappy with the direction of the organization and...
2011-04-01
393 reads
April Question: Which high availability option(s) do you employ for SQL Server instances, and why did you choose them?
As DBAs, we are responsible for the protection of our organization’s data, and we have many different options to protect...
2011-04-01
596 reads
Changing Directions
I See Dead Tech….
Knowing when a technology is dying is always a good skill to have. Like most of my...
2011-04-01
916 reads
Indexing Just Got Easy
As a database professional one of the things that we should be familiar with is the use of indexes. In...
2011-04-01
657 reads
Indexing Just Got Easy
As a database professional one of the things that we should be familiar with is the use of indexes. In SQL Server an index helps to improve query performance...
2011-04-01
6 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