SQLManager: SQL Articles

Window Functions in Firebird 3 (part2) - cumulative aggregates

Another article about the specifics of using the window functions support in Firebird 3.

Replacing MEMORY storage engine with MySQL Cluster

The article discusses using MySQL Cluster as an alternative to the MySQL MEMORY storage engine.

Encrypting PostgreSQL data with pgcrypto

In this article we'll go over the basics built-in and the more advanced provided by the PostgreSQL contrib module pgcrypto.

A Practical Guide to Adopting an Open Source Database for Enterprise IT Use

Trends & Applications: The article discusses the drivers and benefits of using open source database management systems in the enterprise.

MERGE Your DML Statements in SQL Server 2008

MERGE is a new statement introduced in the SQL:2003 standard for performing multiple DML (Data Manipulation Language) statements against a target table at once. In this article we’ll look into ways to take advantage of this powerful addition to SQL.

Oracle Database Partitions - Partition Virtually

Save space by deactivating index partitions, and use virtual columns to partition more logically.

Regular Expressions in PostgreSQL

This article highlights the methods of using regular expressions in PostgreSQL SQL statements.

Window Functions in Firebird 3

One of the Firebird Core Developers has published some information about the implementation of the OVER function in Firebird 3.

Validating MySQL data entry with triggers: A quick look at the SIGNAL syntax

MySQL 5.5 New Features: support for an ANSI/ISO standard SIGNAL syntax.

How to identify unused indexes in DB2 for Linux, UNIX, and Windows

Get to know different approaches for determining indexes never or rarely used by database queries.

Replicate down or up-level - your choice

The article discusses the replication with different versions of SQL Server.

Scripting Oracle RMAN Commands

Learn how to create and automate scripts to execute common recovery tasks.

A first look at Microsoft SQL Server 2008 R2

Read the following article for an overview of the benefits, new features and improvements to expect with SQL Server 2008 R2.

10+ tips for working smarter with SQL

Whether you use SQL a lot or sparingly, working smarter with SQL will help you avoid errors and improve performance.

Get rid of those NOLOCK hints

This article discusses the use of various techniques to reduce the negative impact of the data locking issues.

Focus on Files and Filegroups

Don’t create too many files in your database in an effort to improve performance

Optimizing the MySQL Query Cache

Keeping MySQL's query cache optimized and used efficiently can make a big difference in the overall throughput of your application.

SQL Server 2008 Express Editions

SQL Server 2008 Express provides developers with high-end database features that enables developers to create powerful databases for Windows and the Web.

Transparent Data Encryption: Experience from the Trenches

Introduced as part of the Oracle Advanced Security Option, Oracle Database Transparent Data Encryption (TDE) allows you to selectively encrypt sensitive database data that's maintained in the underlying data files of a database

Grouping with SQL Server 2008

Grouping records is the process of combining like SELECT columns together. Once combined, Aggregate functions such as SUM and AVERAGE can be performed on the set. This article will examine several SQL Server 2008 grouping functions including GROUP BY, GRO

Open-Source Databases MySQL, PostgreSQL, Adoption Rising

Open-source databases MySQL and PostgreSQL are gaining steam, but rip-and-replace situations where MySQL and PostgreSQL replace Oracle Database, IBM DB2 or Microsoft SQL Server databases remain rare.

SQL Server 2008 Top 10 List for Developers

My boss, Mauricio, has been on me for months asking me to list the top 10 features of SQL Server 2008. I have been stalling. I think every single feature in the product is compelling, and inevitably I am going to leave something out and will hear about it

SQL Server 2008 released

Once again, Microsoft has released a new version of SQL Server that promises to improve life for database administrators. The latest version is SQL Server 2008, and it offers a large variety of new features and functionality that will make the administrat

MySQL 5.1 partitions in practice

This article explains how to test the performance of a large database with MySQL 5.1, showing the advantages of using partitions.

UNIQUE Column with multiple NULL values

In this article, author illustrates how to maintain uniqueness on a column and also allow multiple NULL values...

Oracle, MySQL and PostgreSQL feature comparison – Part 2

Though the feature sets certainly differ between Oracle, Postgresql, and MySQL, most of your daily needs are met in these areas. This time around, we'll hit upon some areas where the platforms differ more significantly

A Primer on Falcon Tablespaces

This article takes a quick look at how tablespaces are used within Falcon and what you can and can’t do with them.

How MySQL Treats Security Vulnerabilities

The purpose of this article is to describe how MySQL has treated security vulnerabilities.

Setting Up Delegation for Linked Servers

This article will discuss how to set up delegation on your SQL Server instances so you can use the impersonate options when setting up the security properties of linked server definitions.

Oracle, MySQL and PostgreSQL feature comparison – Part 1

This is a first article to take a look at Postgresql, MySQL, and Oracle and discover which ones do what you need.

Using Non-Standard Port for SQL Server

In this article author discusses how to use different port number than 1433 and the issues he came across when setup up SQL Server 2005 to use a non-standard port number

Debunking GROUP BY Myths

This article shows how and why in MySQL, one can write GROUP BY queries that reference non-aggregated columns in the SELECT list that are not included in the GROUP BY clause

Row Movement in Oracle

This article looks at three major operations where row movement is required: partition key value change, flashback and space management.

Using NOLOCK and READPAST table hints in SQL Server

This article focuses on two table hints: NOLOCK and READPAST. I'll set up a table to use for our example queries

Multipurpose code in Oracle and Oracle Forms

For DBAs and developers, this article should serve as a valuable lesson in learning how to take charge of what Oracle provides out of the box and making something better to suit your own purposes.

Using Multiple Active Result Sets (MARS)

The concept of MARS is explained in an understandable and simple way...

Stored Procedures in MySQL 5.0

Stored Procedures allows to automate or program our way out of many tasks on directly on the server rather than having to write external scripts to do complex manipulation of data.

MySQL 5.1's New XML Functions

MySQL version 5.1.5 has functions for searching and changing XML documents. This article has examples.

MySQL 5.0 New Features: Triggers

This article covers MySQL 5.0 support for Triggers using detailed examples, source code, and hands-on exercises.

MySQL 5.0 New Features: Data Dictionary

This article covers the MySQL 5.0 Data Dictionary using detailed examples, source code, and hands-on exercises.

MySQL 5.0 New Features: Views

This article covers MySQL 5.0 support for Views using detailed examples, source code, and hands-on exercises.

Managing Hierarchical Data in MySQL

Two models for dealing with hierarchical data in MySQL.

A Practical Look at the MySQL Query Cache

A quick look on how the popular database vendors implement their caching strategies...

Firebird for the Database Expert: Episode 1 - Indexes

This paper focuses on the unusual characteristics of Firebird indexes.

Firebird Null Guide

NULL behaviour and pitfalls in Firebird SQL

Point-in-Time Data Recovery

Binary logging will slow a server by only one percent. In return, though, it allows for up to the minute data recovery.

An Overview of SQL Server 2005 for the Database Developer

PostgreSQL Authenication with pam_ldap

This article will discuss how to setup PostgreSQL to authenticate against an LDAP system.

Choosing the Right MySQL Version

Which MySQL version you should use, whether you should consider upgrading, what to do when you find a bug?..

MySQL 5.0 New Features: Stored Procedures

This article shows you how to write stored procedures and shares the implementation details of Stored Procedures in MySQL 5.0.

MySQL Network and You

MySQL Network is presented in the press. What it all means for you?

SQL Constraints With PostgreSQL

This article has covered a variety of constraints that help restrict user data within specified limits.

Using PostgreSQL User-Defined Functions to solve the Tree Problem

In this article we demonstrate how to solve the classic tree problem using PostGreSQL user-defined functions.

Prepared Statements

Benefits (and trade-offs) of the new server-side prepared statements and the support for it from various programming languages.

Structure Means Subqueries: Nesting SELECTs in MySQL 4.1

Subqueries are another way to get data from multiple tables using a single query, and MySQL 4.1 includes support for this standard SQL construct.

New in MySQL 4.1: All the Little Features

We've covered the major features in 4.1, now we wrap up our 'New in 4.1' series with an article about all of the little features.

Writing Secure Transact-SQL

There are plenty of good sources of information about how to deploy SQL Server in a secure fashion.

Extending InterBase with User Defined Functions

An overview of UDF's - User Defined Functions

Packaging SQL Procedures into iSeries Applications

This article explains a cost-effective way to package SQL procedures that does not require additional software.