Profile

Cover photo
Philipp Kanne
1,074 followers|198,329 views
AboutPosts

Stream

Philipp Kanne

Shared publicly  - 
 
Did you ever heard about the "Cardinality Estimation" Problem using #SQL Server? Did you ever had the feeling your application uses a wrong, poor execution plan?

Then this is yours: https://technet.microsoft.com/en-us/library/ms181034(v=sql.105).aspx

Our problem was an implicit cast between varchar and nvarchar fields, causing low query performance. Using the SSMS the execution plan shows costs of ~3 - same query executed through the application uses a plan of ~5800 resulting in heavy io consumption.

1
Add a comment...

Philipp Kanne

Shared publicly  - 
 
Today my new #naze32 - #Rcexplorer frame arrived. I had problems to run the controller under linux. Cleanflight always showed "Failed to open serial port".

Here is my solution
1. Check dmesg for "cp210x converter now attached to ttyUSB0"
2. if not available you have to install the driver, it's included in kernel 3.13.x and above
3. Check the permission, echo > /dev/ttyUSB0
If it fails, change permissions
sudo adduser <MyUser> dialout
sudo chmod a+rw /dev/ttyUSB0

Done!
1
Add a comment...

Philipp Kanne

Shared publicly  - 
 
Back in the sky - and down to earth :(
I had some connectivity problems with the yaw-motor, above 20m high the yaw lost the signal. This was again a hard touchdown.

Back to hangar ...
1
Add a comment...

Philipp Kanne

Shared publicly  - 
 
I received my brand new spare parts from china. In a few days im ready to fly again!!
1
Add a comment...

Philipp Kanne

Shared publicly  - 
 
Started optimizing the #KK2 parameters. I've found a very interesting video
1
Add a comment...

Philipp Kanne

Shared publicly  - 
 
Today i had to upgrade #kibana 4.0.x to 4.1.x release. How to transfer all dashboards, visualizations and settings? This helped a lot: http://air.ghost.io/kibana-4-export-and-import-visualizations-and-dashboards/
Kibana 4.0.0 does not allow you to save and load JSON visualizations and dashboards through its interface, Kibana 3 had an option to do this. This missing feature is planned to be part of the Kibana 4.1....
1
Add a comment...

Philipp Kanne

Shared publicly  - 
 
Tricopter repaired!
I've successfully repaired my tricopter yesterday. I had to change two motor axles after my hard touchdown. Meanwhile i've ordered Davids super-duper brandnew, super simple #yaw mechanism. It's really neat!

To enter next level, i've ordered #fpv equipment today.
1
Add a comment...

Philipp Kanne

Shared publicly  - 
 
Yesterday it happend, i smashed my #tricopter down to earth. I was flying about 15meters high and then i lost control. The result: one motor axle is out of shape, two propellers are broken, the yaw mechanism is totally damaged.

I was happy to see there are spare parts available for the motor. So i ordered a new axle from china. I hope it will arrive soon.

Maybe its time for a new version of the #yaw mechanism? I think a yaw with zipties is more resistant - as David already said ;)
1
Add a comment...

Philipp Kanne

Shared publicly  - 
 
2nd tricopter build!

Today i've done my 2nd #tricopter build. It's based on Davids 2.6HV design, http://rcexplorer.se/projects/2012/07/the-tricopter-v2-6hv/. Last year i did the first, but after the yaw mechanism broke apart i've finished this hobby for a while ;)

After spending some time for redesign, it's done:
- A brand new yaw mechanism
- Simplified vibration damper system

Parts list
- Front booms are made of beech, 13mm², 35cm
- Rear boom is 13mm², 38cm
- SunnySky 2216 880KV
- HobbyKing 20A Ubec, SimonK
- KK2.0, FW 1.6
- 10x4,7" Props
- Spektrum Dx6i
- Savöx SH-0255MG
- XT60 connectors
- 2200mAh 3S

The yaw mechanism is based on David's original design - without the direct connection to the servo. I had some trouble with it, after 20 liftoffs the gear broke. I decided to build another yaw - with indirect control.
2
Add a comment...
Story
Tagline
Me.
Links
Basic Information
Gender
Male