In a previous blog post we went through how to build a Docker container image from a remote (Github) repository. Here we’re going to expand on that by actually...
2024-05-10 (first published: 2024-04-25)
377 reads
EightKB is back! The biggest online SQL Server internals conference is back in 2024…it’s all happening on August the 8th! We’ve open our call for speakers, you can submit...
2024-03-01 (first published: 2024-02-21)
241 reads
In the latest version of Docker Desktop a new command has been included call docker debug. Now this is only available with a Pro Docker licence but it’s an...
2024-02-12 (first published: 2024-01-30)
140 reads
To build a custom Docker image we create a docker file with instructions in it. For example, a really simple custom SQL Server 2019 Docker image can be built...
2024-01-19 (first published: 2024-01-05)
269 reads
When I first started working with SQL on Linux one of the first things I did was to remove the default the [BUILTINAdministrators] login. This is pretty much standard...
2023-12-27 (first published: 2023-12-15)
246 reads
This Thursday, November 30th, is the next VMUG Ireland event…our end of year social meetup! We’re going to be down in BrewDog Dublin: – THREE LOCKS SQUARE, 4, DUBLIN...
2023-11-27
13 reads
In my last couple of blog posts (here and here) I talked about how to get SQL Server running in Docker Swarm. But there is one big (and show-stopping)...
2023-09-15 (first published: 2023-08-23)
215 reads
In a previous post I went through how to run SQL Server in Docker Swarm and in this post I want to continue delving into the Docker Swarm platform...
2023-08-23 (first published: 2023-08-02)
200 reads
I haven’t touched Docker Swarm for a looooong time but I was asked about running SQL Server in Swarm at a conference a while back…so here’s how it can...
2023-08-14 (first published: 2023-07-26)
356 reads
One of the options that I completely missed with the new go-sqlcmd CLI tool is the ability to spin up a container running SQL Server. Let’s have a look...
2023-06-02 (first published: 2023-05-19)
497 reads
It’s been forgotten about and neglected for few years but I’ve decided to dust...
I am honored to announce that I have been renewed as a Microsoft MVP...
By Rohit Garg
🔍 Demystifying KTLO: A Deep Dive into Keep The Lights On Work in IT...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Navigating Multi Platform Realities in...
I have tried a number of times to export and then import my SSMS...
For the Question of the day, I am going to go deep, but try to be more clear, as I feel like I didn't give enough info last time, leading folks to guess the wrong answer... :) For today's question: You’re troubleshooting a performance issue on a critical stored procedure. You notice that a previously efficient query now performs a full table scan instead of an index seek. Upon investigating, you find that an NVARCHAR parameter is being compared to a VARCHAR column in the WHERE clause. What is the most likely cause of the query plan regression?
See possible answers