Posts

Showing posts with the label WindowsAzure

Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

Windows Azure Cloud computing top points you need to learn now

Image
Interestingly, Windows Azure is an open platform that will support both Microsoft and non-Microsoft languages and environments. Basically Windows Azure is Cloud computing To build applications and services on Windows Azure, developers can use their existing Microsoft® Visual Studio® 2008 expertise. What is Azure Windows Azure is not grid computing, packaged software, or a standard hosting service. It is an integrated development, service hosting and management environment maintained at Microsoft data centers. The environment includes a robust and efficient core of compute and simple storage capabilities and support for a rich variety of development tools and protocols. Jon Brodkin of Network World quotes Tim O'Brien, senior director of Microsoft's Platform Strategy Group, as saying that Microsoft's Windows Azure and Amazon's Elastic Compute Cloud tackle two very different cloud computing technology problems today, but are destined to emulate each other over ti