The Easy Phone Restore
This is hardware week for me, with a new phone coming in the mail. This was a warranty replacement for...
2016-02-18
766 reads
Blog Posts
and other pointless query rewrites
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-17 (first published: 2016-02-09)
1,926 reads
Azure SQL Database security
Life we be so much easier if we could just trust everyone, but since we can’t we need solid security...
2016-02-17
968 reads
CONVERT and HEX
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-02-17
7,604 reads
Leadership and the Data Professional
Many traits make up data professionals and the many who find themselves in leadership roles. The traits being shared in...
2016-02-17 (first published: 2016-02-10)
1,799 reads
Pronouns in technical writing.
When doing technical writing, or for that matter most forms of writing , we need to be able to refer to...
2016-02-17
657 reads
TSQL Tuesday #75 – PowerBI
This month’s TSQL Tuesday post is from one of my favorite people in the community – Jorge Segarra a.k.a. SQL Chicken. It...
2016-02-17
447 reads
T-SQL Tuesday #75: Jump into Power BI
So this month I’ve decided to bring every participant in this blog series kicking and screaming into the BI world. Power BI, if you haven’t heard or seen it...
2016-02-17
14 reads
T-SQL Tuesday #75: Jump into Power BI
So this month I’ve decided to bring every participant in this blog series kicking and screaming into the BI world. Power BI, if you haven’t heard or seen it...
2016-02-17
25 reads
T-SQL Tuesday #75: Jump into Power BI
So this month I’ve decided to bring every participant in this blog series kicking and screaming into the BI world....
2016-02-17
1,987 reads
Blogs
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...
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...
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