Tech and Work: 2013

Sitecore,
Umbraco,
Orchard,
Sitefinity
CrowdCMS,
Kentico,
DotNetNuke (DNN),
N2

Free Tutorials
http://stackoverflow.com/questions/5602715/sitecore-tutorials
http://learnsitecore.cmsuniverse.net/en/GlobalNavigation/Sitecore-beginners-guide.aspx

dreamfarmer邀请您访问新足迹
http://www.oursteps.com.au/bbs/?fromuser=dreamfarmer

Tuesday, November 12, 2013

.NET Framework

.NET Family

ASP.NET + MVC
WCF
WPF + SilverLight
WWF
LightSwitch
Sharepoint
CRM
BuziTalk
WinRT

Development Guide
****
http://msdn.microsoft.com/en-us/library/hh156542(v=vs.110).aspx

The new features of .NET 4.5

http://msdn.microsoft.com/en-us/library/ms171868%28v=vs.110%29.aspx

Details
https://www.simple-talk.com/dotnet/visual-studio/the-new-features-in-c4.0/

Named and Optional Parameters
Dynamic Support
Variance
COM Interop

C# 5.0 new features

Parallel and Async
MSDN - Best Practices
http://msdn.microsoft.com/en-us/magazine/jj991977.aspx

Architecture
http://msdn.microsoft.com/en-us/library/dd460693%28v=vs.110%29.aspx
http://msdn.microsoft.com/en-us/magazine/cc163340.aspx

[Useful Components]

Network
http://eex.codeplex.com/documentation

SimpleMembershipProvider
http://weiyuenetdev.blogspot.com.au/

Thursday, November 7, 2013

Dev Ops

Dev Ops - Requirement

* Consult and advise clients and teams on Amazon Web Services

* Lead and support the Solution Architect on the logical and physical infrastructure

* Lead and mentor others in the use of infrastructure automation

* Assist and work on setting up Continuous Integration

* Help the Solution Architect choose the right solutions to aid in scalability & security

* Continue to help push the edge of Continuous Delivery across all Scrum teams and with DevOps colleagues

You must have:

* 1-2+ years experience in a DevOps role or equivalent

* Solid understanding of IP networking

* Strong knowledge and experience with Linux (CentOS and Debian based)

* Hands-on knowledge of automation on AWS with Puppet/Chef

* Engineering background (focus on performance optimisation)

Bonus criteria that will make you stand out:

* Having written and executed load & stress tests

* Previous work in an Agile company

* Monitoring with Nagios/Icinga

* Any Windows administration skills

Tuesday, November 5, 2013

Shortcuts

Firefox
Ctrl+U - view page source
Ctrl+H - histroy
Ctrl+J - downloads
Ctrl+L - Address bar
Ctrl+K - Search bar
F12 - Firebug

Windows Explore
Alt+D - Highlight address bar

Windows
Win+L - Lock screen

UltraEdit
See https://sites.google.com/site/weiyuenet/developer/tools/ultraedit

Entity Framework

Tutorials
http://www.entityframeworktutorial.net/code-first/configure-classes-in-code-first.aspx
http://msdn.microsoft.com/en-us/data/ee712907.aspx#getstarted

EF6 and Procedures
http://www.dotnetcurry.com/showarticle.aspx?ID=938

MySQL Support
http://dev.mysql.com/doc/refman/4.1/en/connector-net-entityframework60.html

Monday, November 4, 2013

WPF

Tutorials
http://wpftutorial.net/DependencyProperties.html

MVVM
http://msdn.microsoft.com/en-us/magazine/dd419663.aspx

Prism
http://msdn.microsoft.com/en-us/magazine/cc785479.aspx
http://msdn.microsoft.com/en-us/library/gg405471%28v=pandp.40%29.aspx

Samples
http://msdn.microsoft.com/en-us/library/ms771633%28v=vs.85%29.aspx

Control Customization
http://msdn.microsoft.com/en-us/library/ms745025.aspx

Free Resources (CodePlex and CodeProject)
Theme
http://elysium.asvishnyakov.com/en/downloads

Sunday, November 3, 2013

SSRS

Dev setup

Visual Studio 2012 - How
http://gauravmahajan.net/2013/03/22/build-ssrs-reports-using-visual-studio-2012/

Tuesday, October 29, 2013

Cloud Stuff

Free hosting
http://www.windowsazure.com/en-us/develop/net/aspnet/?WT.mc_id=A5A71FF5F

AWS Services

EC2
S3
RDS
SNS
SQS

Monday, October 28, 2013

ASP.NET MVC

Best Practice

Put validation logic to "view model" instead of your business model - Link
Automapper improve productivity but slow, use with care
Entity Framework Patterns - Link1 Link2

Security tips for security (ref link )

Anti-Forgery-Token (attribute) on the login page
Slow all authentication attempts down by at least a second (makes brute force impractical)
Implement an account lock out procedure on n amounts of invalid logons
Always use a generic error message on your failed logins to prevent hackers knowing which part of a login is wrong
Always encrypt your passwords in the db with a salt, the salt should be per user to prevent a rainbow attack on a stolen database
Always make sure that any data displayed or retrieved is valid for that user
Always use parameterised sql
Try and obfuscate the ids passed around in your urls and views to prevent modification or an attempt at a direct reference attack

Components

Elmah
Glimpse
Ninject (https://github.com/ninject/ninject/wiki/_pages)
WebMatrix - SimpleMembershipProvider
WebActivator
OAuth
EntityFramework
Javascript Libs

JQuery UI
Kendo UI
http://www.nuget.org/packages/Google.DiffMatchPatch.Js/
Knockout
Backbone

Bundle

Concepts

Routing
ViewModel
Validation
Model Binder
Bundle
Partial View
Child Action
Filter
View Engine
Controller Factory

Questions and Answers

http://www.codeproject.com/Articles/639717/MVC-Interview-Questions-and-Answers-All-about-MVC

Thursday, October 24, 2013

Some guys

Great developers
http://www.andyhawthorne.co.uk/about/

6 Steps

To learn a programming language or a technology, I can follow the 6 steps:

Architecture
Dev Environment Setup and Sample Projects
Basic Features
Advance Features
Tools, Books, Videos
Real world Projects (Learning by doing)

The 6 things or steps to become an effective developer.

Saturday, October 19, 2013

Job Interviews

Questions

All Technical Interviews
http://www.indiabix.com/technical/interview-questions-and-answers/
http://www.pcds.co.in/

Generic Programming Skills

Client side performance improvement
OOP and OOAD
CSS inline width and hight
ER diagram
UML diagram
Design API
Patterns

Project Related

Git - difference between pull and rebase

Generic Front-end

Mobile 300ms delay - Solution
HTTP Status Code
HTTP Methods

ASP.NET MVC

MVC globalization, and differences with traditional ASP.NET

*JavaScript

Javascript OO Features

Backbone.js
Angular.js
Knockout.js

Database

SQL interview Q&A http://blog.sqlauthority.com/sql-server-interview-questions-and-answers/
SQL server performance tuning (http://www.mssqltips.com/sqlservertip/1429/sql-server-dba-performance-tuning-interview-questions/ )

Non-Technical Questions:

Talk about yourself.
What are things you don't like to be a front-end developer.
What's your weakness?
Why do you leave your company?

Job Sites and Resources

SEEK
CareerOne

DBA - MS SQL Server

Become The DBA
http://www.johnsansom.com/how-to-become-a-sql-server-dba/
http://www.idevelopment.info/

Database Documents
MySQL - http://dev.mysql.com/doc/index-topic.html
SQL Server - http://www.microsoft.com/en-us/sqlserver/default.aspx
Oracle Database - http://www.oracle.com/us/products/database/overview/index.html

DBA
http://www.mssqltips.com/sql-server-tip-category/53/dba-best-practices/
[SQL Job] http://www.mssqltips.com/sqlservertip/2561/querying-sql-server-agent-job-information/

Tutorials
http://www.studytonight.com/dbms/er-diagram.php
Locking - Pessimistic and Optimistic locking in .NET
http://www.codeproject.com/Articles/114262/ways-of-doing-locking-in-NET-Pessimistic-and-opt

Sites
http://sqlfool.com
e.g. http://sqlfool.com/2011/06/index-defrag-script-v4-1/

All samples (sample database, project, etc..)
http://sqlserversamples.codeplex.com/

CLR and Aggregate function

Syntax
Union and Union All - Union All allows duplicates, but Union will remove duplicated rows.

Cluster and Non-Cluster Index

http://stackoverflow.com/questions/91688/what-are-the-differences-between-a-clustered-and-a-non-clustered-index

Clustered indexes are stored physically on the table. This means they are the fastest and you can only have one clustered index per table.

Non-clustered indexes are stored separately, and you can have as many as you want.

The best option is to set your clustered index on the most used unique column, usually the PK.

A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore, the table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.

A non-clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a non-clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows. (Read more here)

SQL Server Optimization
http://technet.microsoft.com/en-us/library/aa964133%28v=sql.90%29.aspx

Thursday, October 17, 2013

Asynchronous Functions c#

Asynchronous Functions

await Task.Delay (5000);

Site Performance and Scalability

REDIS
http://highscalability.com/blog/2014/9/8/how-twitter-uses-redis-to-scale-105tb-ram-39mm-qps-10000-ins.html

Still good to read:

Scale up and Scale out
http://www.codinghorror.com/blog/2009/06/scaling-up-vs-scaling-out-hidden-costs.html

Performance - Good Start:
http://stackoverflow.com/questions/2246251/how-to-improve-asp-net-mvc-application-performance

Integration Test
For web applications, the most common approach to integration testing is UI automation. This term
refers to simulating or automating a web browser to exercise the application’s entire technology stack by
reproducing the actions that a user would perform, such as clicking buttons, following links, and
submitting forms.
The following are the two best-known open source browser automation options for .NET
developers:
• Selenium RC (http://seleniumhq.org/), which consists of a Java “server”
application that can send automation commands to Internet Explorer, Firefox,
Safari, or Opera, plus clients for .NET, Python, Ruby, and multiple others so that
you can write test scripts in the language of your choice. Selenium is powerful and
mature; its only drawback is that you have to run its Java server.
• WatiN (http://watin.sourceforge.net/), a .NET library that can send automation
commands to Internet Explorer or Firefox. Its API isn’t as powerful as Selenium,
but it comfortably handles most common scenarios and is easy to set up (you
need to reference only a single dynamic-link library).

View
In the view, you can access WebPageRenderingBase directly, e.g. get user name - @User.Identity.Name

Server Debugging Tools

Dumpchk - check dump
winDbg - hang or crash
vmMap - memory leaking
Fuslogvm - assembly binding (Link)

Wednesday, October 16, 2013

Visual Studio - The Best IDE for .NET

Plugin

Resharper

Extension

Flow
JSLint
AWS
Azure
PHP (https://visualstudiogallery.msdn.microsoft.com/8292e47d-8ed2-48cb-9ebd-064e0b7891cf)

Analyze

Profiling
Load Testing

NuGet
Template
Team Foundation
MSBuild

Increase VS Memory:
http://old.stevenharman.net/blog/archive/2008/04/29/hacking-visual-studio-to-use-more-than-2gigabytes-of-memory.aspx