Data

535 Items

Sort by Date | Title

Designing Microsoft Access 2007 Forms for Efficient and Accurate Data Entry: May 4, 2007; Paul McFedries introduces you to several techniques that serve to either make data entry less of a chore, or to reduce or eliminate data entry errors (or both).

Designing Objects and Relationships with IBM DB2 for z/OS: Feb 25, 2005; When you design any sort of database, you need to answer many different questions. How will you organize your DB2 data? How will you create relationships between tables? How should you define the columns in your tables? What kind of table space should you use? In this sample chapter, you'll learn about the DB2 UDB data types as well as the characteristics of tables, views, and indices.

Designing Organizational Unit and Group Structure in Windows Server 2003: Jul 4, 2003; Administrators need a way to lasso groups of users together so that changes, security privileges, and administration can be accomplished en masse. Learn how proper design of both organizational unit and group structure in Active Directory will go a long way toward helping you gain control in your domain environment.

Developers vs. DBAs: Keys to Successful Cohabitation: Oct 6, 2005; Baya Pavliashvili points out a few common situations that can cause tension between developers and DBAs and provides some advice for working your way out of an argument before it leads to a war.

Dimensional Databases: Building A Data Warehouse: Sep 17, 2004; Building a data warehouse involves several complicated steps and can take time if the population routines aren't designed carefully. But the effort is worth it. Baya Pavliashvili addresses some of the challenges involved in building and maintaining dimensional databases that serve as the foundation of a data warehouse.

Drag-and-Drop Techniques for Creating Database Applications in Visual Studio 2005: Sep 22, 2006; Don't think of drag-and-drop as something for the ill-prepared, says John Mueller. It's a valuable technique for anyone who can express an idea as a stored procedure.

DTS and the Flow of Data Through the Enterprise: Dec 12, 2000; This chapter from Microsoft® SQL Server™ 2000 Data Transformation Services examines the flow of data through an organization, and presents DTS as a powerful and flexible tool for meeting such data transformation needs.

DTS Tips and Tricks: Mar 8, 2002; In this third article of their three-part DTS series, Baya Pavliashvili and Dan Lampkin share the DTS tips that one can learn only through a hands-on experience with DTS packages and components.

Effective Database Design: Choosing The Right Process: Mar 4, 2005; This chapter examines the process of project design, and discusses the various models of project life-cycle, with the intention of helping you to choose the right one for your database design project.

Emulation: Role-Playing for Computers: Oct 13, 2006; Emulation is used in one form or another increasingly frequently in modern computing environments. David Chisnall takes a look at some of the common mechanisms used.

End-to-End JPA Collections with MySQL, Part 1: Apr 30, 2012; Having difficulty getting your JPA collection code up and running? Stephen Morris demonstrates an end-to-end, working example of a JPA collection in this first part of a two-part series.

End-to-End JPA Collections with MySQL, Part 2: May 1, 2012; Stephen Morris provides simple, end-to-end working code illustrating how to modify JPA collection code. Also, the area of MySQL stored procedures is looked at, using some simple examples in this the concluding part of a two-part series.

Enhanced Connectivity from SQL to SharePoint to Office: Jul 12, 2010; Flexible dynamic data access is an impressive improvement to SharePoint 2010 that provides both read and write capabilities back to an external data source, like SQL, so that you can adjust data between Office, SharePoint and SQL. In this article we will show you how!

Enhancing DTS Package Performance: Oct 5, 2001; Jim Samuelson and Brian Sullivan show you how to improve the performance of your DTS Packages.

Enhancing SQL Server Functionality with Functions: Feb 21, 2003; In this first article in a series on functions, Baya Pavliashvili introduces you to the various flavors of built-in functions available in SQL Server 2000, with a focus on aggregate functions.

Entering Data in Access 2003: Oct 20, 2006; Shelley O'Hara explains how to enter data into a database table, creating the records for your database table. She also cover how to work with the records, edit data, sort records, and print data.

Enterprise Application Architecture: Mapping to Relational Databases: Jan 24, 2003; The role of the data source layer is to communicate with the various pieces of infrastructure that an application needs to do its job. Learn how to talk to a database—which means a relational database for the majority of systems built today.

Enterprise Data Management in SQL Server 2005: Apr 7, 2006; This chapter covers what’s new in enterprise database administration. It doesn’t just look at the product from a feature list, but groups the features according to some tasks common to database administration.

Evolutionary Database Development: Mar 10, 2006; Modern software processes, also called methodologies, are all evolutionary in nature, requiring you to work both iteratively and incrementally. Working iteratively, you do a little bit of an activity such as modeling, testing, coding, or deployment at a time, and then do another little bit, then another, and so on. With an incremental approach, you organize your system into a series of releases rather than one big one. This chapter will help you manage your software project keeping these principles in mind.