I’m sorry, you’ve committed a GIANT INTERNET FAIL (#SQL2012)
Updated with links to no-login goodness. Updated again with IE rage.
This week, Microsoft announced the SQL Server 2012 release to...
2012-03-07
931 reads
Blog Posts
Intel Xeon E5-2600 Series Processors Released
Yesterday, Intel finally released the much anticipated Xeon E5-2600 family of processors, also known as Sandy Bridge-EP. This is a...
2012-03-07
1,229 reads
Physical or Virtual
Today I get to share something that has been on my someday list for quite some time. I have planned...
2012-03-07
2,135 reads
Physical or Virtual
Today I get to share something that has been on my someday list for quite some time. I have planned on getting a solution that involves TSQL to help...
2012-03-07
5 reads
PowerPivot 2012 RTM Release
Somewhat overshadowed, for obvious reasons, by the big RTM release of SQL Server 2012 was the RTM release of PowerPivot...
2012-03-07
1,186 reads
SQL Server – sys.master_files and list all database files
Use the system view “sys.master_files” for a single view of databases and database files.
Instead of using sys.sysfiles joing to sys.sysdatabases...
2012-03-07
1,452 reads
SQL Server 2012 (“Denali”): Reporting Services in SharePoint integrated mode
In SQL Server 2008, if you wanted to run Reporting Services in SharePoint integrated mode, these where the steps you took...
2012-03-07
4,500 reads
SQL Server 2012 Data Mining add-in for Excel 2010 Released
Another release that went without much trumpeting was the SQL Server 2012
Data Mining add-in for Excel 2010. This has...
2012-03-07
1,672 reads
SQL Server Database Mirroring (Not Dead Yet)
SQL Server Database Mirroring is a high availability and disaster recovery feature that was added to the product with SQL...
2012-03-07
3,084 reads
Windows Server 8 Hyper-V Lab boot from VHD
Windows Server 8 Beta is out, check this video to use existing windows laptop/desktop to build VHD bootable Windows server...
2012-03-07
942 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