Creating an automated SQL query that will retrieve timely data and transmit that information to a person who can act upon it is a basic task for many SQL Server database administrators. However, the process for developing that automated query is not always as obvious as you might expect. This downlo
Other News
Enterprise Data Management with SQL (Sample Chapter)
(Eric L. Brown) In the beta history of the SQL Server 2005 release, significant emphasis has been put on the new features for developing applications. Let’s just say that Microsoft loves developers. But what happened to the features for those who get paged in the middle of the night when mission-cri
Lower Costs, Support Compliance and Drive Revenue by Automating Business Information Delivery
To stay competitive and compliant, organizations need to deliver information generated in business applications more quickly, improve internal workflow and ensure document security–all while reducing costs and providing superior products and services. (R)
Facilitating Information Sharing Using Meta-Data
(Patrick Cross and Booz Allen Hamilton) Information sharing has consistently been a significant problem across government and industry. Once IT portfolios grew beyond a few simple applications the need to share and integrate information across those applications has grown along with the increase in
A DBA’s view on SQL 2005 Database Snapshots
(Andrew Calvett) Database Snapshots are a new Enterprise Edition-only tool, introduced in SQL 2005, that provide a read-only, “virtual” copy of a database, at a given point in time. This article will discuss how, as a DBA, you might use snapshots in a production environment and why you might not con
IBM DB2 Content Manager for iSeries, Part 6: Customize eClient
(Jack Boswell) The eClient is a Web application that enables users to search for and retrieve documents from content servers. Learn to customize your eClient application to meet the needs of your organization. (pdf)
ISV success with DB2 Viper
(Louisa Ford) DB2 Viper has been designed to permit ISVs to focus more on application development and less on database configuration and administration. The new and enhanced development tools will make it even easier for developers to rapidly develop and deploy database applications, and the signifi
Staying Power, Part 2
(Robert Catterall) In my previous column, I covered DB2 high availability in terms of dealing with “localized” failure events: situations that can be disruptive but don’t incapacitate an entire data center, such as server or disk subsystem failure or the abnormal termination of an operating system o
Linux to be top Oracle platform within a year
Linux is likely to supplant Solaris as the dominant platform for Oracle Corp’s databases within the next year, according to a survey commissioned by the International Oracle Users Group (IOUG).
Stored procedures? A good practice :)
(Gevik Babakhani) As a developer I often come across SQL statements that are hardwired into the source code regardless of the programming language they are used in. It makes the code messy and unreadable when sometimes seeing large SQL statements chopped and concatenated in several string constants.