database
News
SQL Server 2008 MERGE StatementWith a single MERGE statement, you can easily implement insert, update, and delete logic to handle criteria for maintaining a table. Read on to learn how to use the MERGE statement.
Source : Database Journal | 24-Jul-2008 19:31
Oracle Reports for DBAs
As an Oracle DBA you might think that Oracle Reports have nothing to do with you, and you might be missing out on a simple means of generating reports to identify a source file, create an external table, write an SQL script and more.
Source : Database Journal | 23-Jul-2008 19:07
Intrinsic Member Properties: The MEMBER_NAME Property
MSAS Architect Bill Pearson introduces the intrinsic MEMBER_NAME property. In hands-on exercises, we gain exposure to the use of the property in generating simple lists, as well as datasets to support report parameter picklists.
Source : Database Journal | 21-Jul-2008 19:02
Focus on Popular Objects to Speed up an Access 2007 Database
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.
Source : Database Journal | 18-Jul-2008 19:16
Sybase-to-Oracle Migration Accelerated By ANTs Software
ANTs software inc. introduces the Sybase-to-Oracle Accelerator Program, a new promotional offering that complements Oracle’s current Sybase Safe Switch Program...
Source : Database Journal | 17-Jul-2008 01:25
Check your SQL Server using Windows PowerShell – Part 3
Part 3 of this series illustrates how to acquire operating system and hardware related information from a host machine.
Source : Database Journal | 16-Jul-2008 19:18
Oracle: MOVE vs SHRINK Commands
This article discusses re-organizing a table using the move and shrink commands, then compares how the rows are compacted within Oracle blocks and how row chaining is resolved.
Source : Database Journal | 15-Jul-2008 19:18
SQL Server Audit in SQL Server 2008 – Part 2
Learn how to monitor database-level actions and write audit results to files.
Source : Database Journal | 14-Jul-2008 19:17
SQL Server 2005 Express Edition - Part 26 - Introduction to Service Broker
This article is a brief overview of Service Broker's core features, which are available (in a somewhat limited capacity) in SQL Server 2005 Express Edition. The next installment will describe a sample application illustrating its operations and discuss its management, security, and routing characteristics.
Source : Database Journal | 11-Jul-2008 19:27
DBA Insider - Useful PL/SQL Packages
Oracle supplies quite a large complement of pl/sql stored procedures, packages, and functions, which can help with some of a DBA's day-to-day needs. This article looks at some of the useful ones that we can add to our DBA or Developer toolbox.
Source : Database Journal | 10-Jul-2008 19:11
Hands-on Oracle: Backup and Recovery Games - Creating Datafiles
Learn how to recover from the loss of a datafile, when you don't have a backup of that file.
Source : Database Journal | 09-Jul-2008 19:27
Dimension Attributes: Introduction and Overview, Part V
Join Business Intelligence Architect Bill Pearson as he continues his subseries surrounding components of the Analysis Services dimensional model. In this article we conclude our introduction to dimension attributes, focusing upon the Source group of attribute properties.
Source : Database Journal | 07-Jul-2008 19:19
Looking at Memory Usage for Oracle Processes
When an Oracle instance starts, or an application uses the Oracle database, the associated Oracle processes are allocated and consume memory. Learn how to use the V$PROCESS view and V$PROCESS_MEMORY to look at this memory usage.
Source : Database Journal | 03-Jul-2008 19:25
SQL Server Profiler Part 2
Part 1 of this series discussed the difference between a Trace and Profiler. This installment examines additional preconfigured templates, how to synchronizing Profiler and Perfmon and how to run Profiler as a scheduled task.
Source : Database Journal | 02-Jul-2008 19:20
Check your SQL Server using Windows PowerShell – Part II
Part two of this series illustrates how to access the Windows service on a remote machine using Windows PowerShell and WMI-Object to see if all of the windows services related to SQL Server are up and running.
Source : Database Journal | 01-Jul-2008 19:09
Oracle Database 11g: Database Replay, Part 3
The final article in this series illustrates how to use Oracle Database 11gR1's new Database Replay (DBR) features to capture and prepare a workload from a current Oracle 10gR2 single-instance database environment and then replay that identical workload in an Oracle 11gR1 Real Application Clusters (RAC) testing environment.
Source : Database Journal | 30-Jun-2008 19:20
Mastering OLAP Reports: Parameterizing Number of “Look Back” Periods with the MDX LastPeriods() Function, Part II
BI Architect Bill Pearson continues his hands-on demonstration of an approach to the parameterization of the highly useful LastPeriods() function.
Source : Database Journal | 27-Jun-2008 19:22
SQL Server 2008 Date Functions, Part 2
To manage and use the new date data types introduced in SQL Server 2008, Microsoft has provided a number of new system functions. In this article, Greg Larsen explores the new system functions and some of the old date functions that were available in older releases of SQL Server.
Source : Database Journal | 26-Jun-2008 19:03
Product Review – Toad Data Modeler 3
Quest Software has hit the ball out of the park with its Toad Data Modeler 3 (TDM) application. Ease of use, a huge amount of functionality, and an outstanding support base all combine to make TDM a superb product. Read on to learn more…
Source : Database Journal | 25-Jun-2008 19:25
Enhancement in variable declaration – SQL Server 2008
Enhanced variable declaration, one of the many enhancements that Microsoft added to SQL Server 2008 allows you to declare and initialize a value at the same time. This article shows you how to do it.
Source : Database Journal | 24-Jun-2008 19:06
Implementing Upgrade of SQL Server 2005 Express Edition
In the previous installment of our series, we presented a variety of reasons that might influence your decision to upgrade a full-fledged member of the SQL Server 2005 family. This article discusses the actual implementation of this process, pointing out additional factors that might affect its complexity.
Source : Database Journal | 23-Jun-2008 19:08
Intrinsic Member Properties: The MEMBER_KEY Property
Join BI Architect Bill Pearson in an introduction to the intrinsic MEMBER_KEY property. In hands-on exercises, we gain exposure to the use of the property in generating simple lists, as well as datasets to support report parameter picklists.
Source : Database Journal | 20-Jun-2008 19:18
Check your SQL Server using Windows PowerShell – Part 1
This new series examines methods and procedures to check the status of the Operating system, SQL Server instances and databases, using Windows PowerShell. Part One illustrates how to create a PowerShell script to ping the host machine and how to source the PowerShell function and call the function.
Source : Database Journal | 18-Jun-2008 19:12
Secure Microsoft Access Passwords and Encryption in Access 2007
Learn how to improve on what already is a very significant security improvement in Access 2007--database encryption.
Source : Database Journal | 16-Jun-2008 19:23
Mastering OLAP Reports: Parameterizing Number of “Look Back” Periods with the MDX LastPeriods() Function, Part I
Parameterization of MDX functions is one of those things that cannot be delivered solely via graphical MDX Editor – but then, you really didn’t think that you could avoid actually touching MDX at all, did you? BI Architect Bill Pearson demonstrates a way to parameterize the highly useful LastPeriods() function.
Source : Database Journal | 13-Jun-2008 19:12
Oracle Automatic Storage Management
ASM provides many benefits, but also requires learning new concepts, commands, utilities, and administration tasks. Sean Hull examines what ASM solves, and what it takes to manage and weigh the pros and cons.
Source : Database Journal | 12-Jun-2008 19:14
Oracle Applications Reference Books
Aside from Oracle's own documentation covering Oracle Apps and a few books covering specific modules, the published books landscape regarding EBS is fairly barren. There are two notable generalist coverage books available that can help you get a good jump on learning Oracle Applications.
Source : Database Journal | 10-Jun-2008 19:07
SQL Server 2005 Express Edition - Part 24 - Planning Upgrade of SQL Server 2005 Express Edition
Part 24 of SQL Server 2005 Express Edition reviews the most common reasons that influence a decision to upgrade to a Workgroup, Standard, or Enterprise member of SQL Server 2005 family.
Source : Database Journal | 09-Jun-2008 19:09
SQL Server Audit in SQL Server 2008 – Part 1
SQL Server 2008 February CTP introduces a new feature, SQL Server Audit. This feature facilitates auditing of Database Engine events by providing simple T-SQL statements to enable, store, and view audits on server and database objects. Part 1 of this series focuses on the server level events.
Source : Database Journal | 06-Jun-2008 19:09
Oracle Database 11g – Common Background Processes
To understand Oracle background processes is to understand how Oracle works--offering opportunity to tune effectively. Learn about the processes that are typically running after a fresh, common, and basic installation.
Source : Database Journal | 05-Jun-2008 19:25
Compound Assignment Operators in SQL Server 2008
MAK illustrates the use of Compound Assignment Operator that is introduced in SQL Server 2008.
Source : Database Journal | 04-Jun-2008 19:02
Introduction to SQL 2005 Profiler Part 1
Profiler is a tool that monitors the events and activity running on a SQL Server. Using profiler, this monitoring can be viewed, saved, and replayed. This article focuses on using Profiler with SQL Server 2005, but the tool is also included with SQL Server 2000 and SQL Server 2008.
Source : Database Journal | 02-Jun-2008 19:08
Oracle Database 11g: Database Replay, Part 2
Part 2 of this series - demonstrates how Oracle 11g Database Replay can be used to capture and prepare a workload from a current Oracle 11g production database environment (P+0) and then replay that identical workload in an Oracle 11g testing environment that represents the next iteration (P+1) of the database system.
Source : Database Journal | 30-May-2008 19:23
Dimension Attributes: Introduction and Overview, Part IV
Business Intelligence Architect Bill Pearson continues his introduction to dimension attributes, focusing upon the Parent-Child group of attribute properties. This article continues our subseries surrounding components of the Analysis Services dimensional model.
Source : Database Journal | 29-May-2008 19:15
Oracle DBA in an Oracle Applications World – Part 2
Steve Callan presents a simple – but effective – means of replicating your production environment for the first time on a new machine.
Source : Database Journal | 28-May-2008 19:06
New Date Data Types with SQL Server 2008
Greg Larsen examines the new SQL Server 2008 date data types, comparing them to the existing data types that are available within older versions of SQL Server.
Source : Database Journal | 27-May-2008 19:23
SqlCredit - Part 16: The Cost of Bloat
Database designers, developers, and administrators deal with a database that continues to grow over time, often at an alarming rate. In this series' current quest to understand costs of different architectures, we will look at what cost is paid in query performance as a table grows.
Source : Database Journal | 23-May-2008 19:20
Intrinsic Member Properties: The MEMBER_CAPTION Property
Architect Bill Pearson introduces the intrinsic MEMBER_CAPTION property. In hands-on exercises, we gain exposure to the use of the property in generating simple lists, as well as datasets to support report parameter picklists.
Source : Database Journal | 22-May-2008 19:23
SQL Server 2005 Express Edition - Part 23 - Manual Upgrade from Microsoft SQL Server Desktop Engine (MSDE)
Part 23 of this series reviews manual workarounds to migrate from MSDE-based installations, when running an in-place upgrade of individual instances isn't possible. Additional factors that should be considered during migration to SQL Server 2005 Express Edition are also covered.
Source : Database Journal | 22-May-2008 19:08
Table-valued parameters – SQL Server 2008
In previous versions of SQL Server, it has not been possible to pass a table variable, as a parameter, to a stored procedure. Microsoft introduces table-valued parameters, along with other features, in SQL Server 2008. This article illustrates the function and usage of table-valued parameters.
Source : Database Journal | 21-May-2008 19:19
Oracle 10g Cloning Guide: A Small County Government Approach
This document offers one approach to database refreshes for Oracle 10g databases on Windows 32 and 64 bit servers.
Source : Database Journal | 20-May-2008 19:20
Sybase Delivers Extreme Analytics Out of the Box With New Analytic Appliance
Sybase, Inc. today announced the new Sybase Analytic Appliance, configured and tuned to provide extreme analytics and alleviate overburdened enterprise data warehouses, data marts and reporting systems.
Source : Database Journal | 17-May-2008 01:16
The future of PHP
Know what changes are in store for PHP V6 and how your scripts will change.
Source : Database Journal | 17-May-2008 01:01
Navicat MySQL GUI for Mac OS X ver. 7.1.3 released
This new version supports Excel Import, Virtual Grouping, Tabbed Window, Tabbed Windows,SSH Connection, Structure Synchronization and other usability and stability enhancements.
Source : Database Journal | 17-May-2008 00:46
MySQL Workbench for Database Change Management
MySQL Workbench contains a number of database change control features that you may not have noticed at first. Robin Schumacher introduces them and shows why they can be a big help when it comes to managing change in your databases.
Source : Database Journal | 17-May-2008 00:31
Posting Microsoft Access Information “Into the clouds”
Part one of this article demonstrated how to retrieve data and save it into XML using Microsoft Access and MSXML. Part 2 shows how to add new data to a Web2 website ("in the clouds").
Source : Database Journal | 16-May-2008 19:16