Skip to main content

Posts

Overview of SQL Background Processes

CMOS checksum error

If you are getting CMOS checksum erorr whenever your system is connected to internet it automatically gets off and restart but while restarting it shows you warning as "CMOS checksum error" CMOS time not set . Solution : Just replace the battery, start windows and change the date time to the current date time.

sql server 2008 r2 installation error on 64 bit

Dear friends , Please make your comment on following error  Error in installing Microsoft SQL Server 2008 R2 Enterprise on Windows Server 2008 Enterprise server R2,Always my all services is not running ,have done installation with repaired option but not able to solved this issue ,even in The installation of single computer mode of AX R2 ,Getting the error of SQL Server update SP1 because of this failed services. Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068578302 Exit facility code: 1204 Exit error code: 2 Exit message: Failed: see details below Start time: 2014-01-01 22:10:21 End time: 2014-01-01 22:23:58 Requested action: Repair Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140101_220847\Detail.txt Exception help link: http%3a%2f%2fgo.mi

Solve the simple square puzzle

Could you solve the simple square puzzle you have good logical mind if its true.

Namespace Definitions in ASP.Net

System- Provides base data types and almost 100 classes that deal with situations like exception handling, mathematical functions, and garbage collection. System.CodeDom Provides the classes needed to produce source files in all the .NET languages. System.Collections Provides access to collection classes such as lists, queues, bit arrays, hash tables, and dictionaries. System.ComponentModel Provides classes that are used to implement runtime and design-time behaviors of components and controls. System.Configuration Provides classes and interfaces that allow you to programmatically access the various configuration files that are on your system, such as the web.config and the machine.config files. System.Data Provides classes that allow data access and manipulation to SQL Server and OleDb data sources.These classes make up the ADO.NET architecture. System.Diagnostics Provides classes that allow you to debug and trace your application. There are classes to interact with event logs, perfo

Managed code execution process in .Net

Unified model on .Net framework

Types of application in dot net

Following list will give you an idea about various types of application that You can develop on .NET. 1. ASP.NET Web applications: These include dynamic and data driven browser based applications. 2. Windows Form based applications: These refer to traditional rich client applications. 3. Console applications: These refer to traditional DOS kind of applications like batch scripts. 4. Component Libraries: This refers to components that typically encapsulate some business logic. 5. Windows Custom Controls: As with traditional ActiveX controls, you can develop your own windows controls. 6. Web Custom Controls: The concept of custom controls can be extended to web applications allowing code reuse and modularization. 7. Web services: They are “web callable” functionality available via industry standards like HTTP, XML and SOAP. 8. Windows Services: They refer to applications that run as services in the background. They can be configured to start automatically when the system boots up.

Popular SQL subjects topics,keywords

sql aptitude questions and answers sqlauthority sql aggregat functions sql basic sql books sql commands sql cursor sql certification sql developer sql download sql dba sql express 2008 r2 sql examples sql formatter sql functions sql full form sql fiddle sql group by having sql get date sql guide sql helper class sql history sql interview questions and answers sql injection sql join sql keys sql keywords sql kill porcess sql knowledge sql loader sql like sql language sql managment stuido 2008,2012 sql means sql notes sql not in sql netowrk interfaces error 26 sql notes pdf sql online test sql order by sql operators sql plus download sql pdf sql profiler sql queries pdf,examples sql rowcount sql replace sql reporting services sql rank sql server 2008 sql tutorial pdf sql update sql union query sql unique sql version sql views sql vulnerable sites sql vs mysql sql w3schools sql wiki sql where sql workbench sql xml path,query,x

protocols used in current connection in sql server

To get details of protocols used in current connection in sql server you can execute following select query . You could know about Shared Memory,TCP/IP,Named Pipes,VIA (Virtual Interface Adaptor) on using below query. SELECT session_id,connection_id, connect_time, net_transport, net_packet_size, client_net_address FROM sys.dm_exec_connections