Monthly Archives: January 2012

HOW SQL Experience Resume looks like ?

A sample SQL Experience Resume, who has 5 years of experience.   Recently, I was being contacted by developer, who wanted to become an DBA and wanted his resume to look like a experience DBA. His current Resume looks likes this and he wanted to transform his current Resume like an Experience SQL DBA Resume. [...]

Microsoft SQL Server 2012 Launch Event

SQL Server 2012 was expected to be released in Q1 of 2012 but recently Microsoft Marketing team has set March 7, 2012 as a official launch event date for SQL Server 2012. You can also register for event virtually at http://www.sqlserverlaunch.com/ww/Home Please check my previous post, for various CTP’s release dates and here is list [...]

Next generation Windows File System – ReFS

Microsoft team is working on Windows 8 that’s a known fact but Microsoft is coming all together with a new FILE SYSTME, this is something new. YES, Microsoft has announced one of the most significant changes that will come with the Windows 8 a new file system, called ReFS, a recent post from Windows engineering [...]

101 SQL Server Reporting Services Interview Questions with Answers

In this post, I am going to walk you thru SQL Server Reporting Services Interview Questions from GENERAL | BASICS | Introduction DBA (Production Support) Prospective DBA + Developer Common Questions Developer (Report Designer) Prospective Solution Architect prospective IT Manager prospective GENERAL Questions – SSRS Interview Questions What is SQL Server Reporting Services? Reporting Services [...]

VIDEO–How to RECOVER Corrupted Database ?

How to Shorten the recovery time in case of database corruption? OR HOW to FIX damaged page in SQL Server ? HOW to FIX SQL Server ERROR : 8928 ? HOW to FIX page level corruption in SQL Server Database ? Error 8928 Details Msg 8928, Level 16, State 1, Line 1 Object ID 2105058535, [...]

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 [...]

DBCC SQLPERF(LOGSPACE) corrected in SQL Server 2012 RC0

DBCC SQLPERF(LOGSPACE) was being modified in SQL Server 2012 CTP3 and they added a new column, “Principal Filegroup Name” as a result set as shown below. This changed has effected lot of maintenance Script which stopped working because of this added new column. This issues was being reported by multiple  community member and they have [...]