Replacing VS Code with Vim
OK so maybe not replacing, this is more like emulating VS Code in Vim. Disclaimer – I like VS Code and I won’t be uninstalling it anytime soon and...
2022-01-14
111 reads
The DBA Who Came In From The Cold
Running Powershell code in Vim
I’ve been mucking about with Vim a bit recently and recently found myself (for reasons unknown tbh) writing powershell scripts in it. Once I’d written a script, I would...
2022-01-26 (first published: 2022-01-07)
364 reads
Building a pacemaker cluster to deploy a SQL Server availability group in Azure
There are new Ubuntu Pro 20.04 images available in the Azure marketplace with SQL Server 2019 pre-installed so I thought I’d run through how to create a three node...
2021-12-08 (first published: 2021-12-01)
276 reads
Operating system error 995 when adding a database to an availability group
I was adding databases to an availability group (SQL Server 2017 CU20 instance) the other day and one database failed to automatically seed to the secondary. When I looked...
2021-10-18 (first published: 2021-10-05)
377 reads
Using environment variable files for SQL Server in containers
There are a whole bunch of environment variables that can be used to configure SQL Server when run in a Docker container. You can check out the full list...
2021-10-08 (first published: 2021-09-24)
502 reads
Updating SQL Server container memory limits on the fly
When running multiple SQL Server containers on a Docker host we should always be setting CPU and Memory limits for each container (see the flags for memory and cpus...
2021-08-18 (first published: 2021-08-06)
325 reads
A storage failover issue with SQL Server on Kubernetes
I’ve been running a proof of concept for SQL Server on Kubernetes over the last year or so (ok, probably longer than that…hey, I’m a busy guy ?? )...
2021-07-26
107 reads
EightKB Summer 2021 Edition
The schedule for EightKB Summer 2021 Edition has been announced! Here’s the schedule: – N.B. – I particularly like that if you click on the session on the website,...
2021-07-02 (first published: 2021-06-15)
201 reads
Running a SQL Server container from scratch
I’ve been interested (obsessed?) with running SQL Server in containers for a while now, ever since I saw how quick and easy it was to spin one up. That...
2021-05-24 (first published: 2021-05-17)
644 reads
Converting a SQL Server Docker image to a WSL2 Distribution
Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives us the ability to run full blown linux distributions on our Windows 10 desktop. This...
2021-04-15 (first published: 2021-04-13)
314 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 Kramat Jati HUB/CS 08216366654
Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati, Kota Jakarta Timur, Daerah Khusus...
BCA KCU GUNSA 45 Telp/WA.0821°3111°179
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Gn. Sahari No.45, Gn. Sahari Utara, Kecamatan Sawah Besar, Kota Jakarta Pusat,...
BCA KCP Kas Pegambiran HUB/CS 08216366654
Jl. Pegambiran No.2B, RT.12/RW.7, Jati, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah Khusus Ibukota...
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