Moving to DataOps
DataOps is another DevOps term for the modern management of data. It's not just the daily work of a DBA, however, as Steve notes in this piece.
2021-11-01
184 reads
Editorials
Do presenting and writing really matter?
I’m sure you’ve heard the adage that people are more afraid of public speaking than they are of death. On the other hand, some folks can’t get enough public speaking and look forward to opportunities to get up in front of a group and talk. Writing is not so scary since it’s a solitary activity, […]
2021-10-30
213 reads
The Future of the Internet and Data
What's the future of the Internet? A lot might depend on how we decide to value and handle data.
2021-10-29
284 reads
Security Bug or Handy Feature
We often misconfigure public access for data, which might contain sensitive information. Steve notes that we could do better, but it requires the effort to classify data.
2021-10-27
212 reads
2021-10-25
348 reads
Maybe It Is DNS
It might be DNS is the problem more often in the future. Steve notes the attacks on this system are rising.
2021-10-23
138 reads
Complex Searching
More complex searching is likely to be a requirement in the future, but for many of us, this won't require us to learn much.
2021-10-22
223 reads
Going Cloud Native
Lots of organizations are moving to the cloud, but having different levels of success. This change can be powerful and create tremendous opportunity, but it can also be a disappointment.
2021-10-20
255 reads
Growing and Keeping Up
Trying to keep up with technology is a losing game. Better to continue to grow and learn, balanced with the rest of your life.
2021-10-18
227 reads
Learning Is Challenging, So, Forgive Yourself
In addition to trying to get better at SQL Server, Redgate Software, and all the various aspects of my job, I'm also trying to get better at this whole human interaction thing AND I'm working on trying to learn PostgreSQL much more deeply. Whew! Yeah, may not seem like a whole lot, but I assure […]
2021-10-16
279 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