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
Blog Posts
Generating a Jupyter Notebook for Glenn Berry’s Diagnostic Queries with PowerShell
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
Learning Jupyter Notebooks
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
My Very First Azure SQL Database
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
The Curiously Large CASE Statement
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
Weekly reading 10#
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
Delivering My First Pre-Con
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
4 Reasons To Avoid VARCHAR(8000)
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
Adding bash to Windows 10
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 Individual Chapter CISA Trainer Accreditation
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
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
Cara buka Blokir Bank Jago salah password Terkunci 1jam
Anda dapat mereset PIN melalui fitur "Lupa PIN" di aplikasi, menghubungi Tanya Jago WhatsApp...
Kantor BCA KCP Cipto Mangunkusumo Telp/wa 085169998803
Telp/wa 085169998803 Jl. DR. Cipto Mangunkusumo No.4E, Pekiringan, Kec. Kesambi, Kota Cirebon, Jawa Barat...
BCA KCP Kelapa Gading Hibrida Telp/WA.0821°3111°179
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,...
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