SQL Server Management Studio: Video Tutorial
SQL Server Management Studio is the all in one tool for developers and DBAs alike to work with SQL Server....
2017-07-25
455 reads
Gethyn Ellis
Installing SQL Server: Video Tutorial
In this video I talk you through installing SQL Server 2017 RC1 on Windows Server 2016 virtual machine. It’s a...
2017-07-24
453 reads
Building Always On Availability Groups - Part 1
Introduction
By David Postlethwaite
Ensuring that your databases can survive a major outage such as a server failure and can continue to...
2017-07-14 (first published: 2017-07-03)
2,188 reads
Dynamic Data Masking
By David Postlethwaite
Introduction
Dynamic data masking is a really useful new tool in SQL Server 2016. Keeping data safe is one...
2017-05-09
1,085 reads
Always Encrypted
By David Postlethwaite
Always Encrypted is new features in SQL Server 2016 and it is also available in Azure SQL Database....
2017-05-01 (first published: 2017-04-24)
15,960 reads
2 Great Courses For Databases Professionals - Deal Of the Week
I received the email from Learning Tree on Wednesday with their weekly offer of courses running in the London Education...
2017-04-21
613 reads
What is SQL Server?
I’ve been playing around with YouTube, making some tutorial videos on SQL Server and it’s been a fun process so...
2017-04-20
528 reads
Gethyn Ellis:My SQL Server You Tube Channel
Its been an interesting weekend at gethynellis.com I have been attempting to put together a SQL Server YouTubechannel. I’m planning...
2017-04-10
314 reads
UK Contracting: Brexit, Dividend Tax and IR35 Having a Huge Impact
At the end of March I wrote a couple of posts discussing the state of IT industry. It looked at...
2017-04-07
291 reads
Dividend Tax Changes and Brexit – Damaging to UK IT company creation
In my previous post titled UK Budget 2017 –The Death Knell for Small Business? We scratched the surface in discussing...
2017-04-03 (first published: 2017-03-22)
1,816 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