Monthly Archives: June 2013

Preparing for MCSA Exam 70-461 – MS SQL Server 2012 exam

Posted on June 28, 2013 by uday arumilli

MCSA Certification Prep | Exam 461: Querying Microsoft SQL Server 2012 SQL Server Certification preparation MCSA Exam 461 Preparing for MCSA Exam 70-461 – MS SQL Server 2012 exam   Review: Just go through this video we’ll get a over … Continue reading →

Posted in Miscellaneous | Tagged , , , , , , , , | Leave a comment

SQL Server Backup and Restore Interview Questions

Posted on June 26, 2013 by uday arumilli

SQL Server Backup and Restore Interview Questions   Here are the list of SQL Server Backup and Restore Interview Questions which are asked in SQL Server DBA interviews. 1. How does the database recovery model impact database backups? Ans: First the … Continue reading →

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , , , | 14 Comments

How to Use DBCC CHECKDB in SQL Server

Posted on June 26, 2013 by uday arumilli

How to Use DBCC CHECKDB in SQL Server Use: By far the most widely used command to check the status of your database is DBCC CHECKDB. This statement checks the allocation and structural integrity of all data and index pages … Continue reading →

Posted in SQL Server DBA | Tagged , , , , , , , , , , , | 2 Comments