Tuesday 21 April 2020

How to Compress 1GB files into 10MB

       Managing space on your hard disk is sometimes a tedious task. Many used to compress their files to save the space. But they could only manage to save a bit . By following the instructions of this article you can Compress 1GB files into 10mb archive.
kgb archiverFirst of all you need to download a software called as KGB Archiver. You can download it by clicking here.
After downloading and installing the software Follow the screenshots below to start archiving.
Step1: Start the KGB Archiver Program and click next.

 





Monday 20 April 2020

MS SQL Server Space / Memory Manegment


Execute This


SELECT SUM(unallocated_extent_page_count) AS [free_pages]

,(SUM(unallocated_extent_page_count) * 1.0 / 128) AS [free_space_MB]

,SUM(version_store_reserved_page_count) AS [version_pages_used]

,(SUM(version_store_reserved_page_count) * 1.0 / 128) AS [version_space_MB]

,SUM(internal_object_reserved_page_count) AS [internal_object_pages_used]

,(SUM(internal_object_reserved_page_count) * 1.0 / 128) AS [internal_object_space_MB]

,SUM(user_object_reserved_page_count) AS [user object pages used]

,(SUM(user_object_reserved_page_count) * 1.0 / 128) AS [user_object_space_MB]

FROM sys.dm_db_file_space_usage;

GO

Activate curl Wamp : windows

The steps are as follows :


  1. Close WAMP (if running)
  2. Navigate to WAMP\bin\php\(your version of php)\
  3. Edit php.ini
  4. Search for curl, uncomment extension=php_curl.dll
  5. Navigate to WAMP\bin\Apache\(your version of apache)\bin\
  6. Edit php.ini
  7. Search for curl, uncomment extension=php_curl.dll
  8. Save both
  9. Restart WAMP

open Rar File Ubuntu




First i need to run :

sudo apt-get install unrar 
for install unrar.


If i want to unpack all files within the .rar files in the same directory
unrar e -r /home/work/software/myfile.rar



if You want to unpack the files in full path
unrar x -r /home/work/software/myfile.rar

tracert cmd Command for Trace Root


tracert cmd Command for Trace Root

syntax

>tracert google.com


-------------------------------------------------------

all over Word cable map
Cables Map: https://www.submarinecablemap.com

speed all over word pont
Speed Meter: http://www.nixi.in/en/mrtg-statistics
--------------------------------------------------------------

oky

-Kishor 

Bluetooth + Arduino Connectivity

/*
 *  The program for ON/ Off LED Using Bluetooth
 *  MAC+tech Development
 *  http://macplustechnology.blogspot.in/
 *  Email: macplustech@gmail.com
 *
 */
char data = 0;                //Variable for storing Bluetooth incoming data
void setup()
{
  Serial.begin(9600);      
  pinMode(13, OUTPUT);        //output pin (+5V)  other connect (GND)
}
void loop()
{
  if(Serial.available() > 0)  // resive data
  {
    data = Serial.read();      //Read the incoming data
    Serial.print(data);        //Print ValueSerial monitor
    Serial.print("\n MAC+tech");      
    if(data == '1')            //Checks whether value of data is equal to 1
      digitalWrite(13, HIGH);  //If value is 1 then LED turns ON
    else if(data == '0')       //Checks whether value of data is equal to 0
      digitalWrite(13, LOW);   //If value is 0 then LED turns OFF
  }                          

}              


load to Arduino And Send data though Android App. where make simple android app. to send data though Bluetooth .....

On off Light Using MObile And Arduino

Steps :

1 . go to http://ai2.appinventor.mit.edu  
    and open Account 
2  Download Android App Source Code from My Drive  https://drive.google.com/open?id=1GS3NbGwm0DaKM89chzyWDuAxkW35xR75

Or  Directly Download APK File from here.. 
3 import this code to http://ai2.appinventor.mit.edu
and Build App Download it Using QR Code Directly Your Android Mobile



Step to run :
 1 . Connect  LED, BT HC-05 To Arduino Upload bellow Program on it  (* IMP NODE : During Upload Arduino Remove Bluetooth HC-05 )
 2.  Using in mobile pair with Bt Devices HC-05 (Default password 1234)
 3. Open App select Device from list connect it
 4. on/ off light  




Write CODE on Arduino AND Config Pin...


CODE:
/* 
 *  
 *  Coder - Kishor M Sonawane




Bluetooth connection:-
Arduino Pins           Bluetooth Pins
RX (Pin 0)     ———->      TX
TX (Pin 1)     ———->      RX
5V             ———->      VCC
GND            ———->      GND


 */
char data = 0;                //Variable for storing received data
void setup() 
{
  Serial.begin(9600);         
  pinMode(13, OUTPUT);        //Sets digital pin 13 as output pin
}
void loop()
{
  if(Serial.available() > 0)  /
  {
    data = Serial.read();      //Read the incoming data and store on variable >> data
    Serial.print(data);       
    Serial.print("\n");        
    if(data == '1')            //Checks whether value of data is equal to 1 
      digitalWrite(13, HIGH);  //If value is 1 then LED turns ON
    else if(data == '0')       
      digitalWrite(13, LOW);   //If value is 0 then LED turns OFF
  }                            
 
}                 




How to delete duplicate records from a SQL data table

  introduction How to delete duplicate records from a SQL data table using CTE (common table expression). Specifies a temporary named result...