Routing in ASP.NET 4.0 vs Routing in ASP.Net 3.5(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years ago

ASP.NET Routing allows us to define routing rules, which map a route pattern – such as Categories/CategoryName – to a class that handles the request. These routing rules are defined when the application starts, in Global.asax’s Application_Start event handler. In ASP.NET 3.5, we must create a route handler class, which passes information about the incoming request and returns an HTTP Handler to process the request. read more...

add a comment |category: ASP.NET |Views: 2

tags: ASP.NET another

[SQL Server Developer Tips] CTE (Common Table Expression)(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years ago

Purpose : A common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query. Unlike a derived table, a CTE can be self-referencing and can be referenced multiple times in the same query. Usage : A CTE can be used to: Create a recursive query. For more inform... read more...

add a comment |category: Database |Views: 7

tags: Database another

[C# Tips] Null Coalescing Operator (??)(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years ago

Purpose : It returns the left-hand operand if it is not null; otherwise it returns the right operand. Eg : int y = x ?? -1; // y = x, unless x is null, in which case y = -1. Remarks : Equivalent of If [...] read more...

add a comment |category: C# |Views: 11

tags: C# another

How to Create a Setup Package in Visual Studio .net(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years, 7 months ago

This article demonstratesHow to create a setup package(.msi file). How to place the files & folders in appropriate locations in the target machine,. Adding registry entry for the project Adding Custom File Types Adding Splash screen, Read-me screen, Confirm screen, License Agreement etc Adding Launch Conditions How to check if .NET Framework is installed in client machine and Various ways to install CLR(Common Language Runtime) in the client machine. How to write formulas to check for File existence, Registry entries & so on. How to Create a setup package read more...

add a comment |category: Visual Studio |Views: 13

tags: VisualStudio another

Steps to Create and Deploy SSIS Package as a SQLAgent Job(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years, 7 months ago

Microsoft says that SQL Server Integration Services (SSIS) “is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.” A simpler way to think of SSIS is that it’s the solution for automating SQL Server. SSIS provides a way to build packages made up of tasks that can move data around from place to place and alter it on the way. There are visual designers (hosted within Business Intelligence Development Studio) to help you build these packages as well as an API for programming SSIS objects from other applications. read more...

add a comment |category: Database |Views: 47

tags: Database another

Handling ASP.Net Controls in JavaScript(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years, 7 months ago

JavaScript tricks for ASP.Net developers Every ASP.Net site on the Internet has various user controls and almost every developer have to handle these controls in JavaScript. Most developers face problem finding these ASP.net user controls in JavaScript side. If you have ever wanted to handle ASP.Net controls in JavaScript, this article should help you get started and demystify what seems to be mysterious task. The following listing will be the agenda for this document.Why JavaScript for ASP.net developers is different? JavaScript tricks for ASP.net developers Reading ASP.net controls values from JavaScript Passing values calculated by JavaScript to the server side. Passing values from ASP.net to JavaScript Reading ASP.net controls values inside data grid from JavaScript Why JavaScript for ASP.net developers is different read more...

add a comment |category: ASP.NET |Views: 13

tags: ASP.NET another

Call ASP.net MVC Server side function using Jquery Ajax(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years, 7 months ago

Overview of Jquery Ajax Jquery API is extension of the JavaScript language. It supports methods which make it easy to write complex client side scripts. The creators of JQuery specifically created the library to make common tasks trivial. Ajax is key part of the websites now a days and asynchronous JavaScript is used widely to do Ajax calls. Jquery provides easy methods which can be used to call server side functions asynchronously without writing much code. Jquery Ajax Methods There are following methods in Jquery which can be used for calling server side functions through Ajax- jQuery. read more...

add a comment |category: ASP.NET |Views: 88

tags: ASP.NET another

Error while processing OLAP cube in SQL Analysis Services(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years, 8 months ago

This article describes the resolution for the issue that is faced while processing the OLAP cube in SQL Analysis Services. While processing the dimension in the cube sometimes the dimension gets hanged or it throws the error “– 2147221411: Process operation failed”. Problem Summary When you try to process the shared dimension of a OLAP cube in SQL Server 2000 Analysis server, It takes time for the dimension to get processed but after a long span of time also if the dimension does not get processed or ... read more...

add a comment |category: Database |Views: 13

tags: Database another

Microsoft SQL SERVER – Security(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years, 8 months ago

What are Builtin\Administrators? SQL Server creates a default NT Group login called Builtin\Administrators during installations.This login facilitates the following All local NT administrators on the server to have default sysadmin privileges Automatic access to system tables Automatic access to user tables How security is compromised? SQL Server security is compromised as follows Vulnerable to changes by local administrators by giving default sysadmin rights System and user database objects can be tampered, changed or deleted High chance of unknowingly deleting objects or critical data No restrictions for these users as they are by default sysadmins Business data can be compromised Auditing is very difficult as tracing these logins is a performance hit on the server Any unwanted hacker can gain access to SQL Server if he/she can get local administration rights Microsoft article – http://support.microsoft.com/kb/263712How to secure SQL Server from this login? read more...

add a comment |category: Database |Views: 4

tags: Database another

Consistency Errors in MS SQL Server 2000(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years, 8 months ago

Overview of Consistency Errors A DBCC CHECKDB statement may report consistency errors in your database when all the following conditions are true: SQL Server loads data into a column that is a sql_variant data type. The data originates in another column that is a sql_variant data type and at some point the data is sent on-the-wire by SQL Server. The data is sent either directly to another server that is running SQL Server or to an intermediate file. The sql_variant column contains numeric values. Here are some examples of statements that could cause this behavior: An INSERT SELECT statement that specifies a remote server in the FROM clause of the SELECT statement. A bcp or a BULK INSERT statement from a file that was originally created by a SELECT statement from SQL Server. A data load using Data Transformation Services. read more...

add a comment |category: Database |Views: 1

tags: Database another

Issues and Resolution while Migrating from DotNet Framework 1.1 to 2.0(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years, 8 months ago

Key Benefits * The new API gives a fine grain control on the behavior of the runtime with regards to multithreading, memory allocation, assembly loading and more. * To take advantage of better Debugging and error checking. * The ASP.NET 2.0 compiler automatically compiles application code and dependent resources when a request is made to a resource on your Web site. * In the ASP.NET page compilation model, code-behind files are compiled at run time into multiple assemblies on first request to the corresponding .aspx files. * Improved markup and code separation, reserved application folders, and automatic code compilation provided by .NET 2.0 framework. * The new code-behind model based on partial classes allows greater separation of markup and code, and removes the need for control declarations and event wire-up code in your code-behind files read more...

1 comment |category: C# |Views: 2

tags: C# another

ACID properties of transactions Atomicity – Either all modifications a(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years, 8 months ago

ACID properties of transactions Atomicity – Either all modifications are performed, or none Consistency – When completed, transactions leave all data and all related structures in a consistent state Isolation – Transactions don’t see other’s transaction’s uncompleted work (intermediate state) Durability – Transactions persist despite of syste read more...

add a comment |category: Database |Views: 2

tags: acid Properties Database another

SQL Server 2008 Concurrency Problems and Isolation(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years, 8 months ago

Concurrency problems SQL Server transaction isolation solves four major concurrency problems Dirty read occur when a reader reads uncommitted data Unrepeatable read occurs when existing row change within a transaction Lost updates occur when two writers modify the same piece of state Phantoms occur when new rows are added and appear within a transaction Locking strategies Optimistic concurrency read more...

add a comment |category: Database |Views: 3

tags: Database another

SQL Server 2008 Top New Features(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years, 8 months ago

Enterprise Data Platform Secure, trusted platform for your data Optimized and predictable system performance Productive policy-based management of your infrastructure Dynamic Development Accelerate your development with entities Synchronize your data from anywhere Beyond Relational Store and consume any type of data Deliver Location Intelligence within your applications Pervasive Insight Integrate all your data in the Enterprise Data Warehouse Reach all your users with scalable BI platform Empower every read more...

add a comment |category: Database |Views: 9

tags: Database another

BACKUP Compression in SQL Server 2008(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years, 8 months ago

Overview SQL Server 2008 has come up with inbuilt compression for backups. Until the release of SQL Server 2005, compression was only available via third party backup software such as SQL Lite Speed, SQL Zip, etc. Exercise Following is the simple example that demonstrates how to take Full, Differential and Transactional log backups with compression, without compression and how to enable compression as a default. read more...

add a comment |category: Database |Views: 5

tags: Database another

Troubleshooting Error The process cannot access the file because it i(technotes.towardsjob.com)

submitted by nitinkumarbe(175) 2 years, 8 months ago

You may come across the error “The process cannot access the file ‘abc.txt’ because it is being used by another process” while programming in DotNet environment. Usually this case occurs when you create a file and do some operation, before completion of the operation or if the file object is been available in memory and you try to either delete the file or rename or open using Read Write mode you will get this error. read more...

add a comment |category: C# |Views: 5

tags: C# another