Wednesday, April 17, 2013

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 

Wednesday, April 3, 2013

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

SQL CLR Vs T-SQL - Microsoft SQL Server

In this blog post, comparing the SQL CLR and T-SQL in Microsoft SQL Server

Attribute   T-SQL SQL CLR
 Code Execution




 Interpreted Compiled
 Code Model Set-Based Procedural-Based
 Access to subset of the .NET
Framework Base Class Libraries (BCL)
 No    Yes
 SQL Server Access  Direct Access In-Process Provider
 Support Complex types No Yes
 Parameter Support Input and Output
Parameters
 Input and Output
Parameters

SharePoint - SandBox solutions Vs Farm Solutions

In this blog post, documenting the quick notes that I made during my learnings on SharePoint SandBox solutions Vs Farm Solutions.

Farm Solution
  • Farm admin needs to deploy
  • Deploy WSP
    • Add WSP to Solution Store using AddSolution
    • Deploy Solution using solution store management page in Central Admin or through Powershell

Sandbox Solution
  • Site Collection Owner can deploy
  • Runs inside a secured monitored process
  • Have Limited Resource Access
  • When deployed will not show up in
    • GAC or in FileSystem
  • Deploy Sandbox solution to Site Collection
    • Site Settings --> Galleries - Solutions --> Upload
  • 14 hive --> UserCode
    • SPUCWorkerProcess.exe is where the Sandbox solution runs not inside the W3WP.exe
    • Web.config --> Trust Level defined as wss_sandbox
  • Central Admin
    • System Settings
      • Services --> Start --> MS SharePoint Foundation Sandboxed Code service
  • Configure Quotas and Locks
    • CA --> Application Management
  • Load Balancing
    • CA --> System Settings --> Manager User Solutions
  • Not allowed (Restrictions)
    • Objects over SPSite
    • SPSecurity (No Impersonation)
    • No FileSystem access
    • WebPart Communications not allowed (As WP comm uses Reflections internally)
  • Solution Validator
    • SPSolutionValidator
      • Using Microsoft.SharePoint.Administration;
      • Using Microsoft.SharePoint.UserCode;
  • Sandbox Solutions Full Trust Proxies
    • Instead use WCF service


Debugging SharePoint Solutions


In this blog post, summarizing quick hint of attach to process and debugging sharepoint solutions

  • Farm Solutions
    • Attach to process W3WP.exe
    • Attach to process OWSTimer.exe
  • Sandbox solutions
    • Attach to process SPUCWorkerProcess.exe
  • Client Side Code
    • Silverlight or Javascript
      • Attach to particular browser process
        • iexplore.exe