Are you a DBA? Need to update your database administration knowledge? We have selected a big collections of
articles for you...
|
Oracle Programming with PL/SQL Collections
|
PL/SQL applications typically consist of SQL statements intermixed with procedural logic to process data retreived from the database.... Read more...
By
|
|
Full-Text Search in MongoDB
|
MongoDB, one of the leading NoSQL databases, is well known for its fast performance, flexible schema, scalability and great indexing capabilities..... Read more...
By Ashish Trivedi
|
|
Memory Leak in 11.2.0.1 on AIX: Shared Cursors Are Not Behaving
|
A "blast from the past" was recently updated by Oracle Support; it involves a subpool memory leak in Oracle 11.2.0.1 and shared cursors .... Read more...
By David Fitzjarrell
|
|
Oracle's ANSI Join Syntax Can Result In Wrong Results
|
ver since Oracle provided their version of ANSI syntax it's been improving with each release. .... Read more...
By David Fitzjarrell
|
|
The PoSh DBA - Towards the Re-usable PowerShell Script
|
How would you improve a PowerShell script in order to make it more versatile? .... Read more...
By Laerte Junior
|
|
Database as a Service metrics: Assessing the value of DBaaS
|
One of the key elements in the development of robust Database as a Service (DBaaS) .... Read more...
By
|
|
Inheritance in the Database
|
In martial arts, fundamentals are everything. .... Read more...
By
|
|
Creating and linking a MariaDB database
|
MariaDB is a drop-in replacement of MySQL, meaning if you have an application .... Read more...
By
|
|
Data Modeling in Document Databases for the RDBMS-Minded
|
Data modeling is the exploration of the structuring of your data.... Read more...
By Cihan Biyikoglu
|
|
Creating a SQL Server Database
|
In April 2015, Microsoft made Azure DocumentDB generally available to the public,... Read more...
By Robert Sheldon
|
|
Creating a SQL Server Database
|
Databases are at the heart of every SQL Server system... Read more...
By Alison Balter
|
|
How to Build a Cassandra Multinode Database Cluster on Oracle Solaris 11.3 with LUN Mirroring and IP Multipathing
|
This article describes how to build a Cassandra single-rack database cluster on Oracle Solaris 11.3 and extend its overall availability with LUN mirroring and IP network multipathing.... Read more...
By Antonis Tsavdaris
|
|
Integrating Big Data Applications into Operational Environments
|
We have evolved some standard responses to the needs for these applications.... Read more...
By Lockwood Lyon
|
|
The SQL of the Feast Days of Western Christendom
|
start getting excited about Christmas around July.... Read more...
By Phil Factor
|
|
RESTful WS with Jersey Part 2
|
This article further takes Part 1 of this article series to the realm of RESTful Web Services with Jersey. .... Read more...
By Manoj Debnath
|
|
Database model for a messaging system
|
The core functionality of a messaging system in an application is to send notifications/messages .... Read more...
ByShantanu Kher
|
|
How to Create a Multilingual JasperReport
|
Almost all modern software that renders text, such as a browser or text editor, supports Unicode .... Read more...
By Manoj Debnath
|
|
Installing node-oracledb on Microsoft Windows
|
In this article Bill Christo (bchr02) leads you step-by-step though the process of installing node-oracledb on Microsoft Windows.... Read more...
By Bill Christo
|
|
Top 10 Most Common Database Scripts
|
You may not have DBA in your job title but you and I both know that you're the person responsible for the database... Read more...
By Grant Fritchey
|
|
Understanding Stretch Database Functionality in SQL Server 2016
|
SQL Server is one of the most widely used RDBMS around the world,... Read more...
By Arshad Ali
|
|
Integration Services Logging Levels in SQL Server 2016
|
At the time of writing, SQL Server 2016 preview (CTP 2.3) has been released ... Read more...
By Koen Verbeeck
|
|
Increased popularity for consuming DBMS services out of the cloud
|
It is a year ago since we blogged about the popularity of Database ... Read more...
By Paul Andlinger
|
|
Using jQuery to Perform Calculations in a Table
|
Use jQuery to traverse all of the values in a HTML table column, convert the values to numbers, and then sum the values. Read more...
By
|
|
Apache Ignite for Database Caching
|
Businesses are accumulating data at enormous rates requiring huge amounts of storage. Read more...
By
|
|
Database Mirroring Is not Going Anywhere
|
Database Mirroring is supported in both Enterprise Edition Read more...
By Matan Yungman
|
|
Why You Should Use Neo4j in Your Next Ruby App
|
Neo4j is a graph database! That means that it is optimized for managing and querying connections Read more...
By Brian Underwood
|
|
To boldly go where no SQL has gone before Part 2
|
Let’s continue looking at a database schema for storing details of every Star Trek Episode. Read more...
By Simon Foster
|
|
Techniques to Monitor SQL Server memory usage
|
Memory has a dramatic impact on SQL Server Performance. Fortunately, in SQL Server you can either use DMVs, , Extended Events,.Read more...
By Basit Farooq
|
|
Microsoft and Database Lifecycle Management (DLM): The DacPac
|
When you need to extract data and metadata from an existing database, deploy a database, report on changes, script out a database,.Read more...
By Phil Factor
|
|
Automated Backups of SQL Server Databases in Azure IaaS VMs
|
Following the main theme of our earlier articles published on this forum, we will continue our quest for methods to simplify and streamline provisioning and management of Azure SQL Database and SQL Server running in Infrastructure-as-a-Service (IaaS) Azure virtual machines..Read more...
By Marcin Policht
|
|
A Database Design Tutorial
|
Everything in this tutorial is going to be explained using an example database.Read more...
By
|
|
Built-in SQL Functions
|
SQL has many Built-In SQL Functions that are useful for performing calculations on data within your database.Read more...
By
|
|
Forgot MySQL Root Password – How To Reset It?
|
This article explains how to recover mysql root password by setting a new MySQL password when you don’t remember your old one.Read more...
By Ramesh Natarajan
|
|
How to Fix java.lang.classnotfoundexception oracle.jdbc.driver.oracledriver
|
How to Fix java.lang.classnotfoundexception oracle.jdbc.driver.oracledriver Read more...
By Jack Desai
|
|
Invoke Fusion Cloud Secured RESTFul Web Services
|
The objective of this blog is to demonstrate how to invoke secured RestFul web services from Fusion Cloud using Oracle Service Oriented Architecture (SOA) as an Integration hub for real time integration with other clouds and on-premise applications. Read more...
By Jack Desai
|
|
Writing type-safe JPA queries with QueryDSL
|
About how easily implement JPA queries using QueryDSL Read more...
By
|
|
SQL Server to add JSON Support
|
SQL Server 2016 is expected to offer native support for working with JSON. Read more...
By Jonathan Allen
|
|
An Oracle Data Integrator Journalizing Knowledge Module for GoldenGate Integrated Replicat
|
All out-of-the-box versions of the ODI JKM for GoldenGate to this date were designed for the Classic Replicat apply mode Read more...
By
|
|
MySQL Calculating Distance Based on Latitude and Longitude
|
With the proliferation of mobile devices being at an all-time high, there has never been more demand for “Find near me” type apps. Read more...
By Rob Gravelle
|
|
SQLXML Bulk Loader Basics
|
SQLXML isn't exactly new technology, but like the even more venerable BCP, Read more...
By Adam Aspin
|
|
The Easiest Way To Bind VB.NET Calendar with DataBase (Web Forms)
|
In this article we will show you the easiest way to bind DHTMLX Scheduler with the Database in an application created in VB.NET using Web Forms. Read more...
By
|
|
Create your Data Services easily
|
We will be bringing you more Data Virtualization Demos, Videos and Workshops. Read more...
By
|
|
Using Oracle Documents Cloud REST API with Python Requests
|
Python Requests is a library that simplifies consuming RESTful resources from the client side.. Read more...
By Peter Flies
|
|
SQL SERVER – Collect and Analyze SQL Server Data Efficiently
|
The tool allows you to view communications between a client and SQL Server, and gives you an insight into its internal performance. Read more...
By Pinal Dave
|
|
Making Data Analytics Simpler SQL Server and R
|
In this article I will describe a way to couple SQL Server together with R, and show how we can get a good set of data mining possibilities out of this fusion. Read more...
By Feodor Georgiev
|
|
SQL SERVER – Introduction to Policy Management
|
SQL Server 2008 introduced this neat feature which is lesser appreciated by many in the SQL Server world. Read more...
By Pinal Dave
|
|
Tame Big Data using Oracle Data Integration
|
This demo illustrates how you can move and transform all your data using Oracle Data Integration Read more...
By
|
|
SQL Server Performance Tuning – Index Tuning
|
In earlier installments of this series we looked at T-SQL Performance optimizations along with different T-SQL practices, Read more...
By Shehap El-Nagar
|
|
DB2 Exploding the Myths of Big Data
|
Many companies have implemented big data applications. Read more...
By Lockwood Lyon
|
|
How DBAs Can Adopt the Craftsman Mindset
|
The job of a DBA requires a fusion of skill and knowledge. To acquire this requires a craftsman mindset. Read more...
By Joshua Feierman
|
|
PHP Email Verification Script Using MySQLi
|
Most of the websites have feature to verify your email upon user registration to avoid spamming and fake registration. Read more...
By
|
|
Does Transactional Replication Include Structural Changes Made to a Database
|
We typically use Transactional Replication for Reporting purposes. In Transactional Replication, Read more...
By Satnam Singh
|
|
Five Steps for Installing Oracle Database 12c on Oracle Solaris 11
|
Step-by-step instructions for how to install Oracle Database 12c on Oracle Solaris 11 in a non-global Oracle Solaris Zone, Read more...
By Ginny Henningsen
|
|
How to get Database Design Horribly Wrong
|
Not so long ago, planning seemed an obvious precursor to development. Read more...
By Robert Sheldon
|
|
MySQL Fuzzy Text Searching Using the SOUNDEX Function
|
Fuzzy searching has become a very prominent feature of Web search engines like Google. Read more...
By Rob Gravelle
|
|
A Brief Introduction on Migrating to an Oracle-based Cloud Environment
|
New inventions or concepts are often times subject to the phrase "what is old is new again". Read more...
By Tom Laszewski
|
|
Database-Trigger Database Trigger for Capturing all DDL Commands and Storing into a TABLE
|
Database-Trigger Database Trigger for Capturing all DDL Commands and Storing into a TABLE Read more...
By Jagat Anand
|
|
DBA of the Day
|
What was your career path to becoming a DBA? Read more...
By Richard Morris
|
|
Full-Text Search with InnoDB
|
MySQL's latest InnoDB engine can now do extensive, high-performance, full text search..Read more...
By Jimmy Yang and John Russell
|
|
Thoughts on Improving DBA Productivity
|
Database administrators (DBAs) need to move away from reactive, repetitive tasks. Use the ideas presented here to become more productive..Read more...
By Lockwood Lyon
|
|
Introduction to MySQL Triggers
|
a trigger is a rule that you put on a table which basically says, whenever you DELETE, UPDATE or INSERT something in this table.Read more...
By John Cox
|
|
Leveraging Data Macro in Microsoft Access 2010
|
takes a look at the server results and PL/SQL function caches..Read more...
By Danny Lesandrini
|
|
On Oracle Database 11g
|
takes a look at the server results and PL/SQL function caches..Read more...
By Tom Kyte
|
|
Sequence in Oracle
|
There are many instances where we want a continuous seqnence of numbers to be generated..Read more...
By Gayathri Sathiamoorthy
|
|
Working with the XML Data Type in SQL Server
|
The XML data type, introduced in SQL Server 2005, is a powerful construct.Read more...
By Robert Sheldon
|
|
An Introduction to Stored Procedures in MySQL 5
|
A stored routine is a set of SQL statements that can be stored in the serverRead more...
By
|
|
Going Beyond the Relational Model with Data
|
Going Beyond the Relational Model with DataRead more...
By Robert Young
|
|
70x Higher Performance, Cross Data Center Scalability and New NoSQL Interface
|
MySQL Cluster is one of the fastest growing technologies available from MySQL today. To build on this momentum, Read more...
By Mat Keep
|
|
PGA and Memory Management in Oracle
|
Several years back, Database Journal published an article on PGA management parameters in the then-recent 9i release. Read more...
By David Fitzjarrell
|
|
SQL Server Reporting Services - Insufficient Rights Error
|
At times when we successfully deploy the reports to the report server and try to view them through report manager we may encounter am insufficient rights error. Read more...
By Franco Lopes
|
|
Analyzing a MySQL database with R
|
In this article, we analyze a MySQL database which contains soccer transfer data, using the R environment Read more...
By
|
|
MySQL 5.6 - (Early Access Features) - InnoDB and Replication!
|
MySQL 5.5 has been widely acknowledged to be the best release in the history of MySQL. Read more...
By Rob Young
|
|
Managing a Data Warehouse with DB2 on z/OS
|
Best practices for transactional systems aren't always relevant in an enterprise data warehouse. Read more...
By Lockwood Lyon
|
|
Replicating Transactions Between Microsoft SQL Server and Oracle Database Using Oracle GoldenGate
|
In this article we will build a simple transaction replication example using Oracle GoldenGate.Read more...
By Phil Factor
|
|
Temporary Tables in SQL Server
|
Temporary tables are just that. They are used most often to provide workspace for the intermediate results when processing data within a batch or procedure.Read more...
By Phil Factor
|
|
Creating Horizontal Tabbed Navigation using jQuery
|
Horizontal Tabs simulates the interface of offline real world being accessed by each computer user. Read more...
By
|
|
Database as code: Microsoft's new SQL Server "Juneau" tools
|
I have been looking at Microsoft's forthcoming SQL Server 2011, code-named Denali, for which the third preview has recently been released..Read more...
By Tim Anderson
|
|
db4o added to Eclipse Indigo
|
db4o Leveraged in Eclipse Indigo: Following the usual annual schedule the Eclipse version 3.7 ("Indigo") is now available.Read more...
By
|
|
Inserting Image into Database in C#.NET Window Application
|
Images are mostely used to recognize identification of any person or firm and while developing any Window Application you need to use Images many times within you Application.Read more...
By Sourabh Sharma
|
|
Whats New in SQL Server Denali: IIF Logical Function
|
If you have developed some sort of applications using Microsoft Access, then you are definitely familiar with "IIF" logical function..Read more...
By
|
|
Arrays in SQL that Avoid Repeated Group
|
It is certainly possible to fake an Array in SQL, but there are only a few occasions when it would be the best design.Read more...
By Joe Celko
|
|
Migrating SQL Server Databases - The DBA's Checklist
|
This is one area of SQL Server where people do not seem to take notice unless something goes wrong.Read more...
By Sadequl Hussain
|
|
Configuring Oracle Solaris Cluster Software With Oracle RAC/CRS and Sun ZFS Storage Appliance 7000 Systems
|
This document describes the installation steps for a 3-node Sun Cluster 3.2 01/09 or Oracle Solaris Cluster 3.3 (or later) configuration running with Oracle
Read more...
By J. Randriam
|
|
TK Prof in Oracle
|
TK Prof is an Oracle tool used to display the statistics generated during a trace.
Read more...
By Vikas Gupta
|
|
Understanding Sequence Object in SQL Server
|
Until SQL Server 2008 R2, the Identity column was used to generate sequential numbers to identify records in a table, mostly used as a primary/foreign key.
Read more...
By Arshad Ali
|
|
Automating ZFS Snapshots and Tracking Software Updates
Part II of Software Management Best Practices for Oracle Solaris 11 Express
|
This is the second article in a series highlighting best practices in Oracle Solaris 11 Express.
Read more...
By Ginny Henningsen
|
|
Four Strategies That Every DB2 z/OS DBA or any DBA Should Know
|
Here are the "best of the best" strategies that define a successful and competent database administrator (DBA).
Read more...
By Lockwood Lyon
|
|
Four Strategies That Every DB2 z/OS DBA or any DBA Should Know
|
Here are the "best of the best" strategies that define a successful and competent database administrator (DBA).
Read more...
By Lockwood Lyon
|
|
Monitor SQL Server Replication Jobs
|
The Replication infrastructure in SQL Server is implemented using SQL Server Agent to execute the various components involved in the form of a job
Read more...
By Yaniv Etrogi
|
|
MySQL 5.5: Pluggable Authentication API
|
MySQL 5.5: Pluggable Authentication API
Read more...
By
|
|
Using SQL HyperBac to Compress Exported Data from SSIS and BCP
|
Because SQL Hyperbac works at the Windows I/O level, it can be configured to work not just with the database files, but also with the files for BCP, DTS, SSIS and SQL Trace/Profiler.
Read more...
By Rodney Landrum
|
|
ASP.NET Session State Management Using SQL Server
|
Web applications are by nature stateless. Statelessness is both an advantage and a disadvantage. When resources are not being consumed by maintaining connections and state
Read more...
By John Paul Cook
|
|
Delivering High Performance with Zero Administration
|
Advances in self-management capabilities are making it possible to maximize performance and prescribe changes and ongoing maintenance tasks with fewer demands on IT staff.
Read more...
By Jose Ramos
|
|
NoSQL to MySQL with Memcached
|
The ever increasing performance demands of web-based services has generated significant interest in providing NoSQL access methods to MySQL
Read more...
By Mat Keep
|
|
Advanced Dimensional Design with Oracle Warehouse Builder
|
Oracle Warehouse Builder 11g Release 2 enables the entire spectrum of operations on dimensional objects, from defining them in a visual environment and then deploying them to either a relational schema
Read more...
By Yuli Vasiliev
|
|
Performance Implications of Parameterized Queries
|
In the Oracle community, there is very strong guidance concerning the use of parameterized queries (or "bind variables", as the Oracle community refers to them).
Read more...
By David Berry
|
|
Adding Column to a SQL Server Table
|
Adding a column to a table is common task for DBAs.
Read more...
By Dinesh Asanka
|
|
How to Perform Live Patching of Oracle Solaris 9
|
Regular patching is part of a system administrator's tasks.
Read more...
By Joseph Gan
|
|
Speeding Up Your Website's Database
|
Website speed has always been a big issue, and it has become even more important since April 2010, when Google decided to use it in search rankings
Read more...
By Paul Tero
|
|
Iron Speed Designer: Web App Development Made Easy
|
A decade ago you could whip together simple database-driven web applications using, among other things, classic ASP.
Read more...
By anny Lesandrini
|
|
Continuous Integration for SQL Server Databases
|
Almost every development team uses Source Control Management for application development.
Read more...
By Troy Hunt
|
|
How to Shrink Oracle Datafile?
|
In order to regain unused space on your database you need to use SHRINK command on Oracle.
Read more...
By Ferhat Ozturk
|
|
Manage and Monitor Identity Ranges in SQL Server Transactional Replication
|
When using transactional replication to replicate data in a one way topology from a publisher to a read-only subscriber(s) there is no need to manage identity ranges.
Read more...
By Yaniv Etrogi
|
|
Monitoring an ERP Application in DB2 for z/OS
|
Monitoring an ERP application suite involves using several basic measurement techniques.
Read more...
By Lockwood Lyon
|
|
Using JRuby with Oracle Database
|
This article explains how to use the JRuby programming language with Oracle Database 11g Release 2.
Read more...
By Pas Apicella and Chris Jones
|
|
A Discussion with Oracle's Java Language Architect
|
Few people have thought as long and hard about the Java platform as Oracle's Java Language Architect, Brian Goetz.
Read more...
By Janice J. Heiss
|
|
Database Refactoring
|
Much of the material that I'll discuss in this article comes from the excellent work done by Scott W Ambler and Pramodkumar J.
Read more...
By Nick Harrison
|
|
Using Partitioning and Event Scheduler to Prune Archive Tables
|
First in our series of Use Case reports on new MySQL 5.1 features, we have Greg Haase of Lotame describing his innovative use of partitioning.
Read more...
By Gregory J. Haase
|
|
Trees in SQL: Nested Sets and Materialized Path
|
Relational databases are universally conceived of as an advance over their predecessors network and hierarchical models.
Read more...
By Vadim Tropashko
|
|
Using Dynamic SQL with Sybase Replication Server
|
Instead of sending SQL language commands, dynamic SQL sends only literals to the target database and thereby improves replication performance while eliminating overheads of SQL statement syntax checking.
Read more...
By Manish Negandhi
|
|
Basic CREATE TABLE statement
|
A very basic CREATE TABLE statement which should work in any SQL database:
Read more...
By
|
|
Data Conversion in SQL Server
|
In this article, I introduce you to both types of data type conversions and provide examples that demonstrate how they work, with a few warnings about the sort of thing that can go wrong with implicit conversions.
Read more...
By Robert Sheldon
|
|
How to Track Your Oracle Sun System Assets
|
Radio Frequency Identification (RFID) is a method for identifying objects using low-range wireless radio frequencies.
Read more...
By
|
|
PureScale Performance Proven
|
DB2 for z/OS provides mainframe users with unmatched levels of resilience and scalability through technology known as data sharing.
Read more...
By Julian Stuhler
|
|
Writing a Custom Storage Engine
|
This chapter is intended as a guide to assist you in developing a storage engine for the new pluggable storage engine architecture.
Read more...
By
|
|
Monitoring Table Size Growth in SQL Server
|
This article takes you step by step to setup Oracle Standby Database.
Read more...
By Jyoti Salunkhe
|
|
Monitoring Table Size Growth in SQL Server
|
In this article I introduce a simple process that saves tables size information at points in time which latter allows for tracking down table growth over time.
Read more...
By Yaniv Etrogi
|
|
Microsoft Access Code Snippets and Other Useful Bits
|
In this article, I cover a few indispensable ones, a few interesting ones and one dangerous one.
Read more...
By Danny Lesandrini
|
|
Enhancing Oracle Database Performance with Flash Storage
|
In the last year or two, enterprise class flash storage devices have entered the marketplace.
Read more...
By
|
|
Automate and Improve Your Database Maintenance Using Ola Hallengren's Free Script
|
After a new SQL Server instance is created, one of the first tasks the DBA must undertake is to create a database maintenance plan.
Read more...
By Brad McGehee
|
|
Setting up Transactional Replication in SQL Server 2008 R2
|
Replication is one of the High Availability features available in SQL Server.
Read more...
By Satnam Singh
|
|
Policy-based Management and Central Management Servers
|
Whilst it may be more exciting as a DBA to rush around fixing broken databases, it is far better to forestall problems by making sure that your servers conform with best-practices.
Read more...
By Rod Colledge
|
|
Performance Tune IBM DB2 z/OS Applications using Resource Constraint Analysis
|
For the DB2 for z/OS professional the two most common systems tuning scenarios are tuning a DB2 data sharing group or tuning a series of application SQL statements.
Read more...
By Lockwood Lyon
|
|
Manage Mass Provisioning Using Oracle Enterprise Manager Grid Control
|
Learn how to provision literally hundreds or even thousands of systems using the mass provisioning techniques described here.
Read more...
By Porus Homi Havewala
|
|
Exception Error Handling Implementation in MySQL/VB.NET Windows Database Applications
|
Error handling implementation in Windows database applications is a must for any Application Developer today.
Read more...
By Ernest Bonat
|
|
Tuning an IBM DB2 for z/OS Application: CPU Constraint
|
When involved in application performance tuning, the database administrator usually concentrates on reducing elapsed times or I/O waits.
Read more...
By Lockwood Lyon
|
|
Top 10 SQL Server 2008 Security Features
|
Protecting database information from threats and vulnerabilities is very important for any organization;
Read more...
By Tapas Pal
|
|
Online Processing
|
This chapter discusses the IMS online environment, online application programs, backup, and recovery.
Read more...
By Anirban Dutta
|
|
Introduction to JQuery -- a Powerful JavaScript Library
|
This article was written and tested using NetBeans IDE 6.8.Introduction
Read more...
By Julien Dubois
|
|
What Every DBA Ought to Know About SQL Server Cursors (and Their Alternatives)
|
Cursors provide a means of processing through a set of records row-by-row.
Read more...
By Deanna Dicken
|
|
Using-MySQL-with-PDO
|
PDO is a PHP extension providing a data-access abstraction layer that can be used with a variety of databases.
Read more...
By Brad McGehee
|
|
Guide to SQL Virtual Restore
|
"So what?" you might ask. "Can't you just restore a database backup to accomplish the same goal?".
Read more...
By Brad McGehee
|
|
Database Triggers
|
Database Triggers are one of the good features available in ORACLE.
Read more...
By Vishant Sanghavi
|
|
Data Mining Using the RDOM Package
|
Data mining, predictive analysis, and statistical techniques generally do not make headlines.
Read more...
By Casimir Saternos
|
|
Introduction to Jersey Standard, Open Source REST Implementation
|
This article is part 1 of a four-part series. It briefly introduces basic Representational State Transfer (REST) principles
Read more...
By Julien Dubois
|
|
IMS Structures and Functions.
|
This article discusses IMS database organization, access methods, secondary indexes, and logical relationships.
Read more...
By Anirban Dutta
|
|
Database Auditing in IBM DB2 9.5 & 9.7: How do I know...
|
Database administrators have both an Instance level and a Database level auditing approach with IBM DB2 9.5 and 9.7
Read more...
By Rebecca Bond
|
|
Binary Trees in SQL
|
So as to illustrate the point he'd reached, I've cleaned up the code just a little bit
Read more...
By Joe Celko
|
|
An Open Pre-Compiler for Embedded SQL
|
Many commercial RDBMS have a pre-compiler that converts embedded SQL macros into inline code for SQL calls.
Read more...
By Alan Walker
|
|
VoltDB Introduces Extreme Transaction Processing Database System
|
VoltDB Introduces Extreme Transaction Processing Database System
Read more...
By Charles Babcock
|
|
SQL Server APPLY Basics
|
In this article, I demonstrate how to work with both forms of the APPLY operator.
Read more...
By Robert Sheldon
|
|
IMS Concepts and Database Administration
|
This article provides a high-level overview of IMS database concepts, terminology, and database design considerations.
Read more...
By Anirban Dutta
|
|
May Madness - Fascinating Acquisitions Surrounding IBM DB2 and Sybase
|
May Madness - Fascinating Acquisitions Surrounding IBM DB2 and Sybase
Read more...
By Julian Stuhler
|
|
Building Customizable Applications Using Oracle Metadata Services
|
Get a hands-on introduction to Oracle ADF's services for personalization and customization
Read more...
By John Stegeman
|
|
Top DBA Shell Scripts for Monitoring the Database
|
This article focuses on the DBA's daily responsibilities for monitoring Oracle databases and provides tips and techniques on how DBAs can turn their manual, reactive monitoring activities into a set of proactive shell scripts.
Read more...
By Daniel T. Liu
|
|
Oracle Database's ADRCI : Reading the Old Alert Log and Listener Log
|
Oracle's ADR seems to be great for the new XML logs but let's not forget about the old style logs as ADRCI can do a few things with them as well.
Read more...
By James Koopmann
|
|
ORACLE RMAN BACKUP
|
This article shows how to setup and configure RMAN backups.
Read more...
By Ferhat Ozturk
|
|
High Performance Storage Systems for SQL Server
|
As DBAs, there are many things we need to worry about. In my last article, Planning for Disaster,
Read more...
By Rod Colledge
|
|
SQL Server Intellisense VS. Red Gate SQL Prompt
|
When I was ten years old, I saw my brother programming in Clipper, and I asked him how difficult it was to write code.
Read more...
By Fabiano Amorim
|
|
Managing database transactions and handling Large Objects from Python
|
Transactions encompass a set of SQL statements that constitute a single logical operation inside the database, e.g. a money transfer or a credit card payment.
Read more...
By Przemyslaw Piotrowski
|
|
Database Management: Metadata is more important than you think!
|
Whether it's data warehousing, MDM or business intelligence, metadata is added to the project plan, is downgraded and eventually dropped from the project plan.
Read more...
By Denise Rogers
|
|
ASP.NET MVC Routing Tutorial - Part I
|
In this tutorial we will take a look at ASP.NET MVC Routing which is a very powerful method of handling URL's in web apps.
Read more...
By
|
|
Advanced Bazaar for MySQL developers
|
Article describing how to get MySQL's code by using Bazaar, and how to compile a MySQL server binary from this.
Read more...
By Guilhem Bichot
|
|
Why Should I Check Out a MySQL-Based Column Database ?
|
Some technologies come on the information technology landscape and stay, providing long-lasting benefits, whereas others are more of a short term fad and ultimately end up disappearing because
Read more...
By Robin Schumacher
|
|
T-SQL Equivalents for Microsoft Access VBA Functions
|
If you need to migrate your Access application to SQL Server, don't count on The SQL Server Upsize Wizard in Microsoft Access to automatically convert your VBA functions. If you want to push the complex query processing done by your Access queries to the back end, you'll have to rewrite them in T-SQL.
Read more...
By Danny Lesandrini
|
|
Oracle ADF Essentials
|
The basics of installing and configuring the Hudson integration engine to continuously build and test Oracle ADF applications
Read more...
By John Stegeman
|
|
DB2 Database Maintenance and Recovery: Getting Past the Common Misconceptions
|
Every DBA strives to maintain a healthy DB2 environment every day. However, there are numerous lingering misconceptions about database health to which many organizations fall prey.
Read more...
By Brenda Honeycutt
|
|
Adding a KPI to an SQL Server Analysis Services Cube
|
Key Performance Indicators, which vary according to the application, are widely used as a measure of the performance of parts of an organisation.
Read more...
By Robert Sheldon
|
|
SQL Server Logical Reads - What do they really tell us?
|
In this article, we will examine this counter's true meaning and provide examples that prove it can sometimes be quite misleading.
Read more...
By Ami Levin
|
|
ORACLE OEM REPOSITORY RECREATION
|
In order to successfully create a new repository for OEM, you need to drop existing repository at first stage.
Read more...
By Ferhat Ozturk
|
|
How DB2 9 for z/OS Can Improve a Data Warehouse's Performance
|
This article focuses on one specific, significant set of DB2 improvements that address performance. Everyone likes to see their performance improve, and with DB2 9, you won't be disappointed.
Read more...
By Willie Favero
|
|
Evolutionary Database Design
|
This article describes the practices that we've used to allow us to do this impossible thing. We won't say that we've completely solved the database evolution problem, but we do think we've demonstrated a set of techniques that many people will find useful.
Dealing with Change
Read more...
By Martin Fowler
|
|
Customizing Security for Oracle WebLogic Server MBeans
|
A quick tour of your options for ensuring security for JMX operations in Oracle WebLogic Server
Read more...
By Peter Bower
|
|
Why VB/ MySQL By
|
In my articles, I will cover some of the basic of developing applications using Visual Basic and MySQL.
Read more...
By Mike Hillyer
|
|
Transparent Data Encryption
|
Encrypt sensitive data transparently without writing a single line of code.
Read more...
By Menon Srivalsala kumar
|
|
Comparison: Oracle WebLogic Integration's Custom Control and SOA Suite Spring Component
|
This article explains how a Spring component in SOA Suite provides the same functionality as a Custom control in WLI. It uses the example of a logger component to describe step-by-step how the Spring component is implemented and deployed.
Read more...
By Clemens Utschig-Utschig and Simone Geib
|
|
Do Alpacas Dream of farming DBAs
|
M
ost days I truly love being a SQL DBA. Then there are the days when I seriously consider making the jump to Alpaca farming.
Read more...
By Timothy Ford
|
|
Database Indexing Development Lifecycle ...Say What?
|
This is the first article of a series where I'll be exploring Indexing Guidelines. Having appropriate indexes on your database is critical in making sure your application is retrieving records quickly.
Read more...
By Gregory A. Larsen
|
|
SQL Azure with ASP Dot Net
|
SQL Azure (SSDS - SQL Server Data Services) is a cloud database system offered by Microsoft.
Read more...
By Don Schlichtin
|
|
Interoperability Between Oracle and Microsoft Technologies
|
RESTful Web services are the latest revolution in the development of Web applications and distributed programming for integrating a great number of enterprise applications running on different platforms.
Read more...
By John Charles
|
|
Falcon storage engine in depth
|
MySQL/Sun released a new storage engine "Falcon" in January, 2007. Falcon is a high performance transactional (fully compliant with ACID) storage engine, which is beta at this time (June 2008). In this article, I describe Falcon's features and its architecture in detail.
Read more...
By Yoshinori Matsunobu
|
|
Exceptional PowerShell DBA Pt1 - Orphaned Users
|
In this script, we will work with PowerShell 2.0 and error handling (in case the SQL Servers are offline or some other problem occurs), and we will also be using a function module (.psm1) to contain the functions that we'll use in our scripts and make them easily available;
Read more...
By Laerte Junior
|
|
Jumpstart for Oracle Service Bus Development
|
his article is aimed at developers and architects who are familiar with Oracle Enterprise Service Bus (OESB) and are (fairly) new to Oracle Service Bus (OSB).
Read more...
By Ronald van Luttikhuizen and Eric Elzinga
|
|
SQL Server Sheep Ticks
|
The doggedness with which certain SQL Server "myths" cling to the coat of the SQL Server community is really quite astonishing.
Read more...
By Tony Davis
|
|
MySQL Database Analytics with InfiniDB from Calpont
|
Let's be honest: working with big databases is a lot of fun. There's something cool about dealing with tables that have hundreds of millions or billions of rows in them, loading huge amounts of data, building star and snowflake schemas for data warehouses/marts, optimizing query performance, and all that jazz. Yes, working with big databases is a lot of fun.
Read more...
By Robin Schumacher
|
|
Getting Started with BI Publisher ToolBox
|
Learn how this free utility can make running BI Publisher reporting components incredibly easy.
Read more...
By Ike Wiggins
|
|
ANSI ISO SQL1999
|
Running sql on various database and Standardizing the sql will be the best option in Development of Application. We can make the sql are standardizes using ANSI/ISO SQL:1999:
Read more...
By menon srivalsala kumar
|
|
Using The Transfer Jobs Task in SQL Server Integration Services
|
SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations.
Read more...
By Ashish Kumar Mehta
|
|
Introduction to Ant-Driven Development and Testing of Oracle WebLogic Server Apps in Eclipse
|
Learn how to complement Oracle Enterprise Pack for Eclipse with Ant to create scripts that build applications, control application server instances, create domains, and more.
Read more...
By Jean Drole
|
|
Introducing the MySQL Librarian
|
The MySQL Librarian is a collection of community-generated and cross referenced content related to MySQL. It's a place where the community, collaboratively, builds and maintains MySQL content.
Read more...
By Giuseppe Maxia
|
|
Bulk-Batch Email From Microsoft Access
|
If your database has a table with "person" information, odds are it has an email column. If your users collect email addresses, odds are they want to send emails to persons in the database and before long, someone's going to get it into their head to send out an email "blast" or batch.
Read more...
By Danny Lesandrini
|
|
Understanding Scans And Seeks
|
There is a popular theory on scans and seeks: "Scan reads through the object (table/index) from top to bottom looking for the records that it needs while seek goes directly to the part of the object that it needs and reads to where the data that it needs ends. This is obviously a must more efficient operation than a scan, as database server already knows where the data is that it is looking for". This article analyzes the validity of the theory.
Read more...
By Preethiviraj Kulasingham
|
|
PostgreSQL Maestro 8.10 released 10/16
|
SQL Maestro Group announces the release of PostgreSQL Maestro 8.10, a powerful Windows GUI solution for PostgreSQL administration and database development.
Read more...
By
|
|
Patch a Thousand Databases, Using Oracle Enterprise Manager Grid Control
|
With Critical Patch Updates (CPUs) now published quarterly by Oracle and with several companies seeking to make application of CPUs mandatory for all their databases as part of their corporate security policy, the onus is on DBAs to make sure the myriad databases in their domain are patched in a controlled and timely manner.
Read more...
By Porus Homi Havewala
|
|
Developing Database Applications Using MySQL Connector/C++
|
The MySQL Connector/C++ provides an object-oriented application programming interface (API) and a database driver for connecting C++ applications to the MySQL Server. Connector/C++ implemented a significant percentage of the industry standard JDBC 4.0 specification in C++ world. This technical article shows the essential steps to build and install MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database. Application developers who are new to MySQL Connector/C++ but not to C++ programming and MySQL database, are the target audience.
Read more...
By Giri Mandalika
|
|
A Code of Conduct for DBAs
|
Physicians, attorneys, accountants, engineers, realtors, and many other professionals have written guidelines designed to discourage misconduct and illegal activity, and to promote the ethical conduct of its members. In fact, according to the Sarbanes-Oxley act, all public companies in the United States are required to create and follow their own code of conduct.
Read more...
By Brad McGehee
|
|
SQL Server eBook Download - SQL Server Tacklebox
|
Inside the SQL Server Tacklebox, you'll find a collection of the day-to-day tools and techniques that I use to automate and standardize SQL Server installation, document and report on my servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of impending issues, secure access to my servers and fight off the data corruption monster.
Read more...
By Rodney Landrum
|
|
Calling Stored Procedures from ADO.NET
|
The Microsoft .NET Framework offers improved performance in accessing stored procedures through ADO.NET when compared to ADO.
Read more...
By John Paul Cook
|
|
Using Transfer SQL Server Objects Task and Execute SQL Tasks in SSIS
|
SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations.
Read more...
By Ashish Kumar Mehta
|
|
Redo Byte Address (RBA)
|
Recent entries in the redo thread of an Oracle instance are addressed using a 3-part redo byte address, or RBA.
Read more...
By Vinod Udapudi
|
|
Introduction to Oracle SQL Developer Data Modeler
|
Learn how to install/configure Oracle SQL Developer Data Modeler and then perform some common tasks.
Read more...
By Casimir Saternos
|
|
Migrating Web Applications for use with SQL Anywhere Web Edition
|
This article outlines some of the motivation behind wanting to port existing applications over for use with SQL Anywhere, and then covers the steps necessary to do this.....
Read more...
By Bryan Sachdeva
|
|
Doing Eighty Things at Once
|
Rodney Landrum is a SQL Server DBA for a large company, with at least eighty SQL Servers to look after. He is now a great fan of SQL Multiscript and explains why....
Read more...
By Rodney Landrum
|
|
DB2-Web-Services
|
How DB2 and data managment fits into the total picture of Web services? How can Web services facilitate information integration and optimized access to a world of data? What do applicaton developers need to know before writing a DB2 Web service application?..
Read more...
By Grant Hutchison
|
|
Flash Back Table
|
This article will help you recover a table upto a certain time. This Procedure was tested on Oracle 10g Release 2.....
Read more...
By Fahad Reyaz
|
|
Guide: Installing Oracle Enterprise Manager 10g Grid Control Rel 5 on Oracle Database 11g and Linux
|
Install Oracle Enterprise Manager 10g Grid Control Rel 5 against an existing Oracle 11g database on Oracle Enterprise Linux version 5, step by step......
Read more...
By Mike Revitt
|
|
Web Services Support in Oracle Enterprise Pack for Eclipse
|
With the emergence of XML and a few arcane ancestors of contemporary WS-* standards in the 1990s, a few frontrunners soon recognized that exchanging data through standard interfaces over the Internet (eg, XML over HTTP) was the way to go.......
Read more...
By Ronald van Luttikhuizen
|
|
Brad's Sure DBA Checklist
|
Sometimes, all a DBA needs, to help with day-to-day work, is a checklist of best-practices and dos and don'ts. It provides a handy reminder. We asked Brad to provide one...
Read more...
By Brad McGehee
|
|
MySQL Developer, meet "Quan" (aka the MySQL Query Analyzer
|
The MySQL Query Analyzer ("Quan") is designed to save development time on query coding and tuning by expanding on all of the good things found in the Slow Query Log, SHOW PROCESSLIST; EXPLAIN plan, and 5.1 profiler all with no dependence of any of these atomic things...
Read more...
By Rob Young
|
|
DB2 and Visual Studio 2008: Getting Started
|
In a previous set of articles, I showed you all the great integration features between the IBM DB2 9 for Linux, UNIX, and Windows (DB2 9) data server and Microsoft Visual Studio 2005........
Read more...
By Paul Zikopoulos
|
|
Constructing a Data Warehouse
|
In today's business world, data warehouses are increasingly being used to help companies make strategic business decisions.......
Read more...
By Tom Moulde
|
|
Sap Parameter Checks
|
Here is same detail of sap parameters......
Read more...
By saji
|
|
On the Trail of the Expanding Databases
|
It is sometimes difficult for other IT people to understand the constraints that DBAs have to work under. So often the ideal or obvious solution is frustratingly out of reach because of 'political' reasons that seem baffling to the spectator. Francis Hanlon describes a typical incident: It is essential reading for anyone wishing an insight of the problems that DBAs face .....
Read more...
By Francis Hanlon
|
|
Why Move to MySQL from Microsoft SQL Server?
|
Before we get started, let me say that I always liked being a SQL Server DBA. My database experience started with DB2, then Teradata, followed by Oracle, and then SQL Server (and then a little bit of Sybase after that, followed by MySQL). .....
Read more...
By Robin Schumacher
|
|
Microsoft Access 2007 Certification
|
I admit that certification doesn't make one an IT superhero but it's something every developer should consider. .....
Read more...
By Danny Lesandrini
|
|
Taking an Oracle ADF Application from Design to Reality
|
Learn techniques for decomposing system requirements into a living, breathing Oracle ADF application.....
Read more...
By Chris Muir
|
|
Using DNS To Distribute Trust
|
In "DNSSEC: Forgetting The User, Again," I opined about why users should be notified about signed vs. unsigned DNS responses. Dan Kaminsky, a security researcher with IOActive, and I got into a quick conversation about DNSSEC, SSL, and trust on the Internet. Kaminsky had some interesting thoughts on distributing trust.....
Read more...
By Mike Fratto
|
|
Using Web Service and XML Tasks in SQL Server 2008 Integration Services
|
SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations....
Read more...
By Ashish Kumar Mehta
|
|
Understanding DB2: Learning Visually with Examples
|
DATABASE 2 (DB2) for Linux, UNIX, and Windows is a data server developed by IBM. Version 9.5, available since October 2007, is the most current version of the product, and the one on which we focus in this book..
Read more...
By Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow
|
|
SQL Server 2005 and Express Installation Tips and Tricks
|
In this article, author John Cook shows how to install SQL Server 2005, to minimize the number of steps. By understanding documented, undocumented, and obscure features, you can get relief from installation pain points.
. Read more...
By John Paul Cook
|
|
High Concurrency with Python and Oracle Database
|
With the trend toward more, rather than faster, cores, exploiting concurrency is increasing in importance. Concurrency creates a new paradigm shift in programming, making it possible to write asynchronous code that separates tasks into a set of threads or processes working in parallel.
. Read more...
By Yuli Vasiliev
|
|
Spicing Up Your Web Services with XSLT
|
In this article, I'm going to show you how to apply Extensible Stylesheet Language Transformations (XSLT) to your Web services.
. Read more...
By Paul Zikopoulos
|
|
SOA Design Pattern Application Sequences: Service Facade + UI Mediator
|
Top-selling SOA author Thomas Erl examines the Service Facade and UI Mediator patterns and explores some creative ways to chain patterns together into pattern application sequences.
. Read more...
By Thomas Erl
|
|
ODBC connectivity using UNIX ODBC and FreeTDS
|
This article will show you how you can use establish connectivity in Oracle and MS SQL database. I did my test on Fedora Core 6 with Oracle 10g R2. The solution is for testing purpose only. Please use it at your risk. The DataDirect offer commercial solution for this type of connectivity.
. Read more...
By Vigyan Kaushik
|
|
Let PowerShell do an Inventory of your Servers
|
If you run a regular and comprehensive inventory of all the servers you manage, you can solve problems more quickly and answer most questions from management. If you then repeat these reports over a time period, it helps to to track trends such as disk space usage
. Read more...
By Allen White
|
|
Getting started with DTracing MySQL
|
DTrace is a dynamic tracing facility built into the Solaris and Open Solaris operating systems and can be used by system administrators and developers alike to observe the runtime behavior of user level programs and of the operating system itself.
. Read more...
By Amit Saha
|
|
ASE 15 and the Optimizer Statistics - More Influential Than Ever
|
ASE 15 introduces completely new Optimizer and Query Processing engines, incorporating many fundamental changes.
. Read more...
By Eric Miner
|
|
Estimating Disk Space Requirements for Databases
|
In the first of a series of Database Maintenance Tips and Tricks, Alex Kozak discusses some general issues surrounding disk space requirements for SQL Server databases and shows how to estimate Disk space usage and requirements.
. Read more...
By Alex Kozak
|
|
Another Look at MySQL 5.1's SQL Diagnostic Tools
|
No matter what they say, I don't think it's true. Database 'experts' say that 80-90% of a database's overall performance comes from the SQL code that's running against it.
. Read more...
By Robin Schumacher
|
|
Access forms and DB2 Data Server - a perfect match
|
I took the concept of linked tables a step further and showed you how to leverage Access 2007 and DB2 as an integration layer; in addition,
. Read more...
By Paul Zikopoulos
|
|
Python Data Persistence with Oracle Database
|
Learn how to build your own Python app backed by Oracle Database, utilizing Oracle XML DB, Python scripts, and PL/SQL stored procedures.
. Read more...
By Yuli Vasiliev
|
|
Password Protection in Oracle
|
Password Protection in Oracle 11g
. Read more...
By Vigyan Kaushik
|
|
Obtaining Index Usage Information
|
When building an application there are a number of different things that are important. One of those is having a good database design.
. Read more...
By Greg Larsen
|
|
Monitor your Database Backups Using Operations Manager
|
While presenting my work on Operations Manager at PASS this year, I showed a new custom monitor for Operations Manager that I had recently written and deployed into our Data Server environment.
. Read more...
By Thomas LaRock
|
|
Developing for the Apple iPhone with Oracle JDeveloper and ADF
|
The Apple iPhone, since its initial introduction in July 2007, has become the fastest selling smartphone in the 18 months of its existence.
. Read more...
By Joe Huang
|
|
An Introduction to Oracle Warehouse Builder 10g
|
Whilst many Oracle DBAs build and maintain their data warehouses using nothing more than UNIX, SQL, and PL/SQL scripts, many are now starting to use graphical tools such as Oracle Warehouse Builder 10g (OWB) to help with development.
. Read more...
By Mark Rittman
|
|
Sybase Resources Site at DBA-Sybase
|
This article reviews a website,dba-sybase, which provides resources for Sybase DBAs through the format of case studies from a working DBA.
. Read more...
By Margaret Cruise O'Briena
|
|
Bound and Unbound DataGridView Control for MySQL 5.0/VB.NET 2008 Windows Applications
|
Understanding and programming MySQL data load into the DataGridView control is a must for Windows Application Developers today. Many times, in real production environment the end-users need to see a result set of data to make daily business decisions. The main question is about how many records they need to see when the control gets loaded. The answer of the question is defined by the client's business rules. At this point application performance is a critical issue for Application Developers. In this paper I'll show you how load MySQL data into the DataGridView control using VB.NET bound and unbound programming modes. A timer class named Stopwatch for VB.NET will be used to measure the execution time between theses two programming modes.
. Read more...
By Ernest Bonat
|
|
Transforming Business Logic into Web Services Using DB2 9.5 and IBM Data Studio
|
Learn how to take business logic such as stored procedures, functions, or SQL statements and turn them into a Web service.
. Read more...
By Paul Zikopoulos
|
|
The DBA Script Thumb
|
Like many DBAs, Rodney has squirrelled away a large number of routines that he uses almost daily to check on his servers and databases. Of this large collection he chooses five that he wouldn't want to be without. and there is something for everyone in this DBA's.
. Read more...
By Rodney Landrum
|
|
Intelligence and Identity
|
Integrating Oracle Business Intelligence and Oracle Identity Management
. Read more...
By Mark Rittman and Joel Crisp
|
|
Using Partitioning to Manage Satellite Networks
|
Using Partitioning to Manage Satellite Networks
. Read more...
By Guy Adams
|
|
Searching For Text Anywhere In a Database
|
This article outlines a simple tool to search tables or linked tables to find if a text string(s) exists in those tables. It does this by building SQL queries after analyzing the system tables in any Access/Jet database. This code is suited to Access 2000, XP, 2003 and 2007.
. Read more...
By Garry Robinson
|
|
Installing dbschema on Windows
|
Dbschema is a utility that extracts the schema of a database or entire Adaptive Server into one or more scripts. This article provides step-by-step instructions for installing the utility on a Windows machine for those without any prior experience of Perl..
. Read more...
By Caroline Walsh
|
|
How to Develop, Maintain, and Support a Quality Management and Development
|
Get an overview of real-world testing methodologies, as well as a getting-started introduction to Oracle Test Manager for Web Applications.
. Read more...
By James Downs
|
|
Operations Manager: A Big Tinker Set
|
In this article, I will describe how to create a customized monitor within Operations Manager 2007.
. Read more...
By Thomas LaRock
|
|
Why This SQL Server DBA is Learning Powershell
|
In this article, I will describe several examples of using PowerShell that I would hope a DBA would find useful. My scripts will demonstrate how to run SQL queries, WMI queries or SMO code on one or more machines, and help you to better manage multiple database servers. All of the scripts have been tested on SQL Server 2005.
. Read more...
By Ron Dameron
|
|
MySQL_Database_Administration
|
If you need to administer MySQL, this article gets you off to a good start. The first of a multi-part series, it is excerpted from chapter four of the book MySQL Administrator's Guide, written by Paul Dubois
. Read more...
By Sams Publishing
|
|
Manually Creating an Oracle Database on Windows
|
Manually Creating an Oracle Database on Windows
Below are the steps involved in manual database creation on Windows.
. Read more...
By john niveth
|
|
How to Develop, Maintain, and Support a Quality Management and Development Process
|
The task of defining test plans, acceptance criteria, and testing deliverables and processes for any software development effort can face many different and evolving challenges, from identifying applicable processes to maintaining those decisions over time.
. Read more...
By James Downs
|
|
An Introduction to Linux Shell Scripting for DBAs
|
About seven years ago, Oracle released the first commercial database on Linux. Since then, Oracle, Red Hat, and Novell/SUSE have been steadily collaborating on changes to Linux kernel as they relate to database and application performance.
. Read more...
By Casimir Saternos
|
|
Tuning Up for OLTP and Data Warehousing - Part 3
|
There are many types of DBAs. Some DBAs work in the developer arena, while others are heavy into performance and tuning, and still other DBAs fall into the operational aspects of managing SQL Server.
. Read more...
By Gregory A. Larsen
|
|
Tuning Up for OLTP and Data Warehousing - Part 3
|
We mentioned that 20 to 25 percent of performance tuning improvements result from configuring the database manager, database, and tablespace container and parameter settings. But 75 percent or more of performance improvements come from properly tuning SQL.
. Read more...
By Scott Hayes and Philip Gunning
|
|
Oracle Workshop's Support for Java EE 5 Web Standards
|
For a long time, J2EE seemed a powerful, complex technology. If you took the time to fully understand it, however, you would have discovered ingenious solutions for building scalable component-based multi-tier enterprise applications.
. Read more...
By Andrei Cioroianu
|
|
MySQL Tuning: Getting the most out of your database
|
This article will deal with a few basic MySQL Tuning options that can make queries run faster on your MySQL database.
This problem can be approached from several different angles.
. Read more...
By
|
|
A Quick Look at MySQL 6.0's New Backup
|
I still remember the day. I was working for a large systems integrator on a very major account, and had responsibility for some DB2 databases, but also had the unfortunate duty of also taking care of some legacy IMS databases!'
. Read more...
By Robin Schumacher
|
|
What use is a Development DBA?
|
I'm sure that there are many Developers who would respond to that question immediately, with something like:
'None, other than to obstruct me at every opportunity!'
'Well, he'd be more use if he stopped breaking things!'
. Read more...
By Doug Burns
|
|
Which Scripting Language for Sybase Administration on Windows?
|
This paper considers five scripting options available to automate the administration of Sybase database servers on Windows.
. Read more...
By Caroline Walsh
|
|
DBA: TEN YEARS AFTER AND BEYOND
|
In March of 1990, a little booklet of ancient and medieval rules appeared on the market. This had the strange name of De Bellis Antiquitatis (and known ever since as just DBA).
. Read more...
By Bob Beattie
|
|
Certifications Compared: Oracle vs. DB2 vs. SQL Server
|
If you're looking into DBA certification, you've got to decide with which product to certify. Which DBA certification is most marketable? Which best fits you? How do the vendors' certification requirements vary, and what are the costs and the time involved?
. Read more...
By Howard Fosdick
|
|
Basic Java Persistence API Best Practices
|
Consider and employ these simple approaches to make your Java Persistence API applications more maintainable.
. Read more...
By Dustin Marx
|
|
How to find out virtual index from database?
|
Virtual index can be created in oracle database which doesn't has any physical body and location. It can create with NOSEGMENT clause for testing purpose.
. Read more...
By Gitesh Trivedi
|
|
SQL Server Performance Coding Standards
|
In this article Amol Ramesh Kulkarni provides a list of his top SQL Server Performance Coding Standards
. Read more...
By Amol Kulkarni
|
|
Getting started with Bazaar for MySQL code
|
Since you're reading this, you probably know that Sun is switching to the Bazaar version control system for all development work on the MySQL server. Unlike the version control system that we've been using previously,
. Read more...
By Amol Kulkarni
|
|
The SQL Builder Development Accelerators
|
DB2 9.5 and IBM Data Studio: Part 8: The SQL Builder Development Accelerators - The Rest of the Story
. Read more...
By Paul Zikopoulos
|
|
Using Database Advisors
|
Advisors are powerful tools that provide specific advice on how to address key database management challenges, covering a wide range of areas, including space, performance, and undo management.
. Read more...
By Sushma Jagannath
|
|
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. Read more...
By Don Schlichting
|
|
Automate Audit Requests
|
In this article TJay Belt describes a process to help respond to audit requests in a timely manner. Read more...
By TJay Belt
|
|
MySQL Workbench for Database Change Management
|
Managing database change is an incredibly important discipline that very few database professionals overtly talk or worry about until they're in the thick of things with a particular database - moving it from development to production, making changes to a newly installed production database, or implementing an updated version of the database (new tables, modifications to existing objects, etc.) in a SaaS application. It's at that point where change management becomes very important because if you don't do things right the first time, you can make a royal mess of things and even (in a small number of cases) reach the point of no return where you've completely torched your database. Read more...
By Robin Schumacher
|
|
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"). Read more...
By Garry Robinson
|
|
Accelerating Data Warehouses
|
An option of Oracle Database 11g Enterprise Edition, Oracle OLAP 11g is a full-featured online analytical processing engine. Because Oracle OLAP 11g is embedded in Oracle Database, it benefits from database scalability, security, and manageability features. Read more...
By Dan Vlamis
|
|
ERP and Data Migration to packages like SAP, PeopleSoft
|
ERP and Data Migration to packages like SAP, PeopleSoft Read more...
By
|
|
A look at Falcon Diagnostic Tables
|
Performance tuning is one of the top disciplines (if not THE top discipline) that database professionals want to excel at. Being able to take a system that's running sluggish and turn it into one that's running as fast as a scalded dog is a talent that's part art and part science, but whatever the combination necessary to make it happen, there will always be strong demand for folks who are good at it. Read more...
By Robin Schumacher
|
|
SQL Server Management Studio Reports and Dashboard
|
SQL Server 2005 and SQL Server 2008 provide graphical reports for monitoring system health and performance. While there have always been various queries, stored procedures, and of late, Dynamic Management Views, to gather system statistics, none were graphical. . Read more...
By Don Schlichting
|
|
Authorizing Access to Dynamic Spatial-Temporal Data
|
Authorizing access to individual data objects based on spatial and temporal references is a complex task. Read this case study to learn one feasible approach. Read more...
By Lucas Jellema
|
|
Build a Google Talk Client Using Oracle ADF Faces Rich Client and the Active Data Service
|
As Oracle OpenWorld 2007 made very clear, the integration of Web 2.0 concepts and trends into enterprise applications is a major trend in application development. Oracle Fusion Applications offer a good example of how combining very appealing, visually rich user interfaces with popular internet trends such as social bookmarking and instant messaging (IM) lead to attractive and productive applications.... Read more...
By Lucas Jellema
|
|
How the MySQL Enterprise Upgrade Advisor Helps DBAs Avoid Being Bitten by Known Bugs
|
In an earlier article I described how MySQL Enterprise takes the guesswork out of deciding which version of the MySQL server customers should be running by providing alerts around regularly scheduled Monthly Rapid Update and Quarterly Service Pack releases of the Enterprise Server.
Read more...
By Budi Raharjo
|
|
The Basic Steps to Connect Oracle and Java Program
|
Traditionally, up to Oracle8 Release 8.0.5 the management of free and used extents of a tablespace was done in the data dictionary. These "traditional" tablespaces are also called "Dictionary Managed Tablespaces", in order to differentiate them from a new type of table space called Locally Managed Tablespaces introduced in Oracle8i Release 8.1.5....
Read more...
By Budi Raharjo
|
|
Locally managed tablespaces in Oracle
|
Traditionally, up to Oracle8 Release 8.0.5 the management of free and used extents of a tablespace was done in the data dictionary. These "traditional" tablespaces are also called "Dictionary Managed Tablespaces", in order to differentiate them from a new type of table space called Locally Managed Tablespaces introduced in Oracle8i Release 8.1.5....
Read more...
By Manikandan Govindaraj
|
|
Managing Complex XML Data in Oracle XML DB 11g
|
Learn how to manage complex XML with Oracle XML DB 11g, including how to change schema online...
Read more...
By V.J. Jain
|
|
SQL Server DBA : Adding users in SQL Server
|
SQL Server provides an effective method for adding users in SQL Server and for managing data and information so that it can easily be stored and retrieved from the underlying files in order to provide the functionality it is designed for ...
Read more...
By
|
|
The DB2 for Linux, UNIX, and Windows DBA Checklist
|
While databases are becoming more and more self-aware and self-healing, they still require some monitoring to keep them running as efficiently as possible. Just like your car, a database requires some checks to keep it running optimally.
Read more...
By Dwaine Snow
|
|
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.
Read more...
By Gregory A. Larsen
|
|
MySQL for Oracle DBAs and Developers
|
Outline
- DBA Tips, Tricks, Gotcha's & Tools
- Key Differences for Developers
- Migrating from Oracle to MySQL
- Questions & Answers;
Read more...
By Ronald Bradford
|
|
Instance Shared Memory and Semaphore Segments
|
This article was written for educational purpose only. Please refer to the related vendor documentation for detail.
Read more...
By Vinod Sadanandan
|
|
The Self-Taught DBA
|
You can't go to college to become a DBA. Sure, you can take some basic classes on database theory and design, and maybe even a couple classes on specific databases, but there is no comprehensive college program you can take to become a DBA.
Read more...
By Brad McGehee
|
|
Installing Oracle9i Release 2 on Linux
|
This article is a comprehensive guide for installing
Oracle9i Release 2 (9.2.0.4.0) on the Red Hat Linux Fedora Core 2
operating environment.
Read more...
By Jeff Hunter
|
|
MySQL 5.1 partitions in practice
|
This article explains how to test the performance of a large database with MySQL 5.1, showing the advantages of using partitions.
Read more...
By Giuseppe Maxia
|
|
Importing Poorly Formatted Text Files using SSIS
|
Handling text files from SQL Server Integration Service (SSIS) is not new and I am not going to discuss about importing well formatted text files. There are many occasions when database developers must import text files which are not properly formatted. I will discuss three methods of doing this. For these situations we are going to use Script Component data flow task.
Read more...
By Dinesh Asanka
|
|
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.
Read more...
By Danny Lesandrini
|
|
Integrating Oracle Business Intelligence Enterprise Edition Plus with SOA
|
A detailed look at the integration possibilities between Oracle SOA Suite and Oracle Business Intelligence Enterprise Edition Plus, from Oracle ACE Director Mark Rittman.
Read more...
By Mark Rittman and Joel Crisp
|
|
Migrating Access Apps to SQL Server
|
This installment concludes the series started by Marc Israel, Migrating Access Applications to SQL Server by Marc Israel. In previous articles, we discussed some of the migration issues, from upsizing tables to conversion of Access queries to SQL Server stored procs. I've procrastinated on this last topic, Query Optimization, because it's the most difficult to describe.
Read more...
By Jon Stephens
|
|
Using XML in MySQL 5.1 and 6.0
|
In this article, we discuss the XML functionality available in MySQL, with an emphasis on new features coming online in MySQL 5.1 and MySQL 6.0. We assume that you already have a working knowledge of XML, and that you know what the terms
Read more...
By Jon Stephens
|
|
Open Source PostgreSQL Developer Bruce Momjian Spills The DB Beans
|
The database architect talks about the emergence of a commercial company, EnterpriseDB, behind PostgreSQL and the vitality of the database itself.
Read more...
By Charles Babcock
|
|
Open Source PostgreSQL Developer Bruce Momjian Spills The DB Beans
|
The database architect talks about the emergence of a commercial company, EnterpriseDB, behind PostgreSQL and the vitality of the database itself.
Read more...
By Charles Babcock
|
|
DB2 9.5 and IBM Data Studio: Using OLE DB to Integrate Data
|
So far, in this series about the IBM Data Studio integrated development environment (IDE) that's available with DB2 Version 9.5 (DB2 9.5), I've shown you how to set up database connection objects and the actions that you can perform on them. In addition,
Read more...
By Paul Zikopoulos
|
|
Installing Oracle Database 11g Release 1 on Oracle Enterprise Linux 5 (32- and 64-bit)
|
Learn the basics of installing Oracle Database 11g Release 1 on Oracle Enterprise Linux 5 from the bare metal up (for evaluation purposes only).
Read more...
By John Smiley
|
|
Oracle RAC Wait Events
|
The main difference to keep in mind when monitoring a RAC database versus a single-instance database, is the buffer cache and its operation. In a RAC environment the buffer cache is global across all instances in the cluster and hence the processing differs.
Read more...
By
|
|
Developing MySQL Applications with Eclipse_CDT
|
In September, the Developer Zone featured Chapter 6 of Paul DuBois' MySQL, 3rd edition on Writing C Programs with the MySQL C API. This month, we continue in this series on developing MySQL applications in C with a tutorial from Mark Schoonover about using the Eclipse CDT (C Development Toolkit) as an IDE for developing C applications for MySQL.
Read more...
By Mark Schoonover
|
|
DB2 9.5 and IBM Data Studio
|
At the IBM Information Management Information on Demand (IOD) conference in Las Vegas in October 2007, IBM made a number of major announcements, which included the christening of the DB2 Viper 2 beta as DB2 Version 9.5 (DB2 ...
Read more...
By Paul Zikopoulos
|
|
Installing SQL Server 2008
|
This article will highlight the steps involved to install SQL Server 2008. The installation is simple and straightforward. Trial and preview versions can be downloaded from Microsoft at ...
Read more...
By Don Schlichting
|
|
Using Python with TurboGears
|
TurboGears offers Python-istas an excellent framework for creating Web-enabled applications backed by an Oracle database.
Read more...
By Daniel Rubio
|
|
Oracle DBA Exam ( the Oracle Architecture )
|
The Oracle Architecture The Diagram below gives a clear idea of the background processes, memory structures, and disk resources that comprise the Oracle instance, and also of the methods in which they act together to allow users to access information.
Read more...
By
|
|
Basic Database Design
|
Database design is becoming key to developing applications. Almost all web applications are driven by a database, and with Core Data, Cocoa applications are starting to have true database back ends. Therefore it is surprising that so many programmers don't know anything about database design. So here is a simple overview of the theory behind database design.
Read more...
By Pilky
|
|
Locally Managed Indexes
|
OK, I'll say it. Oracle does not always work the way I want it to work. The most obvious example of this is how indexes are managed. As data is manipulated, it is evident that the index does not reuse space that it had. For example, if I have a column containing the values A,D,B,E,C,F, and I put an index on this, then the index is created in the following order:
Read more...
By John Weeg
|
|
Oracle Blocksize and Index Tree Structures
|
Each data block within the Oracle index serves as a "node" in the index tree, with the bottom nodes (leaf blocks) containing pairs of symbolic keys and ROWID values. To properly manage the blocks, Oracle controls the allocation of pointers within each data block. As an Oracle tree grows
Read more...
By Donald K. Burleson
|
|
Monitoring Index Usage in Oracle9i
|
DBAs and developers love indexes. They speed up query searches, especially in a data warehouse environment, where the database receives many ad-hoc requests. To avoid fulltable scans, we tend to put indexes on every potentially searchable column.
Read more...
By Daniel T. Liu
|
|
Automated Table/Index Reorganization In Oracle8i
|
Automation can free the DBA of boring, time-consuming tasks and allows him to focus on more challenging activities.
Read more...
By Mike Hordila
|
|
Learn how to use the various partitioning methods in Oracle9i Release 2.
|
Oracle DBAs face an ever growing and demanding work environment. The only thing that may outpace the demands of the work place is the size of the databases themselves.
Read more...
By Liza Fernandez
|
|
An introduction to foreign keys and referential integrity in MySQL.
|
Referential integrity is an important concept in database design. The term refers to a state when all the references in a database are valid and no invalid links exist between the various tables that make up the system.
Read more...
By Contributor Mellonfire
|
|
An Oracle Instructor's Guide to DBA Tips and Tricks
|
This series of articles is a little different than others you may read. It doesn't focus on one, single topic, but it does provide a wealth of interesting information on a lot of different areas.
Read more...
By Christopher Foot
|
|
Work in multiple databases using these methods
|
SQL Server developers sometimes have to use tables residing in a database other than a project's "home" database. This need typically arises when you need to draw information from some other application;
Read more...
By Arthur Fuller
|
|
Understand the ambiguities of compound JOINs in SQL
|
This article begins with a test. Look at the SQL below and determine, without using your computer, what the result set will look like.
Read more...
By Arthur Fuller
|
|
Project Raptor – Oracle's New Tool for DBAs and Developers
|
It may be possible that raptors once feasted on toads, and if that were the case, it would be safe to assume that Oracle hopes its new Raptor product will do the same to the Toads of today.
Read more...
By Steve Callan
|
|
Database Migration - A Planned Approach
|
A fairly common event in a database's lifecycle is that of the migration from version "older" to version "newer." Migrating from one version to another may be as simple as exporting the old and importing into the new, but chances are there is a lot more involved than first meets the eye.
Read more...
By Steve Callan
|
|
Copying Databases from Server to Server
|
Method 1-- The fastest way to achieve this is by detaching the database from source server and then attaching the data and the log files to the destination server.
Read more...
By Rahul Sharma
|
|
Project Raptor - Oracle's New Tool for DBAs and Developers
|
It may be possible that raptors once feasted on toads, and if that were the case, it would be safe to assume that Oracle hopes its new Raptor product will do the same to the Toads of today
Read more...
By Steve Callan
|
|
CASE STUDY OF RMAN IMPLEMENTATION --- Administering the database
|
This paper focuses on the real-world implementation of RMAN at Eaton Cutler-Hammer. It includes a brief explanation of various Oracle backup methods, requirements at Eaton Cutler-Hammer
Read more...
By Ketan Shah, Eaton Cutler-Hammer
|
|
New and Improved Methods for Administering Your Database
|
Expose you to some of the database features available in 10g and compare them to the lengthy workarounds that were used in previous Oracle versions.
Read more...
By Howard Horowitz
|
|
Review of Pro .Net Oracle Programming
|
The reason I got this book is simple. I have spent a very large part of my development career firmly in the Microsoft stable. I know how to use Microsoft technolgies such as .net and I am very familiar with
Read more...
By Adrian Allan
|
|
Review of SQL Server 2000 Programming
|
SQL Server 2000 Programming claims to be a comprehensive guide to SQL Server 2000, and at a hefty 1390 pages, you can't argue with that. Being a programming guide, it concentrates only on issues that affect an SQL Server developer, but it still covers topics such as Database Administration to a reasonable level.
Read more...
By James Crowley
|
|
Database Design Guidelines and Rules of Thumb
|
Primary Keys You have three choices for defining the primary key for most tables: a 'natural' key, a system generated or 'internal' key, and (for smaller lookup tables) a mnemonic code. Internal ID numbers Rule of thumb: for any table over 100 records, use a system-generated number as the primary key.
Read more...
By Thomas B. Cox
|
|
Beginners Guide To MySQL and PHP
|
We've assembled a series of thoughts and examples based upon my own experience using Php 3.0 and MySql. Our goal is that it will aid any beginners in jumping over the common obstacles that hinder progress at the earliest stages of Php/MySql implementation.
Read more...
By W.J. Gilmore
|
|
Just SQL Part II - The Simple SELECT
|
At the core of most queries is an underlying table structure. Part II discusses how we can issue the most basic of SELECT statements to extract information from a database table.
Read more...
By James F. Koopmann
|
|
Just SQL Part I - Introduction
|
How many have you asked yourself what SQL is all about anyway? Join me as I begin a venture down the road of understanding SQL and how to take advantage of this language.
Read more...
By James F. Koopmann
|
|
Upgrade Oracle 9i RAC to Oracle 10g RAC
|
VThis article provides the procedures for converting Oracle 9i (9.2.0.4) RAC to Oracle 10g (10.2.0.1) RAC on Red Hat Enterprise Linux 3 (RHEL3).
Read more...
By Vincent Chan
|
|
The True Test of a Good DBA
|
There are a number of reasons why good DBA's tend to be among the better paid folks in a software development shop and always considered among the least expendable in a any intensive production computing environment.
Read more...
By Bill Wunder
|
|
Evaluating DBA Job Applicants in an OCP World
|
Not long ago, weeding through DBA applicants with a tech interview was a straightforward process. You'd ask candidates 200 or so technical questions. If they got 100 correct answers, you knew they'd been around the block; 150 or more and you knew you were on
Read more...
By Robert Hamel
|
|
.NET/OOP Primer for SQL Server CLR Integration
|
One of the all new pieces of SQL Server 2005 is Common Language Runtime (CLR) integration. CLR integration extends the database to improve computational performance, text manipulation, and access to system resources outside
Read more...
By Bill Wunder
|
|
The Seven Deadly Habits of a DBA
|
Calling widespread bad habits in database administration "deadly" may seem extreme. However, when you consider the critical nature of most data, and just how damaging data loss or corruption can be to a corporation, "deadly" seems pretty dead-on.
Read more...
By Paul Vallee
|
|
Building a Hybrid Data Warehouse Model
|
As suggested by this reference implementation, in some cases blending the relational and dimensional models may be the right approach to data warehouse design.
Read more...
By James Madison
|
|
Keep a check on your IDENTITY columns in SQL Server
|
The IDENTITY columns, or 'auto number' columns as some people call them, are auto incrementing columns provided by SQL Server. There can only be one IDENTITY column per table. You just have to provide a base value, and an increment value, and SQL Server will take care of incrementing this column automatically.
Read more...
By vyaskn
|
|
MDX Essentials: Set Functions: The MeasureGroupMeasures() Function
|
This article is a member of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs.
Read more...
By William Pearson
|
|
MySQL Failover Strategy using State Management, introducing MPP - Part 1
|
Having a strategy for failover has become almost standard in the
business world. Whether it is a total site failover from a NOC in one
city to another, or just a simple redundant server
Read more...
By Russell E Glaue
|
|
Reporting with the Familiar
|
Having a strategy for failover has become almost standard in the
business world. Whether it is a total site failover from a NOC in one
city to another, or just a simple redundant server
Read more...
By Mark Rittman
|
