MS SQL
3/17
The SQL-92 standard unknowingly and without planning introduced the capability to perform full hierarchical data processing with its introduction of the LEFT Outer Join operation. This natural hierarchical processing capability will be explained in this article.
3/10
NoSQL databases offer an alternative to traditional relational databases, but they might not be the right fit for everyone.
3/08
In his latest article, Marcin Policht demonstrates a variety of tools that can be employed to execute SQL Server Integration Services packages, focusing in particular on the method leveraging functionality available within the Business Intelligence Development Studio.
more...
Oracle
3/18
Oracle's new ADR with command interface shows promise for database administrators who like to script their
own solution for quickly scraping the alert log and automatically looking for errors.
3/10
Much has been said about why Oracle acquired Sun, how it will be the demise of the free world and produce a one-world database monopoly. While there is probably a little truth in the statement, we should keep in mind that much of what is happening can be beneficial for the end customer.
3/09
One of the initial obstacles a database administrator encounters is learning where features of his/her system live or reside on a less familiar system. Steve Callan approaches this feature comparison by taking SQL Server and mapping its features back into Oracle.
more...
MS Access
3/01
If you need to migrate your Access application to SQL Server, don't count on The SQL Server Upsize Wizard in Microsoft Access to automatically
convert your VBA functions. If you want to push the complex query processing done by your Access queries to the back end, you'll have to rewrite them in T-SQL.
2/10
Microsoft Access is fun,
but it is also powerful and more importantly, it has a place in the development community and in the real world of production applications. What follows are the top 10 reasons why Danny Lesandrini believes this is still true.
12/18
It's possible to treat a text file as a data table, and use the standard approaches to dealing with tables, which is a major advantage in that you can use SQL to filter the text in the file. Doug Steele shows you how.
more...
DB2
3/16
Rebecca Bond discusses a few of the options available in IBM DB2's new CLPPLUS command line processor that you can use to connect to databases and to define, edit, and run statements, scripts, and commands.
2/19
It's a challenge to adapt to change, but the changes in IBM DB2 9.7's Database Administrator authority bring significant database security benefits. Join Rebecca Bond as she shares some twists, some turns, and some clues regarding DB2 9.7's Database Administrator (DBADM) authority.
1/21
Database security should have multiple locks at multiple layers with multiple keys (and perhaps some barbed wire, an electric fence, a moat and a mean junkyard dog as well). With all these locks and keys, some locksmith skills are certainly useful. Rebecca Bond introduces some of her favorite DB2 Locksmith tips.
more...
