=> What is normalization ?
Defination :Normalization is the process of efficiently organizing data in a database. There are two goals of...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2010-09-07

303,348 reads

Generate Insert Query in SQL

Sometimes we need to generate the INSERT script in sql server. When, we need to insert bulk of data from...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2010-08-26

3,161 reads

SQL Blog (Basic)

1. SQL Objects
a. Stored Procedures : a bunch of SQL statement which can be stored under one name.
Adventages :
can be used...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2010-07-02

1,032 reads

Today’s coping tip is to focus on what’s good, even if today feels tough....

SQL Data Compare (SDC) is a great way to sync data among tables. It’s...

Today’s coping tip is to be gentle with yourself when you make mistakes. I...

I have a two-replica SQL Server Availability Group running on Windows VMs in the...

I have a SQL agent job which starts the trace (for audit purpose) everyday...

I have a number of databases on a sql server 2017 instance. For most...