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

Securing Kubernetes With External Secrets Operator on AWS

By

Here’s a way to centralize management, rotate secrets conveniently without downtime, automate synchronization and...

Save Azure PostgreSQL Backup to Storage

By

This may or may not be helpful in the long term, but since I’m...

The Book of Redgate: What’s Great about Redgate?

By

“I’m sick of hearing about Red Gate.” The first article in the book has...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

Collation related issues

By LearningDBA

I have read that the collation at the instance level cannot be changed. I...

getting started paas SSAS

By stan

hi our on prem STD implementation of SSAS currently occupies about 3.6 gig of...

Visit the forum

Question of the Day

Multiple Sequences

In SQL Server 2022, I run this code: 

CREATE SEQUENCE myseqtest START WITH 1 INCREMENT BY 1;
GO
CREATE TABLE NewMonthSales
  (SaleID    INT
  , SecondID int
 , saleyear  INT
 , salemonth TINYINT
 , currSales NUMERIC(10, 2));
GO
INSERT dbo.NewMonthSales
  (SaleID, SecondID, saleyear, salemonth, currSales)
SELECT
  NEXT VALUE FOR myseqtest
, NEXT VALUE FOR myseqtest
, ms.saleyear
, ms.salemonth
, ms.currMonthSales
FROM dbo.MonthSales AS ms;
GO
SELECT * FROM dbo.NewMonthSales AS nms
Assume the dbo.MonthSales table exists. If I run this, what happens?

See possible answers