How Important is a Conference?
Is going to a conference valuable for you? Your employer? Today Steve asks you to think about what might be important.
2020-10-12
97 reads
Editorials
2020-10-10
152 reads
What's the Lunch Factor?
DevOps is about being effective and getting work out to customers. Today Steve notes that the lunch factor might help you reexamine your software development process.
2020-10-09
315 reads
Pulling Together
A number of companies worked together to ensure that they could meet the challenge of the NHS. Sharing data was critical to this effort.
2020-10-08
129 reads
AI Data
Data is important for AI projects, but the ethics and privacy implications are complex. A new project from Microsoft aims to help users control their data and make it available for use.
2020-10-07
189 reads
DevOps and Exhibits
DevOps continues to improve the way we build software and Steve has a good example in today's editorial.
2020-10-06
73 reads
Detecting Logins
A recent issue with malware and SQL Servers has Steve wondering if you would detect a new, and unapproved, login added to an instance.
2020-10-05
223 reads
Azure Resource Mover
Microsoft recently held the 2020 Ignite conference. Just like in previous years, there were many announcements introducing new services and expanded capabilities of existing ones, especially in Azure. Ahead of Ignite, I was asked to take a test drive of one of the new features, Azure Resource Mover (in preview). It’s easy to move a […]
2020-10-03
203 reads
2020-10-02
141 reads
DR as a Service
It's not the first task when I start a new job, but often as a DBA or developer, I usually ask about Disaster Recovery (DR) plans sometime within the first six months. If I'm a DBA, of course I need a plan. If I'm a developer, however, I still need to understand how this might […]
2020-10-01
121 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
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