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

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.