KAVALIPOST

Tuesday 21 May 2013


Gramin Dak Sevak's son cleared Civil Service (Main) Examination 2012 (UPSC)


Union Public Service Commission (UPSC) on 3 May 2013 declared final result of Civil Service (Main) Examination 2013. A total of 998 candidates have been recommended for appointment to Indian Administrative Service, Indian Foreign Service, Indian Police Service, and Central Services, Group ‘A’ and Group ‘B’. CLICK HERE to see the result
In Tamilnadu Circle, Sri.R.KesavanS/o Sri.Ravindran, GDS MD, Sankarankudiyiruppu Branch Post Office, account with Satankulam SO in Tuticorin Division of Tamilnadu Circle has passed Civil Services Examinations with111th rank.

SQL Database Recovery Terms


As we know in SQL Database recovery we have these three options which we use commonly:
  • Restore from backup
  • DBCC Command & Repair command or 
  • Third Party SQL Database Recovery Software
So, I would like clear most of the doubts related to above three options:

Is “REPAIR_ALLOW_DATA_LOSS” command not cause data loss:  It all totally depends on corruption level. When you are using this command, you should make up your mind that you can also lose you data. That's why the option is named that - seriously.

Can we run repair without running DBCC CHECKDB: No, we can’t. Repair is an option to one of the consistency-checking commands (DBCC CHECKALLOC, DBCC CHECKTABLE, or DBCC CHECKDB

Note: DBCC CHECKFILEGROUP and DBCC CHECKCATALOG don't support repair

Is Repair fix every SQL Database corruption: No, it don’t fix, Its all depends on corruption level. There are some errors that DBCC CHECKDB cannot fix.  For more detail please check this post. 

Repair is safe to use on system databases: No, it’s not safe. We should never use it on master or tempdb because they cannot be put into single-user mode.  

Is 'REPAIR_REBUILD' resolves every SQL Database corruption: No it’s not true. REPAIR_REBUILD only fixes problem in nonclustered indexes. 

Is EMERGENCY mode repair always helps: No, it’s not repair. If there is something broken in the file-system than the command get fail. 

Can we roll back repair command?: It depends. You can roll back everything if you started an explicit transaction. But users do it very rarely.

Note: EMERGENCY mode repair can never be rolled back.

Is SQL Database Recovery Software safe to use: YES, when you are using this software, you should first make a backup of your database. I always first preferred restore from backup solution so I will also recommend you it as a first step. You should only use this option when you don't have backup.  
Before using any recovery step, you should be properly aware about their pros & cons.  It will help you to choose better solution to recover your corrupt SQL Server database. 

Top 10 things Stellar Phoenix SQL Recovery user needs to know

Recover your corrupt SQL Server Database with a dedicated software application is a SQL Recovery Software provided by Stellar. The application runs directly from your system after installing software on specified location. Here I am sharing useful information of SQL Recovery Software. 


There are two types of files, mdf and ndf which manage your data in proper format. The ndf file is a secondary file, if you have a large amount of data; you probably have a secondary file (ndf) to save your data. The new feature is to recover large ndf files. Now you have no need to worry about large file recovery, Stellar SQL Recovery can also recover large corrupt ndf files. The SQL Recovery Software should run on copy of the corrupt file.

In any version of SQL Database, if you find any problem to find the corrupt mdf file then you can easily search it by using the "Find Option". Just click on this button & the application find into your system that appears immediately in list view format. You can choose the file that you want to recover from this list. 

The new version of SQL Server Database launched in 2011. Another new feature is- supports to latest version of SQL Server Database that is SQL Server 2008 R2. 

Fast scanning algorithms — you can recover database quickly & accurately without completing the whole recovery. 

In addition to the whole process information, the new set includes separate log report after scanning database which shows all recovery process. I am eager to see how this apps sharing this process in the software. 

You can also recover XML data types and XML indexes with this software.

You cannot save preview of your database in demo version. For this you have to purchase full version of the software.

You can check the preview more than one objects at a time. Click on either one to multiple objects to recover it. Save it quickly and easily on location as you like.

You should perform software updates as soon as they become available. The easiest way for users to update your software is through update button. If you are using software, when an update is available, you can see it by clicking update button the top fifth right button on the software screen. Just click on this button to install the new updates.

If any of option isn’t used by you just yet, don’t worry use it now & give your precious comments about it.

Increment provision for retiring employees: Govt reply in Rajya Sabha


In written reply of question "whether Government proposes to modify the existing recommendation of the Sixth Pay Commission that Central Government employees will get an increment in the month of July in every calendar year to ensure that those Government employees who are retiring irrespective of the month of the calendar year and have at least put in more than six months of service get the last increment", Govt has submitted that there is no proposal under consideration of the Government to make any changes in increment date.

See full details of Rajya Sabha Q&A:-


GOVERNMENT OF INDIA
MINISTRY OF  FINANCE
RAJYA SABHA
UNSTARRED QUESTION NO-4380
ANSWERED ON-07.05.2013
Increment provision for retiring employees
4380 .   SARDAR BALWINDER SINGH BHUNDAR



(a)
         whether Government proposes to modify the existing recommendation of the Sixth Pay Commission that Central Government employees will get an increment in the month of July in every calendar year to ensure that those Government employees who are retiring irrespective of the month of the calendar year and have at least put in more than six months of service get the last increment;

(b)
         if so, by when a revised notification will be issued to benefit those retiring Government employees as it affects their pensionary benefits etc.; and

(c)
         if not, the reasons therefor?

ANSWER
MINISTER OF STATE IN THE MINISTRY OF FINANCE (SHRI NAMO NARAIN MEENA)

(a) to (c) : The existing provision for uniform date of annual increment on 1st July every year is based on the recommendations of the 6th Central Pay Commission which went into the service conditions of the Central Government employees taking into account all relevant factors. There is no proposal under consideration of the Government to make any changes therein.

*******
भारत सरकार
वित्त मंत्रालय
व्य्य विभाग

राज्य सभा

अतारांकित प्रश्न। संख्याक-4380 

 मंगलवार, 07 मई, 2013/17 वैशाख, 1935 (शक

सेवानिवृत्त हो रहे कर्मचारियों हेतु वेतन-वृद्धि संबंधी प्रावधान 

4380. श्री बलविंदर सिंह भुंडर:  
क्यान वित्त मंत्री यह बताने की कृपा करेंगे कि:
()       क्या सरकार का प्रत्येक कैलेंडर वर्ष के जुलाई माह में केन्द्र सरकार के कर्मचारियों की वेतन-वृद्धि होने संबंधी छठेवेतन आयोग की मौजूदा सिफारिश में बदलाव करने का विचार हैताकि सुनिश्चिेत किया जा सके कि एक कैलेंडर वर्ष मेंकिसी भी माह में सेवानिवृत्ता होने वाले तथा उस वर्ष में कम से कम माह तक अपनी सेवाएं प्रदान कर चुके सरकारीकर्मचारियों को अन्तिम बार वेतन-वृद्धि मिल सके
()       यदि हांतो सेवानिवृत्र हो रहे ऐसे सरकारी कर्मचारियों को लाभान्वित करने हेतु संशोधित अधिसूचना कब तकजारी कर दी जाएगीक्योंकि इसका प्रभाव उनके पेंशन संबंधी लाभों आदि पर पड़ता हैऔर 
()       यदि नहींतो इसके क्याकारण हैं

उत्तर

        वित्त राज्य़ मंत्री (श्री नमो नारायन मीना)

(से (): प्रत्येक वर्ष 1 जुलाई को वार्षिक वेतन-वृद्धि की एक समान तारीख का वर्तमान प्रावधानछठे केन्द्री  वेतनआयोग की सिफारिशों पर आधारित है जिसे सभी संबंधित कारकों को ध्यान में रखकरकेन्द्र सरकार के कर्मचारियों की सेवाशर्तों में शामिल कर दिया गया है। सरकार इसमें परिवर्तन के किसी प्रस्ताव पर विचार नहीं कर रही है। 
*****
Source: Rajya Sabha Q&A
Hindi version: http://164.100.24.219/qhindi/228/Au4380.doc

No comments:

Post a Comment