In this blog post, I will show you how to build a hello world container-based web application in the go programming language. The reason I want to do this...
2023-03-01 (first published: 2023-02-19)
211 reads
Today’s coping tip is to support a local business with a positive online review or friendly message. When I discover a business I like or one that delivers value...
2023-02-17
27 reads
A while back I wrote a post on how to retrieve the SQL Server images in the Microsoft Container Registry (MCR). It’s pretty simple to check the MCR but...
2023-02-27 (first published: 2023-02-17)
421 reads
Today’s coping tip is to focus on being kind rather than being right. This is one of the things that grows my wisdom over time. I don’t need to...
2023-02-16
18 reads
On 14 February 2023, Microsoft released updates for all supported versions of SQL Server in the form of a General Distribution Release (GDR). A GDR is an out-of-band update...
2023-02-24 (first published: 2023-02-15)
1,297 reads
Today’s coping tip is to look for good in others, particularly when you feel frustrated. We all deal with conflicts with others throughout out lives. How we handle those...
2023-02-15
26 reads
It was a lot of fun to speak at the Louisville Data Technology Group in February. Sheila and I presented on Jupyter notebooks in Azure Data Studio. The session...
2023-02-27 (first published: 2023-02-14)
487 reads
Today’s coping tip is to thank someone and tell them how they made a difference for you. I’ve had a lot of success in my life, as well as...
2023-02-14
25 reads
I’m excited to announce I’ve been selected again as a speaker for Techorama 2023. Techorama is one of the biggest Microsoft-focused events in the European mainland, and it’s always...
2023-02-14
29 reads
Hello Dear Reader! We had a great last week on Tales from the Field. This weekend was also a really nice one. On Saturday a group of friends gathered...
2023-02-13
36 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