August 28, 2012
Hadoop in Practice author Alex Holmes explains how you can use the Sqoop relational database import / export system with Hadoop.
May 9, 2011
Research firm The 451 Group coins "NewSQL" to categorize a new breed of database designed for distributed environments -- like the cloud.
September 28, 2010
Their differences complement one another, with each delivering functionality the other cannot, occupying different but equally important pieces of the database pie.
August 3, 2010
The NoSQL phenomenon is worth keeping an eye on for these five reasons.
July 30, 2010
There will always be a place for relational databases, but non-relational solutions are proving to be fast, flexible, and scalable for many tasks.
May 3, 2010
The NoSQL concept has been attracting a lot of attention in recent years, primarily due to big-name production implementations.
March 23, 2010
In addition to the world's biggest set of genealogies and missionaries in 160 countries, the church has more than 260 centrally managed databases.
March 9, 2010
This infrastructure will allow you to focus on your application's look and feel to create more elaborate and elegant Flex applications.
September 18, 2009
A corrupt table in MS Access means lost time and data. It can lead to a loss of revenue or even employment. Learn how you might be able to recover most of the data when the worst happens.
August 11, 2009
The key to working with null values properly is to accommodate them consistently. Learn a few tricks that will help you do just that.
August 5, 2009
Routine maintenance can keep index fragmentation to a minimum—with some help from an index-defragmenting script.
July 15, 2009
You can't let a little thing like not knowing a database's structure keep you from your work. Without identifying tables and columns, you can still find specific values and columns.
July 7, 2009
The Advantage Data Provider for .NET provides a feature-rich mechanism for Delphi developers using the Advantage Database Server (ADS) to build ASP.NET web applications and web services.
June 19, 2009
From monitoring e-mail messages to distributing reports for users, SQL Server's database mail proves quite useful. Learn how to use it in SQL Server 2000 and SQL Server 2005/2008.
June 9, 2009
Implement a CRUD automation framework that handles insert and simple queries, an easy way to talk to a database without needing to write any database-access code.
June 4, 2009
If you're a .NET newbie coming from Access or SQL Server, let .NET do the hard work of creating a connection to foreign data. Then customize the resulting control to add functionality.
May 19, 2009
You can easily limit or group a recordset, but doing both to the same recordset takes a bit of hand coding. Find out how both SQL Server and MS Access can handle the task.
April 30, 2009
Oracle 10g introduced a new feature called ROWDEPENDENCIES, which made every row independent. Learn how to use this feature to improve application concurrency and avoid the dreaded ORA-8177 error.
April 9, 2009
This short introduction to .NET shows Access and SQL Server developers how to use a development tool to create connections to data and a user interface to manipulate that data.
March 6, 2009
A column alias seems like a great tool for referencing complex expressions, but SQL Server doesn't work that way. Learn a simple workaround.
February 19, 2009
Deleting all the data in a SQL Server database doesn't have to involve complex code. The undocumented stored procedure sp_MSForEachTable safely bypasses built-in limitations to accomplish this common task.
January 30, 2009
Determining which queries will provide the best performance for a given application often comes down to a simple question: Does Query X perform better than Query Y? Learn the tools and methods that can help you compare query response times in Oracle.
January 7, 2009
You likely will need to test data against SQL Server 2008 and SQL Server 2005, but ordinary backups are incompatible. Use SQL Server 2008's Generate SQL Server Scripts Wizard to push your SQL Server 2008 data back into SQL Server 2005.
December 17, 2008
Access can offer a lot of help with missing values, but finding and generating missing values in a field of sequential values requires a bit of code. Find it here.
December 16, 2008
Once you've established a connection between an Adobe AIR application and a local database, you can run SQL commands (CREATE TABLE, INSERT, DELETE, SELECT, etc.) using the flash.data.SQLStatement class. Find out how.
December 10, 2008
SQL does not support direct operations on matrices, but it does allow easy manipulations with matrices. Learn a few SQL techniques for performing some basic operations on matrices.
November 13, 2008
Maintaining a database often means schema changes. Before you change or delete anything, be sure to check for dependent objects.
October 30, 2008
If you have ever had to analyze the data in a large Oracle database with no documentation, this integrated-documentation tool is for you. Check out this PL/SQL-generated HTML database dictionary.
October 16, 2008
Getting to the data you need is always a challenge. Views can provide a "no muss, no fuss" way to retrieve the data you need—whether it's in the current database or another.
September 24, 2008
Learn how executing frequent backups and maintaining healthy transaction logs in SQL Server leads to quick recovery. Failing to do so can mean having to re-enter a lot of data.
September 9, 2008
MS Access can retrieve and measure time with millisecond precision, but only with the help of a few well-known API calls and several user-defined functions.
July 3, 2008
Histograms help people analyze large amounts of data, whether you display them as tables or as charts. This article shows you how to do both.
April 29, 2008
Learn how to flexibly define a SQL Server Reporting Services report for ranking purposes. This article provides a workaround for custom grouping totals for top items and for jazzing the table up with some visual chart indicators.
April 18, 2008
Learn how to build robust Matrix-style reports in SQL Server Reporting Services. These advanced reporting techniques make it easier to build a fully-functional report.
April 8, 2008
In this article, David Leibowitz compares the performance of the prerelease of Microsoft's SQL Server 2008 Reporting Services to SSRS 2005. While it is clear performance improvements have been made for report automation, developers might have differing opinions on the new Report Designer.
April 3, 2008
Often developers are tasked with not only developing functional code, but also with ensuring that the code they develop scales well and performs in the application environment.
January 23, 2008
By adding XML-based documentation capability to your SQL code, you can automatically extract and format tagged comments into a complete API documentation set for your SQL libraries.
January 11, 2008
A
previous DevX article chronicled the data loss that the SQL Server 2005 merge replication engine can cause. Microsoft has since opened an active—although unpublished bug—for it. Find out how this bug manifests itself in real-world scenarios.
January 3, 2008
The many popular rules concerning T-SQL filtering operators can't be trusted implicitly; instead, you should evaluate your options explicitly.
November 2, 2007
The SQL Server 2005 merge replication engine introduced breaking changes that can cause data loss for both MSDE and SQL Server Express subscribers. Find out how this bug manifests itself in a real-world scenario.
November 1, 2007
Simplify your SQL tasks by giving your queries and stored procedures the ability to iterate over arrays of table names or values.
October 2, 2007
Learn one of the techniques for calculating percentiles with SQL Server 2005 using the new SQL Server Common Table Expression and the latest ROW_NUMBER function.
May 15, 2007
When can you use arithmetic operators in date/time calculations in SQL Server? When are the date/time functions provided by Microsoft the better option? Follow a few scenarios that demonstrate when arithmetic operators are safe and when they are risky.
May 2, 2007
The only way to guarantee that your business rules are always enforced for all your data is by using constraints. Learn how to use them to enforce business rules in the database.
April 20, 2007
Prove that your refactored SQL query returns the expected results using the EXCEPT operator, new in SQL Server 2005.
March 27, 2007
Not quite a knockout, SQL Service Broker beats MSMQ at its own game.
February 20, 2007
Learn how to build date generators without loops using SQL, and some useful techniques to help you manipulate date and time data.
February 6, 2007
Using a SQL Server back end with a Java application server may sound like an unnatural proposition but there's no need to bow to such arbitrary limitations. In this article you'll get step-by-step instructions on making a JDBC connection between the four most popular Java application servers and Microsoft SQL Server.
January 23, 2007
Stored procedures can be an effective way to handle conflicting needs, but it's not always so obvious how to write them so they both perform well and scale.
January 8, 2007
One of the most noteworthy updates to JDBC 4 is the support for the XML data type, which improves XML data handling and reduces development time.
FEATURED ARTICLE
HTML5 is the new standard that is expected to take over the Web. New versions of browsers are already starting to support the advanced features. Learn why HTML5 is important and discover how to start developing with it today.
