Database

TwitterFacebook
Get flash to fully experience Pearltrees

SQL Injection Cheat Sheet

http://ferruh.mavituna.com/sql-injection-cheatsheet-oku/ Find and exploit SQL Injections with free Netsparker SQL Injection Scanner SQL Injection Cheat Sheet, Document Version 1.4 About SQL Injection Cheat Sheet Currently only for MySQL and Microsoft SQL Server, some ORACLE and some PostgreSQL . Most of samples are not correct for every single situation. Most of the real world environments may change because of parenthesis, different code bases and unexpected, strange SQL sentences.
The goal of this page — which is a work in progress — is to gather information relevant for people who are porting SQL from one product to another and/or are interested in possibilities and limits of 'cross-product' SQL. The following tables compare how different DBMS products handle various SQL (and related) features. If possible, the tables also state how the implementations should do things, according to the SQL standard. I will only write about subjects that I've worked with personally, or subjects which I anticipate to find use for in the near future. Subjects on which there are no significant implementation variances are not covered. Beta-versions of software are not examined. http://troels.arvin.dk/db/rdbms/

Comparison of different SQL implementations

Best practices to improve performance in JDBC

Best practices to improve performance in JDBC This topic illustrates the best practices to improve performance in JDBC with the following sections: Overview of JDBC JDBC defines how a Java program can communicate with a database. http://www.precisejava.com/javaperf/j2ee/JDBC.htm
All the tips provided on this website about indexing are general guidelines .

General Tips on Optimizing SQL Server Indexes

http://www.sql-server-performance.com/2007/optimizing-indexes-general/

SQL Server Indexes

Relational databases like SQL Server use indexes to find data quickly when a query is processed. Creating and removing indexes from a database schema will rarely result in changes to an application's code; indexes operate 'behind the scenes' in support of the database engine. However, creating the proper index can drastically increase the performance of an application. http://odetocode.com/Articles/70.aspx
https://www.simple-talk.com/sql/learn-sql-server/sql-server-index-basics/ Given the fundamental importance of indexes in databases, it always comes as a surprise how often the proper design of indexes is neglected. It often turns out that the programmer understands detail, but not the broad picture of what indexes do. Bob Sheldon comes to the rescue with a simple guide that serves either to remind or educate us all!

SQL Server Index Basics

Connection String Syntax

The value of a keyword must be specified as a string. http://msdn.microsoft.com/en-us/library/windows/desktop/ms722656(v=vs.85).aspx
http://www.techrepublic.com/article/sql-basics-query-multiple-tables/1050307

SQL basics: Query multiple tables

The TechRepublic CIO50 list celebrates the most influential and innovative tech chiefs, voted by their fellow CIOs
MySQL

Visual FoxPro

SQL Server

Oracle

SQLite

Tutorials and Tips