This is the last workday of 2022. Next week starts a new year, and as I've often done, I wanted to look back at the year. This time I decided to look back month by month, at some of the headlines and memorable data-related topics. I'm tackling things month-by-month. In January there was a set […]
2022-12-30
82 reads
Steve lists a few things to think about for an end of year career evaluation.
2022-12-28
140 reads
2022-12-26 (first published: 2017-02-24)
210 reads
2022-12-24
95 reads
Many software packages are moving to the cloud, but Steve doesn't like to see this without some ability to extract data.
2022-12-23 (first published: 2022-11-30)
136 reads
A large part of the success I've had in my career has come from growing my skills, both technical and soft, throughout the years. I've always been driven to learn more and improve my ability to accomplish the tasks I've been assigned. Or those that I've sought out and tackled. A little initiative has been […]
2022-12-23 (first published: 2022-12-17)
394 reads
Would you invest in someone else's career? An actual investment? Would you sell shares in yourself? Steve talks about this today.
2022-12-23 (first published: 2022-11-28)
116 reads
This weekend is Christmas, and likely many of you are not working hard today and will enjoy a long weekend until Tuesday. There are many other holidays at this time of year as well, and I hope you are enjoying the season with loved ones. I want to take a moment to wish everyone a […]
2022-12-23
69 reads
Does your database server need an upgrade? Steve notes that you might learn a bit about the best hardware to ensure a good ROI. Even if you wouldn't make a change for your own desktop machine.
2022-12-21
156 reads
Steve realizes that he doesn't use physical storage anymore for transferring data.
2022-12-19 (first published: 2022-12-16)
177 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