Pluralsight Authoring – Upcoming Course
I am super excited to announce that I have recently been accepted as an author for Pluralsight.
My audition was on...
2015-08-29
1,264 reads
Anthony Nocentino Blog
Pluralsight Authoring – Upcoming Course
I am super excited to announce that I have recently been accepted as an author for Pluralsight.
My audition was on Monitoring AlwaysOn Availability Groups and was accepted on the...
2015-08-29
4 reads
Monitoring Availability Groups with Redgate SQL Monitor
In previous posts here and here we discussed AlwaysOn Availability Group replication latency and monitoring concepts, specifically the importance of monitoring the...
2015-06-17
5,062 reads
Monitoring Availability Groups with Redgate SQL Monitor
In previous posts here and here we discussed AlwaysOn Availability Group replication latency and monitoring concepts, specifically the importance of monitoring the send_queue and redo_queue. In this post I’m going to...
2015-06-17
14 reads
When was your last database backup?
Its pretty often that you have to sit down at a SQL Server and need sort out what the backup...
2015-06-10
1,455 reads
When was your last database backup?
Its pretty often that you have to sit down at a SQL Server and need sort out what the backup situation is. One of the first things that I...
2015-06-10
5 reads
Immersed in SQL Server at SQLskills
Over the last two years I have had the pleasure of attending all three SQLskills Immersion Event classes. This training...
2015-05-16
628 reads
Immersed in SQL Server at SQLskills
Over the last two years I have had the pleasure of attending all three SQLskills Immersion Event classes. This training is second to none in its quality and intensity....
2015-05-16
6 reads
Moving SQL Server data between filegroups – Part 2 – The implementation
In this post we are going to show the implementation of a PowerShell script using SMO to move data between filegroups...
2015-05-06 (first published: 2015-04-28)
7,177 reads
Moving SQL Server data between filegroups – Part 2 – The implementation
In this post we are going to show the implementation of a PowerShell script using SMO to move data between filegroups on SQL Server. This article is the second of our...
2015-04-28
6 reads
Blogs
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...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
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?
Removing TDE
Comments posted to this topic are about the item Removing TDE
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