database
News
SQL Server 2012 Integration Services - OverviewMarcin Policht presents a high-level overview of SQL Server 2012 Integration Services, covering some significant advances in the areas of usability, productivity, and manageability.
Database Journal | 03-Feb-2012 09:01
DB2 z/OS Systems Tuning Tactics
In the z/OS
environment, tuning a DB2 subsystem may require the DBA and systems programmers
to wear multiple hats and approach overall performance tuning from several
different angles. What approaches are best in which situations?
Database Journal | 01-Feb-2012 09:01
Usage and Benefits of Using WITH RESULT SETS In SQL Server 2012
Having stored procedures returning result sets can become a problem when you want to have control of the name and data type of the columns being returned. Arshad Ali explains a new SQL Server 2012 feature, which lets you redefine the name and data types of the columns being returned from the stored procedure.
Database Journal | 30-Jan-2012 09:01
Managing Data Growth with Enterprise-class Databases
Compliance isn’t the only reason to retain large data sets; better historical business reference and real-time analysis, all require access to large volumes of data to gain better business insights. Read on to learn more.
Database Journal | 27-Jan-2012 09:01
SQL Server 2008 and 2008 R2 Integration Services - Sort Transformation
SQL Server 2008 R2 Integration Services offer a wide range of pre-built components, which deliver generic functionality commonly required when performing ETL tasks. While most of them are fairly straightforward to deploy in their basic form, there are caveats that should be taken into account as part of their implementation. Read on to learn more.
Database Journal | 25-Jan-2012 09:01
Data Driven Subscription in SSRS 2008 R2
Learn how to acquire data or parameter values required during the execution of a report from a database query, using Data-Driven Subscription in SQL Server Reporting Services (SSRS).
Database Journal | 23-Jan-2012 09:01
Couchbase Moving Forward In 2012
NoSQL startup is gearing up for a major new database release.
Database Journal | 20-Jan-2012 23:18
SQL Server 2008 and 2008 R2 Integration Services - Sampling Transformations
Row Sampling Transformation and Percentage Sampling Transformation, which provide data sampling functionality, are useful in a number of Analysis Services and Data Mining-based scenarios. Marcin Policht demonstrates the functionality of both transformations.
Database Journal | 20-Jan-2012 09:01
Report Subscription in SSRS 2008 R2
SSRS allows you to create two types of subscriptions, e.g., Standard Subscription and Data Driven Subscription. This article discusses the standard subscription in which you need to specify the parameters the report expects at the time of subscription creation and which cannot be changed at runtime.
Database Journal | 18-Jan-2012 09:01
SQL Server 2008 and 2008 R2 Integration Services - Dimension Processing Data Flow Destination
The SSIS component, Partition Processing Data Flow Destination, is capable of performing direct data load from a fact table into an arbitrarily chosen partition of a measure within an Analysis Services cube. In this article Marcin Policht examines its counterpart known as Dimension Processing Data Flow Destination, which provides equivalent functionality in regard to dimensions.
Database Journal | 13-Jan-2012 09:01
Archiving Oracle
Archiving older data is a complex task. Within the context of an Oracle database there are methods of archiving data, some simple, some a bit more complex but still within the realm of possibility. Let's look at those options and what they can, and cannot, offer.
Database Journal | 11-Jan-2012 09:01
Understanding SSRS Report Definition Language (RDL)
SSRS reports are defined in Report Definition Language (RDL), which is nothing but Extensible Markup Language (XML) adhering to a defined report definition language schema. This article examines RDL and some of the elements that you will notice in your report's RDL.
Database Journal | 09-Jan-2012 09:01
The Format() Function in SQL Server 2012
The only formatting capabilities that SQL Server has had until now were the CAST and CONVERT function, forcing developers to write user defined functions using native string functions/date functions or CLR. The long wait for this format function is over; SQL Server 2012 RC0 is leveraging the .NET format capabilities by introducing the FORMAT() function.
Database Journal | 06-Jan-2012 09:01
SQL Server 2008 and 2008 R2 Integration Services - Partition Processing Data Flow Destination
The primary purpose of Integration Services technology is to deliver ETL functionality that supports core features of SQL Server database management systems. However, many times its role involves interaction with components that provide Business Intelligence-related features. This article discusses one such scenario, which leverages built-in SSIS Partition Processing Data Flow Destination in order to facilitate Analysis Services processing.
Database Journal | 04-Jan-2012 09:01
Setting Up Email Notification for SSIS Package Failure
Learn how to enable the logging functionality for SQL Server Integration Services (SSIS) and how to capture detailed information for immediate troubleshooting without re-running the package.
Database Journal | 30-Dec-2011 09:01
Report Snapshots in SSRS 2008 R2
Arshad Ali explores the report snapshot feature in SQL Server Reporting Services (SSRS). Learn how to show data at a point of time or how you can subscribe to your published reports.
Database Journal | 28-Dec-2011 09:01
SQL Server 2008 and 2008 R2 Integration Services - Customizing Slowly Changing Dimension Transformation
While SQL Server 2008 R2 Integration Services' Changing Attribute and Historical Attribute options facilitate a variety of different data analysis scenarios, its wizard-driven configuration is relatively inflexible and generates a Data Flow structure whose performance tends to be suboptimal. This article presents a few methods of remediating these shortcomings.
Database Journal | 23-Dec-2011 09:01
Physical Database Design Consideration
Greg Larsen explores different physical database design elements that should help you make the right design choice for your database.
Database Journal | 21-Dec-2011 09:01
Can you Make Money with a Cloud Database as a Service?
Xeround has raised millions for its database app technology as demand for cloud services ramps up.
Database Journal | 20-Dec-2011 00:45
Operational Scalability and Security with Sybase Adaptive Server Enterprise
Robert Schneider defines the elements that comprise operational scalability, and then provide concrete examples of how Sybase Adaptive Server Enterprise (ASE) augments operational scalability via minimizing downtime, sustaining heavy workloads, and supplying enterprise-grade security.
Database Journal | 19-Dec-2011 09:01
Report Caching in SQL Server Reporting Services 2008 R2
To improve the performance of report processing, SQL Server Reporting Services (SSRS) lets you enable caching for the report so that if the same report request comes again, the stored copy can be rendered in the desired format and served instead of processing it from scratch. This article explores this caching feature in detail.
Database Journal | 16-Dec-2011 09:01
SQL Server 2008 and 2008 R2 Integration Services - Slowly Changing Dimension Transformation - Historical Attributes
Recently we described the characteristics of Slowly Changing Dimension methodology, focusing in particular on its implementation in SQL Server 2008 R2 Integration Services. Its wizard-driven transformation does not offer full support for all existing change types. We continue our coverage of this subject by presenting an equivalent setup that eliminates this shortcoming.
Database Journal | 14-Dec-2011 15:00
New Date,Logical Functions in SQL Server 2012
With the official release of SQL Server 2012 RC0, Microsoft has added more features and enhancements to Transaction SQL. This article illustrate some of the new the DATE and LOGICAL functions introduced in SQL Server 2012.
Database Journal | 12-Dec-2011 15:00
Patching a Newly Added Node for an Existing SQL 2005 Clustered Instance
Learn how to apply a service pack and hotfix to a newly added SQL Server 2005 clustered node.
Database Journal | 09-Dec-2011 14:00
Creating and using Report Parts in Report Builder 3.0
Arshad Ali shows you how to create and publish a report part in SQL Server 2008 R2 using Report Builder 3.0.
Database Journal | 07-Dec-2011 15:00
SQL Server 2008 and 2008 R2 Integration Services - Slowly Changing Dimension Transformation - Type 1 Changes
An introductory article into the subject of Slowly Changing Dimension from the perspective of SQL Server 2008 R2 Integration Services.
Database Journal | 05-Dec-2011 16:00
Oracle 11gR2 I/O Performance Tuning: Using Solid State Drives
Solid-state drives (SSDs) can make an incredible difference when applied judiciously to an apparently intractable I/O performance bottleneck.
Database Journal | 02-Dec-2011 17:39
Salesforce Heroku Offers Standalone Cloud-Based PostgreSQL Database
Since 2007, Heroku has offered database-as-a-service to its platform-as-a-service customers for use with Heroku platform applications. Now the company is extending the service for use with any cloud platform.
Database Journal | 28-Nov-2011 20:43
Achieving Five Nines Availability Using Synchronous Cluster Replication for MySQL
SchoonerSQL can help you achieve five nines availability for your MySQL database.
Database Journal | 23-Nov-2011 21:57
Thoughts on Improving DBA Productivity
Lockwood Lyon offers ideas for how database administrators can react less, think more and find lasting solutions.
Database Journal | 18-Nov-2011 23:57
Sybase ASE Application Development and Big Data
Sybase ASE can now work with unstructured data and very large data volumes.
Database Journal | 15-Nov-2011 13:59
Data Mining Model Training Destination in SQL Server Integration Services
How to incorporate data mining directly into the Data Flow of SQL Server 2008 R2 Integration Services-based packages.
Database Journal | 10-Nov-2011 21:29
MongoDB - Why Does NoSQL Matter?
NoSQL isn't a fad, it's delivering real business value today.
Database Journal | 08-Nov-2011 00:31
Using Autoextend to Increase Oracle Database File Sizes
Autoextend can save DBAs precious time by allowing Oracle to automatically increase database file sizes to a pre-determined limit.
Database Journal | 04-Nov-2011 21:59
Finding the Source of Your SQL Server Database I/O
There are a number of ways of measuring and identifying I/O-related performance information for your SQL Server database instances.
Database Journal | 01-Nov-2011 01:59
Database Buyer's Guide Conclusion: Which Database Is Best for You?
Desktop databases, server databases, the Cloud or open source – which route is the right one for your organization?
Database Journal | 27-Oct-2011 12:57
Neo Launches NoSQL Graph Database
New type of 'graph' based NoSQL database debuts with tight integration for Spring-based development.
Database Journal | 25-Oct-2011 23:29
Why You'll Want to Upgrade to Sybase ASE 15.7
Sybase ASE 15.7 has a bunch of new features you may want to consider, including improved performance, scalability and security.
Database Journal | 21-Oct-2011 21:29
Getting Started with SQL Server Report Builder 3.0
SQL Server offers a simple tool for business users to perform ad-hoc reporting.
Database Journal | 18-Oct-2011 22:59
Data Mining Query Transformation in SQL Server Integration Services
We look at another way to execute Data Mining Extension (DMX) queries against data mining models in SSIS.
Database Journal | 15-Oct-2011 00:59
Microsoft 'Denali' Set for 2012 Delivery
At Microsoft's premier event for SQL Server developers, the company renames "Denali" and gives glimpses of its future.
Database Journal | 12-Oct-2011 19:59
Cloud Database Buying Guide
Cloud databases can save you time and money, but use them carefully.
Database Journal | 11-Oct-2011 12:58
Color Coding Your SQL Server Connections
Here's an easy way to keep track of your SQL Server instances.
Database Journal | 07-Oct-2011 23:27
An Easy Way to Monitor SQL Server Replication
SQL Server replication is important for keeping data consistent. Here's how to make sure it's working properly.
Database Journal | 05-Oct-2011 21:29
Oracle Goes Big for NoSQL
Oracle explains what 'big data' is all about and delivers new Hadoop, R and NoSQL database hardware and software.
Database Journal | 04-Oct-2011 20:59
Getting Started with Utility Control Point in SQL Server 2008 R2
Utility Control Point can help SQL Server DBAs in multi-server administration.
Database Journal | 28-Sep-2011 23:57