Office 2010 and Windows XP (64 bit)
I wanted to install Microsoft Office 2010 on an old Windows XP (64 bit) laptop. I tried running the setup...
2012-09-18
1,594 reads
Gethyn Ellis
An Introduction to SQL Server
I will be delivering Learning Tree course 137 SQL Server 2008 a Comprehensive Hands-On Introduction in London this December (18th...
2012-09-17
747 reads
Two Hundred Up
I was working on my blog this last week when I realised I was approaching my 200th blog post on...
2012-09-14
748 reads
Winner Winner Chicken Dinner!
I have spent a lot of time on the road this year with work but over the summer I was...
2012-09-13
647 reads
SQL Server Virtualization
This past summer I have been working on a new course for Learning Tree 2109 SQL Server Virtualization and Consolidation:...
2012-09-12
998 reads
Windows Server 2012
I haven’t paid too much attention to this version of windows yet, but I have just been reading up on...
2012-09-04
731 reads
Celebrity DBA–West Coast Time
At the end of July I was fortunate enough to visit the City of Angels, Los Angeles, or simply LA....
2012-08-21
938 reads
SQL Server 2012 and summertime in London
The week just passed I have been teaching Learning Tree course 2108 SQL Server 2012 Database Administration in London. It...
2012-07-23
1,016 reads
Not enough available space on destination..495GB available!
I bought a USB hard disk recently that I wanted to use to backup some VMware Workstation and some Hyper-V...
2012-07-13
1,004 reads
Guest Post: SQL Server Installation Error by David Postlethwaite
A strange SQL installation error with even a stranger solution
This week I was installing SQL Server 2008 R2 Developer onto...
2012-07-02
1,010 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers