When you run the sp_databases stored procedure in Microsoft SQL Server 2000, you may receive the following error message: Msg 8115, Level 16, State 2, Procedure sp_databases, Line 31 Arithmetic overflow error converting expression to data type int
Other News
Understanding Data Growth and Best Methodologies for SQL Optimization with Toad for Oracle Xpert
(Bryan Huddleston) If your shop has not experienced data growth in the last two-10 years, you are in the minority. The explosion of the information age has increased the amount of data we send, receive, process and use. Whether it’s customer or employee information, portals, dashboards or even perso
New Directions For OLAP
(Seth Grimes) The online analytical processing tool arena is now in its second decade, and the focus of business intelligence innovation has shifted to dashboard displays, applications such as performance management, and operationally embedded analytics. That’s a hallmark of the acceptance of multid
ROME in a Day: Parse and Publish Feeds in Java
(Mark Woodman) Ready to parse and publish RSS and Atom feeds in Java? In this step-by-step tutorial, we’ll show you how to pull in an existing feed, add your own content, and publish the results in a new format, all in 100 lines of code. (200 lines with whitespace and comments.)
Database Programming in Python: Accessing MySQL
(A.P.Rajshekhar) While data storage for applications is no longer considered complex, it is now simplified to the point that flexibility is sacrificed. There is a good compromise, however. In this article, you will learn how to access a a MySQL database with Python.
Data Binding in Windows Forms 2.0
(Wei-Meng Lee) There’s a lot of new ground to cover about data binding in Windows Forms 2.0, so it’s best to just jump right in. This article assumes you have SQL Server 2005 Express Edition (download here) installed on your computer. I will also use the pubs sample database familiar to most SQL Ser
First impressions of Oracle SQL Developer (formerly Raptor)
(edmon) Boastful ones call it a TOAD killer. Humbler ones call it a new, more able SQLPlus.
Surviving Common DB2 Per Performance Problems
(Craig S. Mullins) In today’s modern enterprise, information is power; and database systems are the predominant technology for storing, managing, and accessing the data that enterprises use to turn into information. And DB2 is one of the leading database systems on the market. (pdf)
Service-Oriented Data Integration Architecture
(Soumendra Mohanty) Information management, which includes both data and content management, is an essential building block for service-oriented architectures (SOAs). Information management provides a means to represent, access, maintain, manage, analyze and integrate data and content across heterog
Displaying RSS feeds in ASP.NET
(Sumit Thomas) The XML control is one of the least used controls in ASP.NET. To be honest I haven’t used it much myself. I combined my little knowledge in XSL with the XML control to create a simple RSS reader.