Ashwini`s TechNet
Search this site
Home
My Tech Blog
Tool & Frameworks
CURL
Directory Monitor
ELMAH
My Refreshers
My Books
My Favorite Links
Under Development Pages
Content Index
Home
1.Topics
Architecture
A.Getting Started
B.OOP Core Concepts
C.Object Oriented Principles (OOP)
A.Open Close Principle (OCP)
B.Single Responsibility Principle(SRP)
C.Don`t Repeat yourself (DRY)
E.Liskov's Substitution Principle(LSP)
F.Interface Segregation Principle (ISP)
G.Dependency Inversion Principle (DIP)
H.Principle of Least Knowledge (LoD)
I.Hollywood principle
J.SOLID Principle
D.OOAD
Patterns
a.Design Patterns
A.Design Pattern Summary
B.Creational Patterns
A.Singleton Pattern
B.Factory Pattern
C.Inversion of control (IOC)
D.Dependency Injection (DI)
E.Service locator pattern
F.Builder Pattern
G.Prototype
H.Object Pool
C.Structural Patterns
A.Adapter Pattern
B.Bridge
C.Composite
D.Decorator
E.Interception pattern
F.Proxy Pattern
G.Facade
H.Property Map Pattern
I.Fly Weight Pattern
J.Private Class Data
K.Value Object
L.Money Pattern
M.Special Case
N.Null Object Pattern
D.Behavioral Patterns
Chain of Responsibility (COR) Pattern
Command Pattern
Event Aggregator
Interpreter Pattern
Iterator Pattern
Mediator Pattern
Memento Pattern
Observer Pattern
State (objects for states)Pattern
Strategy Pattern
Template Method Pattern
Visitor Pattern
b.Application Patterns
a.Generic Base Patterns
Mapper Pattern
Separated Interface Pattern
b.Domain Logic Patterns
a.Transaction Script
b.Table Module
c.Domain Model
d.Service Layer
c.Data Access Patterns
a.Active Record Pattern
b.Row Data Gateway Pattern
c.Table Data Gateway Pattern
d.Data Mapper Pattern
e.Record Set Pattern
ORM Patterns
a.Behavioral ORM Patterns
a.Unit of Work Pattern
b.Identity Map
c.Lazy Load
b.Structural ORM Patterns
a.Identity Field
b.Foreign Key Mapping
c.Association Table Mapping
d.Dependent Mapping
e.Embedded Value
f.Serialized LOB
g.Single Table Inheritance
h.Class Table Inheritance
i.Concrete Table Inheritance Pattern
j.Inheritance Mappers
c.Metadata ORM Patterns
a.Metadata Mapping Pattern
b.Query Object Pattern
c.Repository Pattern
d.Presentation Patterns
Client Presentation Patterns
a.Separated Presentation Pattern
Presentation Model Pattern
Supervising Controller
b.MV-VM Pattern
c.Model View Controller (MVC)
Web Presentation Patterns
a.Model-View-Presenter (MVP)
b.Application Controller
c.Model View Controller2 (MVC2)
d.Page Controller
e.Front Controller
f.Intercepting Filter
g.Template View Pattern
h.Transform View Pattern
i.Two-Step View
e.Distribution Patterns
a.Remote Facade Pattern
b.Data Transfer Object (DTO) Pattern
f.Integration Patterns
Gateway Pattern
Pipe and Filter Pattern
Registry Pattern
Service Stub
g.Offline Concurrency Patterns
a.Optimistic Offline Lock Pattern
b.Pessimistic Offline Lock Pattern
c.Coarse Grained Lock Pattern
d.Implicit Lock Pattern
i.Session State Patterns
a.Client Session State Pattern
b.Server Session State Pattern
c.Database Session State
j.Extensibility patterns
Object Assembler Pattern
Plugin Pattern
c.Deployments Patterns
Layer Facade
Layer Supertype
Layered Application
Tiered Distribution
d.Programming Patterns
Aspect Oriented Programming (AOP)
Async Programming Model (APM)
Complex Event Processing (CEP)
Event Programming Model (EPM)
Task-based Async Pattern (TAP)
e.SOA Design Patterns
Enterprise Service Bus
Service Facade
Trusted Facade Pattern
Cloud Computing
A-Introduction to Cloud
B-Microsoft Cloud Platform
C-Getting Started
D-Most Frequently Asked Question
Top Tools for Azure
Domain Analysis
E-learning
A:eLearning Overview
B:System Components
C:mLearning
D:Industry Standards
E:Well Known Solutions
References and Dwonloads
Z:Case Studies
Dot.Net
A.Framework Fundamentals
A.Version History
Z.Dot Net Framework FAQ
B.C# Language
C# FAQ
Code Contract
LINQ
LINQ to ADO.NET
LINQ to DataSet
LINQ to Entities
LINQ to SQL
LINQ to Events(Rx/CEP)
LINQ to Objects
LINQ to XML
C.ASP.NET
A.ASP.Net (Web Forms)
A.Versions
B.Architecture
C.User Interface
Configuration
D.Ajax
E.Security Architecture
F.ASP.Net Performance Optimization
G.ASP.Net Caching
H.ASP.Net Diagnostics
Y.Best Practices
Z.ASP.Net FAQ
B.ASP.Net (MVC)
A.Versions History
ASP.Net MVC Security
B.Getting Started
C.Architecture
Design Patterns
Hybrid Websites
MVC Localization
MVC Mobile
MVC Tools and Frameworks
Performance Optimization
Routing Advance Concepts
Y.Best Practices
Z.ASP.Net MVC FAQ
C.ASP.NET Web API
D.WCF
A.WCF Overview
B.WCF SOAP
C.WCF REST
D.WCF Hosting
F.WCF Extensibility
G.WCF Transactions
H.WCF-Security
I.WCF Advance Topics
Y.WCF Data Service
Z.WCF RIA Services
E.Entity Framework
F.WPF
G.Silverlight
H.Workflow Foundation (WF)
WF VS Rule Engine
I.AOP Framework(Ent. Lib.)
A.Quick Overview
Tips and Tricks
Unity Block
J.Extension Frameowrks
Managed Add-in Framework(MAF)
Managed Extensibility Framework(MEF)
Sync Framework
Mobile Development
Responsive Web
a. Getting Started
Key Concepts
Responsive Best Pratices
Responsive Frameworks
Bootstrap
Salesforce Platform
A.Overview
B.Architecture
SOA
Single Sign -On
SOA Fundamental
SQL Server
1.DML Statements
2.Integrity Concepts
3.Indexes
4.Triggers
5.Transaction and Concurrency
StreamInsight
Testing
Pex and Moles(Whitebox Testing)
Spec Explorer
Threading & Async Programming
A-Async Terminologies
B-Architectural Consideration
C-Asynchronous Approachs
D-Synchronization Constructs
E-Async Design Patterns
F-Async Programming Patterns
G-Application Threading Models
H-Async Programming Models
I-Exception Handling Considerations
J-Most Frequently Asked Questions
Web Devlopment
JQuery
JQuery Mobile
Node JS
Prototype js
Responsive Web Design (RWD)
2.What Is New
Entity Framework (1 - 4.5)
HTML5
MSSQL
MSSQL 2005
MSSQL 2008
MSSQL 2008R2
MSSQL 2012
Visual Studio
VS2011
WCF Data Service
3.Best Practices
C# Programming Fundamentals
EF Best Practices
MS SQL Server Best Practices
WCF Data Service
4.Case Studies
Threading Case Studies
FAQS
Architecture General
Entity Framework FAQ
HTML-CSS
IIS FAQ
SQL Server FAQs
WCF (SOAP) FAQ
WCF Data (OData) Service FAQ
My Tech Space
My Books
My Favorite Links
My Forums
CodePlex
Microsoft Connect
MSDN Code Gallery
My MSDN Forum
Silverlight (MSDN)
My Refreshers
Tool & Frameworks
ASP.NET MiniProfiler
CURL
Directory Monitor
DirectoryMonitor
Dotfuscator
ELMAH
Fiddler
Frameworks
AutoMapper : Unit Test Helper
Bootstrap : CSS Framework
ELMHA: No Code Diagnostics Framework
IE9IFY: IE9 UX Helpers
Knockout.js : Client Side Data Binding Framework
Modernizr:Backward Compt Framework for HTML5 and CSS3
Mustache.js: Client Side Templating Framework
MVC Controls Toolkit : Advance UI Controls Framework
MvcContrib : MVC Extensions
NuGet: VS Package Manager
Should : Unit Test Helper (Assert Lib)
SpecFlow : TDD Framework
StructureMap : IOC Framework
WebGrease: Bundling and Minification Framework
Glimpse
ILSpy
ReSharper
Soap & Load UI
StyleCop
Wireshark
Sitemap
Site owners
Ashwini Kumar Singh
Ashwini Kumar Singh
FAQS
>
SQL Server FAQs
What is Linked Server Feature in SQL Server
References
Consolidated FAQ from SQLAuthority.com
http://www.pinaldave.com/sql-download/SQLServer2008InterviewQuestionsAnswers.pdf