Error in SSMS: Attempted to read or write protected memory.
There are a lot of reasons to write a blog post. One of my favorites is when I’ve been asked...
2019-02-18
171 reads
Kenneth Fisher
What is your why?: T-SQL Tuesday #111
This month Andy Leonard (b/t) wants to know why we do what we do. Funnily enough, this is something I...
2019-02-12
686 reads
What’s a differential backup?
Of the different basic types of backups (full, differential and log) I find the differential the most interesting, and frequently...
2019-02-12 (first published: 2019-01-23)
2,156 reads
Using Cloud Academy
The other day I talked about using Microsoft Learn. Well, honestly, Cloud Academy is the learning tool I’ve been using...
2019-02-06
214 reads
Read-only tables
Sometimes you need a table that is read only. You don’t want anyone to be able to write to it...
2019-02-05 (first published: 2019-01-21)
2,658 reads
SQL Homework – February 2019 – Instance configurations
This homework series really has two purposes. It’s a primer for beginners. These are tasks I think most if not...
2019-02-04
198 reads
2019-01-30
241 reads
Controlling the firewall for an Azure SQL DB via T-SQL
The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I...
2019-01-29 (first published: 2019-01-16)
2,196 reads
SQL Bits 2019: The Great Data Heist
SQL Bits is almost here! It’s February 27th to March 2nd. SQL Bits is one of the most popular SQL...
2019-01-14
728 reads
#SQLCareer 4/4 January 2nd 2019
Last July (yes, it’s taken me 5+ months to finally finish this) Steve Jones (b/t) suggested that it might be...
2019-01-10
172 reads
Blogs
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...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
BCA KCP Permata Kota HUB/CS 08216977701
Komplek Permata Kota, Jl. Pangeran Tubagus Angke No.170 Blok L Kav 8 & 9,...
Kantor BCA KCU Magelang Telp/wa 085169998803
Telp/wa 085169998803 Jl. Ahmad Yani No.1, Magelang, Kec. Magelang Tengah, Kota Magelang, Jawa Tengah...
BCA KCP Abdulrahman Saleh Telp/wa 085169998765
Telp/wa 085169998765 Jl. Abdulrahman Saleh No.101 Kav C-D, Kalibanteng Kulon, Kec. Semarang Barat, Kota...
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