Skip to content

Database

SQL Server - Introduction to Business Intelligence Development Studio

Database Journal News - Mon, 03/08/2010 - 06:00
In his latest article, Marcin Policht demonstrates a variety of tools that can be employed to execute SQL Server Integration Services packages, focusing in particular on the method leveraging functionality available within the Business Intelligence Development Studio.
Categories: Database

MySQL migration and risk management - Database expert Ronald Bradford on the pros and cons of migrating from Oracle to MySQL

O'Reilly News: MySQL - Fri, 03/05/2010 - 15:00
Ronald Bradford has been guiding DBAs through key aspects of database integration for years. In this Q&A, he discusses the pros and cons of migrating from Oracle to MySQL (hint: it's not just about cost savings). He also weighs in on how Oracle's acquisition of Sun will shape the future of MySQL and its community.
Categories: Database

SQL Server Indexed Views

Database Journal News - Fri, 03/05/2010 - 06:00
Views can be an effective tool for speeding up your selects and simplifying complex queries. Learn what indexed views are, where you might want to use them, how to create them, and what constraints exist with their use.
Categories: Database

DbWrench Database Design & Synchronization v1.6.3

PostgreSQL News - Fri, 03/05/2010 - 01:00
Version 1.6.3 of this database design and round-trip engineering software has been released.
Categories: Database, Open Source

Use DB2 pureXML to implement a healthcare industry data solution

IBM - DB2 and Informix Articles - Thu, 03/04/2010 - 06:00
Interoperability and standards are the latest buzzwords in the healthcare industry today. Use of standards is key to giving hospitals and doctors the capability to interoperate to share patient records better. IBM Research has been investigating the healthcare industry's evolution of standards, including the IHE and HL7 standards. This article offers a brief introduction to these standards and protocols, and it offers a scenario of an IBM DB2(R) pureXML(R) solution that follows the IHE QED protocol.
Categories: Database

Understanding IBM FileNet Content Manager storage management

IBM - DB2 and Informix Articles - Thu, 03/04/2010 - 06:00
This article discusses the storage mechanisms of IBM FileNet Content Manager and describes how to effectively use storage areas and storage policies with IBM FileNet P8 applications. It also discusses storage farming strategies to distribute I/O load and to provide for continuous storage availability. Finally, it discusses storage area state transitions and what to do when a storage area reaches its size limit.
Categories: Database

IBM Cognos 8 Go! Dashboard 8.4.1 Companion Guide

IBM - DB2 and Informix Articles - Thu, 03/04/2010 - 06:00
This document will help assist any installation issues that might occur while installing, configuring andusing IBM Cognos 8 Go! Dashboard FP1 or IBM Cognos 8 Go! Dashboard FP2.
Categories: Database

Oracle Database Archive Logging -- Where are my archive logs?

Database Journal News - Thu, 03/04/2010 - 06:00
Archive log destinations can be tricky when defining or viewing in Oracle Database. Stick to a few common rules and never get lost.
Categories: Database

Sybase and Orange Business Services Partner to Provide Mobile Device Management Services for Enterprises Worldwide

Sybase:Press - Company Announcements - Wed, 03/03/2010 - 09:00
Partnership Extends Best-In-Class Enterprise Mobility Platform Addressing Management, Security, Back-End Integration and Application Deployment Challenges
Categories: Database, Vendor

Displaying Dates in Crosstabs within IBM Cognos 8 Report Studio

IBM - DB2 and Informix Articles - Wed, 03/03/2010 - 06:00
This document describes a technique that can be used to display dates as the measure values in a crosstab.
Categories: Database

SQL Server 2008 : Accessing Audit Details

Database Journal News - Wed, 03/03/2010 - 06:00
Learn how to use the SQL Server 2008 catalog view and dynamic management view to access the audit details of existing server and database level audits.
Categories: Database

Do You Know Your Data? Test Yourself with the SQL Server Sequence

In anticipation of our upcoming R2 launch, we’re holding a contest to test your knowledge of SQL Server and give away some great prizes in the process. For the next 12 weeks, we’ll be issuing a new question per week on one of our three social networks: Facebook, Twitter, and YouTube

Answer a question correctly and you’ll be placed into a drawing to win a brand new netbook. (If you get stuck on any of the questions, check out the SQL Server website to jog your memory.) There’s a new chance to win each week, and the more questions you answer correctly, the better your chances will be to win the grand prize – a Suped-up Set-up for your workspace from SQL Server. The grand prize includes a wireless keyboard and mouse, 24-inch HD monitor, speakers and noise canceling headphones all valued at over $1000. 

Become a fan of the SQL Server on your favorite social network to find out the location of each week’s question. Come back to the SQL Server blog for the answers to each week’s question, as well as updates on winners and prizes. 

Between taking your best guess and finding out if you’re a winner, be sure to visit the SQL Server website to download SQL Server 2008 R2 CTP and find out more about the upcoming release. You can also drop by the Facebook page and let us know your experience with SQL Server.

This week’s question: What are the four new types of data visualization provided in SQL Server 2008 R2 Reporting Services?

Tweet your answer @MS_SQL_Server before Monday, 3/8/2010 at 11:59 pm PT. Stay tuned for more questions and be sure to check out the official rules.

Categories: Database

Nose Scanning Biometric Software

Dr.Dobb's DataBase Articles - Tue, 03/02/2010 - 19:56
PhotoFace software sniffs out identity by the shape of a nose
Categories: Database

SAP and Sybase Deliver First Set of Applications to Millions of Mobile Workers Worldwide

Sybase:Press - Company Announcements - Tue, 03/02/2010 - 09:00
SAP Extends Reach of SAP® Business Suite Applications, Including SAP® CRM, to iPhone, Windows Mobile and Other Mobile Device Users
Categories: Database, Vendor

In_Range Filters and Character Fields

IBM - DB2 and Informix Articles - Tue, 03/02/2010 - 06:00
This document details an optional setting which may be used to have a report return data within a range regardless if the From value is greater than the To.
Categories: Database

Guidelines to using Calculation Accounts for IBM Cognos Controller

IBM - DB2 and Informix Articles - Tue, 03/02/2010 - 06:00
This document will provide guidelines to using Calculation Accounts.
Categories: Database

Auto-Size Select and Search Prompt within IBM Cognos 8 Report Studio

IBM - DB2 and Informix Articles - Tue, 03/02/2010 - 06:00
This document details an optional switch which may be used to make the display areas dynamically re-size to meet the demands of the wider data.
Categories: Database

Using the Sybase ASE Resource Governor

Database Journal News - Tue, 03/02/2010 - 06:00
The Sybase ASE Resource Governor provides you with a mechanism to limit the resources a given process may request or acquire. If you have very heavy resource drains, it may be that adding this tiny bit of overhead can reduce whatever is currently stressing your system.
Categories: Database

Architecture and Server Sizing for IBM Cognos Controller 8.5

IBM - DB2 and Informix Articles - Mon, 03/01/2010 - 06:00
This document will provide guidelines on architecture and server sizing for IBM Cognos Controller 8.5.
Categories: Database

Understanding IBM Cognos 8 PowerPlay Performance

IBM - DB2 and Informix Articles - Mon, 03/01/2010 - 06:00
This document is intended to provide IBM Cognos Series 7 PowerPlay administrators an overview of the tuning mechanisms in place for IBM Cognos 8 PowerPlay.
Categories: Database