MS SQL
9/05
This refresher on SQL Server examines when to use a database as well when not to, along with some of the key terms used with SQL Server. 9/03
This
article illustrates how to create a simple procedure to kill many sessions at
the same time, kill a range of sessions and kill all of the sessions
connecting to a database.
8/29
Join Business Intelligence Architect Bill Pearson as he kicks
off an exploration of Attribute Member Keys, a continuation of a body of
articles surrounding significant components of the Analysis Services
dimensional model. In this article we introduce Attribute Member Keys, focusing
upon the simple keys and their properties.
more...
Oracle
9/02
Oracle's new ADR with command interface shows promise for
DBAs to quickly investigate diagnostic information.
8/28
Learn how to install EBS, starting from scratch and walk away with an up and
running EBS instance using the Vision Enterprises database.
8/27
Oracle Database 11gR1 offers several new performance enhancements that limit
"round trips" between database server, application servers, and applications
when the identical data is required. The final article in this series explores
how the latest release of Oracle extends the ability to cache result sets to
applications and PL/SQL functions.
more...
MS Access
8/11
Garry Robinson fills the gap found in the Access 2007 help manual by providing some much needed help on how to use the charting object in Access 2007.
7/18
Garry Robinson outlines how usage data can make the quest to speed up an Access database more focused. The article also delves into an Access 2007 ACCDB only feature called TempVars.
6/16
Learn how to improve on what already is a very significant
security improvement in Access 2007--database encryption.
more...
DB2
8/04
Earlier installments of this series discussed how to use Microsoft Access 2007 as a graphical front end to a back-end IBM DB2 data server and how to leverage Access 2007 and DB2 as an integration layer. This installment examines how to build reports that run against DB2 data servers.
7/01
In this chapter you will be introduced to the DB2 family of products that run on the Linux, UNIX, and Windows operating systems.
6/11
Paul Zikopoulos gets you started on the path to DB2 9 and Visual Studio 2008 for .NET developers including hints and tips to get you in the express lane when it comes to enabling .NET
developers to build DB2 data-bound applications.
more...
