(Shaun Eutsey) There are times in a developer’s life when you get to use great new tools. Recently, at a client site, I was asked to create a few web based reports that would fit into the application that I was working on. I was given my options; create them using a repeater control, Crystal Repor
Other News
SELECT COUNT(*) FROM Tab -> No Rows Selected
(Alex Fatkulin) In the following SQL*Plus output… SQL> select sum(tran_sum), count(*) 2 from trans; no rows selected …something is goofed up. You should not have a no rows selected with this SQL.
How do I enable core dumps for everybody
In most Linux Distributions core file creation is disabled by default for a normal user. However, it can be necessary to enable this feature for an application (e.g. Oracle). For example, if you encounter an ORA-7445 error in Oracle, then it must be possible to write a core file for the user «oracle
FIX: You may receive an access violation or error 942 when you drop a database in SQL Server 2005
When you drop a database in Microsoft SQL Server 2005, you may receive an access violation. Or, you may receive the following error message: Msg 942, Level 14, State 4, Line 1 Database DatabaseName cannot be opened because it is offline.
SQL Server Performance Bugbears
(Tony Davis) Whilst trying out Robyn and Phil’s excellent TSQL Newsfeed, some of the first articles that I saw was Linchi Shea’s fascinating Blog entries about the performance impact of not using owner-qualified stored procedure calls. I had no knowledge of this particular performance hit, which see
The Lure of Open Source Databases
(Alex Polishchuk and Michael Procopio) Wouldn’t it great to have a database to store all your data, not have to pay for the software licensing and get a low annual support cost per machine not per CPU, or users, or company revenue? Absolutely perfect! Better yet, such things do exist, they are calle
Get to Know Your Data
Featured Article(s) Tips for using SQL Server 2005 Snapshot Replication (Part 2) Here are some helpful tips to performance tune and optimize SQL Server 2005 Snapshot Replication. Watch Now: Using SQL Agent to Automate Tasks with SQL Server Find out how to use the SQL Server Agent to run jobs automatically on your system. From maintenance to pulling information to […]
Good Suggestions for Security
Featured Article(s) Risk Management — Prevention is better than cure [Part II] We have had a look at Risk Management in the earlier part of this series. This is the concluding part of this series of my articles on Risk Management and discusses the activities involved in the Risk Management process and the roles and responsibilities of a Risk Manager. […]
IBM Tivoli Asset Management for IT Portfolio Overview
(Bart Jacob, Nicholas Ara, Michael Beres, David Boggs, Carmen Ces and Julio Zaima) This IBM Redbooks publication provides an overview of the IBM Tivoli Asset Management for IT portfolio. The portfolio is made up of the three primary products, IBM Tivoli Asset Management for IT, IBM Tivoli License Ma
How To: Study Guide for DataStage Certification
(Vincent McBurney) This entry is a comprehensive guide to preparing for the DataStage 7.5 Certification exam.