S3OLV April 2011
Are you ready to learn again? The Las Vegas SQL Users Group is ready to have our April meeting. The...
2011-04-05
538 reads
Blog Posts
S3OLV April 2011
Are you ready to learn again? The Las Vegas SQL Users Group is ready to have our April meeting. The meeting is to be held April 14, 2011 at...
2011-04-05
4 reads
Should a DBA be involved in the physical set up of a Database server? Part1
There is always some disconnect between the network admins and the DBA’s regarding hardware set up of a SQL Server....
2011-04-05
1,636 reads
SQL Rally Schedule
Thursday, May 12
BI
DBA
DEV
PD / WILD
CARD
8:30 - 9:30
SQL Server Parallel Data Warehouse - Under the Hood
Brian Mitchell
The Dirty Dozen: PowerShell Scripts for the...
2011-04-05
1,123 reads
SQL Server Role Membership
How well do you know the security in your SQL instances? Do you know who has sysadmin level permissions? SQL...
2011-04-05
802 reads
SQL Server Role Membership
How well do you know the security in your SQL instances? Do you know who has sysadmin level permissions? SQL Server provides a few methods for you to find...
2011-04-05
28 reads
SQL Validation Functions - 4 Cool UDF's to have handy
Everyone knows that in SQL 2000, yes 2000, Microsoft jumped aboard the bandwagon of other platforms, and gave the developers...
2011-04-05
40,739 reads
This appears to be a system procedure..but it isn’t!
G’day,
Recently, I was browsing through my database server when suddenly under the “System Stored Procedures” folder of the master database...
2011-04-05
2,040 reads
To TOP or not to TOP an EXISTS
Earlier this year I had a look at a query pattern that I often see on forums and in production...
2011-04-05
5,751 reads
T-SQL UPPER(): Change an all lowercase string to uppercase
The T-SQL UPPER() command allows you to change a lowercase string to an uppercase string.
For example, it will allow you to change the word...
2011-04-05
1,708 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