Follow WebProNews
Yahoo Adds Capabilities to YQL

Last year, Yahoo debuted its YQL language, which lets users query, filter, and join data across web data sources or services on the web. YQL or Yahoo Query Language is based on a SQL-like language, and it helps apps run faster with fewer lines of code.

Today, Yahoo announced a new feature for YQL, and that is the Insert/Update/Delete feature. A spokesperson for Yahoo tells WebProNews this extends the platform by adding “write" capability to its capabilities, including YQL Open Data Tables and Execute."

Convert a MySQL Injection Script for Use in Microsoft SQL Server

MySQL Server is the most widely used database management system in the world, primarily because it is open source and free.

SQL Server Triggers
· 1

Triggers are stored procedures which are fired when data is modified in an underlying table.

SQL Server 2000 Data Types

SQL Server requires that each variable and column in a table should be defined with respect to the type of data it will store.

Web App Vulnerabilities Over Buffer Overflows

This should be an eye opener to many. In September Mitre reported that web application vulnerabilities are claiming the top three spots on their CVE request list, beating out Buffer Overflows.

Open Source SQL Full Text Search Engine – Sphinx

I came across Sphinx via the MySQL Performance Blog (which has some good entries you might want to check out). It is an Open Source Full Text SQL Search Engine.

CLR vs T-SQL and Stored Procedures in SQL Server 2005

CLR or TSQL? That is the question.

Practice Makes Perfect For SQL

MySQL guru Sheeri Kritzer listed eight SQL best practices for database professionals who are hard at work on their projects.

MySQL Turbo Manager and Dream Coder

The success and the longevity of any prominent business nowadays depend on powerful application infrastructures and effective, reliable management and development solutions.

SQL Replication

Database management systems are very important for business today. Whether your application has a network access to all employees in your organization or whether it’s a web application.

When Should You Use Microsoft SQL Server Over Microsoft Access?
· 9

Two of the coolest tools that have ever come out from Microsoft are certainly Microsoft SQL Server and Microsoft Access.

How Bad Guys Hack into Websites Using SQL Injection
· 26

SQL Injection is one of the most common security vulnerabilities on the web. Here I’ll try to explain in detail these kinds of vulnerabilities with examples of bugs in PHP and possible solutions.

Developers Spoiled For Free DB Choices

It is not just MySQL or PostgreSQL offering freely available databases, as Oracle, Microsoft, and IBM all want to hook developers on lite versions of their products.

SQL Server Indexes

A database index is similar to an index in a book – it is comprised of a lookup value, and a number identifier that corresponds to the row number in a table.

SQL Server Stored Procedures

SQL Server Stored Procedures are SQL statements saved in a database as an object. They can be called interactively through the Query Analyzer, and by other stored procedures.

Oracle Produces Oracle SQL Developer

The kids out in Redwood Shores announced a new product called SQL developer, known previously as Project Raptor. The product is a free database development tool designed for use by Oracle Database developers.

SQL Injections Abound

Danish security firm Secunia reported on Monday several moderately critical vulnerabilities in various software products that allow SQL injection attacks. Products like Gregarius, Total Ecommerce, Akarrus Social Bookmarking Engine and others.

Protecting Against SQL Injection With PHP And MYSQL

Security is important for all developers, but more so when combining two of the most popular Database and Web Programming technologies.

SQL Injection Vulnerability

A vulnerability was discovered in the ADOdb and can be exploited by hackers doing SQL injection attacks. The vulnerability only works on the PostgreSQL users. Andy Staudacher discovered the vulnerability and Secunia reported the issue as moderately critical on Tuesday.

Microsoft SQL 2000 Disaster Recovery with SANRAD V-Switch – Planning Guide

Designing a disaster recovery system requires planning and consideration of the available options that will best fit your company’s needs, SLA and budget.

MS SQL / MySQL – A Case Study

The release of Microsoft SQL Server 2005 on November 7th 2005 created a buzz around the office for IT professionals.

Understanding SQL Web Hosting

Before understanding the concept of SQL web hosting, it’s necessary to have a basic grasp on what SQL is, and also how web hosting works.