Vinay Kumar

  • Interests: Hi, I worked with different technologies like C#, ASP.NET, Web services and sql server. But i was fall in love with sql server and became a DBA. I always try to learn something new or recall old stuff. Frankly speaking, i don't think that i am a DBA. Still learning. I like to spend my spare time with my family and friends. Recently, i have stared blogging and improving my writing way. :-). that's all about me. Keep Learning - Keep Growing !!! Thanks Vinay Kumar

All authors

Technical Article

Shrink databases

This procedure is used to shrink the databases. Many times we use shrink option to shrink the databases for backup. and we do it N number of times, when we take the back of databses or make free space of drive.instructions:- Follwo the step.1. run script.2. And execute the statement, exec shrink_databasesI m new, if […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2007-06-27

800 reads

All authors

Blogs

AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared

By

Both SQL Server and PostgreSQL are moving fast into AI territory — and if...

Monday Monitor Tips: AI Alert Analysis

By

We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...

From SQL Saturday to Day of Data

By

A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...

Read the latest Blogs

Forums

Install SQL Scripts via GUI Wizard

By Jörg

Hallo all! My problem is this: I have quite a bunch of TSQL scripts...

Would You Retire Rather Than ...

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Would You Retire Rather Than...

Vector Search in SQL Server 2025: Storing Embeddings, Querying Them, and What to Watch Out For

By vgupta

Comments posted to this topic are about the item Vector Search in SQL Server...

Visit the forum

Question of the Day

Converting Money

Does this run successfully on a SQL Server 2022, US English default installation? 

DECLARE @YenAmount MONEY;
SET @YenAmount = ¥1500; 

SELECT @YenAmount AS RawValue;

See possible answers