- "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.
|