Category Archives: Video – DBATAG

How to Restore only Corrupted pages from a database backup ? VIDEO

How to Shorten the recovery time in case of database corruption? PAGE Level database restore is new feature which was introduced in SQL Server 2008 onwards. This is a new feature in SQL Server 2008, where we can restore only some corrupted pages from a good database backup. For example you have a 100 Gb [...]

SQL WHERE – Video Tutorial

Prior to understand Where clause, lets do a quick recap of SQL and then we will focus of WHERE clause. What is SQL Queries ? With SQL, we can query inside a database and have a result set returned. A query like this: SELECT FirstName, LastName FROM Person.Contact this query will return result set like [...]

How to Install and Configure Master Data Services ?

This video explains how to install the new Master Data Services component included with SQL Server 2008 R2. This video demonstrates the following: Where to find the installation program for MDS How to complete the installation wizard How to configure the MDS database How to configure the MDS website

How to Create Database in SQL Server – Video

Q : How to Create Database in SQL Server ? Creation of database in SQL Server is pretty, specially using SQL Server Management Studio. We create a database easily by performing following steps. Open SQL Server Management Studio. In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that [...]

SQL Server HADR Video

How to Implement HADR Videos… Another alternative Video for implementing HADR with CTP1

VIDEO : SQL Server Contained Database

The Following Video covers What is Contained Database Why Contained Databases were Required What all is being saved inside a Contained Database Benefits of using Contained Databases DEMO How we create a Contained Database ? How to create Users in Contained Databases ? How to create a user inside a Contained Database ? How to [...]