|
Database Management & Programming News, Articles & Tutorials for Database Administrators
SQL Server 2008 and 2008 R2 Integration Services - Sampling Transformations 01/20
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.
Report Subscription in SSRS 2008 R2 01/18
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.
SQL Server 2008 and 2008 R2 Integration Services - Dimension Processing Data Flow Destination 01/13
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.
Archiving Oracle Databases 01/11
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.
Understanding SSRS Report Definition Language (RDL) 01/09
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.
The Format() Function in SQL Server 2012 01/06
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.
Couchbase Moving Forward In 2012 01/20
NoSQL startup is gearing up for a major new database release.
Can you Make Money with a Cloud Database as a Service? 12/19
Xeround has raised millions for its database app technology as demand for cloud services ramps up.
Salesforce Heroku Offers Standalone Cloud-Based PostgreSQL Database 11/28
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.
MongoDB - Why Does NoSQL Matter? 11/07
NoSQL isn't a fad, it's delivering real business value today.
Neo Launches NoSQL Graph Database 10/25
New type of 'graph' based NoSQL database debuts with tight integration for Spring-based development.
Microsoft 'Denali' Set for 2012 Delivery 10/12
At Microsoft's premier event for SQL Server developers, the company renames "Denali" and gives glimpses of its future.
Oracle Goes Big for NoSQL 10/04
Oracle explains what 'big data' is all about and delivers new Hadoop, R and NoSQL database hardware and software.
Oracle Debuts New Database Appliance for the Midmarket 09/21
Oracle's engineered system effort goes down market with small box designed for ease of use.
PostgreSQL 9.1 Advances Open Source Database Innovation 09/13
After 6 months in beta, PostgreSQL 9.1 is now officially available.
Oracle Expands MySQL for Windows 09/07
MySQL isn't just for the LAMP stack anymore.
More Database News...
Receive news via our XML/RSS feed
|
