SQL Server Triggers
Triggers are stored procedures which are fired when data is modified in an underlying table.
Date: 2006-12-19
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.
Date: 2006-12-05
Using DataTables More For Improving Performance
There are some features in the System.Data.DataTable class that a lot of developers don't utilize. I base that statement on different code samples I've seen on blogs and article bases during the last couple of years. Some of these features can improve the performance.
Date: 2006-11-21
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.
It can be installed as a storage engine type on MySQL, and from what I hear can beat the pants off of MySQL's built-in full text search in some cases.
Date: 2006-11-07
Malicious Code Injection: Not Just For SQL Anymore
More and more, developers are becoming aware of the threats posed by malicious code, and SQL injection in particular, and by leaving code vulnerable to such attacks.
Date: 2006-10-24
What To Know About SQL Injection Attacks
Recently when going through some student projects on web design I came across codes similar to the following many times.
Date: 2006-10-10
CLR Vs T-SQL And Stored Procedures In SQL Server 2005
CLR or TSQL? That is the question.
Date: 2006-09-26
MySQL Gets Telecom-Specific
Due to demand, MySQL AB announced the expansion of its telecom-specific services
and consulting for MySQL software. Specifically, the company is promoting its
MySQL Cluster, a high-end version of the standard database designed for fault-tolerant,
mission-critical network and telecommunications applications at carrier-grade.
Date: 2006-09-19
Practice
Makes Perfect For SQL
Practice Makes Perfect For SQL
Date: 2006-09-12
Ingres Christens Project Icebreaker
The open source database company Ingres teamed with another open source player to deliver Icebreaker, a way to place database services on a server with no operating system required.
Date: 2006-08-29
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.
Date: 2006-08-15
Free VPN: Secure and extend your network
Every day it's getting easier for hackers to infiltrate, manipulate and steal your data. It's not because they're getting better at being mischievous — their tools are. And your tools need to start working harder to protect your data. They need to be more intimidating and resilient to attacks. That's where Rackspace and Cisco can help you.
Date: 2006-08-10
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.
Date: 2006-08-01
Your Old MySQL Needs An Update
Versions 3.23 and 4.0 of the popular open source database will soon reach their end-of-life dates this year.
Date: 2006-07-18
Industry leading management tools for your server
We're a service company that supports you, not just the technology we provide you — your devices, operating systems, data centers and network. It's a distinction that will change the way you do business every day. Our willingness to go above and beyond your expectations makes our SLAs, contracts and promises actually worth something. We call this kind of commitment Fanatical Support, and it's why our customers trust us to manage more than 20,000 servers.
Date: 2006-07-13
PHP Pagination With MySQL
It is extremely common these days to make results display across multiple pages. Some examples are maybe browsing through picture galleries, store products, blog entries, etc.
Date: 2006-06-20
MySQL Named As Possible Acquisition Target
As corporations continue to merge, sell out, and gobble each other up, analysts have identified the next likely targets in the software world: MySQL and Linux.
Date: 2006-06-06
How Bad Guys Hack Into Websites Using SQL Injection
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.
Date: 2006-05-23
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.
Date: 2006-05-09
Four solutions to data backup problems
Rackspace knows you grasp the importance of data backup. You don't need to hear doomsday scenarios and scare tactics. You need to hear solutions. And we offer you the solutions and expertise that no other managed hosting provider can.
Date: 2006-04-27
GData, MySQL, And The Future Of On-line Databases
In reading Richard MacManus' Why Google is extending RSS, I couldn't help feeling that he was missing the point a bit.
It's as if he was focusing on the small things ("Why RSS?") rather than looking at the bigger picture of where all this is going.
Date: 2006-04-25
MySQL, Oracle Agree On InnoDB Deal
A multiyear agreement
between Oracle and MySQL over the InnoDB storage engine license
should put an end to fears of a potential Oracle-fueled money
grab for MySQL's customers.
Date: 2006-04-11
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.
Date: 2006-03-28
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.
Date: 2006-03-14
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.
Date: 2006-03-07
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.
Date: 2006-02-14
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.
Date: 2006-01-24
Microsoft SQL 2000 Disaster Recovery
Designing a disaster recovery system requires planning and consideration of the available options that will best fit your company's needs, SLA and budget.
Date: 2006-01-10
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.
Date: 2006-01-03
|
