The Value of Consistent Design
Yesterday I wrote about best practices, illustrating that what may be an assumed technical design standard doesn’t fit every scenario....
2017-12-13
398 reads
Blog Posts
Learning Through Blogging and Speaking
This post is a response to this month’s T-SQL Tuesday prompt created by Mala Mahadevan. T-SQL Tuesday was created by...
2017-12-12
164 reads
Learning Through Blogging and Speaking
This post is a response to this month's T-SQL Tuesday prompt created by Mala Mahadevan. T-SQL Tuesday was created by Adam Machanic and is a way for SQL users...
2017-12-12
4 reads
Power BI Custom Visuals Class (Module 80 – TreeViz)
In this module you will learn how to use the TreeViz Custom Visual. The TreeViz is a breakdown tree that...
2017-12-12 (first published: 2017-12-04)
1,744 reads
Reducing the Number of Reads in Your Queries
“A-Bridged” – reducing reads – get it? I’m sorry you’re reading this. Photo by Jamie Street on UnsplashIn last week’s post, we went over how...
2017-12-12
215 reads
Reducing the Number of Reads in Your Queries
In last week's post, we went over how one of best ways to improve query performance was to reduce the number of reads that your query has to do.
Less reads...
2017-12-12
8 reads
SQL Server Failed to Open Loopback Connection – What?
I could not read my error log on one of my local SQL Servers, when I executed the following code:
EXEC...
2017-12-12
816 reads
SQL Vulnerability Assessment
A very interesting feature was recently added to SQL Server Management Studio 17.4 (SSMS): The new SQL Vulnerability Assessment.
What is...
2017-12-12
146 reads
The Eleven Days of Festivus 2017
Last year, I celebrated the holiday season by blogging daily during the 11 days leading up to Festivus, writing about...
2017-12-12
316 reads
The One Piece of Career Advice I Wish I’d Gotten
Over the years, I’ve been approached numerous times with requests for advice from folks who are looking to get started...
2017-12-12 (first published: 2017-11-29)
2,520 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