Home > Articles > Data

Data

RSS Feed Subscribe to this topic  RSS details

529 Items

Sort by Date | Title

Reporting Databases: The Two Things You Need to Know
By Roger Johnson
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
By Baya Dewald
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
By Baya Dewald
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
By Baya Dewald
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
By Ben Forta
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
By Baya Dewald
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
By Baya Dewald
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
By Arie D. Jones, Ron D. Plew, Ryan Stephens
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
By Jesse Feiler
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.
Examples of SQL Server Implementations
By Alex T. Silverstein, Paul Bertucci, Chris Gallelli, Ray Rankins
Sep 22, 2010
This chapter provides examples of real-life database applications running in production environments at major organizations around the world.
Recommended Practices for SQL Server Analysis Services 2005/2008 Design
By Baya Dewald
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
By Baya Dewald
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
By Linda Leung, Dan Hotka, Bert Scalzo
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
By Guy Harrison
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.
Oracle Performance Tuning: A Methodical Approach
By Guy Harrison
Nov 5, 2009
Guy Harrison shares a methodology that ensures that you focus on the root causes of Oracle performance problems.
SQL Fundamentals LiveLessons (Video Training): ANSI SQL Select Statement
By Arie D. Jones
Nov 3, 2009
This video excerpt is from SQL Fundamentals LiveLessons Bundle (Video Training).
SQL Fundamentals (Video Training): Introduction to MySQL Interfaces
By Arie D. Jones
Oct 26, 2009
This video excerpt is from SQL Fundamentals LiveLessons Bundle (Video Training).
TOAD Setup and Configuration
By Bert Scalzo, Dan Hotka
Sep 18, 2009
Bert Scalzo and Dan Hotka review some of the more common and critical setup and configuration steps necessary to fully maximize your initial TOAD experience.
Deploying Merge Replication Subscribers in SQL Server
By Hilary Cotter
Sep 10, 2009
Hilary Cotter shows how to decouple your SQL Server snapshot generation from your snapshot application process for the best possible performance - all while letting you keep your sanity.
Oracle SQL: The Basics
By Alice Rischert
Aug 25, 2009
In this chapter you will learn the basics of the SQL language and use SQL Developer and SQL*Plus.

<< < Prev Page 3 4 5 6 7 Next >