(Steven Smith) In this article you will learn how to create a simple ASP.NET report using Web Forms, C#, and a View Model class rather than drag and drop controls, resulting in very clean and understandable HTML. Then, you’ll learn how to add Export to Excel functionality, allowing users to export t
Other News
Application Express 4.0 and Library Cache Latch Contention in Oracle DB 11.2.0.2
(Joel Kallman) In January of 2011, Oracle Support approached me about a Service Request they received from a customer. This customer had an APEX 4.0.2 application in production with more than 1,000 users. After they upgraded their Oracle database to version 11.2.0.2, the system ran fine for 2 days a
Oracle Hyperion 11.1.2.1 features and gotchas
(Eldred Smikle) After a yearlong wait, Oracle has released Oracle Hyperion Enterprise Performance Management (EPM) 11.1.2.1. This is a much friendlier release than 11.1.2, with a few new utilities and a large number of much needed bug fixes that users should find to be a refreshing change from versi
ORA-14404 / 14405 and Deferred Segment Creation
(Randolf Geist) Have a look at the following SQL*Plus output snippet:
SQL Server Management Objects 2008 (SMO) New Features
(Pravinkumar Dabade) MSDN defines SMO as – SQL Server Management Objects (SMO) is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server. In this article we will practically explore some features of SQL Server Management Objects.
Fetch random records from the table using NewID() function
(Venkatesan Prabu Jayakantham) Query: Am having 10000 records and I need some 2000 random records. How can I fetch the same? Answer:
Before scaling up Microsoft SQL Server, a few questions
(Don Jones) So, you’re looking at scaling up Microsoft SQL Server. OK, but before you set out on an upgrade, make sure you’re getting maximum value and performance from the hardware you already have and the IT infrastructure that supports it. Here’s a checklist of often-overlooked considerations:
Selecting Data Within Ranges in SQL
(Mike Chapple) The Structured Query Language (SQL) provides database users with the ability to create customized queries to extract information from databases. In an earlier article, we explored extracting information from a database using SQL SELECT queries. Let’s expand upon that discussion and ex
Sybase to DB2 Conversion Guide
(Whei-Jen Chen, Vlad Bregvadze, Kenneth Chen, Marina Greenstein, Vikram S Khatri and William Kulju) IBM DB2 for Linux, UNIX, and Windows has long been known for its technology leadership. The IBM DB2 SQL Skin feature for applications compatible with Sybase ASE (IBM DB2 SSacSA) offered in DB2 9.7 pro
Reality of Innodb Caching
(Peter Zaitsev) I have mentioned few times Innodb caches data in pages and even if you have working set consisting of relatively few rows your working set in terms of pages can be rather large. Now I came to do a little benchmark to show it in practice.