Architecture of your version of Windows platform. How to find ?

How to find the architecture of your version of Windows platform?

Use the following command in the Command Prompt:

C:> wmic os get osarchitecture

Output:

OSArchitecture

64-bit

How to disable password expiration for a local user

This blog post describes (one of the way) steps required to disable password expiration for a local user.

1.) Start an elevated command prompt 
-- Start --> Run --> C:\windows\system32\cmd.exe
-- then right click, 'run as administrator' (accept if any UAC dialog appears for permissions)

2.) Execute the following command into the command window:

wmic path Win32_UserAccount WHERE Name='testlocaluser' set PasswordExpires=false

Microsoft HDInsight Public Preview - Setting up Hadoop cluster on Windows Azure

 Windows Azure HDInsight public preview announced on https://HadoopOnAzure.com



I was an existing HadoopOnAzure.com beta users so signing up with already signed up live account



Requesting for creating new cluster



Sample request form for cluster creation on HDInsight


After click on "Request Cluster" button on right bottom corner of web interface



Hadoop Cluster creation in progress



Hadoop cluster created and in Running status.



After clicking on "Go to Cluster" link under Cluster URL section in screenshot above.
- we see the cluster information screen as below.



Configure Ports (ODBC server)



Configure Ports (ODBC server)



Sample HDInsight Hadoop cluster NameNode Remote Desktop RDP connection file content



Connecting Remotely to NameNode desktop through RDP



Sample My Computer - Explorer view of the NameNode hadoop cluster created.



Local user "bphdinsight" created with what we provided under cluster login section during requesting form submission for hadoop cluster creation.



Remote Desktop view


Sample preview of setup version of builds available on Hadoop Cluster 

Google BigQuery Vs HDInsight - Comparison

Comparison	Google BigQuery	Windows Azure HDInsight
Pricing	•https://cloud.google.com/pricing/big-query •https://developers.google.com/bigquery/pricing	•http://www.windowsazure.com/en-us/pricing/details/hdinsight/
	BigQuery uses a columnar data structure, which means that for a given query, you are only charged for data processed in each column, not the entire table. Note: The first 100GB of data processed per month is at no charge. Only 2 pricing components (query processing, storage)	Priced based on the configuration of Hadoop cluster and storage configuration.
Storage Options	Data can be loaded directly to Tables in BigQuery project. Note: Recommendation -to load data files first to Google Cloud Storage and then load data to BigQuery tables. -Max 4 GB per file -Max 100 GB per load -Max 1000 files per load	HDInsight provides two options for storing data •Windows Azure Blob Storage and •Hadoop Distributed File system (HDFS)
Data Formats	BigQuery supports two schema types: A flat schema in CSV or newline-delimited JSON format. A nested/repeated schema in newline-delimited JSON format.	Supports unstructured data formats
Performance	Very fast in response for the query submitted	Slow in response (waited for several minutes to hours to complete to provide required output)
Best Practices	BigQuery Data Strategies and Best Practices •https://developers.google.com/bigquery/articles/ingestionbestpractices	Big Data Solutions on Windows Azure •http://wag.codeplex.com/releases/view/103405 •http://wag.codeplex.com/

Google Glass APIs for Developer Preview

Google Glass APIs available for Developer's Preview

Official documentation: https://developers.google.com/glass
API and starter projects: https://developers.google.com/glass/downloads
Playground (card simulator): https://developers.google.com/glass/playground

Knockout.js overview

Knockout.js javascript library helps to build dynamic, data-centric user interfaces.

Foundation for the Knockout.js library

• MVVM --> The Model-View-ViewModel design pattern, 
• Observables, and 
• Bindings

Observables
- Knockout.js uses observables to expose & track a ViewModel’s properties

• Computed Observables
• helps to create properties that are dynamically generated.
• Observable Arrays
• helps native Javascript Arrays with power of Knockout.js observables

 Bindings
- Helps to connect a user interface HTMLcomponent in the view to a particular observable.

Begin learning about Knockout.js from this Step-by-Step link
- http://learn.knockoutjs.com/#/?tutorial=intro
- http://knockoutjs.com/

MapReduce Design Patterns

• Summarization patterns: get a top-level view by summarizing and grouping data
• Filtering patterns: view data subsets such as records generated from one user
• Data organization patterns: reorganize data to work with other systems, or to make MapReduce analysis easier
• Join patterns: analyze different datasets together to discover interesting relationships
• Metapatterns: piece together several patterns to solve multi-stage problems, or to perform several analytics in the same job
• Input and output patterns: customize the way you use Hadoop to load or store data 

Key SQL CLR Decisions - Microsoft SQL Server

Key SQL CLR Decisions
# Using SQL CLR or T-SQL
# Using SQL CLR or Extended Stored Procedures
# Using SQL CLR or OLE Automation Procedures
# Using the Data Tier or Application Tier for Business Logic

SQL CLR Barriers of Entry
# Security Considerations
# The DBA Perspective on SQL CLR
# Implementation Considerations
# Performance Considerations
# Maintenance Considerations

Required Namespaces for SQL CLR Objects
There are four namespaces required to support the creation of SQL CLR objects. The required namespaces
are:
❑ System.Data
❑ System.Data.Sql
❑ System.Data.SqlTypes
❑ Microsoft.SqlServer.Server