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 [...]
Category Archives: Video – DBATAG
How to Restore only Corrupted pages from a database backup ? VIDEO
Posted by Mahesh Gupta on January 13, 2012
0 comments
SQL WHERE – Video Tutorial
Posted by Mahesh Gupta on December 28, 2011
0 comments
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 ?
Posted by Mahesh Gupta on August 30, 2011
0 comments
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 Install Microsoft Silverlight To enhance your [...]
How to Create Database in SQL Server – Video
Posted by Mahesh Gupta on July 9, 2011
0 comments
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
Posted by Mahesh Gupta on April 14, 2011
2 comments
How to Implement HADR Videos… Another alternative Video for implementing HADR with CTP1
VIDEO : SQL Server Contained Database
Posted by Mahesh Gupta on December 4, 2010
2 comments
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 [...]
