Tuesday, 16 June 2015

Full form of OTA

In area of Technology we use OTA for Over The Air programming or free-to-air. Sending software updates to mobiles, tablets, and laptops with the necessary settings with which to access services such as WAP or MMS. Some devices with this capability are labeled as being OTA capable.

In area of electronics full form of OTA is written as Operational Trans-conductance Amplifier.

In India, OTA is also expanded for the Officers Training Academy. OTA trains officers for the Short Service Commission. It is a Government of India establishment under Indian Army.

Contains: OTA meaning, OTA refers to, expand OTA, fullform of OTA

Moto X 1st Generation Users will get Android 5.1 Lollipop OS update soon

Moto X 1st Generation gksea images
According to sources, Moto X (1st Generation) owners will be receiving Android 5.1 Lollipop operating system update through OTA in the next couple of days. While Moto X 2nd Generation will get it later because of some technical issues.

Tuesday, 2 June 2015

Sneak peek into Windows 10

Windows 10 Image Rights: Microsoft

Rolling on years now Windows 10 is coming live on July 29, 2015. All Windows OS 7 or above versions will get free Windows 10 updates.
Lets look at the features that will be available in Windows 10:

1.The Start Menu is back
Windows 10 is having the things which are combination of windows 7 and windows 8 says a Microsoft Employee. So the start menu which you missed in Windows 8 is now back. You can see this in the image above.

2. Microsoft Edge
There will not be any Internet Explorer named entity but a new web browser from Microsoft that is Microsoft Edge. Edge was coded by the name Spartan. So previously people were thinking as of Microsoft will name it as Spartan but they did not do that and they announced Edge as the new browser.

3. Multi Doing
You can open up to four apps in a single view so that you are having your eyes on four together making things fast. Also there is a provision of creating virtual Desktop.

4. Windows Store
One place for buying  digital content including apps,games, music etc.

5.Cortana the digital personal assistant

6. Xbox the gaming application.

There will be many new features in the upcoming version of Windows. So lets wait for the upgrade.

Thanks for reading!

gksea.com Technology

Thursday, 28 May 2015

copy tables with data from Current Database to another database in SQL Server Sytax

Suppose you have a table with some data in a Database A and you want to copy this data to a table in Database B .

then you should use the following syntax:

USE DatabaseB;

INTO NewTable
FROM DatabaseA.Schemaname.OldTable
Here NewTable and OldTable are two similar tables in different databases.
While handling different databases we must use fully qualified names
 to reach correct tables.

SQL Query COUNT() function syntax

Suppose you have a table, now you want to know the number of records in it. Then COUNT function will do the job.


SELECT COUNT(ColumnName) from Table_NAME;

Suppose we have a table named Table_NAME
sql result image

Now if we run query     SELECT COUNT(ColumnName1) from Table_NAME;

Output = 4
 or if we run  SELECT COUNT(ColumnName3) from Table_NAME;

Output= 2
it means if we are running count on columns then it neglects the null value columns.

If you want to know the total number of records in a table then you can simply use
SELECT COUNT(*) from Table_NAME;

SQL Query Average function syntax

Scenario: Suppose you have a everyday sales table with you and you want to know the average sale happened on a day. Then using this function you can easily get this.

Syntax SELECT AVG(ColumnName) FROM table_name;

So lets suppose i have a 30 day sales data in the table named SALE. And there is a column SalesAmount which depicts the daily sale amount. and If we want to know the average sales happened in that month. We can easily get this using:


SQL query Syntax Select all record from table

If you want to select everything from a table then use the follwing syntax:

SELECT * FROM table_name;

Here table_name is the name of the table of which you want to select the records.

This is basically see all record / data query.

How to create table in SQL Server Management Studio using SQL query

In SQL Server Management Studio, Althogh there are many ways to create a table using GUI and using query written in SQL.
So simple SQL Query to create a table


CREATE TABLE table_name
column_name1 data_type(size),
column_name2 data_type(size),
column_name3 data_type(size),

for example: 
Create table Student(
StudentID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)

Wednesday, 27 May 2015

Fetching data from SSAS cube in MVC 4.5

I need data in my mvc app coming from SSAS cube. I am not able to open the data source connection. Firstly i was extracting it using SQLClient Data provider using a sqlconnection. I was thrown a error <{"Cannot open database \"DataBASENAME\" requested by the login. The login failed.\r\nLogin failed for user 'Domain\user'."}>
Then I changed my provider TO MSOLAP.5 in connection string. Then also i am getting same error. After a research I came to know that namespace Microsoft.AnalysisServices.AdomdClient is used while connecting to analysis database. But I am not able to get the dll for it to make it a reference.
Please suggest with an example how to get it done. Requirement is data from SSAS cube needs to be fetched on MVC Application. please tell the name space and connection string and data flow if ever handled such situation. Thanks in Advance.

A Reply for connection string From DevMitra:
Connection String must be 
<add name="ConnectionStringName" connectionString="Data Source=ServerOrMachineName;Initial Catalog=DatabaseName;" providerName="MSOLAP.4" />

this is the correct string while data is need to be fetched from Analysis Services.

How to make parse float function in javascript return two decimal places

What happens when you use parseFloat() in javascript.
If you pass 10 to this parseFloat() then the output comes is just 10 not 10.00
So if you want to have output to two decimal places that is 10.00
use following


What it return is actually a string of format(##.##) when we use .toFixed(2)

Convert a number to two decimal places in SQL Server Query

Many a times we get some number(float or double) from our sql query operation. But at the end we need a two decimal number. Then how can we achieve this