Quick Tests–Function Returns
I ran across a neat piece of code recently from Gail Shaw. She answered a question on returning the base...
2016-02-15
1,451 reads
Blog Posts
Shrinking Database Log Files
When should you shrink your log files and what does it mean to performance?
2016-02-15
85 reads
Shrinking Database Log Files
Files in SQL Server need to grow as the database grows, and in very specific circumstances need to be shrunk...
2016-02-15
1,282 reads
Speaking at the first Belgian SQLSaturday!
I’m delighted to announce that I’ll be giving a session at the very first SQLSaturday (aka SQLSaturday 505) in Belgium....
2016-02-15
497 reads
SQL Server 2016 Row-level Security and SSRS a perfect match
In this blog I will explain and demonstrate how to leverage a new feature in SQL Server 2016, Row Level...
2016-02-15 (first published: 2016-02-08)
9,049 reads
varchar(1) VS char(1)
The other day I made a somewhat flip coment on twitter. (I know, everyone is shocked right?)
varchar(1) Really? It’s...
2016-02-15
1,613 reads
SQL Saturday 496 Exeter – PreCon Agenda
Hi
Unfortunately due to matters outside of my control, SQL Saturday 502 in Edinburgh has been cancelled, I would like...
2016-02-14
493 reads
Goodness-of-Fit Testing with SQL Server Part 5: The Chi-Squared Test
By Steve Bolton
…………As I’ve cautioned before, I’m writing this series of amateur self-tutorials in order to learn how to use...
2016-02-13
1,281 reads
PASS Summit 2016 Program Committee
As I usually do, I applied to be a member of the Program Committee for the 2016 PASS Summit. I have been on the program Committee the last 4...
2016-02-13
10 reads
PASS Summit 2016 Program Committee
As I usually do, I applied to be a member of the Program Committee for the 2016 PASS Summit. I...
2016-02-13
359 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