- Navigating the New Access 2007 User Interface
- May 18, 2007
- Access consists of a multitude of related tools for generating, organizing, segregating, displaying, printing, and publishing data. This sample chapter describe Access's basic functions and operating modes.
|
- Binding Data in BIRT
- May 18, 2007
- This chapter explains column bindings in BIRT (Business Intelligence and Reporting Technology), including what they are and how to create, edit and delete them.
|
- 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 Forms for Efficient and Accurate Data Entry
- Apr 16, 2007
|
- Navigating the New Access User Interface
- Apr 16, 2007
|
- Using CLR Integration in SQL 05 for Writing Stored Procedures
- Apr 13, 2007
- Join Jesse Smith to learn more about writing stored procedures using a .NET-based language with SQL Server 2005.
|
- Customizing an Excel 2007 Pivot Table
- Apr 6, 2007
- Although pivot tables provide an extremely fast way to summarize data, sometimes the pivot table defaults aren't exactly what you need. This chapter covers functional areas in customizing pivot table settings to help you zero in on the results you're looking for.
|
- UDM in SQL Server 2005: Linking Relational and Multidimensional Databases
- Mar 23, 2007
- This sample chapter describes how Microsoft SQL Server Analysis Services 2005 utilizes the Unified Dimensional Model (UDM) to enable clients to access relational and multidimensional database systems without the need for multiple data access models.
|
- PHP's Building Blocks: Data Types, Literals, Variables, and Constants
- Jan 19, 2007
- Marko Gargenta and Ellie Quigley discuss the basic building blocks of all languages: data types. They teach how to work with different types of numbers, strings, and booleans. Variables, HTML forms, and constants are also covered.
|
- Relational Databases 101
- Dec 29, 2006
|
- UDM: Linking Relational and Multidimensional Databases
- Dec 25, 2006
|
- Inside SQL Server 2005 Management and Administration Tools
- Dec 22, 2006
- SQL Server Management Studio is a rich and comprehensive tool that enables many management and administration scenarios. This sample chapter provides some tips and tricks for using the tool, straight from the Microsoft team that created it.
|
- Reap the Benefits of Web Caching, Part 3: Database Integration
- Nov 22, 2006
- If you've followed the first two articles in this series and implemented their recommendations, your web pages are almost perfect. Now it's time to add a back-end SQL database. In the final article of the series, Ivan Pepelnjak shows you how to cache the content generated from your SQL database, using a small but highly optimized order-entry system.
|
- Reap the Benefits of Web Caching, Part 2: Reduce the Download Time
- Nov 17, 2006
- Now that you've mastered the basics of web caching (setting the content expiration date), it's time to deploy more caching mechanisms to reduce the download time. In part 2 of his series, Ivan Pepelnjak explains how to get the most out of the HTTP caching architecture when using dynamic web pages.
|
- SELECT Statement: The GROUP BY Clause in SQL
- Nov 17, 2006
- Rick F. van der Lans explains how SQL's GROUP BY clause groups rows on the basis of similarities between them. He goes on to explain the use of adding aggregation functions to display summations, averages, frequencies, and subtotals.
|
- Practical Business Intelligence with SQL Server 2005: Data Mining
- Nov 10, 2006
- This sample chapter looks at how to use some of the data mining features in SQL Server Analysis Services 2005 to perform tasks such as customer segmentation and market basket analysis.
|
- Reap the Benefits of Web Caching, Part 1: Explicit Content Expiration
- Oct 27, 2006
- In this three-part series, Ivan Pepelnjak describes how you can benefit from the web caching architecture to increase the speed of your ASP or PHP applications while reducing the load on your web server. Part 1 shows you how to use explicit content expiration.
|
- 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.
|
- SQL Server 2005 Transactional Replication Agents
- Oct 20, 2006
- SQL Server 2005 replication agents are configured optimally out of the box, but occasionally you might need to alter the default behavior by tweaking the agent's parameters. Baya Pavliashvili encourages you to learn the new options available with each replication agent and how to fine-tune these options for your applications.
|
- 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.
|