(c) 1999-2005 EMS Database Management Solutions, Inc. All rights reserved.http://www.sqlmanager.net/en/articlesSQL Articlesen86400http://www.sqlmanager.net/en/articles/1389http://www.sqlmanager.net/en/articles/1389Once 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 administrathttp://www.sqlmanager.net/en/articles/1318http://www.sqlmanager.net/en/articles/1318This article explains how to test the performance of a large database with MySQL 5.1, showing the advantages of using partitions.http://www.sqlmanager.net/en/articles/1306http://www.sqlmanager.net/en/articles/1306In this article, author illustrates how to maintain uniqueness on a column and also allow multiple NULL values...http://www.sqlmanager.net/en/articles/1280http://www.sqlmanager.net/en/articles/1280Though 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 significantlyhttp://www.sqlmanager.net/en/articles/1272http://www.sqlmanager.net/en/articles/1272This article takes a quick look at how tablespaces are used within Falcon and what you can and can’t do with them.http://www.sqlmanager.net/en/articles/1271http://www.sqlmanager.net/en/articles/1271The purpose of this article is to describe how MySQL has treated security vulnerabilities.http://www.sqlmanager.net/en/articles/1251http://www.sqlmanager.net/en/articles/1251This 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. http://www.sqlmanager.net/en/articles/1220http://www.sqlmanager.net/en/articles/1220This is a first article to take a look at Postgresql, MySQL, and Oracle and discover which ones do what you need.http://www.sqlmanager.net/en/articles/1209http://www.sqlmanager.net/en/articles/1209In 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 numberhttp://www.sqlmanager.net/en/articles/1188http://www.sqlmanager.net/en/articles/1188This 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 clausehttp://www.sqlmanager.net/en/articles/1166http://www.sqlmanager.net/en/articles/1166This article looks at three major operations where row movement is required: partition key value change, flashback and space management.http://www.sqlmanager.net/en/articles/1164http://www.sqlmanager.net/en/articles/1164This article focuses on two table hints: NOLOCK and READPAST. I'll set up a table to use for our example querieshttp://www.sqlmanager.net/en/articles/1151http://www.sqlmanager.net/en/articles/1151For 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.http://www.sqlmanager.net/en/articles/1143http://www.sqlmanager.net/en/articles/1143The concept of MARS is explained in an understandable and simple way...http://www.sqlmanager.net/en/articles/776http://www.sqlmanager.net/en/articles/776Stored 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.http://www.sqlmanager.net/en/articles/775http://www.sqlmanager.net/en/articles/775MySQL version 5.1.5 has functions for searching and changing XML documents. This article has examples.http://www.sqlmanager.net/en/articles/773http://www.sqlmanager.net/en/articles/773This article covers MySQL 5.0 support for Triggers using detailed examples, source code, and hands-on exercises.http://www.sqlmanager.net/en/articles/772http://www.sqlmanager.net/en/articles/772This article covers the MySQL 5.0 Data Dictionary using detailed examples, source code, and hands-on exercises.http://www.sqlmanager.net/en/articles/771http://www.sqlmanager.net/en/articles/771This article covers MySQL 5.0 support for Views using detailed examples, source code, and hands-on exercises.http://www.sqlmanager.net/en/articles/725http://www.sqlmanager.net/en/articles/725Two models for dealing with hierarchical data in MySQL.http://www.sqlmanager.net/en/articles/704http://www.sqlmanager.net/en/articles/704A quick look on how the popular database vendors implement their caching strategies...http://www.sqlmanager.net/en/articles/692http://www.sqlmanager.net/en/articles/692This paper focuses on the unusual characteristics of Firebird indexes.http://www.sqlmanager.net/en/articles/691http://www.sqlmanager.net/en/articles/691NULL behaviour and pitfalls in Firebird SQLhttp://www.sqlmanager.net/en/articles/682http://www.sqlmanager.net/en/articles/682Binary logging will slow a server by only one percent. In return, though, it allows for up to the minute data recovery.http://www.sqlmanager.net/en/articles/655http://www.sqlmanager.net/en/articles/655http://www.sqlmanager.net/en/articles/654http://www.sqlmanager.net/en/articles/654This article will discuss how to setup PostgreSQL to authenticate against an LDAP system.http://www.sqlmanager.net/en/articles/653http://www.sqlmanager.net/en/articles/653Which MySQL version you should use, whether you should consider upgrading, what to do when you find a bug?..http://www.sqlmanager.net/en/articles/652http://www.sqlmanager.net/en/articles/652This article shows you how to write stored procedures and shares the implementation details of Stored Procedures in MySQL 5.0.http://www.sqlmanager.net/en/articles/646http://www.sqlmanager.net/en/articles/646MySQL Network is presented in the press. What it all means for you?http://www.sqlmanager.net/en/articles/636http://www.sqlmanager.net/en/articles/636This article has covered a variety of constraints that help restrict user data within specified limits.http://www.sqlmanager.net/en/articles/593http://www.sqlmanager.net/en/articles/593In this article we demonstrate how to solve the classic tree problem using PostGreSQL user-defined functions.http://www.sqlmanager.net/en/articles/592http://www.sqlmanager.net/en/articles/592Benefits (and trade-offs) of the new server-side prepared statements and the support for it from various programming languages.http://www.sqlmanager.net/en/articles/591http://www.sqlmanager.net/en/articles/591Subqueries are another way to get data from multiple tables using a single query, and MySQL 4.1 includes support for this standard SQL construct.http://www.sqlmanager.net/en/articles/590http://www.sqlmanager.net/en/articles/590We'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.http://www.sqlmanager.net/en/articles/589http://www.sqlmanager.net/en/articles/589There are plenty of good sources of information about how to deploy SQL Server in a secure fashion.http://www.sqlmanager.net/en/articles/588http://www.sqlmanager.net/en/articles/588An overview of UDF's - User Defined Functionshttp://www.sqlmanager.net/en/articles/587http://www.sqlmanager.net/en/articles/587This article explains a cost-effective way to package SQL procedures that does not require additional software.