Expose Multiple Docker Ports
I was working with containers recently with Jenkins. I didn’t want the server process running on my machine all the time, but I did need to allow some communication....
2019-08-21 (first published: 2019-08-07)
402 reads
The Voice of the DBA
Getting Downtime
It’s been a crazy year, as are many of my years. I tend to like that, because I prefer to be busy rather than idle. That’s good, but I...
2019-08-02
20 reads
Copy Files to a Docker Container
One of the things that’s handy when working with containers is being able to move files in and out of the container. Certainly you can do this from a...
2019-08-16 (first published: 2019-07-31)
414 reads
Off-Topic Origem HS-3 Headphones Review
I’m a big fan of music when I’m moving through life, and I use a lot of headphones. Between the gym, travel, and downtime between volleyball matches, I often...
2019-08-05 (first published: 2019-07-30)
266 reads
More Kubernetes Concepts
This post continues looking at my process of learning more about Kubernetes. I’ve been working through the 50 days of Kubernetes (K8s). Now that I had a break from...
2019-07-29
103 reads
The Data Request
Spotify implemented a way to get your data from your profile. This looks at the request and initial data download. The Request When you go there, you see a...
2019-07-26
33 reads
Redis University
As if I don’t have enough to do, I started a data structures class at Redis University. Someone recommended this to me as another way a company has structured...
2019-07-24
43 reads
Kubernetes Pipelines
This post continues looking at some of the Kubernetes concepts I’ve been learning with the 50 days of Kubernetes (K8s). Specifically in this post, I’m writing and thinking about...
2019-07-22
31 reads
Investigating Azure Databricks
At SQL Saturday #884 – Pensacola, I dropped into Rodney Ladrum’s session on Azure Databricks (ADB) and the Traditional DBA. I had heard a bit about Databricks, and read...
2019-07-17
61 reads
Learning more Kubernetes
I’ve been slowly working my way through the 50 days of Kubernetes (K8s). As you might have guessed if you remember my first post, this has been more than...
2019-08-08 (first published: 2019-07-15)
430 reads
Blogs
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Forums
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers