SQL Server 2012 FileTable – Part 1
In a series of blog posts we will have a look at the new SQL Server 2012 table type called...
2012-01-06 (first published: 2012-01-03)
4,925 reads
Danish Developer Conference – DDC 2012
I am proud to announce that we at Geniiius will be speaking at DDC 2012. DDC 2012 is a one...
2011-12-29
1,681 reads
SQL Server 2012 – new conversion functions
With SQL Server 2012 comes a new set of conversion functions, that will certainly help doing type casts and conversions...
2011-12-20
1,190 reads
SQL server 2012 Startup parameters
I’m sure that I’m not the only one with nightmares about the startup parameters in older versions of SQL Server...
2011-12-06
1,172 reads
CONCAT() – SQL Server 2012
With SQL Server 2012 a new string function is born – CONCAT(). The output is a string, as the result of...
2011-11-29
1,070 reads
SQL Server trace flags
Normally I’m not a big fan of using traceflags, my advice is only to use these when it is absolutely...
2011-11-22
2,350 reads
SQL Server ® 2012 Release Candidate (RC0)
Finally it is here, the SQL Server 2012 RC0 is ready for download, click this link and you’ll be downloading...
2011-11-18
760 reads
SQL Server 2012 licensing
Microsoft has recently released the licensing overview for SQL Server 2012. A few things has changes from SQL Server 2008,...
2011-11-14
950 reads
How much space are you wasting?
A few weeks back a client of mine asked me to write a script that could tell him the space...
2011-11-08
855 reads
Backup/restore/checkdb/shrinkfile progress
Have you ever wonderet how long you need to wait for a backup or restore command to complete? If you...
2011-11-01
1,112 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
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...
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