SQL Saturday #316, MVP’s, MCMs and a baby.
TweetG’Day,
Saturday June 14th 2014 seen the Christchurch, New Zealand SQL SERVER user group host its second SQL Saturday (#316).
We learnt...
2014-06-27
1,403 reads
Blog Posts
SQL Server Database Ownership: survey results & recommendations
SQL Server Datenbankbesitz: Umfrageergebnisse und Empfehlungen
(en)
You may remember the survey on database ownership which I launched several months ago.
In...
2014-06-27 (first published: 2014-06-23)
2,919 reads
What is 268435456?
What is 268435456? is the Friday question of the day. It’s a trivia question, but maybe an interesting one for...
2014-06-27
1,324 reads
What is an “operational” DBA?
On Facebook last night, I posted the following:
An operational DBA isn’t just a manager of a traditional RDBMS, transactional system....
2014-06-27
5,287 reads
Entity Framework Fluent API and Indexing
With the release of Entity Framework 6.1 the Fluent API can now be used to create indexes. It’s still pretty...
2014-06-26
144 reads
Finding the last successful CHECKDB
One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using...
2014-06-26
3,205 reads
Finding the last successful CHECKDB
One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using...
2014-06-26
425 reads
It's not Business, It's Personal
Hello Dear Reader. I find myself at this late hour unable to sleep. Yesterday the slate of speakers for the...
2014-06-26
847 reads
Microsoft Azure Portal Preview looks promising !
This is one of those posts which is pending for a very long time. I was pretty excited when Azure...
2014-06-26
944 reads
PASS Summit – What Does It Mean To Me?
PASS Summit – what does it mean to me? So listen, I’m not perfect. I will never claim to be and...
2014-06-26
390 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