Vasanth Kumar Makam

Vasanth Makam is a consultant and expert in Agile Methodologies and Computer Systems since 2010. He has more than 10 years of experience in technology management, computer systems, cloud computing and software development. He has extensive experience in cloud technologies such as Amazon Web Services, Microsoft Azure and holds AWS certifications. Vasanth has MBA from the University of Cincinnati, he also virtually teaches Indian underprivileged students.
  • Interests: Cloud, CI/CD, Agile

SQLServerCentral Article

How to Restore a Snapshot in AWS RDS with the Same Name?

The demand for increasingly scalable, capable, and inexpensive database, backup, and recovery solutions has never been higher than it is now, as digital transformation reaches its pinnacle. Restoring is the process of recovering data from a backup and applying logged transactions to the data. Backups are used to restore data. Restoring returns the backup file […]

You rated this post out of 5. Change rating

2021-07-09

10,780 reads

Blogs

A Last Minute Trip to the EU

By

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

By

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

By

I’m excited to announce the release of a new open-source project that fully automates...

Read the latest Blogs

Forums

ORDER BY alias

By aniap

Comments posted to this topic are about the item ORDER BY alias

Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure

By vgupta

Comments posted to this topic are about the item Optional Parameter Plan Optimization in...

AI Experience Gap that we keep talking about

By Pat Wright

Comments posted to this topic are about the item AI Experience Gap that we...

Visit the forum

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) + 1
Which of the following queries produces the expected ordering and why? (Select all correct)

See possible answers