SQL Homework – September 2023 – Time for temporal tables.
Recently I needed to use temporal tables. And not just for the job history table in a managed instance. In ... Continue reading
2023-09-27 (first published: 2023-09-05)
406 reads
Blog Posts
Common Mistakes in SQL Server – Part 2
The Identity property creates an incremental value for the specified column automatically, which is why it is widely used by developers when they designed the table and a primary...
2023-09-25
72 reads
Common Mistakes in SQL Server – Part 2
The Identity property creates an incremental value for the specified column automatically, which is why it is widely used by developers when they designed the table and a primary...
2023-09-25
14 reads
Enable PowerShell Remoting
Enable PowerShell Remoting
I use PowerShell quite a lot to manage servers, especially SQL Servers. So I need to be able to run PowerShell...
2023-09-25 (first published: 2023-09-24)
229 reads
Future Data Driven 2023 is This Week
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register today and save a note in your calendar. The event has a great schedule (scroll...
2023-09-25
15 reads
Opening the SQL Prompt Command Palette
A few years ago SQL Prompt added a command palette to let you search the commands available. This is similar to the same concept in Visual Studio Code, ADS,...
2023-09-25
74 reads
Quickly Creating a tsqlt Test for a Query
One of the things that I feel is important to building better software is testing your code. It should be easy and simple to test code and determine if...
2023-09-25 (first published: 2023-08-28)
380 reads
SQL Saturday Denver 2023–VCS Primer for the Database slides
My slides are here: VCS Primer Denver 2023 This was an overview of what version control is, and the basics of Git. Not too many questions, but if you...
2023-09-25
16 reads
Yet another kind of orphan users in SQL Server
Yet another kind of orphan users in SQL Server
Or YAOU for short. (This silly acronym, I just made it up so don’t try...
2023-09-25 (first published: 2023-09-02)
1,142 reads
A Study in SQL Server Ad hoc Query Plans
A Study in SQL Server Ad hoc Query Plans
We, (or maybe it’s just my dismissive attitude towards it), often think of ad hoc...
2023-09-23 (first published: 2023-09-22)
389 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