Monthly Archives: June 2013

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

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

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 , , , , , , , , , , , , , , , , , , | 13 Comments

How to Use DBCC CHECKDB in SQL Server

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