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 will be my first speaking event this year...
2016-12-19
6 reads
Anthony Nocentino Blog
SQL Server on Linux – How I think they did it!
OK, so everyone wants to know how Microsoft did it…how they got SQL Server running on Linux. In this article,...
2016-11-29 (first published: 2016-11-21)
2,919 reads
SQL Server on Linux – How I think they did it!
OK, so everyone wants to know how Microsoft did it…how they got SQL Server running on Linux. In this article, I’m going to try to figure out how.
Update: Since...
2016-11-21
5 reads
Building Open Source PowerShell
Open Source PowerShell is available on several operating systems, that really what’s special about the whole project! To get PowerShell...
2016-11-07
656 reads
Building Open Source PowerShell
Open Source PowerShell is available on several operating systems, that really what’s special about the whole project! To get PowerShell to function on these various systems we need to...
2016-11-07
2 reads
Configuring Passwordless PowerShell Remoting over SSH
Open Source PowerShell has been on fire, getting tons of community support and really making people think about what’s to...
2016-09-28
3,198 reads
Configuring Passwordless PowerShell Remoting over SSH
Open Source PowerShell has been on fire, getting tons of community support and really making people think about what’s to come with a single language to manage a heterogenous...
2016-09-28
10 reads
5 Must Haves Before You Start Consulting
Please join me at IT/Dev Connections on Oct. 12 at 8:00AM* where I’ll be hosting a Birds of a Feather session “Moving to Independent...
2016-09-19
516 reads
5 Must Haves Before You Start Consulting
Please join me at IT/Dev Connections on Oct. 12 at 8:00AM where I’ll be hosting a Birds of a Feather session “Moving to Independent Consulting” Bring your questions!*
Yes, an 8:00AM session in Las Vegas,...
2016-09-19
5 reads
Open Source PowerShell – Play by Play
What’s going on here?
So last week you may have seen this picture on Twitter…it went a little crazy…and you may...
2016-09-23 (first published: 2016-09-16)
1,670 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