Author Archives: Mandeep Singh

Data Type in SQL Server

Data Type in SQL Server Hi friends, in this post we will learn about Data Type in SQL Server. A data type is an attribute that specifies the type of data that the object can hold: integer data, character data, monetary data, date and time data, binary strings, and so on.We can also define our own data

Drop-Delete SQL Server Database Using Management Studio or Query

Drop-Delete SQL Server Database Using Management Studio or Query Hi friends, in this post we will learn how to Drop-Delete SQL Server Database Using Management Studio or Query. Sometime we have a requirement of deleting database, we can do it by two ways. Using SQL Server management studio and Query. We will demonstrate you both ways.

Alter-Rename SQL Server Database Using Management Studio or Query

Alter-Rename SQL Server Database Using Management Studio or Query Hi friends, in this post we will learn how to Alter-Rename SQL Server Database Using Management Studio or Query. Sometime we have a requirement of changing database name, we can do it by two ways. Using SQL Server management studio and Query. We will demonstrate you both

SQL Server 2012 installation

SQL Server 2012 installation HI friends in this post we will learn about SQL Server 2012 installation. We are installing SQL Server 2012 on Windows 7 Operating system. Earlier we had discussed about Microsoft SQL Server Introduction and Microsoft SQL Server System Databases.

Microsoft SQL Server System Databases

Microsoft SQL Server System Databases In this post we will learn about Microsoft SQL Server System Databases. SQL Server includes the following system databases, every system database has its own importance and responsibilities. System Databases: master Database: Records all the system-level information for an instance of SQL Server. msdb Database: Is used by SQL Server Agent for scheduling alerts