Speaking at PowerShell Virtual Group of PASS
This month I’ll be speaking to the PowerShell Virtual Chapter of PASS. The session is on Linux OS Fundamentals for the SQL Admin. At the core of the session...
2017-01-19
2 reads
Anthony Nocentino Blog
Weekly Newsletter
This week we started our Centino Systems weekly newsletter. Check out the first edition here!
The newsletter is going to include...
2017-01-15
652 reads
Weekly Newsletter
This week we started our Centino Systems weekly newsletter. Check out the first edition here!
The newsletter is going to include the latest in SQL Server and other things in...
2017-01-15
5 reads
New Pluralsight Course – LFCE: Advanced Network and System Administration
My new course “LFCE: Advanced Network and System Administration” in now available on Pluralsight here! If you want to learn about the course,...
2017-01-13
687 reads
New Pluralsight Course – LFCE: Advanced Network and System Administration
My new course “LFCE: Advanced Network and System Administration” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to...
2017-01-13
4 reads
Understanding Network Latency and Impact on Availability Group Replication
When designing Availability Group systems one of the first pieces of information I ask clients for is how much transaction...
2017-01-17 (first published: 2017-01-06)
3,096 reads
Understanding Network Latency and Impact on Availability Group Replication
When designing Availability Group systems one of the first pieces of information I ask clients for is how much transaction log their databases generate. *Roughly*, this is going to...
2017-01-06
4 reads
Microsoft Most Valuable Professional – Data Platform
Today, I’m proud to announce that I have been named a Microsoft MVP – Data Platform. This is an exceptional honor...
2017-01-02
650 reads
Microsoft Most Valuable Professional – Data Platform
Today, I’m proud to announce that I have been named a Microsoft MVP – Data Platform. This is an exceptional honor and I’m humbled to be included in this...
2017-01-02
9 reads
Speaking at SQLSaturday Nashville!
Speaking at SQLSaturday Nashville!
I’m proud to announce that I will be speaking at SQL Saturday Nashville on January 14th 2017! This...
2016-12-19
330 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?
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