Wednesday, December 4, 2019

Chandrayaan2 Vikram lander found by NASA

The Chandrayaan2 Vikram lander has been found by NASA Moon mission, the Lunar Reconnaissance Orbiter.

Chandrayan2 Vikram-lander-found NASA Page Link

Indian software engineer Shanmuga Subramanian helped NASA to locate the debris of Chandrayan2 Vikram Lander failed mission to the moon.

Sunday, October 27, 2019

Happy Diwali

"Wish you all a Very Very Happy Diwali and Hope that Every Person on the Earth, Transform from the Darkness to Happiness."


Clean your house, society, nearby road after enjoying Diwali Festival. To improve your environment pollution-free. It has been improving humans life span on Earth.

Tuesday, October 15, 2019

Beautiful clean white sand Shrivardhan beach in Raigad District

You can visit beautiful clean white sand Shrivardhan beach  near Raigad District in the Konkan region.
You can take Maharashtra state transport bus from Mangaon to reach Shrivardhan Beach.
You can play water sport between Dec to May . Water sport is closed in water season.It's a 5 hours travailing from Mumbai.
You can also reach through train from  Mumbai to Mangaon then take bus from Mangaon.

Thursday, October 10, 2019


Maharashtra Legislative Assembly Election, 2019

Election will be held in a single phase on 21-Oct-2019.

Visit Election Commission of India web site for more live update and result.

Maharashtra Online Voter Registration

Sunday, September 29, 2019

5th anniversary of Swatch Bharat Abhiyan

We are celebrating 5th anniversary of 'Swatch Bharat Abhiyan' on 2nd October 2019.
So many initiatives for Swatch Bharat Abhiyan on this day.

1. Cleaning up 'Elephanta Island' one of the World Heritage site's of our Nation.
Our small contribution towards the well-being of our nature and our nation.@FoundationWaste

2.Contribute in making India clean by the 150th birth anniversary of Mahatma Gandhi.

5. Say No To Plastic and Save Earth

Saturday, September 21, 2019

Food Wastage in Chandivali Andheri Mumbai

Food Waste google map  Location

Address :  Ansa Industrial Estate, Chandivali, Andheri East, Mumbai, Maharashtra 400072

This image taken from two location, too much food waste found in that location.

Food Waste google map  Location

Address : Chandivali Road, Chandivali, Andheri East, Nanshi munshi chawl, Chandivali, Powai, Mumbai, Maharashtra 400072

Thursday, September 12, 2019

Maharashtra Government eBalbharati books online

"Sarva Shiksha Abhiyan Education for all"
Maharashtra State Board books
Read eBalbharati books online using this link ebook library
Book types
1. Text Books
2. Teachers Handbooks
3. Work Books
4. Other Books
5. Kishor Khand

Saturday, September 7, 2019

Food wastage in Goregaon East Mumbai

1.  Food wastage Post 1

    Hanuman Tekdi, Goregaon East, Mumbai, Maharashtra 400063

2. Daily use food wrapper in garden dustbin
    P L Deshpande Garden, Pandurang Wadi, Goregaon, Mumbai, Maharashtra 400063

Saturday, July 20, 2019

SQL server 2008 R2 Performance tuning

SQL Server 2008 R2 Performance Tuning

#1. Check fragmentation for indexing.

Check particular all index details based on selected database.

SELECT dbschemas.[name] AS 'Schema'
 ,dbtables.[name] AS 'Table'
 ,dbindexes.[name] AS 'Index'
FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) AS indexstats
INNER JOIN sys.tables dbtables ON dbtables.[object_id] = indexstats.[object_id]
INNER JOIN sys.schemas dbschemas ON dbtables.[schema_id] = dbschemas.[schema_id]
INNER JOIN sys.indexes AS dbindexes ON dbindexes.[object_id] = indexstats.[object_id]
 AND indexstats.index_id = dbindexes.index_id
WHERE indexstats.database_id = DB_ID()
ORDER BY indexstats.avg_fragmentation_in_percent DESC

#2. Shrink Database log file.

     Shrinking database log file when SQL Server log file size increased.




#3. Check last backup details for particular database.

Check database specific backup details using this query.



SET @DatabaseName = '<DB Name>'

SELECT DISTINCT d3.user_name
 , AS backup_name
 ,(datediff(ss, d3.backup_start_date, d3.backup_finish_date)) / 60.0 AS duration
 ,d3.type AS [type]
  WHEN (d3.backup_size / 1024.0) < 1024
   THEN (d3.backup_size / 1024.0)
  WHEN (d3.backup_size / 1048576.0) < 1024
   THEN (d3.backup_size / 1048576.0)
  ELSE (d3.backup_size / 1048576.0 / 1024.0)
  END AS backup_size
  WHEN (d3.backup_size / 1024.0) < 1024
   THEN 'KB'
  WHEN (d3.backup_size / 1048576.0) < 1024
   THEN 'MB'
  END AS backup_size_unit
  WHEN d3.differential_base_lsn IS NULL
   THEN 'Not Applicable'
  ELSE convert(VARCHAR(100), d3.differential_base_lsn)
  END AS [differential_base_lsn]
 ,b6.device_type AS [device_type]
FROM sys.databases d1
INNER JOIN backupset d3 ON (d3.database_name =
LEFT OUTER JOIN backupmediaset b5 ON (d3.media_set_id = b5.media_set_id)
LEFT OUTER JOIN backupmediafamily b6 ON (b6.media_set_id = b5.media_set_id)
WHERE ( = @DatabaseName)
ORDER BY backup_start_date DESC