What is SCHEMABINDING?

SCHEMABINDING with a Query...

***Table***

CREATE TABLE Sampletbl ( col1 DATETIME ) 

***Data***

INSERT  INTO Sampletbl
VALUES  ( GETDATE() + 1 )

***Function***

CREATE FUNCTION SampleFunction ( )
RETURNS DATETIME
    WITH SCHEMABINDING
AS 
    BEGIN 

        DECLARE @t DATETIME

        SELECT  @t = col1
        FROM    dbo.Sampletbl

        RETURN @t

    END

MS SQL - Standby Servers and Types of Standby Servers

Standby servers - Standby Server is a type of server that can be brought online in a situation when Primary Server goes offline and application needs continuous (high) availability of the server. There is always a need to set up a mechanism where data and objects from primary server are moved to secondary (standby) server. This mechanism usually involves the process of moving backup from the primary server to the secondary server using T-SQL scripts. Often, database wizards are used to set up this process.

Languages for BI – MDX, DMX, XMLA

BI stands for Business Intelligence 

What languages BI uses to achieve the goal? 

MDX – Multidimensional Expressions. This language is used for retrieving data from SSAS cubes. It looks very similar to T-SQL, but it is very different in the areas of conceptualization and implementations.

DMX – Data Mining Extensions. This is again used for SSAS but rather than cubes it is used for data mining structures. This language is more complicated than MDX. Microsoft has provided lots of wizards in its BI tools, which further reduced experts for learning this language which deals with data mining structures.

XMLA – XML for Analysis. This is mainly used for SSAS administrative tasks. It is quite commonly used in administration tasks such as backup or restore database, copy and move database or learning meta data information. Again, MS BI tools provide lots of wizards for the same.

Android 5.0 Lollipop VS Android 4.4 Kitkat

The announcement of Android 5.0 Lollipop has, indeed, incorporated another achievement in the kitty of Android in terms of technological advancement. Android L is, certainly, considered to be one of the biggest updates by Android as of now due to the incredible changes and upgraded progressions. The new version of Android was announced recently at a conference in San Francisco with tons of changes, especially for developers. At present, it is available only in Google Nexus 6 and Google Nexus 9 tablet. However, there is a lot of chit-chat and gossip in the market about the features that both Kitkat and Android L provide to the users, and which is the best. Have a look at what more or less Android L is providing, and whether it is better than Android 4.4 Kitkat or not.