As our organizations grow, they may add new data stores. That might not be the best decision for staff as the amount of knowledge they need grows. Steve notes that you might seek to limit the number of technologies you support.
2022-11-21
225 reads
Steve is challenging himself to do better, which means he might not hit his goals.
2022-11-18
113 reads
When I first started work as a software developer, I knew that getting an environment set up where I could compile a project might take a few hours or a few days. The complexities of how people built software projects, the dependencies, and more were handled in a very immature manner. These days I can […]
2022-11-16
232 reads
Building software means not only considering the data people expect, but also edge cases. Steve asks if you know what those edge cases are?
2022-11-14
307 reads
The use of IoT and lots of data is allowing governments to better serve their citizens.
2022-11-12
128 reads
When I was younger, it seemed that everyone I worked with in technology knew how to build a computer. Most knew how to work with a BIOS, were comfortable with command lines, and could assemble complex compiler directives into a Make file. Over time, it seems many people, especially Windows and MacOS users, became focused […]
2022-11-11
224 reads
Building psychological safety inside of a company is hard, but it is important to build trust and develop a team.
2022-11-09
97 reads
A big part of adopting DevOps and becoming better at building software is establishing culture.
2022-11-07
212 reads
For years, those of us in technology have often worked outside of the core working hours for the rest of our organization. Whether this is being on-call, staying late, or coming in when asked. It's not uncommon for many developers and Ops staff to work 60, 70, or more hours to get things built/deployed/supported for […]
2022-11-04
187 reads
Steve looks back at Summits past and his excitement for this year.
2022-11-03 (first published: 2022-11-02)
99 reads
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
Comments posted to this topic are about the item AI Experience Gap that we...
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