- Reporting Databases: The Two Things You Need to Know
- Apr 5, 2012
- You've probably heard the term 'data warehousing,' and you want to learn more about this technology. Roger Johnson, coauthor of IBM Cognos 10 Report Studio: Practical Examples, shares his revelations about developing a database that's designed for reporting in a simple, easy-to-understand way.
|
- Synchronization with Microsoft SQL Server Analysis Services
- Feb 21, 2012
- Database administration expert Baya Dewald shows how built-in synchronization works and how it compares to other approaches for distributing the querying load across multiple hosts.
|
- Transact-SQL Improvements with SQL Server 2008, Part 2
- Oct 4, 2011
- Baya Dewald concludes this two-part series on Transact-SQL by discussing functions for grouping and table-valued parameters for passing multiple data rows to a stored procedure.
|
- Transact-SQL Improvements with SQL Server 2008, Part 1
- Sep 27, 2011
- Baya Dewald discusses some of the most exciting of the new and changed functionality for working with variables, managing date and time values, and row constructors in Transact-SQL .
|
- Working with MariaDB
- Sep 24, 2011
- In this chapter, you learn how to connect and log in to MariaDB, how to issue MariaDB SQL statements, and how to obtain information about databases and tables.
|
- Monitoring and Tuning Analysis Services with SQL Profiler, Part 2
- Aug 30, 2011
- Baya Dewald concludes his series on monitoring and tuning SQL Server analysis services with a discussion of how to use SQL Profiler to analyze and adjust your MDX queries and your database's processing with the goal of streamlining everything for best performance.
|
- Monitoring and Tuning Analysis Services with SQL Profiler, Part 1
- Aug 23, 2011
- Database administration expert Baya Dewald explores the possibilities of using the SQL Profiler framework to find common performance problems in your SQL Server Analysis Services (SSAS) cubes.
|
- Managing SQL Database Objects
- Jun 16, 2011
- In this chapter you will learn about database objects: what they are, how they act, how they are stored, and how they relate to one another.
|
- Working with Mobile Devices When Designing Data-Driven Applications
- Jun 14, 2011
- Jesse Feiler discusses how to account for the unique features of mobile devices, such as touchscreens and their methods of manipulating text, when developing your apps.
|
- Microsoft OneNote as a Distributed Information Item Database System
- Jan 28, 2011
- Architecturally, OneNote is a subtly sophisticated distributed database management system, making it a powerful solution for today's occasionally-connected and multi-device requirements. This article explains OneNote's distributed database architecture and its utility.
|
- Examples of SQL Server Implementations
- Sep 22, 2010
- This chapter provides examples of real-life database applications running in production environments at major organizations around the world.
|
- 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!
|
- Microsoft Access 2010 and SharePoint 2010: A Match Made in Redmond
- Jul 5, 2010
- Roger Jennings describes Microsoft Access 2010’s latest SharePoint 2010-based Web database features.
|
- 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.
|
- How I Got into Bento
- Jun 15, 2010
- Long-time database user and designer Jesse Feiler shares his experiences with Bento — a very different kind of database.
|
- Bento and iPad: The Start of Something New
- Jun 11, 2010
- If you’re looking for a great database to run on iPad, Filemaker’s Bento is a good choice. Jesse Feiler tells you why.
|
- Recommended Practices for SQL Server Analysis Services 2005/2008 Design
- Feb 8, 2010
- Baya Dewald offers recommendations for avoiding the most commonly encountered dimension/partition design pitfalls for SQL Server Analysis Services 2005 and 2008.
|
- SQL Server Analysis Services 2005/2008 Administration
- Jan 22, 2010
- Baya Dewald shows you the skills required for administering the latest versions of Analysis Services and how they compare to managing relational databases.
|
- The Beauty of TOAD for Oracle
- Jan 6, 2010
- Linda Leung caught up with TOAD experts Bert Scalzo and Dan Hotka to discuss TOAD, how it's used, and their views on where Oracle as a company is headed.
|
- Oracle Performance By Design
- Nov 30, 2009
- An application’s design determines whether the application performs like a Ferrari or a gas-guzzling clunker. If you want your Oracle application to win the performance race, Guy Harrison showcases these high-performance design patterns.
|