Read the error message
This post is brought to you — indirectly — from a boss I loved working for, on a project which almost killed me, at a company which I had...
2020-10-07
439 reads
Blog Posts
The SQL Server and Containers Guide
I’ve been blogging about running SQL Server in Docker containers for a while now and, to be honest, my blogs are scattered over a few years and some need...
2020-10-07 (first published: 2020-09-30)
644 reads
Undercover Academy – SQL Server Backup and Recovery – Module 1: Taking and Restoring a Backup
Welcome along to the first module in our Undercover Academy’s SQL Server Backup and Recovery course. In this module we’re going to look at how to take and restore...
2020-10-07 (first published: 2020-09-30)
339 reads
Azure Databricks Overview
I have spent many long weekends getting stuck into Azure Databricks, plenty of time to understand the core functionality from mounting storage, streaming data, knowing the delta lake and...
2020-10-06
167 reads
Daily Coping 6 Oct 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-10-06
14 reads
Failing SQL Agent Jobs – Part 4
Here we are, another Tuesday!! It is time for our Fourth and final installment in the Failing SQL Agent Jobs series. This week, we will cover how to store...
2020-10-06 (first published: 2020-09-29)
324 reads
Fixing the PoSh Hotkey in ADS
I installed the PowerShell (PoSh) extension in ADS recently. This is available in the extension pane, and once installed, you get the 4th icon on the right added to...
2020-10-06 (first published: 2020-09-28)
143 reads
New Presentation - The SQLFamily
A couple months ago I delivered a short (15 minute) presentation at work about the importance of having a good professional network and how I’d found mine. As I...
2020-10-06
3 reads
A Database Playlist for Your Mom
Recently someone asked me if I had a video explaining what a database was. I didn’t, but was curious. Apparently, this person wanted to learn a bit about databases...
2020-10-05
31 reads
Capture Execution Plans Only For Long Running Queries
I love questions. Most of all, I love questions I can answer. I spotted this question recently: How can I use Profiler to capture execution plans for queries over...
2020-10-05 (first published: 2020-09-28)
520 reads
Blogs
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Forums
BCA KCP Kas Cibinong City Center TLP/WA 08216977701
Jl. Cibinong City Center No.5 Ruko Blok A, Pakansari, Kec. Cibinong, Kabupaten Bogor, Jawa...
BCA KCP Cilegon II TLP/WA 08216977701
Ruko Cilegon City Square, Jl. Pondok Cilegon Indah No.1 Blok A No. 1-3 &...
BCA KCP Cilegon TLP/WA 08216977701
Jl. Raya Merak No.42, Ramanuju, Kec. Purwakarta, Kota Cilegon, DKI Jakarta 42411
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers