filter sql
WHERE convert (datetime, convert (varchar, datecol, 101), 101) = @yourdate
Best Interview Picks...
The Common Language Runtime
The CLR is a runtime execution engine of .NET that provides an environment to execute programs that are targeted at the .NET platform. It provides memory allocation, security, code verification, type verification, exception handling and garbage collection in the managed environment.
Strong Name
A Strong Name is a unique identifier given to an assembly using cryptography and a digital signature that is used to identify a particular assembly. An assembly is provided a strong name using the utility called sn.exe.
A strong name consists of the following.
· Name of the Assembly
· Digital Signature
· Version Number
· Culture Information
Global Assembly Cache
The Global Assembly Cache is a system wide storage of shared assemblies. Assemblies can be stored or moved to and from the Global Assembly Cache using a tool called GacUtil.
Satellite Assembly
When you wish to localize the application, it can be written in culture-neutral code and can distribute the localized modules in separate assemblies called satellite assemblies.
Assembly Manifest
The Assembly Manifest contains the information about an assembly. This includes the version number of the assembly, the list of the files that comprise the assembly, etc. An assembly manifest is contained in the dll file or the exe file itself.
Caching
Caching is a feature that stores the data in the memory for serving the incoming requests from the memory itself. Caching in ASP.NET can be of three types.
· Page Output Caching
· Page Fragment Caching
· Data Caching
Session State
A session is the period of a connection between a server and a client. The Session State allows storage of objects in a user’s session. A session can be stored in one of the following ways.
· InProc
· State Server
· SQL Server
Remoting
Remoting allows two processes, a Server and a Client, to inter-communicate in the same system, the same network or across networks. In Remoting, a server and client communicate using a Channel.
Biztalk Server
This is a set of Microsoft Server Applications that allow integration, automation and management of different server applications.
::: SharePoint Concepts :::
What is the concept of ghosting and unghosting in SharePoint?
ghosted pages :::
In SharePoint most of the site pages derive from templates. The custom pages only store the difference between them. The template is loaded in memory and applied to the custom pages on fly. In other words the template is stored in a cache. This definitely brings in performance and flexibility. Flexibility is in terms that when we change the template page it's applied to all custom pages. These pages are loaded from the file system. So pages which are loaded from the file system are termed as ghosted pages.
If the page data is loaded from the content database it's termed as unghosted pages.
Steps to building custom service application
Development tasks
create service application
create service application endpoint(WCF)
create service application installers
create service application proxy
create service application proxy installers
create service application consumers
ConfigureBCS
Steps to Configure BCS in sharepoint2010
========================================
1. Configure the site in sharepoint designer2010
2. select external content type from site objects
3. press add connection button and set up the external data source and select whatever the operation types which related to the datatable
4. press save button to upload content to the sharepoint server
5. from the site select external list under the list collection
Backup & Restore site collection
Backup & Restore site collection
================================
Backup ->
Can use -> Perform a site collection backup under Granular Backup or SharePoint 2010 management shell
Restore ->
SharePoint2010 management shell Only.
Cmd:
restore-spsite -identity "http://win-b9m88cn17s2" -path "C:\_backUPs\siteCollection.bak" -force
Subscribe to:
Posts (Atom)