Serverless
The idea of serverless computing is interesting, and with Azure Stack, might be something more of us embrace.
2019-05-02
369 reads
Editorials
Are you a Data Scientist?
A data scientist needs some specialized skills. Today Steve Jones talks a bit about the requirements to be good at this job.
2019-05-01 (first published: 2015-09-29)
592 reads
Guest editorial: SQL Code Metrics
In which Phil Factor toys with the thought of producing quality metrics for SQL code, before dismissing the idea as foolhardy.
2019-04-30 (first published: 2009-02-17)
654 reads
2019-04-29 (first published: 2015-09-14)
325 reads
2019-04-27
172 reads
2019-04-26
231 reads
The Database Giveth and Taketh Away
A database error at Southwest Airlines confused some customers and was embarrassing. Steve worries that we might want to be more careful in the future about making database mistakes.
2019-04-25
308 reads
Can Azure Stack Reduce Software Development Costs?
Azure Stack provides a hybrid cloud infrastructure platform. Steve wonders if this really helps reduce software development costs.
2019-04-24
217 reads
Changing Context and Data Reuse
We don't have strong data consent rules in the US, but Steve thinks we should.
2019-04-23
276 reads
Protecting Data Between Services
Microsoft is shutting down HealthVault, which means that customers need to manage their records. That's a challenge for many people.
2019-04-22
178 reads
Blogs
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
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...
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