|
Database Management & Programming News, Articles & Tutorials for Database Administrators
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.
SQL Server 2008 and 2008 R2 Integration Services - Partition Processing Data Flow Destination 01/04
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.
Setting Up Email Notification for SSIS Package Failure 12/30
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.
Report Snapshots in SSRS 2008 R2 12/28
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.
SQL Server 2008 and 2008 R2 Integration Services - Customizing Slowly Changing Dimension Transformation 12/23
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.
Physical Database Design Consideration 12/21
Greg Larsen explores different physical database design elements that should help you make the right design choice for your database.
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.
More Database News...
 |
By Chris Bennett
Published February 24, 2011
Not sure about Android Development? Take a look at this video as Chris Bennett demonstrates the Android Development tools provided with the SDK from Google.
|
 |
By Jason Gilmore
Published February 23, 2011
Learn two easy ways to begin testing your Zend Framework forms using PHPUnit and the Zend_Test component.
|
 |
By Chris Bennett
Published January 31, 2011
Start learning to develop for the Android platform today with the first episode of the Android Development 101 series. In this installment Chris Bennett demonstrates the Android environment and shows you how to create your first Android Hello World application.
|
 |
By Jason Gilmore
Published January 26, 2011
In the second installment of this two part series introducing PHP's object-oriented features, we'll explore the concept of creating class hierarchies through inheritance, class abstraction, and managing arrays of objects.
|
More Videos
Receive news via our XML/RSS feed
SQL Server performance tuning solution that provides instant performance
improvement advice based on real-time analysis of SQL Server data. Try
it now!
Free tool for data comparison and sincronization in Oracle databases.
Entity relation diagramming, automatic synchronizing between your
database design and your server, reverse engineering, custom data
editing forms and more in a single program.
|
