Category Archives: Sql Server

SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing

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

Microsoft SQL Server Introduction

Microsoft SQL Server Introduction In this tutorial, we will learn about Microsoft SQL Server Introduction, SQL Server is a Relational Database Management System developed by Microsoft. SQL Server primary function is storing and retrieving data through applications. Microsoft SQL Server comes in different editions: Enterprise, Buisness Intelligence, Standard, Web, Developer, Express Microsoft SQL Server Components

SQL Server 2012 Interview Question Answers

SQL Server 2012 Interview Question Answers Q: Difference Between DTS and SSIS. DTS SSIS DTS stands for Data Transformation Services 1.SSIS stands for Sql Server Integration Services DTS is a set of objects using an ETS tool to extract, transform, and load information to or from a database SSIS is an ETL tool provided by

SQL Server Database Mirroring in Domain Environment

SQL Server Database Mirroring in Domain Environment Hi friends, in this post we will discuss how to configure SQL Server Database Mirroring in Domain Environment. Earlier we have discussed How To Set Up Database Mirroring In Windows Workgroup. Here are some conditions to be meet to configure Database mirroing: For a mirroring session to be

Manual Failover Cluster

Manual Failover Cluster Hi friends, in this post we will learn how to manual Failover SQL Server Cluster. Earlier we had learnt how to configure a two node SQL Server Failover Cluster. Step by Step SQL Server 2008 R2 Clustering Part 1 Step by Step SQL Server 2008 R2 Clustering Part 2 Step by Step