Overview SQL injection is a type of web application security vulnerability whereby an attacker supplies malicious data to the application, tricking it into executing unanticipated SQL commands on the server. These attacks are fairly easy to prevent, but they’re also both common and pernicious because they allow attackers to run database commands directly against the [...]
Tags: ASP.Net Vulnerability, LINQ, SQL Attack, SQL Injection and LINQ, SQL Injection Attack, SQL Injection in ASP.Net
DB2 Error: SQL1263N Description : The archive file name is not a valid log file for database name on node node-number. Explanation: The specified archive log file exists in the database log directory or the overflow log directory on the specified node, but the file is not valid. Roll-forward recovery processing stops. Solution: To determine [...]
DB2 Error: SQL0161N Description : The resulting row of the insert or update operation does not conform to the view definition. Explanation: The WITH CHECK OPTION clause was specified in the view definition that is the object of the insert or update operation or a FROM clause specified an insert or update operation with a [...]
DD statements define the data sets that a program or procedure uses when it runs. Each data set requires one DD statement. The order of DD statements within a job step is not usually significant. A DD statement describes a data set extensively, and can include the following information: The name that the program uses [...]
Tags: Introduction to JCL, JCL Training, JCL Tutorial, Job Control Language
We might have seen the error “Cannot install SQL Server cluster on a computer that runs Microsoft Windows Server 2003 “ during the process of SQL Server Installation in Windows Server 2003. Let us discus why we get the error and how to recover from the error Problem Description You cannot install SQL Server cluster [...]
Tags: sql server 2000, sql server error, terminal server, windows server 2003
SQL Compare is a Data comparison and synchronization tool from Redgate, This is an effective tool for SQL developers, Test Engineers and SQL DBAs to accomplish their task. The specialty of the software is that it can be used with live database, Database Snapshots as well as SQL Scripts. Some of the identical features of [...]
Tags: SQL Compare, SQL Server Compare Tool, SQL Server Synchronize Tool
PostgreSQL 9.0 has added the features that have been requested for years, such as easy-to-use replication, a mass permission-changing facility, and anonymous code blocks. While past major releases have been conservative in their scope, this release shows a bold new desire to provide facilities that new and existing users of PostgreSQL will embrace.
This is an easy error to make. If you’re used other languages before, such as Pascal, you’ll realize just how poor a choice this was by the language’s designers. In Pascal, for example, we use the := operator for assignment, and leave = for comparison. This looks like a throwback to C/C++, from which Java [...]
When you try to install an instance of Microsoft SQL Server 2000 virtual server on the failover cluster nodes that are running Microsoft Windows Server 2003, you may notice that the SQL Server 2000 virtual server installation is not completed successfully. Additionally, you may receive the following error message: “An error occurred while creating virtual [...]
Tags: sql server 2000, SQL Server Installaion Error, SQL Server Virtual Installaion, windows server 2003
As your WPF projects grow larger, you’re going to start to get a lot of resources and you’ll need to move them out of "App.xaml" (which, while we’re on the subject, I always rename to "Application.xaml"). But how do you organize them? Here’s what I use. 1. Structuring Resources I think there are two different [...]
Tags: DotNet 3.5, Resource Organization, WPF, WPF Coding Standards
Resource Organization in WPF
ASP.Net 4.0 | View State Performance Enhancement
Use C# to create LINQ to SQL 2008 Entities
[C# Tips] Null Coalescing Operator (??)
DotNet Interview Questions – Part 3
Asp.net 4.0 Webform Features
[C# Tips] Flags Attribute – Enums
ASP.Net Developers Checklist – Security Checklist
[ADO.Net Tips]Transaction Scope
Use of Bulk Bind to reduce loop overhead In PL/SQL – Part 1
Oracle Interview Questions | What is a view?
About Blocking Locks in Oracle database – Part 2
About Blocking Locks in Oracle database – Part 1
Oracle Interview Questions | What is a cursor?
Oracle Interview Questions | What is a sequence?
Oracle Interview Questions | What is referential integrity?
Oracle PL/SQL: Declaring Variables
SQL TIP – Select the second max value from the table
Java Interview Questions and Answers – Part 7
Java Interview Questions and Answers Part 1
Java Developers Forgetting that Java is zero-indexed
Java Interview Questions and Answers – Part 5
Java Programming Best Practice Writing blank exception handlers
How to avoid Null pointers Error while coding Java programs
Java Interview Questions and Answers – Part 9
Java Interview Questions and Answers – Part 2
Java Interview Questions and Answers – Part 8
SQL Compare – Compare and Synchronize tool for SQL Server Database
Error while installing the SQL Server 2000 Virtual Instance
An Introduction to Microsoft SQL Server 2008 – Part 1
SQL Server Interview Questions – Part 1
Clustered and NonClustered Index in SQL Server
Backup SQL Server database using T-SQL
[SQL Tips] SET vs SELECT in Sql Server
Uninstall SQL Server 2005 instance manually
Index page in SQL Server
