So if you are following the Droid Razr HD / Vanquish / Fighter a.k.a XT926 fiasco chances are you know that few days ago the Droid RAZR HD has passed the
Federal Communications Commission (FCC) which means that the release date is fast approaching.
if you did not know, then now you know!
What you do not know probably is its battery capacity, many people speculated that it will have the same battery life as Motorola DROID RAZR MAXX (3300 mAh) .. unfortunatly that is not going to happen according the FCC reveleaed specs, … the device will feature a 2530 mAh battery (exact model number is SNN5915A)
That is a little disappointing, but the battery should still prove that it is good combined with the efficient s4 processor.
exact info can be found in the Portable Cellular Phone SAR Test Report.
Well I am kind of sure anyone dealing with database queries must have come across this problem
You need a list (or better said) table of Dates between two dates (start date, end date ) that you have
Well usually you will be handling this using loops, coursers to do your operation row by row for each date between start date and end date,
While playing around I just found another way(I feel it is better way)
The Better way
Just found out that TSQL (since SQL SERVER 2005) new keyword is introduced WITH and it is used to created temporary table !
So why don’t we create a temp table using WITH that has dates between my start date and end date
Here is how
declare @start datetime
with alldates as
select @start DateVal
select DateVal + 1
where DateVal + 1 <= @end
This will list down dates
Well doing that will gave me all dates within my start date and end date
but still there is some problems with the WITH keyword (it could be better in SQL SERVER 2008) in SQL SERVER 2005 you can’t use it in complicated query
Simple enough what I did currently is I can get the start date and the end date from another table by sql query , so I created a view that that uses the mighty WITH and creates dynamic list of dates between two dates in different table (note: this code is written as if the T_Period table has only one row, in case there were more rows a where condition could have been added like where PeriodToUse=1
WITH alldates AS
(SELECT period_start AS DateVal
SELECT alldates_2.DateVal + 1 AS Expr1
FROM alldates AS alldates_2
(alldates_2.DateVal+ 1 <=
(select period_end from dbo.T_Period)
FROM alldates AS alldates_1
Just got an idea to find out what are the databases used by the big heads in IT these days
Had a small search and found out the following
Google uses BigTable database(created by google)
Twitter uses MYSQL as database ! [I think they moved to some NOSQL kind of DBMS now]
Facebook uses MYSQL as database ! [I think they moved to some NOSQL kind of DBMS now]
( at least these two were using MYSQL the days the article I just read about them were writtern)
Well ok we understand the case for google it for sure needs a really extraordinary DBMS that can handle its unique requirements, but what about twitter and facebook!
These two giants have that huge data , and really fast growing database, with huge audience accessing and updating these database rapidly.
It really shows how much power an opensource DBMS like MYSQL can provide and again raises the question why many companies in our part of the world insist their DBMS must be either Oracle or Microsofts’ SQLSERVER !!! while 99% of the companies around here will never require more than the amount of data, number of users, powerfull security that MYSQL provides to Facebook and twitter.
What is the problem with the decisions of these companies ?! if you know the answer please let me know in the comment
The Asus Transformer TF101 is one of the most inticipated android tablets for this year with its Tegra2 processor … however the (more) special thing about the transformer is its form factor, its a normal 10.1 inches android tablet … but with a little twist, you could combine it with a keyboard dock, which will then transform your tablet into a netbook – hence the name “transformer” – the keyboard not only provides you with a full qwerty physical keyboar, it provides 2 USB ports, HDMI port, SD Card slot …. AND it (the dock) can charge your tablet and prolong your tablet’s battery life to up to juicy 16 hours (as Asus claim) … pretty neat eh?
Rest of the specs can be found here
Now you would probably say “so what? .. i have a small netbook with a keyboard” .. but let me tell you something, the experience of having a touch screen + keyboard at the same time is extraordinarily, …. especially in browsing, …. ever navigated to a website and then u saw a link and you got lazy to move your hands on the mouse and point at the link and click? .. well all those steps can be done by you “poking” the actual link on the screen, and then continue with the keyboard … the experience is much more rich than that, but thats what i could think of right now.
I have had the transformer for 2 days now, everything run smooth,
the only things that i have problems with are I have ZERO problems with the transformer right now! … the solutions came pretty fast.
Android Market: Good god android market for honeycomb devices seems a beta product to me! 90% of the apps in the android market fail to install on my device (free and paid alike) gives me an error “this item cannot be installed in your country“! what is interesting is, i have an HTC desire with stock android 2.2 and it runs the market perfectly and i can download free and paid apps without any problem, so whats with the transformer? i dont know you tell me … i have sent a ticket to Asus and Android and I am yet to get a useful reply for my query. Scratch that!!! I am able to download apps from the market now without any annoying error messages !
The promised Android Honeycomb 3.1 still has not reached my transformer? even though that world wide it has been announced that the upate has been rolled. scratch that, i just received the Honeycomb 3.1 official OTA update from Asus, … the first problem still persist though
Asus transformer is a truly a “game transformer” … It has set a new standard, specially with its form factor. after using the transformer, its very hard for me to imagine using just a plain “tablet” .. Asus did very well with this product.
Over all, ….
excluding the Android Market issue (which i believe only people outside the US and Europe encounter this) the Transformer experience is really a nice one, and if you are going for a tablet nowadays, … you definitely can NOT go wrong with the Asus Transformer.
If you have any questions or comments about the Asus Transformer, let me know.
Updates: My two problems has been solved (within two days from reporting it!), i dunno wither its just my luck or i pushed Google or Asus to fix it, .. but I am a happy camper nowRead More
Google has decided to dip its toe in the water and now the +1 button is available for publishers, bloggers and basically everyone to put on their websites.
The button, as you may remember, was found only on the Google’s search results page, but as it turns out the search giant is taking it one step further. Rather than waiting for you to search a page, figure it’s useful and then “+1″ it, Google lets publishers take the initiative and allow people to recommend their website right on it.
In order to use it, though, you will have to allow it from your Google’s account settings. You will only see your friends’ recommendations if you have opted for it, so don’t forget to put a check next to it.
Google has now put the “+1 button” on Android’s Market website as well, so give it enough time and we should see if the recommended apps are the most downloaded ones. We too have placed a “+1″ here in our blog so if you feel a post may be useful to others just hit the new button.
Smart phone apps are the new hot thing in the horizon, all technology entrepreneur are thinking to move their business (partially , or clone) from web or desktop to smart phones. Well that not something no one was expecting but until iPhone come to the world people were thinking it will be on Nokia’s Symbian phones anyone remember (S60).
Well once iPhone came many developer looked at it as a big possibility, but there were limitations in the initial IOS version ,in wireless mobile data connections (no 3g or very expensive) , in development support (less APIs , limit programming in Objective C) , in features of hardware.
But in that time another giant was looking at it also as a big possibility, but why don’t we make the possibility in our own way, and why not make it bigger wider and better! , that giant was Google, and here was the birth of Android.
Having these two super powerful operating systems for smart phones(IOS & Android) now it is the time for innovation and there are lots of innovators creating great really great apps and games for these devices that will one day be with each and every human being .
As OmanDev.NET we decided two things
- As bloggers we will be addressing these innovators of new world and will be reviewing them and their apps & games
- As programmers we should start contributing to the world with our ideas our innovations (so wish us luck , or better lend us a helpful hand)