MS SQL
2/09
Learn how to create a database
level audit at a granular level and retrieve the audit records in this 9-step tutorial. 2/03
MAK shows us how easy it is to create a database level audit, test the audit and retrieve the audit records in
Microsoft SQL Server 2008.
2/02
Internet.com launches a new daily newsletter to provide one-stop coverage of all the database technology information and trends that matters to you.
more...
Oracle
2/08
Discover what happens
within SQL Server during and after configuring Oracle as a data source. Quite a
few objects are created, including a system-level database, numerous jobs
running under the SQL Server agent, and flat files created on the file system.
Read on to learn more.
2/04
Before you start monitoring your Oracle database, make sure you understand some of the
behind-the-scenes issues of using Oracle monitoring.
1/27
Oracle Data Guard still offers support for the venerable logical standby database in Oracle Database 11g. This article, investigates how data warehouse and data mart environments can effectively leverage logical standby database features, but simultaneously provide a final destination when failover from a primary database is mandated during disaster recovery.
more...
MS Access
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.
12/07
While it's not carved in stone, you can do yourself a favor by following this list of dos and don'ts when naming tables and fields.
11/12
While it's not possible to change the behavior of the InputBox function, this article illustrates how to create your own Access form that includes a text box with its InputMask property set to Password, and then use that form instead of the one generated by the VBA InputBox function.
more...
DB2
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.
2/10
The first thirteen parts of this series introduced some of the many features available within the IBM Data Studio integrated development environment (IDE) that's available for use with the IBM data servers. This installment explains how to apply Extensible Stylesheet Language Transformations (XSLT) to your Web services.
1/13
Paul Zikopoulos continues his series on DB2 9 and Microsoft Access 2007, explaining in this installment how to build forms that run against DB2 data servers.
more...
