In two previous posts, I’ve showed how to configure Jenkins in a container as well as how to add the SQL Change Automation plugin. This post looks at an...
2019-09-12 (first published: 2019-08-26)
626 reads
VSCode was making me crazy as I was writing a script. I like a light theme, and every time I went to type, I saw this: The highlight was...
2019-09-05 (first published: 2019-08-23)
2,542 reads
In a previous post, I explained how to get Jenkins running in a container for your local CI work. In this one, I’ll expand on the process for database...
2019-08-30 (first published: 2019-08-21)
527 reads
The summary from my fourth T-SQL Tuesday hosting for #117. This time I was scrambling a bit, but since I’ve worked with a few customers in the last year...
2019-08-20
25 reads
This post continues looking at my process of learning more about Kubernetes. I’ve been working through the 50 days of Kubernetes (K8s). I completed the first 3 sections (Days...
2019-08-30 (first published: 2019-08-19)
392 reads
tl;dr For Windows when you need a different account. I had to work with a new GitHub account recently and needed to add a separate account. I worked through...
2019-08-16
7,496 reads
One of the things I needed to do recently was get Jenkins running as a demo for a customer. We have some pre-built VMs to do this, but I...
2019-08-26 (first published: 2019-08-14)
498 reads
Still learning more about Kubernetes. I’ve been working through the 50 days of Kubernetes (K8s). Let’s keep exploring The API is the security boundary Everything happens with the Kubernetes...
2019-08-23 (first published: 2019-08-12)
382 reads
Hiring at Basecamp is interesting. I caught this interview and think it’s a good look at a process most of us have gone through, but perhaps not thought about....
2019-08-09
33 reads
When Memory-Optimized Tables (MOT) were announced for SQL Server, there was a lot of excitement about the technology. After this was released on SQL Server 2014, feelings waned with...
2019-08-08
60 reads
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Comments posted to this topic are about the item Server-Level Table sizes
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
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