I bought Dialog LIVIT Fitness Band couple of week ago. So, I would like to share my experience it. LIVIT is low price fitness band. So I bought this fitness band for 1745 LKR (Discounted Price). I think it good for that price. However, LIVIT doesn't have heartbeat sensor.
Features
All day activity tracking (steps,distance,calories burned,active minits,hourly activity).
Notification and calender alerts - (Call,text,facebook,Twitter,WhatApps,skype,Gmail).
Reminder to move (encorage you to take steps every hour).
Auto Sleep Traking (how long well you sleep).
Sync Wirless (Bluetooth 4.0 with Android and Apple devices).
USB Charge.
Easy Touch and Gesture Control (High sensitivity touch screen).
I'm going explain, how to config SQL Server Mail Service step by step
Step 01
Log in to SQL Server , Extract Management and Right click on Database Mail. Then select Configure Database Mail.
Step 02
Following window will appear , Then click Next button
Step 03
Select Set Up Database Mail by performing the Tasks and Click Next.
Step 04
If this feature disable , wizard will ask to enable it. So Enable it. Then below window will appear.
Enter Profile and Description and click ADD button on Right side.
Step 05
Here we have enter more detail. First enter Account Name and Description. Then enter SMTP mail server configurations .
email address
Display Name (optional)
Reply email (optional)
SMTP Server
Port Number ex- (25 ,457 ,587)
Select Basic Authentication under the SMTP Authentication. Then enter mail sending email account's Username and Password and click Add .
Step 06
Then window will appear. it shows your created profile and click Next.
Step 07
Then another window will , the Configure System Parameters description is shown.
Step 08
Then Click Next. It will show confirmation about your profile , so click Finish.
Step 09
Now SQL server was configured email service and click close .
Step 10
Run following SQL Query
sp_CONFIGURE 'show advanced', 1GORECONFIGUREGO
sp_CONFIGURE 'Database Mail XPs', 1GORECONFIGUREGO
How to test SQL Sever mail
Then again right click on Database Mail and select Send Test Email. Then select Database mail profile and enter receiver mail address , mail subject.
How to view Database Mail Log
Right click on the Database mail and select View Database Mail Log
Above two query will return date of Monday in current week ex -2017-06-12 . So if you want to get other days like Tuesday, Wednesdays etc of current week, you can simply change int value in function.
The HC-SR04 sensor use ultrasonic sound to determine distance to object. We can measure from 2cm to 400cm using HC-SR04 sensor. It operation is not affected by sunlight and black surface , but temperature and humidity can be affected to accuracy of reading. It also hard to detect soft material ex - cloth. HC-SR04 sensor has ultrasonic receiver and transmitter.Here, my goal is to help you to understand how this sensor works and program with arduino .
NOTE :- NewPing is a arduino library, that makes easier to use HC-SR04 with arduino.
HC-SR04 Ultrasonic sensor Technical Specification
HC-SR04
power supply :- 5DC
Quiescent Current :- 2mA
Working Current :-15mA
Effect Angle :<15 degrees
Distance :- 2cm to 400cm
Resolution :-0.3cm
Trigger input pulse width :-10us
Ultrasonic Frequency :-40KHz
Pins
VCC :- arduino 5v pin
TRIG :- arduino Digital pin
ECHO :- arduino Digital pin
GND :- arduino GND pin
TRIG pin will be used to send ultrasonic sound and ECHO pin will be used to listen.
Example
int triggerPin= 8; int echoPin= 7; long pulsDuration =0; long distanceCM =0; long distanceINC =0; void setup() { // put your setup code here, to run once: pinMode(triggerPin,OUTPUT); pinMode(echoPin,INPUT); Serial.begin(9600); } void loop() { // put your main code here, to run repeatedly: digitalWrite(triggerPin,LOW); delayMicroseconds(5); digitalWrite(triggerPin,HIGH); delayMicroseconds(10); digitalWrite(triggerPin,LOW);
FC-51 IR sensor module is a proximity sensor module. We can identify obstacle in front of sensor. So it has built in IR transmitter and IR receiver. It also has built in potentiometer to adjust distance rage. IR sensor module operate in 2cm-30cm range. FC-51 is compatible with Arduino.
Technical Specification
1. Operation Voltage - 3.3V - 5V
2. Detection Angle -35 degrees
3 Active Output level - Outputs Low logic level when obstacle is detected
4.Detection range: 2cm – 30cm (Adjustable using potentiometer)
PIN Out & In
1. VCC - 3.3V-5V DC power input
2. GND -0V Power pin
3. OUT - Digital Output Pin
Programming
There are may way to do it. So here i try to use IR sensor with Arduino Uno board. When obstacle is detected by sensor, it will generate LOW output, otherwise output is HIGH.
Example 1
int irSenRead =7; int isObstacle = HIGH; void setup() {
isObstacle = digitalRead(irSenRead); //// Read IR sensor output Serial.println(digitalRead(irSenRead)); //// print the output // // isObstacle ==low there is obstacle infront of sensor // // using serial monitor we can see this output if (isObstacle == LOW) { Serial.println("OBSTACLE"); } else { Serial.println("NO"); } delay(500); }
Example 2
In below code sample .LED bulb will be on when obstacle detected
int irSenRead =7; int LED=6; int isObstacle = HIGH; int delayRead =100; void setup() { pinMode(irSenRead ,INPUT); pinMode(LED ,OUTPUT); Serial.begin(9600); } void loop() { isObstacle = digitalRead(irSenRead); Serial.println(digitalRead(irSenRead)); // isObstacle ==low there is obstacle infront of sensor if (isObstacle == LOW) { digitalWrite(LED ,HIGH); } else { digitalWrite(LED ,LOW); } delay(delayRead); }
LEDs blink in a sequence with Arduino [Knight Rider]
We all remember TV-series from the 80's Knight Rider. So there was a car with LED flash. This time I used Arduino UNO board to program LED display, here I used 10 LED bulbs. There are many way to program micro chip in Arduino.
Sys.Sql_Modules return objects detail in Sql Server database. We can get detail about Stored Procedures, Replication filter procedure , Views , DML Triggers ,SQL Scalar Function ,SQL in line table, SQL Table value function ,Rules