Roopesh Uniyal

I have 20 years of progressive IT experience and have worked in different capabilities. I have worked with Data, Database, and Content management extensively in the last 15 yrs. I have worked in different capacities to manage structured, semi-structured, and unstructured data.

I have worked in the IT, Insurance, and Financial industry, which gives me an insight not only from an IT industry perspective but from a business vertical too. I have been working as Sr. Systems Architect and designed and implemented Content Management solutions and database solutions for enterprises in the last fifteen years.

I hold an MBA - Analytics degree from the University of Florida and a Bachelor of Commerce from India. I am a certified TOGAF Enterprise Architect and Certified Information Systems Auditor (CISA). I also own Oracle Database Administrator and CompTIA Security+ certification. I am also an AIIM and Scaled Agile PM/PO, certified practitioner.
  • Skills: Data, Database, Content Management, Web Management, Analytics, Reporting, Agile, Cloud, Enterprise Architecture

All authors

All authors

Blogs

The Book of Redgate: We Value Teams

By

This value is something that I still hear today: our best work is done...

Troubleshooting TempDB Log Full Errors When SSMS Won’t Connect

By

Have you ever received the dreaded error from SQL Server that the TempDB log...

Accelerating AI with Confidence: Why Microsoft Purview is Key to Responsible Innovation

By

Artificial intelligence is no longer a distant concept. It is here, embedded in the...

Read the latest Blogs

Forums

Planning for tomorrow, today - database migrations

By John Martin

Comments posted to this topic are about the item Planning for tomorrow, today -...

Bottlenecks on SQL Server performance

By runarlan

We have a BI-application that connects to input tables on a SQL Server 2022...

Is there some good routines for updating SQL Server database objects with GitHub

By Rod at work

At work we've been getting better at writing what's known as GitHub Actions (workflows,...

Visit the forum

Question of the Day

The Tightly Linked View

I try to run this code on SQL Server 2022. All the objects exist in the database. 

CREATE OR ALTER VIEW OrderShipping
AS
SELECT cl.CityNameID,
       cl.CityName,
       o.OrderID,
       o.Customer,
       o.OrderDate,
       o.CustomerID,
       o.cityId
 FROM dbo.CityList AS cl
 INNER JOIN dbo.[Order] AS o ON o.cityId = cl.CityNameID
GO
CREATE OR ALTER FUNCTION GetShipCityForOrder
(
    @OrderID INT
)
RETURNS VARCHAR(50)
WITH SCHEMABINDING
AS
BEGIN
    DECLARE @city VARCHAR(50);
    SELECT @city = os.CityName
    FROM dbo.OrderShipping AS os
    WHERE os.OrderID = @OrderID;
    RETURN @city;
END;
go
What is the result?

See possible answers