REPAIR SUPSPECTED / CORRUPPED SQL DATABASE USING QUERY

Query For Repairing SQL Databases

Database needs to bring the database into single user  mode then only you can execute DBCC CHECKDB command, otherwise you will get errors. see the below example to bring database into single user mode.

Use database_name GO ALTER DATABASE database_name SET SINGLE_USER
GO
DBCC CHECKDB('database_name', REPAIR_REBUILD)
GO

• to return to multi-user mode: 

ALTER <database-name> SET MULTI_USER

Reason For Execute The Above Command In Single User Mode

it is required to run this command in SINGLE USER Mode. This is because when SQL does thie REPAIR_REBUILD command internally it allocate/deallocate references to the pages and move them here and there. So that is the reason for running this command in SINGLE USER mode.

DOWNLOAD MOZILLA FIREFOX V41 FROM GOOGLE DRIVE

Mozilla FireFox v41 is available for download and its now in Google Drive. Any one can download the below link. It may very useful for Post Offices which is migrated to Sify Network. Sify Network allows only limited sites, we could not access the Firefox Official site.

Sify Network Users (Department of Posts) should use Mozilla Firefox for Checking GMail, Access Google Drive / Blogger, it may overcome proxy settings issue.

Download.

Point Of Sale in Core System Integrator (CSI) Project Deployed for Testing

Point Of Sale in Core System Integrator (CSI) Project Deployed for Testing

The Department of Posts (DoP) and Tata Consultancy Services (TCS) officially kicked-off the Core System Integrator (CSI) Project on 2nd of May 2013, as a part of the IT Modernization Project.

Core Systems Integration (CSI) will integrate all solutions implemented under the IT Modernization Project across different channels, levels and locations.

Now the CSI Project is under testing at selected Post Offices. By the rolling out of this project, the entire local database based applications like Meghdoot and SpeedNet Software will be replaced with web based application developed by TCS.

Following are some details about new Point Of Sale module under CSI Project.

Overview

1.    Login Module for each of the roles is Based on

2.    User ID is Created and Shared with each and Every individual Centrally Separately

3.    Roles and setup at the Identity Access Management are Forgot (IAM) Application

4.    Individual applications use the Centrally setup password

Login to POS

1.    Counter POS Application Allows a person provided the person has the Allocation to login to use the counter

2.    Counter Allocation Happens at the Back Office Application of POS

3.    Single Sign On (SSO) Allows login to Counter POS, Back Office, PBS, PLI, SAP through the CA -SSO

Day Begin

1.    Post Master, Supervisor, Treasurer are the controlling Users

2.    Start the Operation Post Master or the designated person will

3.    Supervisor will allocate the counter to the operators

4.    Treasurer will receive the Cash, Stamps, IPOs from the F & A

5.    Treasurer will allocate the Cash, Stamps, IPOs to the users

6.    Treasurer / Supervisor will Get approval for alerts

7.    Close the Post Office Post Master or the designated person will during Operation End of the Day

Mysuru postal division in Karnataka gets integrated system for services

Customers will get delivery status of their posts or parcels on their mobile phones or can track status online.— PHOTO: M.A. SRIRAM

CUSTOMERS CAN AVAIL THEMSELVES OF ANY SERVICE FROM ANY COUNTER

Mysuru is all set to become the first postal division in the country to adopt a common system for various postal services, integrating all software solutions introduced under a core banking network.

From Thursday, customers need not wait at a particular counter for a particular service, as every counter will be able to provide all the services available at the post office.

A team of professionals from Tata Consultancy Services (TCS) on Wednesday took up the task of integrating the solutions into a common system. Postal services across the division, covering 65 post offices and 202 branches, remained suspended to facilitate the work.

The team, with the support from the Department of Posts, spent over six months to accomplish the task.

Shivaiah, Senior Superintendent of Post Offices, Mysuru division told The Hindu that Mysuru was selected for the pilot project considering previous ‘models’ successfully introduced here, for improving customer service.

“The integration work is underway and the common system will be ready for operations from Thursday. With this, Mysuru division will become the first postal division in the country to introduce this improved service,” he said.

Barring Nanjangud and T. Narsipur (which are part of Chamarajnagar postal division), the remaining taluks in the district – Mysuru city, Mysuru taluk, K R Nagar, H D Kote, Periyapatna, and Hunsur – come under Mysuru division.

Mr. Shivaiah said software had been developed for various services such as postal life insurance, postal savings account, recurring deposits and so on. Recently, core banking system had been introduced for the convenience of customers.

The officer said customers sometimes had to wait for their turn to avail services at a particular counter even though the next counter was free. However, with the integration of various software solutions and bringing them under a unified system, customers can avail any postal service from any counter, he explained.

Importantly, customers will get delivery status of their posts or parcels on their mobile phones or can track status online. All data will be stored at the central server in Mumbai.

After the integration of software solutions, the company professionals would provide post-implementation service, assisting the employees to trouble shoot any problem, Mr. Shivaiah added.

Mysuru division can become a model for other postal divisions across the country for replicating the common customer service system in the coming months.

Mysuru division will become the first postal division in the country to introduce this improved service.

Tools For Post Offices created by Shivaram Puttur

Tools created by Shivaram Puttur:

Weblink Updated on 19.09.2015	A must have tool for all to connect the websites required for day to day work in a right click. It contains useful utilities also.	Download (Complete application) Download Manager
FMenu Updated on 16.09.2015	Very useful tool for easy Finacling. It contains almost all important menus for the day to day Finacling.	Download
Converter	Tool for changing the extn of exe file to the desired extn.	Download
HSheet	Tool for preparing History Sheet of Computers/Printers/UPS etc	Download
RList	Tool for bulk booking of RL in DO. This will generate data in text file which can be uploaded to Despatch module in PO	Download  Includes Help document and New exe
RODak	Tool for DO to prepare Despatch list/ Receipt List of RO documents.	Download
BCGen	Tool for generating Barcode numbers in DTC/WCTC for Training purpose Saves Barcode wastage in Training.	Download
MM Updater	Tool for applying patches and updates to Meghdoot application.	Download
ConfiGen	Tool for use in DTC/WCTC for linking Clients to Server and making the Clients as Stand alone Servers for Meghdoot operations.	Download
RegisterDLL	Tool to register/ unregister all DLL files in a single click.	Download
Blank Configen	When ePayment site is to be re registered, blank Config file  can be created through this without  re installing the  package.	Download
DOPad	Notepad like utility for preparation of instant letters in DO. Supported by MS Office.	Download
SOPad	Notepad like utility for preparation of instant letters in SO. Supported by MS Office.	Download
SAPad	Notepad like utility for preparation of instant Reports for SA. Supported by MS Office.	Download

Shivaram PutturInstructorDTC-Puttur - 574201, Karnataka9449012470srputtur@gmail.com