Dilip_Ravindran

I am a seasoned security engineering leader boasting an impressive track record in the technology industry. My expertise stretches across various areas such as cloud security, infra security, engineering leadership, and blockchain technologies. Currently, I lead Coinbase's cloud security efforts, dedicated to crafting strategies and solutions that enhance the platform's security, thereby ensuring we maintain our position as the most secure crypto platform in the world.

Over the span of my dynamic career, I have made considerable contributions to the field of software engineering. I have had the privilege of working with renowned companies and have spearheaded innovative projects. Among my accomplishments, I am proud to have been one of the early engineers who developed the SMS endpoint for AWS SNS, and I also led Teradata's effort to launch on the Google Cloud Platform.

At Coinbase, my current role entails managing a proficient team of security engineers. I regularly conduct security audits to identify vulnerabilities and potential threats, and oversee the implementation of advanced security technologies like firewalls, intrusion detection and prevention systems, and SIEM.

Being a passionate advocate for staying abreast of the latest advancements in cloud technology, I not only drive innovation within my own work but also find immense satisfaction in sharing my knowledge and expertise with others. My focus on thought leadership and collaboration positions me well to make a meaningful impact on the technology community and beyond.

Blogs

Free PostgreSQL Performance Monitoring with pgNow

By

I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...

Dealing with Changing Data Formats: Schema Drift in Azure Data Factory

By

(2025-Feb-12) I will jump straight to the problem statement without a "boring" introduction, which, in...

Adding Manual Relationships Between Tables in the TDM Subsetter

By

I wrote about getting the Redgate Test Data Manager set up in 10 minutes...

Read the latest Blogs

Forums

sqlserver metrics to capture

By mtz676

Can this baselining and benchmarking sqlserver be done using extended events ? What are...

SSMS Object Explorer Not Showing Tables

By Ahr Aitch

If this post doesn't meet protocol here, please tell me how to improve as...

Do You Folks Mind Beginners Here?

By Ahr Aitch

I'm a retired IT guy in his 80s fighting boredom by trying to learn...

Visit the forum

Question of the Day

The Rank Window

I have this table and data:

CREATE TABLE [dbo].[SalesTracking]
(
[SalesDate] [datetime] NULL,
[SalesPersonID] [int] NULL,
[CustomerID] [int] NOT NULL,
[PONumber] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[paid] [bit] NULL,
[total] int
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [SalesTrackingCDX] ON [dbo].[SalesTracking] ([SalesDate]) ON [PRIMARY]
GO
INSERT dbo.SalesTracking
  (SalesDate, SalesPersonID, CustomerID, PONumber, paid, total)
VALUES
  ('2024-03-15 10:45:55.067', 1, 1,'PO965' ,1, 100),
  ('2023-09-24 10:45:55.067', 1, 2,'PO627' ,1, 200),
  ('2022-07-02 10:45:55.067', 1, 3,'PO6'   ,1, 300),
  ('2022-11-03 10:45:55.067', 1, 4,'PO283' ,1, 400),
  ('2022-11-26 10:45:55.067', 1, 5,'PO735' ,1, 500),
  ('2023-04-28 10:45:55.067', 1, 6,'PO407' ,1, 600),
  ('2022-09-09 10:45:55.067', 1, 7,'PO484' ,1, 700),
  ('2024-03-13 10:45:55.067', 1, 8,'PO344' ,1, 700),
  ('2024-04-24 10:45:55.067', 1, 9,'PO254' ,1, 800),
  ('2022-06-19 10:45:55.067', 1, 10,'PO344',1, 800)
GO
When I run this query, how many unique values are returned for the SalesRank column?
SELECT
  st.SalesDate
, st.SalesPersonID
, st.total
, RANK () OVER (PARTITION BY st.SalesPersonID
                ORDER BY st.total desc) AS SaleRank
FROM dbo.SalesTracking AS st;

See possible answers