Home > Articles > Data

Data

535 Items

Sort by Date | Title

"Don't Talk to Our People..." and Other Warehousing Death Knells
Sep 2, 2001
Mark W. Humphries and Michelle C. Dy present IT war stories from their data warehousing consulting practice.
6 Reasons to Migrate Your Oracle Databases Twice as Fast to Release 12.1.0.2
Sep 15, 2015
Oracle Database 11.2.0.4 is the terminal release for Oracle 11g R2, and extended support for that release ends as of December 2015. Yet many Oracle shops haven't accelerated their pace to transition to Oracle Database 12c R1. Oracle ACE Director Jim Czuprynski, author of Oracle Database 12c New Features, Part 1 LiveLessons, explains why Oracle DBAs should redouble their upgrade efforts to take advantage of six key feature sets available in Oracle Database 12.1.0.2.
A Close Look at Oracle8i Data Block Internals
Feb 9, 2001
Data blocks: how they're created, how space is really managed inside a tablespace, and some other geeky internal things
A Crash Course in Test-Driven Development
Apr 4, 2013
Get a crash course in test-driven development, including the test-first technique, a test's proper role in your organization, what you want to specify, and traditional database design concepts.
A Database Technology Recommended Reading List by Mike Hernandez
By Michael J. Hernandez
Feb 11, 2013
If you're interested in an in-depth study of database technology, Michael J. Hernandez, the author of Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, 3rd Edition, recommends these books.
A Product Overview of DB2 9 for Linux, UNIX, and Windows
Jul 1, 2008
In this chapter you will be introduced to the DB2 family of products that run on the Linux, UNIX, and Windows operating systems.
Absolute Beginner's Guide to Database Design
May 17, 2002
This tutorial provides step-by-step direction to building a database for a law firm's time entry and billing.
Absolute Beginner's Guide to Database Normalization
Jul 19, 2002
Learn how to enhance consistency and reduce redundancy by understanding how to normalize your data model and apply it to your design.
Access 2002: Building a Simple Desktop and Web Application
Dec 14, 2001
Detailed, step-by-step instructions guide you through the process of designing an Access application.
Access 2010 Macros: A New Way of Programming
Jun 25, 2010
This exciting article takes you on a tour of the new Access 2010 macro designer and the new features available with Access macros. After reading the article, you will be comfortable with the Access 2010 macro designer and will be able to take advantage of all that it offers.
Access Database Design and Normalization
Jun 14, 2002
Here you can learn just enough relational theory to enable you to design Access databases that take advantage of the way relational database operations work.
Access Fear Factor I: Basics
Dec 30, 2005
Afraid of the dark? Spiders? Heights? If you are an experienced Word/Excel user who has Access-phobia, this article is for you. Herb Tyson shows you how to use Word and Excel to start creating what should be a simple database. When limitations become obvious, you learn how to use an Excel spreadsheet as the starting point for an Access database that ultimately will be more useful.
Access Fear Factor II: Merging the Unfamiliar with the Familiar
Feb 3, 2006
If you can't use Access for more than five minutes without cursing, join the club. If you're an experienced Word and Excel user who has not experienced Access, this article will help you overcome Access-phobia and easily recover from frightening Access experiences. If you're an Access expert and are easily angered, on the other hand, please don't read this article! In this second Access Fear Factor article, Herb Tyson encourages you to eschew Access best practices and to avoid overcomplicating matters.
Access Fear Factor III: A Picture Is Worth a Thousand Words
Feb 17, 2006
Still cursed with Access-phobia? If you're an experienced Word and Excel user who has not yet experienced Access, you really can overcome your fear. Herb Tyson continues where his Access Fear Factor II article left off. This third installment deals with a few loose ends from the previous article and shows you how to integrate pictures while simultaneously learning as little about Access as possible. If you're an Access expert and are not easily amused, Herb encourages you to look elsewhere for your amusement.
Accessing a MySQL Database from a C++ CGI Program
Oct 31, 2003
If you want to access a MySQL database through CGI, C++ is a great option. Sure, you can use other languages such as PHP or Perl, and they might be easy to use, but C++ has the advantage of being fast, powerful, and fully compiled, thereby hiding your original code. In this article, Jeff Cogswell shows you how you can write CGI programs in C++ to access a MySQL database.
Accessing SQL 2000 via HTTP
Oct 26, 2001
This sample chapter from XML and SQL Server discusses how the open-endedness of client/server architecture provides for enhanced extensibility. The HTTP protocol is examined for various ways to execute SQL statements against SQL Server.
Accessing the Web Storage System Using ADO and ExOLEDB
Mar 30, 2001
Microsoft's Universal Data Access (UDA) strategy is finally starting to come to fruition with the advent of the Exchange 2000 Web Storage System. A developer can use the familiar ADO object model to deal with Exchange data and even write SQL queries ...
Accessing Your MySQL Database from the Web with PHP
Sep 30, 2008
In this chapter, learn how to access a database from the Web using PHP, read from and write to the database, and filter potentially troublesome input data.
Adding a User to a Database
Nov 6, 2000
Everything you do in SQL Server is authenticated, including creation of the databases and files. Understanding SQL Server security is critical to the successful operation of your SQL Server.
Adding Data to Web Pages
May 11, 2001
If you want to use Web pages in your business solutions or create a corporate intranet or Internet site, data access pages can help you get the job done. By adding text, graphics, and controls, you can define a rich interface for your end users.

Page 1 2 3 4 5 Next >