Database In Recovery Redux
One of the more gut-wrenching experiences of a DBA is to have a database get stuck in recovery. This typically happens when the server was rebooted unexpectedly and typically...
2019-04-08
7 reads
One of the more gut-wrenching experiences of a DBA is to have a database get stuck in recovery. This typically happens when the server was rebooted unexpectedly and typically...
2019-04-08
7 reads
The March release of Azure Data Studio now supports Jupyter Notebooks with SQL kernels. This is a very interesting feature...
2019-04-08 (first published: 2019-03-20)
681 reads
I’m starting the process of learning how to use Jupyter Notebooks. Notebooks are documents that contain live code, commentary, results, pictures and more. Jupyter Notebooks are used for presentations,...
2019-04-08
35 reads
I recently delivered my very first SQL Saturday pre-con for SQL Saturday Richmond on Friday, March 29, 2019. You can read about that adventure here. As part of the...
2019-04-08
27 reads
A powerful little expression in SQL Server is the CASE statement. The CASE statement has the ability to “transform” data...
2019-04-08 (first published: 2019-03-20)
4,019 reads
New week has started. 1/2 of the Coding Family Team has exams at school today. We were all busy last weeks…. But now it ends! And this must be...
2019-04-08
29 reads
I didn’t announce this before it happened because I didn’t want to “jinx” myself, but I am happy to say that it’s finally happened. I have delivered my very...
2019-04-06
46 reads
Watch this week’s episode on YouTubeWhen first learning SQL Server, I had the brilliant idea of defining every column on...
2019-04-05 (first published: 2019-03-19)
1,602 reads
Awhile back I added the Windows Subsystem for Linux to my machine, rebooted, and promptly forgot about it. After all, I’m doing more PoSh these days and bash isn’t...
2019-04-05
46 reads
ISACA is the professional organization for security, audit, and assurance professionals. There are local chapters, just like with PASS. Here in South Carolina we have the South Carolina Midlands...
2019-04-05
40 reads
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Anda dapat mereset PIN melalui fitur "Lupa PIN" di aplikasi, menghubungi Tanya Jago WhatsApp...
Telp/wa 085169998803 Jl. DR. Cipto Mangunkusumo No.4E, Pekiringan, Kec. Kesambi, Kota Cirebon, Jawa Barat...
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Boulevard Raya No.14 Blok RA-1, RW.15, Klp. Gading Tim., Kec. Klp. Gading,...
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