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

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

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.

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 or TSQL? That is the question.

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

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

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.