Live From @LearningTree London Backup and Restore - Day 3
This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the LEC in London. Following on from last weeks...
2016-07-14
461 reads
Gethyn Ellis
Live from @LearningTree London - Security Day - Day 2
This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the LEC in London. Following on from last weeks...
2016-07-13
381 reads
Are you a new SQL Server DBA? Live Blog @LearningTree
This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration course in LEC in London. Following on from...
2016-07-12
549 reads
Introducing SQL Server Reporting Services
In an earlier post I introduced the SQL Server umbrella and briefly discussed a number of products that make up...
2016-07-12 (first published: 2016-06-29)
3,136 reads
Influence Skills: Live from @LearningTree London Day 4
We've made it to the final day, day 4 of Learning Tree course 294 Influence Skills: Getting Results without Direct Authority.
Today...
2016-07-08
517 reads
Influence Skills: Live From London Day 3
The main news this morning: Wales' heroic efforts at the Euros came to end last night with a 2-0 defeat...
2016-07-07
381 reads
Do you have Influence? Live from London Day 2
Live from London Day 2
In the most important news of the day, Wales play Portugal in the semi-final of the...
2016-07-06
479 reads
Do You Want to Retain Your Best Employees?
I think you do.
According to a report by Oxford Economics it costs in excess of £30K, or if you prefer,...
2016-07-05
380 reads
Influence Skills Live from London Day 1
This week I am producing course 294 Influence Skills: Getting Results without Direct Authority. I wrote what being a producer...
2016-07-05
422 reads
Influence Skills
I wrote in my earlier post today that I was producing 294 Influence Skills: Getting results without direct authority. I...
2016-07-04
441 reads
Blogs
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...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
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?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
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