(Greg Hamilton) It is amazing the amount of cycles, hardware and brain ware, go into paging results efficiently. Recently Scott Mitchell authored an article titled Efficiently Paging Through Large Result Sets in SQL Server 2000 that looked at a stored procedure that returned a particular “page” of d
Other News
Domain Objects Caching Pattern for .NET
(Iqbal M. Khan) Caching greatly improves application performance because it reduces expensive trips to the database. But, if you want to use caching in your application, you must decide what to cache and where to put your caching code. The answer is simple. Cache your domain objects and put caching
Controlling Backups with Database Control
(Steve Callan) The newer version of Oracle Enterprise Manager, aka Database Control, offers an easy way to learn RMAN, Oracle’s server managed physical backup utility. The basic or Oracle recommended version of an RMAN backup is useful, but it is the custom backup which exposes more of RMAN’s capabi
Working with schemas in SQL Server 2005
(Adam Machanic) If you were to ask a group of database administrators which key personality trait they have that helps them do their jobs well, the most important and popular answer would be an excellent sense of organization. Great DBAs organize everything in the database — from the data itself to
Data Modeling Made Simple
(Carol Lehn) I have to get one thing out in the open right away – I am a Steve Hoberman fan. After hearing him speak at conferences and user group meetings, I recommended we invite him to give his Data Modeling Master Class at my company. Each time I attended one of his presentations, my expectation
Extending Visual Studio 2005
(Vijay Mehta) The Visual Studio 2005 Integrated Development Environment (IDE) has an abundance of features. These include support for all of your favorite .Net languages, out—of—the box solutions (i.e., web sites, windows forms, mobile applications, etc.), built in refactoring and code snippet suppo
CodeSnip: Using ConfigurationManager.RefreshSection method in .NET 2.0
(Steve) This application uses the System.IO.FileSystemWatcher class in .NET 2.0. This was not easy in .NET 1.0 or .NET 1.1, but only requires a couple lines of code in .NET 2.0.
You’re in V8 CM and don’t like your access path. Now what?
(Willie Favero) Good question and one that I think is of concern to almost everyone when they migrate to V8 (or any other version migration). I guess you always have the option to scream “Hey DB2 land, what’s wrong?” Of course, what would probably be a better approach would be to start checking out
How to configure a low-cost load-balanced LAMP cluster
(Keith Winston) The ubiquitous Linux, Apache, MySQL, and PHP/Perl/Python (LAMP) combination powers many interactive Web sites and projects. It’s not at all unusual for demand to exceed the capacity of a single LAMP-powered server over time. You can take load off by moving your database to a second s
From Application Express to XE
(David A. Kelly) As IT systems get larger and more complex and as business requirements multiply, developers and architects strive to keep up with their organizations’ demands. Oracle makes developers’ lives easier with its integrated technology stack, support for industry standards and open source,