2021-04-09
149 reads
Work environment
Working in a Distributed Fashion
With many of us working in a distributed fashion, Steve wonders if things have changed for the process flow you follow.
2021-03-22
146 reads
Every IT Organization is a Snowflake
Some people think every IT department is unique. While that might be literally true, Steve doesn't think that is actually the case.
2021-03-17
226 reads
Viva
Microsoft is working on the future of work, and adapting to remote work. Steve isn't sure this will work, but they have at least one interesting technology idea he likes.
2021-03-01
141 reads
The Pandemic Work Load
With the new year proceeding along, we are still in a pandemic. Is that affecting your work load?
2021-02-12
136 reads
Are You Empowered?
Many people don't feel like they can make changes in their work environment. Today Steve notes this is common in many organizations.
2021-01-25
118 reads
Dread or Desire
Today Steve wonders about the move back to offices and if you are looking forward to it or trying to avoid it.
2021-01-04
147 reads
Keeping Your Staff
Retaining staff is always a challenge for many organizations. Today Steve talks about the difficulties of doing so and in choosing who to retain.
2020-09-29
159 reads
Remote Work Benefits
Today Steve wonders if companies ought to support remote work better with other benefits.
2020-09-11
208 reads
2020-08-17
132 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