Android Development Notes

Android Development Screen shots Notes, showing my settings, and most especially space costs on my dual OS laptop.

I dual boot into Windows 10 or  Ubuntu 16 on my laptop, l find the later faster and more Android sdk development simpler since l have to disable Hyper-V which l need on Windows 10 if l setup my full Android development on it – including emulator for testing.

Note, the complete tools below l chose and use take a lot of space. In my case, 30Gb, so plan accordingly.

Choice of SDK platforms.

My current phone is the LGG5 – running Android 7.0, however l also own an older Nexus 6 [no sim card/wireless plan] which l use for Android development testing running Android 7.1.1 [google nexus phones get the latest android releases frirst, unfortunately at least the nexus 6P not 6 is required for Android Oreo/8] 🙁 , and one of my target platform is Ikechukwu’s older samsung galaxy tablet which runs Android lollipop 5.0.1

I also chose Android MM – Marshmellow 6.0.1 since l have a tester using that version residing in Jos/Lagos on his phone – onijec [click here for his twitter link].

I want to test developing a small birthday countdown app for Ikechukwu, see if this works on multiple Android versions, test and use my google developer account/playstore and non playstore app distribution – before diving into more deep stuff like geo location based apps l am more interested in.

 

 

Microsoft Certified Technology Specialist: Sql Server 2008…

mctsrgb

Passed my Microsoft Cerfification Exam on first attempt on Tuesday June 2nd! Score: 814

The certificate says l’m now recognized as a MCTS – Microsoft Certified Technology Specialist: SQL Server 2008, Implementation and Maintenance. The exam is the MCTS 70-432. Next goal is the 70-450 which has no study book in print, and the only material l can find so far is the CBT-NUGGETS training video on Exam 70-450 which is very good.

Materials l used to study other than multiple SQL Server instances on my laptop, Virtual PC Windows 2008 Machines with SQL Server 2008 installed – for database replication, mirroring and failover clustering practise!!!
– MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 – Implementation and Maintenance by Mike Hotek (Very good, in-depth all round material, lab oriented book with real life stories). This seems to be the only main book out there.
– Self Test Software for MCTS 70-432, bought the download version of this excellent practise test program.
– Microsoft Sql Server 2008 Books on line (download the latest update from Microsoft)
– Took the official Microsoft 6231 course at SQLSoft (Beaverton)
– Books on Microsoft SQL Server 2005 exam 70-431

Microsoft Sql Server Administration…

Useful commands I’ve found from various sources for Microsoft Sql Server 2005/2008 include:

EXEC sp_configure
GO
–Instance level principals.
SELECT * FROM sys.asymmetric_keys
SELECT * FROM sys.certificates
SELECT * FROM sys.credentials
SELECT * FROM sys.linked_logins
SELECT * FROM sys.remote_logins
SELECT * FROM sys.server_principals
SELECT * FROM sys.server_role_members
SELECT * FROM sys.sql_logins
SELECT * FROM sys.endpoints
GO

–Database level principals.
SELECT * FROM sys.database_principals
SELECT * FROM sys.database_role_members
GO
ALTER LOGIN sa WITH NAME = hiddenSaAccount
GO
–Check your user execution context
SELECT SUSER_SNAME(), USER_NAME()
GO
–View the list of objects in the database
SELECT * FROM sys.objects
GO
–Change user context
EXECUTE AS USER = ‘AnotherUserName’
GO
–Return to your login
REVERT
GO
–explore database files
select * from AdventureWorks.sys.database_files
select * from master.sys.database_files
select * from msdb.sys.database_files
select * from tempdb.sys.database_files
–explore endpoints
select * from sys.endpoints
select * from sys.tcp_endpoints
select * from sys.http_endpoints
select * from sys.database_mirroring_endpoints
select * from sys.service_broker_endpoints

–Security

SELECT * FROM sys.symmetric_keys
GO

SELECT * FROM sys.certificates
GO

Build your own Virtual World…

Check out this amazing video – World Builder by Bruce Branit Some day l guess we might be building entire cities virtually like this, walk through them and then create them. Beats a 3D object molder.

Heres a direct link to the quicktime .mov file for faster viewing on your PC. [ Right click, save as, download]

Network Addressed Storage.. [NAS]

Looking for a NAS, with gigabit interface (l’m done with slow access speeds via usb interface to my internal gigabit network) so as to speed up my rendering server farm file access, and expandable with support for additional sata drives and affordable. Finally settled for the DLINK DNS-321 for $130 and bought just one 1Tb SATA drive that was on sale for $87 – a Samsung 10,000rpm 32Mb buffer drive. As sata drives fall in price and l get more bang for a buck l can add to this unit. I can mirror a drive, but the unit doesnt support ntfs etc – which is fine for me since my shared files on this will be media files, mp3 and rendered jpeg pictures. It has a web interface control and can be accessed remotely via ftp anywhere on the net. This system is built on a GPL / Linux based system, and will format your drive to ext2 format. There might be a hack out there for a more native windows file system support.

Update: 5/14/09. I’m returning this item. The file transfer time to and fro ext2 to my ntfs formatted drives is so so slow, about 10-20x (even by Windows wrong estimates). The gigabit connectivity makes no noticable difference, even when on the same Cisco 5 port Gigabit switch as my server. I’ve ended up overloading my faithful dell sc430 server by “creatively” adding this 1Tb drive to it, the server is designed to support only 2 sata hard drives. See picture below.

capture_dns321_300

dns-321_main

capture_dns001

See this website on links for DNS-321 NAS Hacking

dellsc430

Microsoft Hyper-V…

Using Windows 2008 Server Operating system, this allows you to create a server based virtualized computing platform.

  • An x64-based processor. Hyper-V is available in x64-based versions of Windows Server 2008—specifically, the x64-based versions of Windows Server 2008 Standard, Windows Server 2008 Enterprise, and Windows Server 2008 Datacenter.
  • Hardware-assisted virtualization. This is available in processors that include a virtualization option; specifically, Intel VT or AMD Virtualization (AMD-V).
  • Hardware Data Execution Protection (DEP) must be available and be enabled. Specifically, you must enable Intel XD bit (execute disable bit) or AMD NX bit (no execute bit).
  • An applicable example is the Intel XEON E5430 Quad core CPU

Good microsoft setup link here.

This week 04252009….

Got a good deal on an executive chair with good back support (really need it) from Office Depot – seems tons of items are marked for clearance. They may be closing soon some say…

Cant wait to see the movie X-Men: Origins Wolverine which comes out on 5/1/2009 [USA] He is my favorite character of them all.

4-25-2009-10-21-34-pm

Update on Wolverine 5/14/2009:

Amazed to find out the african city where the x-men travel to is LAGOS, NIGERIA !! Also guess what, my tribe [ibo] seem to be [according to the movie] the source of adamantium – the core metal used to make Wolverine invincible – hmm, wonder why l’m not. Sad – my tribesmen and women get wiped out in the movie, such is how most tales mentioning africa go. For more upbeat fealing, listen to Akons Africa song.
Installed Ubuntu 9.04, this install went flawlessly on my HP laptop as well as the updates, wireless card support and nvidia video card support.  To get ubuntu to run/play DVD’s, mp3, quicktime, windows media files etc – run:
sudo apt-get install ubuntu-restricted-extra

Finally gave up on working on my stop and go, 2 year old lawn mower – had a choice between a basic new push mower for 149 and and electric (no gas, no fumes etc) mower for 50 more, went for the second. Seems the old one may have some rusts parts in it, and l’ve done the drain fuel/dis-assemble/assemble routine one too many times as well as some creative engineering for the pull rope to work. Now if only l could afford a robot lawn mower and gardner….

NBA: Saw Yao Ming of the Houston rockets at the Starbucks – Pioneer square early last week. He’s 7’6″ and had to bend down to get out of the door. We werent allowed to take pictures, besides seems no one was crazy to see him given that Houston beat the Portland TrailBlazers on the 1st playoff games. Sucks – SAS lost today to Dallas. Hope the Blazers win the next game against Houston. Here are some pictures l took at the Rip City Party on the Portland Blazers getting into the playoffs. Didnt get pictures of the players while at a meeting for work.

Posted pictures l captured as l used 3Ds max 2009 with V-ray at this link.

Benchmarking my system using Maxon Cinebench R10

My results: OpenGL test – 2868, single CPU 2692, Multiple CPU render test: 9374.

Internet Explorer 8….

Installed this on my laptop and workstation.
I visited Wellsfargo online banking and immediately got a warning that it only supports the older browser, IE7 or Firefox 3. I could not go on further, and either have to use firefox which l have installed or re-install IE7.
Then l remembered that IE8 offers a compatibility mode, so l simply added wellsfargo.com to my list of sites under this option and bingo – it worked! l could use the banks website from IE8!

World Community Grid…

Please join my team. African3

Current statistics:

wcg_3_25_2009

World Community Grid’s mission is to create the largest public computing grid benefiting humanity.

as of 5/11/2010

World Community Grid Points = 9,056,280

Results returned = 16,351

As of 3/25/2009
World community Grid total credits = 808,331 and SETI@home credits = 103,712

5/15/2009

WorldCommunity Grid
6/20/07 – Current  8:211:02:54:27  5,922,916  11,246

SETI
Total credit 158,259
Recent average credit 1,035.21

Total credit 158,259
Recent average credit 1,035.21