2020-02-20
345 reads
Editorials
2020-02-19 (first published: 2019-03-14)
495 reads
Leveling up Core Skills: A Pattern for Launching an Internal Training Initiative
Today, Julia Hayward explains how Redgate is leveling up core skills.
2020-02-18
213 reads
2020-02-17
193 reads
A New World of Data
I started in the early days of SQL Server, when having a gigabyte of disk storage was unheard of, much less a gigabyte of RAM. My watch has more storage space than the mainframe we replaced with an early version of SQL Server years ago. The technical possibilities and amounts of data we are capable […]
2020-02-15
143 reads
2020-02-13
229 reads
The Main Obstacles to Implementing Database DevOps
Today, Kendra explains what's holding organizations back from implementing Database DevOps.
2020-02-12
250 reads
Giving Computers Ethics
There is a need to ensure we decide what ethics a computer system ought to have.
2020-02-10 (first published: 2019-03-27)
272 reads
Personal Power
Because of my job with Redgate (which I love and will never leave even after I’m dead), I spend a lot of time learning about compliance and all the new laws and regulations coming out of things like the GDPR and the CCPA (they changed the name evidently). However, I’m a nerd. I’m not a […]
2020-02-08
152 reads
2020-02-06 (first published: 2019-02-28)
410 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