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.

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.

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.

Version 1.6.3 of this database design and round-trip engineering software has been released.

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.

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.

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.

Archive log destinations can be tricky when defining or viewing in Oracle Database. Stick to a few common rules and never get lost.

Partnership Extends Best-In-Class Enterprise Mobility Platform Addressing Management, Security, Back-End Integration and Application Deployment Challenges

This document describes a technique that can be used to display dates as the measure values in a crosstab.

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.

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.

PhotoFace software sniffs out identity by the shape of a nose

SAP Extends Reach of SAP® Business Suite Applications, Including SAP® CRM, to iPhone, Windows Mobile and Other Mobile Device Users

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.

This document will provide guidelines to using Calculation Accounts.

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.

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.

This document will provide guidelines on architecture and server sizing for IBM Cognos Controller 8.5.

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.