Anyone Can Click Through Once
Using some sort of scripting or automation is important for your career.
2021-02-10
175 reads
Editorials
2021-02-09
183 reads
AI Can Improve Healthcare
One area where AI has found some traction is in the healthcare industry, where is seems to be helping improve care.
2021-02-08
334 reads
Let it go
I’ve been digging through the 18 years’ worth of articles, editorials, blogs, contests, interviews, promotions, and announcements over at Simple Talk. There are over 5000 posts, and many are quite outdated, especially those announcing beta versions of software or other time-sensitive content. Some articles haven’t seen the light of day for 10 years, yet some […]
2021-02-06
124 reads
Tough Interview Questions
Steve ran across a list of interview questions and wonders if it's a good test for an experienced database developer.
2021-02-05
406 reads
Do it. Try it. Fix it.
Building better software requires some experimentation, but also some learning. Building better software as an organization requires even more.
2021-02-04
315 reads
Artist or Scientist?
In your work, are you an artist or a scientist? Steve Jones knows we need to be both, but when is each appropriate?
2021-02-03 (first published: 2014-08-19)
422 reads
Bronze Age Development
The slow pace of Visual Studio development had a number of problems over the years, but Microsoft has dramatically changed the way they build their software for the better.
2021-02-02 (first published: 2014-08-21)
343 reads
The Database Server Upgrade for Let's Encrypt
Let's Encrypt upgrades their database servers and publishes the details.
2021-02-01
137 reads
Information Security, ITs Abused Step Child
Many of us grew up with one version of Cinderella or another. The step child that's horribly mistreated by the new parent is a scary story. In the Disney version, everything works out fine. However, if you read some of the original Grimm versions of the story (and there is more than one version), not […]
2021-01-30
71 reads
Blogs
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...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Forums
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...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
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