Results for "sql server basics"
9 / 142 posts
Dynamic Linked Server Management in SQL Server
Introduction In SQL Server, sometimes we need to connect with another database server. This is done using a Linked Server . But manually creating and deletin...
SQL Server Configuration Manager
Introduction Jab hum Microsoft SQL Server install karte hain , tab kuch important tools automatically install ho jate hain. Unme se ek bahut important tool…
SQL Server Database Shrink Maintenance
Database shrink ka matlab hai database file (ya log file) ke size ko chhota karna by removing unused space . Matlab, agar tumhare DB me data delete ho gaya h...
SQL Server System Databases
Introduction SQL Server me jab hum kaam karte hain, to generally hum tables, queries aur user databases par focus karte hain. Lekin ek hidden backbone hota…
Model & Resource Database in SQL Server
Introduction SQL Server ke system databases me kuch aise hidden heroes hote hain jo directly dikhte nahi, lekin bahut powerful role play karte hain. Aaj hum...
SQL Server Administration – Management Tools Overview
Is section me hum mainly SQL Server ke management tools aur system databases ko samjhenge. SQL Server Management Tools Jab aap Microsoft SQL Server install…
Master Database in SQL Server
Introduction SQL Server me agar koi ek database sabse zyada critical hai, to wo hai: Master Database Ye SQL Server ka core brain hai. Agar master database …
TempDB in SQL Server
Introduction SQL Server me ek aisa database hai jo har query, har process aur almost har operation me involve hota hai. Ye ek temporary w…
MSDB Database in SQL Server
SQL Server me ek aur powerful system database hai jo automation + scheduling ka backbone hai: MSDB Database