EightKB August 2022
EightkB is back! Today we announced the schedule for the next EightKB, which is happening at 1pm UTC on the 3rd of August. We have five more amazing, mind-melting...
2022-07-13
15 reads
The DBA Who Came In From The Cold
Shutting down nodes in Azure Kubernetes Service
A while back I wrote a post on Adjusting Pod Eviction Timings in Kubernetes. To test the changes made in that post I had to shut down nodes in...
2022-07-04 (first published: 2022-06-24)
168 reads
Installing the mssql-cli on Ubuntu 22.04
I really like the mssql-cli tool. I use it pretty much everyday however it seems like it’s not being maintained anymore and as such, there are issues when trying...
2022-06-08 (first published: 2022-05-13)
380 reads
Space Invaders on Kubernetes
A while ago I blogged about an awesome Chaos Engineering tools built by Eugenio Marzo (t) call KubeInvaders. Since then Eugenio has updated the repo to make it easier...
2022-03-25 (first published: 2022-03-10)
237 reads
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
90 reads
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)
276 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)
170 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)
304 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)
324 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)
274 reads
Blogs
Daily Coping 22 Mar 2023
By Steve Jones
Today’s coping tip is to appreciate your hands and all the things they do...
FIRST Robotics Competition 2023 - World Championships!
By alevyinroc
On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...
Errata for my book: Pro Encryption in SQL Server 2022
My biggest fear when my book went into production was that any factual errors...
Forums
Query based on sorting based on month
SELECT BusinessEntityID,FirstName,MiddleName,LastName, YEAR(OrderDate) AS OrderYear, DATENAME(MM,OrderDate) AS OrderMonth FROM Person.Person Pp INNER...
SSRS 2017 - SSRS 2019 migration
I am after some advice, I have completed a SSRS migration 2017 - 2019. ...
Fixing a mismatched collation on MSDB
Hi, I've been tasked with finding out why we've been unable to patch the...
Ask SSC