Databases
Multi Table Loop
This article examines how to loop through multiple tables to process the data.
Row Value Constructor in SQL Server 2008
This article illustrates different methods to insert data into a table, including the new Row Value Constructor, which simplifies the data insertion.
Programming, Perl + Oracle
Perl is a powerful scripting language that can meet your day-to-day scripting needs as a database administrator, and if used prudently, and responsibly, as a language to build large web-based applications. Here's a quick introduction to using Perl with Oracle.
SQL Server Management Studio Reports and Dashboard
This article examines the built in reports called SQL Server Management Studio Reports and an additional add-on called Performance Dashboard.
The Flash Guru: Serving FLV Files Over Slow Connections
In this latest installment of our popular monthly series, we again turn to our favorite Flash Video expert, Stefan Richter, to answer a question from our forum. This time: How to serve video to users with slow Internet connections.
Create Your Own Reports with Oracles Snapshot Information
If you are tired of running the same old Oracle AWR reports, not getting to the data quickly, or just need to write your own, then this article will get you started.
Oracle Database 11g: Database Replay - Part 1
This article provides a primer for using Oracle 11g Database Replay to effectively predict the performance of rapidly changing applications within increasingly fluid database environments.
Support Parameterization from Analysis Services Parameter Defaults
BI Architect Bill Pearson demonstrates a straightforward solution from the Analysis Services layer - for supporting parameter defaults that represent the last periods of data entry within our cube.
DB2 9 and Microsoft Access 2007: Working with your DB2 Data in Access 2007
Part one of this series discussed using Access 2007 as a graphical front end to a back-end DB2 data server. Part two examines how to leverage DB2 as an integration layer, and demonstrates some of the business rules that Access 2007 maintains when presenting DB2 data to information workers.
SqlCredit - Part 15: The Cost of Distribution
Part 15 of this series examines what cost is paid when tables are separated into multiple databases on the same server.
SQL Server 2005 Express Edition - Part 21: Using Replication Management Objects
Recent installments of this series have demonstrated SQL Server 2005 Express Edition's replication characteristics by taking advantage of replication-specific executables and T-SQL code combined with Windows Synchronization Manager and Web Synchronization technologies. This article explores another method of reaching the same goal, which involves Replication Management Objects (RMO).
Connection Strategy for Multiple Database Environments
Greg Larsen looks at one way to design your database connection strategy to simplify changing application connections so you can plug-n-play databases with less administrative overhead when the need arises.
Oracle DBA in an Oracle Applications World
Steve Callan takes a look at what is behind the smoke, mirrors, and curtains of Oracle Applications.
DB2 9 and Microsoft Access 2007 Part 1: Getting the Data
Paul Zikopoulos explores how to configure Access 2007 as a graphical front-end for DB2 data operations.
Dimension Attributes: Introduction and Overview - Part 2
Join Business Intelligence Architect Bill Pearson as he continues his subseries surrounding components of the Analysis Services dimensional model. In this article we continue our introduction to dimension attributes, focusing upon the Basic group of attribute properties.
Policy-based Management in SQL Server 2008 Part 1
Policy-base Management is a new feature in SQL Server 2008 that helps Database Administrators manage SQL Server instances by intent through clearly defined policies. This article introduces the basics of Policy-based management and shows an example of using this new feature to prevent incompliance.
UPSERT Functionality in SQL Server 2008
This article illustrates the functionality of UPSERT via the MERGE command in SQL Server 2008.
Using Microsoft Access to Query and Update Web Sites
Learn how you can use an Access Database and VBA to manipulate a Web 2 application.
Implementing a Left Join with LINQ
Learn how to implement a Left Outer Join with LINQ.
Authenticating Merge Web Synchronization
We have been discussing SQL Server 2005 Express Edition replication-specific features, investigating authentication mechanisms that are available in order to accommodate connection attempts from remote clients interacting with SQL Server-based distributor via Internet Information Services. We will continue coverage of this topic here.
Oracle Indexing - What, Where, When?
If you are new to databases, or perhaps new to Oracle, you may find the discussion on indexes and indexing strategy complicated. Don't fret. To get started it's fairly straightforward, and as long as you pay attention to the options relevant to day-to-day DBA needs, it should remain fairly simple.
Recovering from Loss of All Control Files
Follow these easy steps to restore a database when the control files haVe been lost.
Set Functions: The StripCalculatedMembers() Function
Business Intelligence Architect Bill Pearson continues his examination of MDX functions, this time introducing StripCalculatedMembers(). In this article, we expose the function, and then lead a hands-on practice session with examples that reinforce the concepts.
Storing Images and BLOB files in SQL Server - Part 4
Part 4 of this series focuses on storing BLOBs on the Windows File System and using Microsoft SQL Server to organize them from a web page.
Measuring Disk I/OOracles ORION Tool
Oracles ORION workload tool enables architects to effectively develop a workload that can mimic and stress a storage array in the same manner as planned applications with an Oracle backend database.
Top Queries in SQL Server 2005
This article illustrates how to query dynamic management views to find the TOP queries based on average CPU and average I/O.
Understanding DB2: Learning Visually with Examples
This excerpt from "Understanding DB2: Learning Visually with Examples" covers the the history of DB2, the information management portfolio of products, how DB2 is developed, DB2 server editions and clients, how DB2 is packaged for developers and syntax diagram conventions.
Exam 70-443 Practice Test from uCertify.com
Greg Larsen reviews the M70-443 PrepKit exam software that helps you prepare for the "Designing a Database Server Infrastructure by using Microsoft SQL Server 2005" exam (70-443), which is one of the exams you need to pass as part of the Microsoft IT Professional: Database Administrator certification.
SqlCredit - Part 14: The Cost of Translation
SQL Server allows us to create a facade using views and triggers so that a table that originally had a certain design can be replaced by a view that looks like the original table to (almost) any code that accesses it. The question answered here is how this translation affects performance.
Using Vertical and Horizontal Table Structures in Oracle
Compare different ways to persist data in a database table. A vertical data layout is one option to consider, as is horizontal tables. Decide which is best for you.
Exposing a Database as a Web Service
Gain a good understanding on how to expose databases as a Web Service using Axis2.
Licensing and Auditing in Oracle
Steve Callan discusses what can take place during the Oracle licensing or renewal process.
Parameterization from Analysis Services Cascading Picklists
BI Architect Bill Pearson adds refinements to Analysis Services- based parameterization within Reporting Services. In this article, we add support for cascading picklists.
Oracle: Unusable Indexes
JP Vijaykumar examines what happens to an index when it becomes unusable.
Authenticating Merge Web Synchronization
SQL Server 2005 Express Edition - Part 19: So far, we have presented a simplified scenario that illustrated Web Synchronization's basic setup and discussed several options. This article will further elaborate on this subject, by focusing on authentication settings that are available when configuring Web access for multi-tier SQL Server-based applications.
Access TreeView-ListView Basics
This article focuses on getting started with Access TreeView and ListView controls.
Using dtutil to Copy SSIS Packages Stored in SQL Server
Learn how to copy SSIS packages stored in SQL Server and their associated package roles using the dtutil command line utility.
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep
This excerpt from "DB2 9 for Linux, UNIX, and Windows" introduces the DB2 family of products that run on the Linux, UNIX, and Windows operating systems.
Find Space Usage by Table, Schema in SQL Server 2005 and 2008
Learn how to identify which schemas and tables are using the most space by querying system catalogs.
The SQL Builder Development Accelerators: The Rest of the Story
Part 8 of this series rounds out the features of the SQL Builder and finishes off with a great feature that is part of the SQL Editor -- SQL templates.
Dimension Attributes: Introduction and Overview, Part 1
Join Business Intelligence Architect Bill Pearson as he continues his subseries surrounding components of the Analysis Services dimensional model. In this article we introduce dimension attributes, and follow up with an examination of the Advanced properties of a sample attribute.
Create a Database Manually - When & Why?
Peering into the Oracle database creation process really pulls back the curtain on the inner workings of the database, allowing us to understand all of the levers, and pieces that make up a running Oracle database.
SQL Server 2005 Express Edition - Part 18 - Merge Web Synchronization Setup
Part 18 of this series explores several scenarios in which the Merge Web Synchronization can be applied and describes their implementation details.
Programming with LINQ to SQL
You can use LINQ to SQL to define an Object Relational Mapping between SQL tables and then query those tables with LINQ.
Hands-on Oracle: Backup & Recovery Games
Learn what happens within the database after the loss of a control file and test it out yourself using a flash drive.
Storing Images and BLOB files in SQL Server - Part 3
Part three of this series walks you through building a web-based application for inserting images into SQL Server.
Measuring Disk I/OA Vendor View
Learn how to compare the workload of a database with the actual mechanical capabilities of individual disks.
Microsoft SQL Server 2008 - Change Data Capture Part 4
Part 4 of this series illustrates how to generate DML [Data Manipulation language Insert, Update and Delete] statements from the history table.
A High Availability Data Synchronization Architecture
Learn how to synchronize high availability databases and set up synchronization systems without single points of failure.
Set Functions: The AddCalculatedMembers() Function
Business Intelligence Architect Bill Pearson continues his examination of MDX functions, introducing AddCalculatedMembers(). In this article, we expose the function, reinforcing the basic concepts, as always, with hands-on practice examples.
SQL Server DBA Dashboard
This article examines a tool called the "SQL Server DBA Dashboard" that provides a number of different Custom Reports that can be used to monitor activities within a SQL Server instance.
Oracle Database 11g: SQL Plan Management, Part 2
Part 2 of this series explains how SQL Plan Management can be used during the upgrade of an existing Oracle 10gR2 database to an Oracle 11g environment, as well as during the deployment of brand new application code, to effectively limit unexpected regression of SQL statement performance.
Cascading in Oracle: Friend or Foe?
Is cascading always a good thing? Steve Callan looks at some of the more common operations where cascade is used.
Support Parameterization from Analysis Services
BI Architect Bill Pearson demonstrates a straightforward solution ? from the Analysis Services layer - for supporting parameterization within Reporting Services.
SQL Server 2005 Express Edition - Part 17: Merge Web Synchronization
Continuing a discussion on the limitations of SQL Server 2005 Express Edition's replication characteristics, this article explores Web Synchronization, with SQL Server 2005 Express Edition instances operating as merge replication subscribers connecting to a publisher via HTTPS protocol.
SqlCredit - Part 13: More on Indexed Persisted Computed Columns
Part 13 of the "Developing a Complete SQL Server OLTP Database Project" series continues an examination of persisted computed columns, this month discussing performance issues and the PCC Column DataType.
DST checking with Windows Powershell
Incorrect time on a server that hosts trading databases screws up transactions and irritates end users. Yan Pan walks through a script that can be re-used every year to report the wrong time on any SQL Server host.
Microsoft SQL Server 2008 - Change Data Capture: Part 3
Part 1 and 2 of this article illustrated how to enable Change Data Capture on a database and on a table. Part 3 continues with an illustration of what happens to Change Data Capture when the table structure is changed.
DB2 9.5 and IBM Data Studio: Part 7: The SQL Builders Development Accelerators
Paul Zikopoulos introduces his four favorite features available in the IBM Data Studio SQL Builder: SQL Assist, Content Tip, colorization, and the design-time parser.
Adding RDL-Resident Code to Reporting Services Reports
Sometimes, it's just easier to use your Visual Basic skills to incorporate complex logic in a report expression.
Dimensional Model Components: Dimensions Part 2
Business Intelligence Architect Bill Pearson continues his subseries surrounding components of the Analysis Services dimensional model. In the second half of this article, we extend our focus on dimensions to include property settings for Cube Dimensions.
Migrating MySQL to Oracle: Part 2
This two-part article discusses all of the steps involved in migrating a database and its attendant applications. Part 2 covers moving production data to development systems, Oracle Migration Workbench, database application migration and more.
Access Paired Forms
Nearly every Access developer will admit to having learned much about user interface design from the Northwind sample database but in time most of us look for ways to improve upon, or deviate from, the template we know so well. My latest idea makes its dbut in this month's article: Paired Forms.
Secrets of the MySQL Client Command Line
Uncover some of MySQL's little-known client features and manage your data more effectively than ever!
Keywords in Oracle
Some words in Oracle can be categorized as reserved words and keywords. Within the keywords category, context comes into play because a word isn't always reserved. Read on to learn how to distinguish between the two.
SQL Server 2005 Express Edition - Part 16 - Transactional and Merge Replication
Marcin Policht provides a step-through sample implementation of transactional and merge replication.
Measuring Disk I/O
Oracle has a variety of I/O types that ultimately need to be mapped, sampled, and related to storage. This article looks at extracting various I/O statistics so that you can monitor and determine just how well your disks are doing.
Microsoft SQL Server 2008 - Change Data Capture - Part 2
Part 2 of this article illustrates how to enable Change Data Capture on a database, on a table and how SQL Server tracks the data changes of the CDC enabled table.
DB2 9.5 and IBM Data Studio: Building an SQL Statement
Part six of this series discusses how to leverage the SQL editor in IBM Data Studio to quickly and easily build an SQL statement.
MDX Numeric Functions: The Min() Function
Business Intelligence Architect Bill Pearson introduces the numeric Min() function, and leads hands-on practice examples of its use.
Storing Images and BLOB files in SQL Server - Part 2
Part two of this article focuses on using the SQL Server Binary data type to store small image files.
Parameter Support Objects - Part 2: Support OLAP Parameter Defaults with Datasets
Join BI Architect Bill Pearson as he continues his examination of parameterization within Analysis Services reports. In this article, we provide a solution for supporting parameter defaults that represent the last periods of data entry within our cube.
Building Custom Reporting Services Reports for SQL Server Management Studio
Learn how to build Custom Reports, without installing Reporting Services, using a new feature found in Microsoft Service Pack 2 (SP2) for SQL Server 2005.
Oracle Database 11g: SQL Plan Management - Part 1
This article - the first in this series - provides a primer to SQL Plan Management principles and offers a simple demonstration of its performance tuning capabilities.
SQL Server 2005 Express Edition - Part 15: Snapshot Replication
SQL Server 2005 Express Edition's replication characteristics' feature set has been significantly restricted compared with its predecessor and full-fledged counterparts. This article examines the practical implications of these restrictions by illustrating the process of setting up a snapshot replication.
SqlCredit - Part 12: Exploring Indexed Persisted Computed Columns
Part 12 of the "Developing a Complete SQL Server OLTP Database Project" series quickly hits the basics of persisted computed columns and then moves on to performance comparisons and other interesting details.
Dimensional Model Components - Dimensions Part 1
Business Intelligence Architect Bill Pearson launches a new subseries surrounding components of the Analysis Services dimensional model. In this two-part article, we introduce dimensions, and focus upon property settings for Database Dimensions.
Managing Oracle's Undo Tablespaces
With the advent of Automatic Undo Management (AUM), Oracle abstracts the management of undo space for you. Read along as Steve Callan explains the intricacies of undo tablespaces.
MS Windows PowerShell and SQL Server 2005 WMI Providers - Part 2
Part 2 of this series covers the WMI Provider for Server Events explaining how to monitor DDL and trace events in a SQL Server instance by leveraging this provider and Windows PowerShell.
Multiple Selection Through Bitmasks
Ever wish you could store multiple selections to a single table column? The solution, Bitmask Fields, have been in use for decades. Follow along as Danny Lesandrini shows you how to unlock the power of two.
Oracle RAC 64 bit for Windows: Preparing the Virtual Environment
Part 4 of this series covers installing Oracle 11g RAC on a 64 bit Windows system using Windows 2003 Service Pack 2.
Reporting Services: Customize Automatically Created Parameter Support Objects
Join BI Architect Bill Pearson as he continues his examination of parameterization within Analysis Services reports. In this article, we create basic report parameters using the graphical user interface, and then customize automatically created support objects to remove the All selection that appears in picklists by default.
Oracle Security: The Big Picture
This book will help the DBA to assess their current level of risk as well as their existing security posture. It will then provide practical, applicable knowledge to appropriately secure the Oracle database.
Oracle 10g Backup Guide: A Small County Government Approach
This document offers one approach to database backups for Oracle 10g databases on Windows 32 and 64 bit servers.
Microsoft SQL Server 2008 - Change Data Capture - Part 1
Part one of this series illustrates how to enable Change Data Capture on a database, and on a table, and how to keep track of Data Definition Language changes on a table.
Migrating MySQL to Oracle - Part 1
This two part article discusses all of the steps involved in migrating a database and its attendant applications, questions to ask yourself, what to watch out for, and how to perform the whole thing within a limited window of downtime.
More on Using Tools for Tracing
There is more than one approach or tool to use in a tuning opportunity. Part two of this article covers Tracing and TKPROF.
DB2 9.5 and IBM Data Studio: Using OLE DB to Integrate Data
Part 5 of this series introduces the OLE DB function capability available in IBM Data Studio.
SQL Server 2005 Express Edition - Part 14: Replication Support
SQL Server 2005 Express Edition's small footprint and free-of-charge use has some negative implications, imposing restrictions on functionality available in the Standard or Enterprise editions. This is especially conspicuous in the case of replication, which we will explore starting with this installment.
Storing Images and BLOB files in SQL Server
This article explores the data types and methods used for storing BLOBs (Binary Large Objects), such as images and sounds, inside SQL Server.
Oracle Library CachePart 2
Part two of this article looks at issues that arise in the Library Cache, how to find those issues and offers solutions to fix them.
New datetime datatypes in SQL Server 2008
Older versions of SQL Server had only one datatype to store both the date and time values. In SQL Server 2008, Microsoft introduces a set of new datatypes that store date and time individually, and both date and time together.
RMAN Tablespace Point in Time Recovery
A user deletes data from a table and commits it. How do you retrieve that data? RMAN tablespace point in time recovery (TSPITR), of course!
MDX Numeric Functions: The Max() Function
Business Intelligence Architect Bill Pearson introduces the numeric Max()function, and leads hands-on practice examples of the basic concepts.
SQL Server 2005 - Hacking password Encryption
Part 2 of this article discusses how to hack/de-cipher the data that has been encrypted by passphrase.
DB2 9.5 and IBM Data Studio: Overview Diagrams, Continued
Part 4 of this series finishes a tour of overview diagrams and introduces some features you can use with them to make them even more useful than simple, quick visuals.
Disk Space Usage and SQL Server Performance
Every extra byte of space you waste in your database causes a performance hit to your application. This article looks at disk space usage and how it affects performance.
SQL Server 2005 Express Edition - Part 13: ClickOnce Deployment and Security
In order to fully understand all aspects of ClickOnce publishing parameters, it is important to become familiar with security mechanisms that affect its outcome. The main purpose of this article is to present their overview.
Oracle Database 11g: SQL Performance Analyzer - Part 3
This article - the final one in this series- explores how the SQL Performance Analyzer can effectively analyze changes in SQL statement performance due to modified database initialization parameters.
Oracle Library Cache - Part 1
Gaining an understanding of internal Oracle structures is essential to becoming better DBAs and servicing our end user community. Oracle's library cache is one such internal structure that can help eliminate some very nasty denial of service requests originating from application users. Read on to learn more.
BACKUP compression in SQL Server 2008
Learn how to take Full, Differential and Transactional log backups with and without compression, and how to enable compression as a default.
Migrating Access Apps to SQL Server
The final article in this series covers Optimizing Client Server Queries.
Manage Unknown Members in Analysis Services 2005 - Part 2
Business Intelligence Architect Bill Pearson continues his hands-on introduction to managing Unknown Member scenarios within Analysis Services 2005.
Eight Ways to Hack Oracle - Part 2: Vulnerability, System Commands and Security
Part 2 of this series covers four vulnerable areas, the Oracle Listener, privilege escalation to get more access from a less privileged login we already have, executing operating system commands, which can be very powerful, and under appreciated, and lastly filesystem security.
Oracle Tuning Using Tracing, STATSPACK, AWR and Toad
Learn the pros and cons of different tools, Oracle-owned or otherwise, that can be effective in helping a DBA solve a performance problem.
Open Source Virtualization: Oracle VM Manager Installation
Part three of this series covers how to install the Oracle VM Manager on your Workstation skeleton.
SQL Server 2005 Express Edition - Part 12: ClickOnce Deployment and Updates
Part 11 of this series presented the publishing options of ClickOnce-capable applications that involve User Instance-based databases. This article takes a closer look at the deployment process, demonstrating the impact of your selections on its characteristics.
Set Functions: The .AllMembers Function
Business Intelligence Architect Bill Pearson introduces the useful .AllMembers function, reinforcing the basic concepts, as always, with hands-on practice examples.
Data Encryption in SQL Server 2005 - Part 1
SQL Server 2005 provides four methods of encryption. Part one of this article covers encryption and decryption by passphrase.
DB2 9.5 and IBM Data Studio - Behind the Story
Paul Zikopoulos shares the vision and the ideology behind the new IBM Data Studio toolset.
Installing SQL Server 2008
This article highlights the steps involved to install SQL Server 2008.
Scheduling Jobs in the Database
Learn about the Oracle job queue sub system and its usage in scheduling and executing PL/SQL routines at predefined times and/or repeated job execution at regular intervals.
Snapshot Reports II: SQL Server Management Studio Perspective
BI Architect Bill Pearson concludes his subseries surrounding Caching Options, examining the use of SQL Server Management Studio to configure / manage Snapshot Caching.
Oracle Database 11g: SQL Performance Analyzer - Part 2
This article - the next in a series on new Oracle Database 11g SQL performance improvement features - discusses how to use the SQL Performance Analyzer to evaluate a SQL workload generated from an Oracle 10gR2 database to detect potential performance issues for that workload if it were executed within an Oracle 11g database system.
Advanced Active Record Validations with Rails
Use Rails' Active Record validation callbacks to exercise greater control over user input.
SQL Server Security Model
Greg Larsen discusses the different options available within SQL Server 2005 for managing security.
Saving Time by Reusing Storage
While truncating a table to remove data is faster than deleting the same data, there are subtle differences that when taken into account, can help improve the overall performance of a job or process. Read on to learn the advantages and disadvantages of each.
SqlCredit Part 11: Change Tracking Using History Records
Change tracking is an important requirement of most OLTP systems. If the PrimaryCardHolder on an account was updated, you should be able to tell who made the change, when they made it, and what the old and new values are. This article discusses tracking these changes in three different types of history records.
UNIQUE Column with Multiple NULL Values
Learn how to maintain uniqueness on a column while still allowing multiple NULL values.
Windows PowerShell and SQL Server 2005 WMI Providers: Part 1
Learn how to perform administrative tasks by accessing the SQL Server 2005 WMI Providers using Window PowerShell.
SQL Server 2005 Express: Deployment and Maintenance Options
Part 11 of the series focuses on the process of deploying and maintaining user instance-based applications that employ ClickOnce technology.
SQL Server Reporting Services: Getting Started
Explore SQL Server Reporting Services and see how to get started quickly.
Avoiding Data Corruption with Rails' Active Record Validations
Use Rails' Active Record validations feature to filter user input with ease.
File Management with Scripting Object
Once you get familiar with the File Scripting Object (FSO), managing files in Access is not so bad--getting started is the painful part. To help you along, this month's download includes sample code for both Access (early bound) and VB Script (late bound).
Manage Unknown Members in Analysis Services 2005, Part 1
Manage members for which no underlying data exists to populate dimensional attributes. Business Intelligence Architect Bill Pearson provides hands-on guidance in handling these Unknown Member scenarios within Analysis Services 2005 through setting associated properties.
Product Review: Oracle PL/SQL Tuning
Books on PL/SQL, like books on other topics related to Oracle, range from the just so-so to what can be called bible status. With respect to PL/SQL, tuning included or not, Tim Halls book is one of those high return on investment purchases.
DB2 9.5 and IBM Data Studio - Part 3: Overview Diagrams - The Basics
Part 3 of this series examines more deeply the overview diagrams introduced in part 2.
Installing Oracle 11g RAC on VMware ESX 3i - Part 1
This article covers installing Oracle 11g RAC on the VMware workstation in ESX 3.x compatibility mode, in anticipation of the release of ESX 3i.
Building a BizTalk Pipeline Content Enricher with SQL Server 2005
Learn how to implement the Content Enricher integration pattern using BizTalk 2006 R2 and SQL Server 2005.
Custom Pipeline Component for the DB2 Adapter
Discover how to use BizTalk custom pipelines to more effectively pull data from the DB2 adapter.
SQL Server 2005 Express Edition - Part 10: Embedded Databases
Part 10 of our series offers more insight into the design and distribution of applications when implementing applications with embedded databases that support XCopy deployment (and depend on user instance technology).
Application Handling of Database Timeouts and Deadlocks
Learn how to minimize the occurrence of database transaction locking and how to handle situations when your database does return error codes that constitute deadlocks and timeouts.
MDX Essentials: Set Functions: The MeasureGroupMeasures() Function
Join Business Intelligence Architect Bill Pearson as he leads a hands-on introduction to the MeasureGroupMeasures() function. Put MeasureGroupMeasures() to work in your own scripting or reporting environment to exploit a list of all measures in the specified measure group.
Eight Ways to Hack Oracle
As with any computing system, there are ways to hack it, and Oracle is no exception. This series discusses some of the ways that you can get at data you're not supposed to, and how to defend against those attacks.
DB2 9.5 and the IBM Data Studio
Part 2 of this series delves into some of the enhanced and new features of the Database Explorer View in DB2 9.5, focusing on the options available from a live database connection object.
Windows PowerShell and SQL Server 2005 SMO - Part 11: Redirection
Learn how to use PowerShell cmdlets in conjunction with the SQL Server client and output redirection to export to a text file or XML file.
SQL 2008 Data Types
This article introduces the new Date and Time data types found in Microsoft SQL Server 2008, such as DATETIME2, TIME, and DATE. The traditional data types that have been carried forward from previous versions will also be reviewed.
Administering SQL Server 2005 Integration Services
This excerpt from "SQL Server 2005 Management and Administration" covers What's new in Integration Services with Service Pack 2, understanding, managing and administering Integration Services and command prompt utilities.
How to Build a Profile Script to Monitor SQL Server off Hours
Learn how to build a Profiler script that can be launched using a SQL Agent job that is scheduled to run during off hours.
Choosing the "Right" DBMS Engine
Picking the "best" database engine is not always (okay, it's rarely) easy.
Database Isolation Levels
Learn the concepts that every database programmer needs to know to develop applications that allow multi-user access to the database: Isolation levels.
Snapshot Reports 1: Report Manager Perspective
BI Architect Bill Pearson continues his subseries surrounding Caching Options, examining the use of Report Manager to configure Snapshot Caching.
SqlCredit - Part 10: MAC Performance and Updating SqlCredit
This month's installment of "Developing a Complete SQL Server OLTP Database Project" covers MAC performance results, a summary of encryption findings, and comments on updating the SqlCredit code based on those findings.
Oracle Database 11g: SQL Performance Advisor - Part 1
This article the first in a series on new Oracle Database 11g SQL performance improvement features reviews how to set up and utilize these features and provides a simple simulation of how SQL Performance Advisor can detect changes to an Oracle 11g database system.
Hashing in Oracle
Hashing is but one of many cleverly implemented functions embedded in Oracle. Learn all about it, what it is and how to use it.
Partitioning a Non-Partitioned Oracle System
Learn how to bring back manageability and responsiveness using Database Partitioning on your current Non-Partitioned system.
SQL Server 2005 Express Edition - Part 9: Managing User Instances
SQL Server 2005 Express Edition's unique functionality allows you to distribute and implement single-user databases, without the dependency of having administrative privileges or the need for a cumbersome configuration. This article illustrates the practical use of this feature, known as XCopy deployment.
DB2 Viper II and the IBM Data Studio Developer Workbench
In part 1 of this new series, Paul Zikopoulos introduces the Database Explorer that's part of the new IBM DS DWB in the DB2 Viper II open beta.
Using Oracle 10g Tuning Utilities
Starting with 10g, Oracle introduced Advisors, which are part of the ADDM (Automatic Database Diagnostic Monitor) and run in the background. This article discusses some of the more common ADDM utilities used and how they can help troubleshoot and tune the database.
Oracle RAC Benchmarking with SwingBench 2.2
Tarry Singh discusses why benchmarking is important and offers an overview of SwingBench 2.2, a free Java based utility, to stress test Oracle databases.
MS Windows PowerShell and SQL Server 2005 SMO: Part 10
This installment of the series illustrates how to use PowerShell scripts in conjunction with SMO and parameters to Generate an SQL Server Script.
SQL Server 2005 Express Edition - Part 8: XCopy Deployment
Part 8 of our series provides an overview of User Instance model (also known as Run As Normal User or simply RANU) and automatic database connectivity, which serve as two primary enablers for XCopy deployment, facilitating distribution of single-user databases.
Oracle, MySQL and PostgreSQL Feature Comparison - Part 2
In the last piece of our database comparison, we hit upon various areas such as triggers, views, and stored procedures. This time around, we'll discuss some areas where the platforms differ more significantly, most importantly in their handling of complex SQL and optimizing choices.
Transportable Tablespaces: Why the Platform Matters
Steve Callan discusses why the platform matters when using transportable tablespaces.
String Functions: The .Properties Function - Part 2
Business Intelligence Architect Bill Pearson continues his hands-on introduction to the .Properties function. In this article, we examine the use of the TYPED flag within the .Properties function to deliver a strongly typed value using .Properties.
Whats New in SQL Server 2008 - Part 3
Don Schlichting highlights some of the new features and benefits found in SQL Server 2008. Covered in Part 3 of this series is new Data Integration features, enhancements to Analysis Services, Reporting Server additions, and Office integration.
Troubleshooting ASM problems on VMware ESX 3.x: Part 2
Tarry Singh looks at some problems that can be encountered during ESX 3.x Oracle RAC setup, and how to fix those problems.
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 9
Learn how to use PowerShell in conjunction with SMO to Generate an SQL Server Script.
Preparing for the M70-444 Exam
Are you considering becoming a Microsoft Certified DBA? Where do you start? How do you prepare for getting certified? This article reviews one set of practice tests for the Microsoft M70-444 exam that is provided by "uCertify.com".
Report Execution Caching 2: Report Manager Perspective
BI Architect Bill Pearson resumes his Caching Options subseries, examining the use of Report Manager to configure Report Execution Caching.
SqlCredit Part 9: Message Authentication Codes
This month's installment of "Developing a Complete SQL Server OLTP Database Project" covers searching encrypted data, dictionary attacks, and look-ups by hashed value.
Oracle Database 11g: Automatic SQL Tuning
This article delves into a new Oracle Database 11g feature that significantly extends this powerful 10g feature by providing the ability to implement improved execution plans automatically within DBA-specified boundaries.
The Dictionary in the Data Dictionary
Take on a trip into Oracles data dictionary, specifically, the dictionary part or aspect of it.
Manage Your MySQL Database with Rails' Migrations
Manage your MySQL database with incredible ease using Rails' migrations feature.
SQL Server 2005 Express Edition - Part 7: Post Installation Configuration Tasks
Previous articles have described activities that enable remote connectivity and enhance security through encryption of network traffic between the database engine and its clients. In this installment, we will look into a few other options intended to simplify the handling of administrative responsibilities.
XML-Enabled Applications - Part 2: Building PHP Applications on Oracle
Oracle XML DB allows you to perform SQL operations on XML data as well as XML operations on relational data, thus bridging the gap between the SQL and XML worlds. You can choose between several storage options and achieve required levels of performance and scalability.
Migrating Access Apps to SQL Server
Danny Lesandrini introduce some home-made tools that may be useful to your migration process, and explain a few of the "gotcha's" associated with the move from a Microsoft Access database to SQL Server 200x.
Tuning an Oracle Procedure
Join JP Vijaykumar as he tunes a procedure that is running for eight hours, bringing the run time of the procedure down to 37 minutes.
MS Windows PowerShell and SQL Server 2005 SMO: Part 8
Part 8 of our series illustrates how to use PowerShell in conjunction with SMO to display object properties of all SQL Server Objects.
Troubleshooting ASM problems on VMware ESX 3.x
Several errors may be encountered when setting up ESX 3.x on Oracle Rac. This article covers some of those errors and how to fix them.
Report Execution Caching I: SQL Server Management Studio Perspective
BI Architect Bill Pearson continues a three-part sub-series on Caching Options within Reporting Services 2005. In this article, we focus upon Report Execution Caching, and its configuration from SQL Server Management Studio.
SQL Server 2005 Express Edition - Part 6: Post Installation Configuration Tasks (Encryption)
Part 6 of this series continues the discussion of network-based configuration tasks, describing other activities that alter default connectivity settings applied during standard installation, focusing in particular on encryption.
Oracle's Transportable Automatic Workload Repository
Oracles Automatic Workload Repository provides a whole new way of gathering, comparing and storing statistics. Read on to learn how AWR differs from the old statspack reports.
Making Database Administration Easier with Freeware
Cygwin, an OpenSSH application, helps relieve the stress of more commonly seen administration problems, including not being able to get a GUI tool (e.g., Oracle Universal Installer) to display and not being able to have it display at the correct location.
Alternatively Sorting Attribute Members in Analysis Services 2005
Go beyond sorting attribute members based upon their own name or key value. Business Intelligence Architect Bill Pearson provides hands-on guidance in sorting attribute members by the name or key of a secondary attribute in Analysis Services 2005.
Whats New in SQL 2008 - Part 2
Don Schlichting highlight some of the new features and benefits found in SQL Server 2008. Covered in Part 2 of this series is Development changes, new Business Intelligence features, Integration additions, and new Data Types.
Using Orion Calibration to Check I/O Numbers
Orion is an I/O metrics testing tool, designed specifically to simulate the I/O workload before installing Oracle RAC on the hardware. It is ideal for capacity planning and checking DAS, SAN or NAS storage.
MS Windows PowerShell and SQL Server 2005 SMO: Part 7
Part 7 of our series illustrates how to use PowerShell in conjunction with SMO to display SQL Server Objects.
String Functions: The .Properties Function
Business Intelligence Architect Bill Pearson introduces the basic .Properties function, within the first of a two-part article surrounding this important member of our MDX toolsets.
Setting Up Delegation for Linked Servers
Learn how to set up delegation on your SQL Server instances, so you can use the impersonate options when setting up the security properties of linked server definitions.
Product Review: HyperBac for Oracle
A relatively new product called HyperBac provides an excellent alternative to Oracle 10gR2 compressed backupset methodology without the need to modify any RMAN backup, restoration, and recovery scripts. This article provides an overview of HyperBac features that nicely complement Oracle 10gR2's enhancements to database backups and exports.
SQLite: The Sensible Database Solution
Take a look at SQLite, a fully featured relational database which, at just 250KB, is by itself able to easily fit on a floppy disk yet capable of managing terabyte-sized databases. You also will see how it works with PHP.
Report Session Caching in Reporting Services 2005
BI Architect Bill Pearson begins a three-part sub-series on Caching Options within Reporting Services 2005. In this article, we focus upon Report Session Caching.
SQL Server: Post-Installation Configuration Tasks
Part 5 of our series continues exploring post-setup tasks, focusing on network specific tasks.
SqlCredit Part 8: Comparing Encrypt/DecryptByCert and Encrypt/DecryptByKey
Having seen in Part 7 of this series that the performance impact of using EncryptByCert and DecryptByCert was unacceptable for any high-volume, transactional data, this month we'll compare that to EncryptByKey and DecryptByKey.
Bring Your Forms to Life With JavaScript
In this article you'll learn how to prevent errors in your forms. This method validates the form and provides immediate feedback to the user. If the form has been correctly filled out, the submit button is enabled, if not, the button remains grayed out.
Clearing Alerts in Enterprise Manager
Using Oracle Enterprise Manager can be one of the most frustrating experiences in Oracle because of OEMs non-intuitive, disjointed interface and OEMs inability to clean up after itself. Follow along with Steve Callan as he delves into the mystery of how to clear alerts in Enterprise Manager.
Stitching Up Time Zones
Performing brain surgery on the Registry need not be fatal.
Programming SQL Server 2005 Compact Edition with ADO
Learn how to use ADO.NET to connect to the SQL Server Compact Edition database as well as how to read, update, and merge the changes back to the SQL Server Compact Edition database in this excerpt from "Microsoft SQL Server 2005 Compact Edition".
Introduction to Linked Objects in Analysis Services 2005
Business Intelligence Architect Bill Pearson overviews Linked Object options that debut with Analysis Services 2005.
Browser Style Form Navigation
This article series features a demo app affectionately named Something Not Entirely Unlike Access, which employs a variety of methods to obfuscate the "Accessian" features. Last month, we discussed how to automatically resize subforms, the way some browser frames work. This month, we'll tackle navigation.
Clustering Oracle RAC Virtual Machines Across Physical and ESX Hosts
Part 4 of this series examines various possibilities for building clusters across several physical and ESX hosts and takes a quick look at upgrading clustered Virtual Machines in all the three scenarios.
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 6
Part 6 of "Microsoft Windows PowerShell and SQL Server 2005 SMO" illustrates how to use PowerShell and PowerShell script to backup databases.
Teach Yourself Microsoft SQL Server T-SQL: Working with SQL Server
This excerpt from Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes discusses how to connect and log into SQL Server, how to issue SQL Server statements, and how to obtain information about databases and tables.
DB2 9 and Microsoft Excel 2007 - Part 4: Creating a Pivot Table
Part 4 of this series examines how to leverage the framework created in part 3 and how to create and populate (with DB2 9 data) one of the most important and capable data analysis tools around: pivot tables.
SQL Server 2005 Express Edition - Part 4: Surface Area Configration
This article demonstrates how you can use Surface Area Configuration utility in order to modify some of the security-related settings that have been applied during installation of SQL Server 2005 Express Edition.
Hierarchical TableAdapters 301
Are you having problems setting up a TableAdapter that can be fed from stored procedures instead of base tables? Here is a road map to guide you to success.
Oracle, MySQL and PostgreSQL feature comparison - Part 1
Oracle, MySQL and PostgreSQL obviously have a lot of features, and different solutions for the same problems. This article looks at the major features, such as stored procedures, views, snapshots, table datatypes, transactions, and so on, to discover which ones do what you need.
Learning Oracle by the Numbers
It's hard enough mastering Oracle 10g, let alone trying to devote time to learning the nuances of an older version. Steven Callan offers advice on how to overcome a step or two backwards with respect to Oracle.
Logical Functions: IsGeneration(): Conditional Logic within Filter Expressions
Use IsGeneration() to support conditional logic within filter expressions. BI Architect Bill Pearson looks beyond employing IsGeneration() in calculations, and provides hand-on practice in its use within the MDX Filter() function.
DB2 9 and Microsoft Excel 2007 Part 3: Building Your Own Queries
Learn how to use the Microsoft Query function that's part of Excel 2007 to customize the data that's retrieved from the STAFF table as opposed to the entire data that's retrieved when using the DB2STAFFTABLE connection object that we built in Part 1 of this series.
What's new in SQL 2008 - Part 1
SQL Server 20008 will be released approximately February of 2008, along with a new version of Visual Studio and Windows. This article will highlight some of the new features and benefits found in SQL Server 2008.
Oracle RAC: How shared storage works on VMware - Part 3
Our previous article looked at the clustering possibilities on the ESX Server. In this article, we will examine the various possibilities for building clusters across several physical ESX hosts and the clustering possibilities across ESX hosts and physical machines.
Setting up a Linked Server for a Remote SQL Server Instance
Learn how a linked server can be used to seamlessly provide an application access to data on a different instance of SQL Server.
RMAN Disk to Disk Backup Methods
Disk to disk backups are becoming the norm. This article takes a 1,000 foot view to help evaluate your options.
SqlCredit Part 7: Performance Impact of EncryptByCert and DecryptByCert
Part 7 of our "Developing a Complete SQL Server OLTP Database Project" discusses performance issues resulting from using EncryptByCert and DecryptByCert. Read the article and download the code to run the test yourself.
Oracle RAC: How shared storage works on VMware - Part 2
Part two of this series discusses creating clustered virtual machines on VMware's ESX 3 Server.
Oracle Database 11g Release 1 New Features Summary - Part 2
Oracle Database 11g Release 1 was launched in mid-July 2007. This second article in a two-part series takes some tantalizing glimpses into the upcoming improvements to database performance and database management that expand even further the revolutionary concepts introduced in Oracle Database 10g.
DB2 9 and Microsoft Excel 2007 - Part 2: Working with the DB2 Data
The last article of this series discussed how to get DB2 data into Microsoft Excel 2007 worksheets, some nice formatting capabilities in Excel 2007 and how to apply them to your DB2 data. This article examines some additional advanced features, and analysis capabilities that are part of Excel 2007.
Perform SQL Queries Using Google-Style Syntax
How would you like to enable searching of your SQL Server data using Google-style syntax instead of Transact-SQL? Because of the commonality of the Google search syntax, most web users find it simple to construct a query using it. This article will show how to implement a .NET class library to perform a full-text search on a SQL Server table using Google-style syntax.
SQL Server 2005 Express Edition - Part 3: Installation
Part 3 of this series describes the installation process of different versions of SQL Server 2005 Express Edition in more detail, including changes introduced in its Service Pack 2.
Using Non-Standard Port for SQL Server
Greg Larsen examines setting up SQL Server to listen on a different port number than 1433.
Oracle Database: Rotating Tables
Learn how to rotate a table to present the one to many relation between two tables as a one to one relation and present all the matching records in a single row.
Auto-Resize Access Subforms
Last month's article introduced an application called 'Something Not Entirely Unlike Access', which simulates some aspects of a web browser in Microsoft Access. This month's article focuses on the process of resizing subforms on the main form.
Open-source Technologies for Oracle DBAs and Developers: Part 2
The open-source community around databases, and Oracle specifically, has literally exploded in the last couple of years. The final installment of this two -part article covers o9pen-source administration, security, benchmarking and monitoring tools.
Getting Inside the Optimizer: Part 2
You dont have to accept what Oracle (or a third party tool) does in terms of an execution plan recommendation. Learn how to distinguish between which to accept and reject.
Open-source Technologies for Oracle DBAs and Developers
The open-source community around databases, and Oracle specifically, has literally exploded in the last couple of years. Sean Hull presents some of the biggest projects in this two part series.
SQL Server 2005 Express Edition - Part 2
Express Edition remains the primary choice for deployments of a full-fledged database engine in less demanding environments. Part two of this series explores its features in more detail in order to better understand its unique role in SQL Server 2005 portfolio.
Monitoring Stored Procedure Usage
Learn how you can use a few DMV's to identify the most frequently run SPs of an instance of SQL Server, as well as those SPs that use the most CPU, I/O or run the longest.
Handling NULLS in SQL statements
For some reason the ability to handle NULLS in SQL statements can confuse some. This article takes a look at how to think of NULLs to avoid some confusion.
Oracle RAC: How shared storage works on VMware : Part 1
Tarry Singh revisits the storage option on VMware Server, VMware Workstation and ESX 3.0.1 Server for Oracle RAC.
Microsoft Windows PowerShell and SQL Server 2005 SMO : Part 3
Previous installments of this series discussed PowerShell installation and simple SMO, WMI cmdlets. This installment illustrates how to script PowerShell cmdlets and execute them.
DB2 9 and Microsoft Excel 2007 - Part 1: Getting the Data
Paul Zikopoulos demonstrates just how easy it is to access data from DB2 9 in your Excel worksheets.
The Lure of Open Source Databases
Interviews with customers and vendors of open source and commercial databases provide a look at various aspects of what open source databases are offering today at a high level and how they stack up against their commercial counterparts from a business perspective.
Monitoring Changes to Your Database Schema
With the introduction of SQL Server 2005, Microsoft now allows you to write Data Definition Language (DDL) triggers to perform actions when events occur on your server. In this article, Greg Larsen discusses (examples included) some of the things that DDL triggers can be use for.
Monitoring Changes to Your Database Schema
With the introduction of SQL Server 2005, Microsoft now allows you to write Data Definition Language (DDL) triggers to perform actions when events occur on your server. In this article, Greg Larsen discusses (examples included) some of the things that DDL triggers can be use for.
Monitoring Changes to Your Database Schema
With the introduction of SQL Server 2005, Microsoft now allows you to write Data Definition Language (DDL) triggers to perform actions when events occur on your server. In this article, Greg Larsen discusses (examples included) some of the things that DDL triggers can be use for.
Monitoring Changes to Your Database Schema
With the introduction of SQL Server 2005, Microsoft now allows you to write Data Definition Language (DDL) triggers to perform actions when events occur on your server. In this article, Greg Larsen discusses (examples included) some of the things that DDL triggers can be use for.
Wait events in Oracle RAC
Tarry Singh discusses wait events in Oracle RAC, focusing on Global Cache waits in particular.
Black Belt Administration: Reporting Services Configuration Manager
Use the Reporting Services Configuration Manager to manage a report server deployment. BI Architect Bill Pearson provides an overview of the various settings provided within this centralized maintenance tool.
Something Not Entirely Unlike Access
Have you ever wanted to create an Access application that doesn't really look and feel like Access. Follow along as Danny Lesandrini shows how to implement browser style effects in an Access application he calls Something Not Entirely Unlike Access.
Manual Standby Database under Oracle Standard Edition
Oracle's Standby technology has been rebranded as DataGuard in recent versions of Oracle. But what about the folks on Standard Edition Oracle; are they left out in the cold? It turns out that it is still possible to create a *manual* standby database on Oracle SE. Here's how you do it.
Partition Pitfalls in Oracle
There are some partition pitfalls you should avoid, and knowing what they are ahead of time can help prevent hours of down time. Read on to learn more.
Rational Data Architect and DB2 9: The Rest of the Database Explorer View
Paul Zikopoulos concludes a discussion of the features in the Database Explorer view.
Distinct Counts in Analysis Services 2005
Business Intelligence Architect Bill Pearson examines the expanded Distinct Count capabilities that debut with Analysis Services 2005.
Templates, Data Sources, and Data Source Views
Part 50 of this series dedicated to SQL Server 2005 Integration Services looks into functionality intended to improve efficiency of managing Business Intelligence Development Studio-based projects.
Oracle RAC: Checking RAC Status with SQL/OS Level Statements
Tarry Singh discusses running typical SQL/OS level statements to check the status of RAC nodes.
Microsoft Windows PowerShell and SQL Server 2005 SMO: Part 1
Discover the power of Windows PowerShell in conjunction with SQL Server 2005.
Designing Forms for Efficient and Accurate Data Entry
This excerpt from "Microsoft Office Access 2007 Forms, Reports, and Queries" introduces several techniques that serve to either make data entry less of a chore, or to reduce or eliminate data entry errors (or both).
MDX Scripting Statements: Introducing the Simple CASE Statement
Use the new CASE statement to support conditional logic within calculations. BI Architect Bill Pearson introduces the simple CASE statement, and then leads a hands-on practice session with this new addition to the MDX toolset.
SQL 2005 Backups using LightSpeed
Don Schlichting provides an overview of Quest Software's LightSpeed, an application for backing up and archiving SQL Server databases.
How Useful Are Those Indexes?
Greg Larsen discusses a Dynamic Management View (DMV) that you can obtain information from to help you understand how your indexes are being used.
Rational Data Architect and DB2 9: Storage Diagrams
Paul Zikopoulos explores Database Explorer's storage diagramming feature--a tool for visualization of the underlying storage used for physical data objects.
SQL Server 2005 Integration Services - Part 49: Maintenance Plan Tasks
Marcin Policht reviews the differences between maintenance plan tasks in Maintenance Plan designer and the Control Flow area of SSIS Designer, by examining the compatibility and level of integration between these two alternative approaches to automating routine administrative responsibilities.
SqlCredit - Part 5: Adding Card, Vendor, and Purchase, Plus Much Refactoring
In Part 5 of the SQLCredit series we fill out the application, adding new tables and their associated stored procedutes, and a new script to build the database.
Oracle Secure Backup - Part 3: Conclusion
Learn how to use an Oracle Secure Backup (OSB) configuration to perform Oracle 10gR2 Recovery Manager (RMAN) restore and recovery operations against previously-created RMAN backups stored on simulated OSB virtual libraries and tape devices.
Serving Up Server Alerts
There are several ways, some free and some hand-crafted, to expose alerts and messages. Steve Callan explores some of the database options available.
Debugging SQL Server 2005 Stored Procedures in Visual Studio
This article, by Scott Mitchell, looks at how to debug SQL Server 2005 stored procedures from within the Visual Studio IDE.
Intelligent Layering: Leverage Conditional Formatting Logic from Analysis Services
Leverage Analysis Services based Conditional Formatting in Reporting Services. BI Architect Bill Pearson demonstrates a simple alternative to reliance upon Cell Properties.
Expand Your SQL Server 2005 Dictionary Using Extended Properties
Generate a data dictionary using SQL Server 2005 metadata then take it one step further. Use Extended Properties to add additional metadata that will explain why each data object is important to the application that uses it.
Access 2007 ... For Dummies?
Access 2007 is not for dummies. Procrastinate, if you must, but sooner or later, we're all going to have to learn the new product. This is one case where the "Dummies" book isn't a bad place to start.
DBA Interview Questions
There are nearly an infinite number and combination of questions one can pose to a DBA candidate in an interview. These questions lean towards the conceptional, rather than the rote, as questions of this kind emphasize your foundation, and thorough understanding.
Upload Multiple XML Files to an XML Data Type Column
Learn how to upload multiple XML files to an SQL Server 2005 database XML data type column.
Rational Data Architect and DB2 9: Using the SQL Editor
Learn what's available and where it's located in Rational DA. This article provides a good understanding of all the capabilities available for SQL generation and editing in Rational DA, and know where to find them.
Positing the Intelligence: Conditional Formatting in the Analysis Services Layer
Support conditional formatting for enterprise reports from the Analysis Services layer of the integrated Microsoft business intelligence solution.
SQL Server 2005 Integration Services: Part 48
Maintenance Plan Designer gives you access to 11 tasks, which allow you to perform a variety of database management activities. This article provides a brief overview of each of them, focusing on their recent improvements.
Oracle RAC Monitoring: Keeping Your RAC Under Control
Proactively monitoring your Oracle RAC or even a typical single node Oracle database will keep you upwind of problems. However, that means you need to know which tools you should be using to do just that.
Row Movement in Oracle
One of the relatively newer features in Oracle concerns the moving of rows--but why would a row move and who or what controls that movement? This article looks at three common cases or situations where row movement needs to be enabled.
Rational Data Architect and DB2 9: Building an SQL Statement
Part 1 of this series introduced the IBM Rational Database Architect (Rational DA) Database Explorer view. Part 2 discusses one of the features available from the Database Explorer view, namely, the ability to build SQL statements to run against your database.
Logical Functions: IsGeneration(): Conditional Logic within Calculations
Use IsGeneration() to support conditional logic within calculations. BI Architect Bill Pearson introduces IsGeneration(), and then leads a hands-on practice session with this useful MDX function.
Using SQL 2005 with Expression Web
Join Don Schlichting as he explores various methods of accessing SQL Server from inside Microsoft Expression Web.
Oracle Extended RAC: Stretching Your RAC to the Limit
Tarry Singh offers an overview of how to extend your RAC geographically, up to 25km or even 50kms.
Query XML Data From a table with XML Data Type
Learn how to create an XML schema and a table with XML data type, as well as how to import and query XML files.
Better Entities with Nullable Types
Tired of checking database entries for null values? Learn how you can use Nullable types to make fields and properties accept nulls.
Oracle Capacity Planning
JP Vijaykumar outlines how to reclaim free space from tablespaces in the database/server that are not 100% full and allocate that space to EMP_TBSP01 tablespace, which is 100% full.
Maintaining a Log of Database Changes: Part 2
In this article we will discuss the pros and cons of using triggers and manual techniques for maintaining changes to a database table. We will also build trigger- and manual-based implementation from the ground up.
SQL for MySQL Developers: A Comprehensive Tutorial and Reference
This excerpt, from "SQL for MySQL Developers: A Comprehensive Tutorial and Reference," discusses adding aggregation functions to a select block with the use of a GROUP By clause.
SqlCredit - Part 4: Schema and Procedure Security
In this month's installment, we will add security to the existing code and add new unit tests to prove that security.
Scripting the Installation of SQL Server 2005
Having a consistent SQL Server environment is important. Gregory Larsen discusses one method of scripting your installation to ensure all of your SQL Server 2005 machines are set up the same.
Quest Code Tester for Oracle
Steve Callan reviews Quest Code Tester for Oracle, a new product from Quest that allows developers to generate test code from user descriptions, then run tests with the press of a button.
Oracle Secure Backup, Part 2: A Sample Implementation
This article the second in this series simulates the creation and administration of an Oracle Secured Backup environment to demonstrate how it can be used effectively in concert with existing RMAN backup and recovery scripts.
Maintaining a Log of Database Changes: Part 1
This article, by Scott Mitchell, looks at techniques for maintaining a log of database changes.
SQL Server 2005 Integration Services - Maintenance Plan Tasks: Part 47
In the previous installment of our series we mentioned that a variety of features have changed with the advent of SQL Server 2005 Service Pack 2. We will point out these changes as we continue our presentation, in order to bring your attention to some of the more relevant improvements.
Manage Recordsets in ADPs
Learn how to use SQL Server stored procs in an Access Data Project.
Oracle RAC: Capacity Planning for your RAC
Implementing RAC, or any clustered solution, requires planning. Tarry Singh discusses capacity planning, breaking it up into several components, such as network, storage, and infrastructure.
CASE Function in SQL Server 2005 - Part 4
Part 4 of this series discusses how to use case functions in GROUP BY clauses.
Rational Data Architect and DB2 9: The Database Explorer
Learn how to add and work with database connection objects in the Rational Data Architect Database Explorer view. This series takes you through the various interfaces of the Rational DA IDE as they relate to DB2 9 data servers and the tasks that you can accomplish with this tool.
Black Belt Administration: Performance Dashboard for Microsoft SQL Server: Part 2
BI Architect Bill Pearson continues his overview of the new Performance Dashboard for MSSQL Server. In this article, we examine the individual member reports and discuss their basic uses.
SQL Server 2005 Integration Services - Maintenance Plan Tasks: Part 46
Continuing coverage of Control Flow tasks in SQL Server 2005 Integration Services, this article focuses on several tasks, whose shared purpose is to provide the ability to perform standard database maintenance procedures.
CASE Function in SQL Server 2005: Part 3
Part 3 of this series illustrates how to use case functions in group by clauses.
Multipurpose Code in Oracle and Oracle Forms
Take charge of what Oracle provides out of the box by learning how to create a small message library to take care of many types of output messages.
Administration and Optimization: SQL Server Profiler
Use SQL Server Profiler to "look behind the scenes" within Analysis Services 2005. BI Architect Bill Pearson leads a hands-on introduction to determining resource utilization effectiveness for both processing and query performance with profiling.
Microsoft SQL 2005 Maintenance Wizard: Part 3
The Maintenance Plan Wizard is a graphical interface for creating a variety of database housekeeping tasks. This article focuses on using SQL Server 2005 Maintenance Plan Wizard for creating Database Backup operations.
Installation Gotchas for Oracle Linux, Oracle RAC 10gR2, and VMware ESX 3.0.1
Tarry Singh covers several issues that can cause problems when installing Oracle Linux 10gR2 RAC on Oracle Enterprise Linux 4.4 with VMware ESX 3.0.1.
CASE function in SQL Server: Part 2
Part 1 of this series illustrated how to use simple case functions in queries. This installment discusses how to use case functions in different types of scenarios.
Logical Functions: IsAncestor(): Conditional Logic within Filter Expressions
Use IsAncestor() to support conditional logic within filter expressions. BI Architect Bill Pearson looks beyond employing IsAncestor() in calculations, and provides hand-on practice in its use within the MDX Filter() function.
Using and Managing Database Mail
Database Mail is a great improvement over SQL Mail that came with earlier versions of SQL Server. Greg Larsen discusses setting up and managing Database Mail.
Data Manipulation Using Java in Oracle
PL/SQL can do many things well, but other languages can do some things much better, with better being measured in terms of speed. If you find that stored data must be manipulated for display type output, don't be afraid to try other languages supported by Oracle.
Data Manipulation Using Java in Oracle
PL/SQL can do many things well, but other languages can do some things much better, with "better" being measured in terms of speed. If you find that stored data must be manipulated for display type output, don't be afraid to try other languages supported by Oracle.
Four Ways to Optimize Your MySQL Database
See how you can make your MySQL database absolutely scream!
SQL Professional Toolbelt
RED Gate Software recently released a new service called SQL Professional Toolbelt, a compilation of all of their tools for an annual subscription.
SQL Server 2005 Integration Services - Part 45: Bulk Insert Task and Format Files
The previous article of our series presented a straightforward approach to importing data from delimited text files into database tables and views, using Bulk Insert Control Flow task. This approach lacks flexibility, which can be addressed by employing format files.
CASE function in SQL Server: Part 1
In SQL Server, the CASE functions evaluate a list of conditions and then return one or many results. This article illustrates the various uses of CASE functions.
Oracle 10gR2 RAC Load Balancing Features
Learn how Oracle 10gR2 takes advantage of client-side connection load balancing, server-side load balancing, and the new Load Balancing Advisor (LBA) features to improve the distribution of workloads across the appropriate nodes in an Oracle 10gR2 (RAC) clustered database environment.
Finding Foreign Key Constraints in Oracle
For a developer to identify and disable foreign key constraints is a difficult task. A brief description on the foreign key (referential integrity) constraints will go a long way in identifying and disabling these constraints.
Black Belt Administration: Performance Dashboard for Microsoft SQL Server - Part 1
Diagnose performance problems in MSSQL Server 2005 with a powerful new administration tool. BI Architect Bill Pearson provides hands-on guidance in installing and using this powerful new dashboard / report pack, freely available to MSSQL Server 2005 users everywhere.
Product Review: SQL Prompt
Learn why Danny Lesandrini thinks SQL Prompt is the Holy Grail of SQL Server utilities.
Oracle RAC Administration: Backing up your RAC with RMAN
Whether you are a single node Oracle DBA or a multi-node RAC farm DBA, you will be confronted with various backup alternatives. Tarry Singh discusses several scenarios and backup possibilities using the RMAN utility.
Using the MySQLi Interface: Basic Techniques
This article will illustrate some basic techniques for using the MySQLi interface. The MySQLi class can be very powerful for doing repetitive data tasks and makes it much easier to encapsulate robust methods into your own custom classes.
Ordering Events in Oracle
The time stamping and ordering of events within Oracle is of prime importance and goes to the heart of how transaction control and serialization are even possible. Read on to learn more about ordering events in Oracle.
Mastering Enterprise BI: Time Intelligence Part 3
BI Architect Bill Pearson continues his introduction to enhanced features in Analysis Services 2005 for Time Intelligence support. In this session, we examine new, wizard-driven features that support the easy addition of Time Intelligence within our cube.
SQL Server 2005 Command Line Tool "SQLCMD": Part 3 - Scripting and Variable Substitution
Learn how to use the SQLCMD scripting variables, startup scripts and variable substitution.
Oracle RAC Administration - Part 16: Balancing act between Server and Client
In this article, Tarry Singh takes a little detour to look at connectivity load balancing and failover.
SQL Server 2005: Using Asymmetric Encryption and Digital Signatures
This article, by Erich Peterson and Siqing Li, explores techniques for encrypting data in a Microsoft SQL Server 2005 database using asymmetric encryption. This article - the final one of the series - starts with a look at the T-SQL commands for performing asymmetric encryption and decryption.
MDX Clauses and Keywords: Use HAVING to Filter an Axis
BI Architect Bill Pearson overviews the new HAVING clause, and then leads hands-on practice with its use in filtering an axis.
Building a Weblog: Part 4
This installment is the conclusion of our series. Topics covered are blog categories, creating new blog entries and updating entries. Adding blog categories uses a page similar to the one for adding comments.
Building and Using an SQL/PL Stored Procedure with Visual Studio 2005
Learn how to create a stored procedure using the SQL/PL Stored Procedure designer and show you how you can leverage that stored procedure in a simple WinForm application.
New Ranking Functions within SQL Server 2005
Gregory Larsen discusses the new SQL Server 2005 ranking functions, which make it much easier for you to code your T-SQL to associate a ranking to your result set.
Oracle: Sorting Out Memory
Keeping track of all the different memory areas in Oracle can be taxing. With Oracle 10g, there can be fewer parameters to keep track of if you remember which parameters drive or affect other parameters.
Using Symmetric Encryption in a SQL Server 2005 Database
This article, by Erich Peterson and Siqing Li, explores techniques for encrypting data in a Microsoft SQL Server 2005 database using symmetric encryption.
SQL Server 2005 Integration Services: Part 43 - XML Task Continued
Marcin Policht concludes his coverage of the SQL Server 2005 Integration Services XML Control Flow task.
Building a Weblog: Part 3 - Building the Category Browser
This week, we're going to build the category browser. In this section, you'll create a page that allows users to browse the different categories and see which blog entries have been posted in each category.
SqlCredit - Part 2: Creating the Database, Tables, CRUD Procedures
In part 2 of our series we begin to create the database, schema and stored procedures of a complete, functioning, tested credit card database.
Oracle 10g Secure Backup, Part 1: Concepts
This article the first in this series provides an overview of Oracle Secured Backup and how it can be utilized in concert with RMAN backup, restoration, and recovery scripts.
Using the FILLBY Method to Filter DB2 9 Data Sets...with a Twist
This article discusses how to use a FILLBY method to pass dynamic parameters to the application.
SQL Server 2005 Command Line Tool "SQLCMD": Part 2
Part 2 of this series illustrates how to use the SQLCMD utility to input Transact SQL scripts to be executed on a SQL Server instance.
Mastering OLAP Reports: Extend Reporting Services with Custom Code
Extend the capabilities of your reports with embedded custom code. In this article, BI Architect Bill Pearson provides hands-on practice creating and referencing embedded custom code, to meet special presentation needs within an OLAP rep | 
eBook library