- Implementing Access Controls on SQL Server Data
- Mar 14, 2008
- Provide fine-grained access control to individual records in the most sensitive tables of your database.
|
- Defining and Working with Fields and Tables in FileMaker 9
- Feb 29, 2008
- Learn techniques to make your FileMaker Pro databases meaningful to yourself and others for the long period of time that they may be in use.
|
- Microsoft Office Access 2007 VBA: Using Built-In Functions
- Jan 4, 2008
- This chapter explains many of the most used functions to give you an idea of VBA's power.
|
- Five Steps to Managing Unstructured Data with Derby
- Dec 14, 2007
- Stephen B. Morris demonstrates how easy it is to store binary data in a database.
|
- SQL Queries for Mere Mortals: Thinking in Sets
-
By
Michael J. Hernandez
- Nov 30, 2007
- This sample chapter discusses the concept of a set along with each of the other major set operations in SQL.
|
- Administering the SQL Server 2005 Database Engine
- Nov 2, 2007
- Learn to administer the Database Engine component and manage the SQL server properties and database properties.
|
- XML Handling in Microsoft SQL Server 2005
- Oct 19, 2007
- Increase the speed of your SQL queries and updates.
|
- DB2 Security—The Starting Point
- Oct 12, 2007
- This sample chapter details the creation of a security plan for your DB2 database.
|
- Further Steps with Derby: Derby Embedded in a Browser
- Oct 5, 2007
- Do you know you can now integrate an instance of Apache Derby into a browser?
|
- Storing XML Data in a Relational Database
- Oct 5, 2007
- Use familiar XML markup to extend the capabilities of your relational database.
|
- Further Steps with Derby: Defining and Accessing Your Data
- Sep 28, 2007
- Database development is no longer the sole preserve of DBAs. You can do it, too.
|
- Serve SQL Data in XML Format
- Sep 28, 2007
- Learn how to extract data from SQL databases and serve it to an AJAX application running in a web browser.
|
- Using Derby as a Network Database Server Engine
- Sep 21, 2007
- Stephen Morris explains how Derby can serve the needs of many remote clients via an open-source RDBMS.
|
- Relational Databases 101
- Sep 14, 2007
- Design relational databases that can perform better, be easier to maintain, and be more successful.
|
- Managing Database Transactions with the TransactionScope
- Sep 7, 2007
- Paul Kimmel explains TransactionScope, a lighter, faster way to enlist modifications to data in a transaction.
|
- FileMaker 9's Custom Function Primer
- Aug 31, 2007
- Learn the basics of one of the most powerful features in FileMaker.
|
- Seven Steps to Improving Your VB Code
- Aug 17, 2007
- Here are the improvements you must make if you want to be more than a macro writer.
|
- Relationships: Your Key to Data Integrity in Access 2007
- Jun 15, 2007
|
- Using Scripting in a Report Design in BIRT
- May 25, 2007
- Learn to write event handlers in BIRT.
|
- Relationships: Your Key to Data Integrity
- May 21, 2007
|