Database-Based Authentication for PHP Apps, Part 1
Managing secure access to Web pages and applications is a common problem. You want to enable those you trust to access data while preventing unauthorized ones from gaining access to it. In most cases, database-based authentication is the solution. Authentication systems contain an Access Control List (ACL) that lists your user credentials and matches them [...]
Introduction to database design
This article/tutorial will teach the basis of relational database design and explains how to make a good database design. It is a rather long text, but we advise to read all of it. Designing a database is in fact fairly easy, but there are a few rules to stick to. It is important to know [...]
3 Quick And Painless Ways To Fine Tune SQL Server Query Performance
Effective database design is an aspect often overlooked in application design phases. A flawed data model will lead to flawed transactions that could compromise your data as well as produce poor response times. There are many factors which affect the performance of your database ranging from hardware to good design. This article focuses on tips [...]
MySQL Security Tips
If you are a web developer or administrator, aside from administering your web server, you should also be administering your MySQL database in terms of security. This database is open source and is commonly used with the PHP web server scripting language; tons of useful applications are being developed with this kind of setup. This [...]
Build a .NET Application on the Oracle Database with Visual Studio 2005 or 2008
With the popularity of Microsoft's .NET Framework, many developers are hungry for information about the best means of integrating .NET applications with Oracle—not only in terms of basic connectivity, but also in relationship to effective and efficient application development using Visual Studio 2005 or 2008. In this article, I'll explain the basic yet essential processes [...]
How Data Access Code Affects Database Performance
There's been a consistent debate over whether query tuning, and database application performance tuning in general, is the province of the database administrator, the application developer, or both. The database administrator usually has access to more tools than the developer. The DBA can look at the performance monitor counters and dynamic management views, run SQL [...]
The SQL Server High Performance Series
Inefficiency is a gluttonous thief. It burglarizes your server rooms at all hours of the day and night, demanding virtually limitless hardware sacrifices to satiate its endless thirst for clock cycles and disk rotations. In return it punishes your users with reduced performance and reduced satisfaction, and devastates your solution's scalability.