(Constantine Plotnikov, Artem Papkov and Jim Smith) Web 2.0 applications developed using standard Java Platform, Enterprise Edition 5 (Java EE)-based approaches face serious performance and scalability problems. The reason is that many principles that underlie the Java EE platform’s design — especia
Other News
How Oracle Really works (27) – Recursive Calls
(Donnie ‘Dean’ Reynolds) Before I get to the next part on the CBO, I wanted to address a reader’s question about recursive calls.
Custom Http Handlers in ASP.NET
(sandeep) The concept of ASP.NET custom HTTP Handlers is not new, but is a bit overlooked one. Performance-wise, using ASP.NET custom HTTP Handler is an excellent choice over ASP.NET web forms when you don’t need the huge overhead of ViewStates, Page life cycle events and support for postback stuff
Gain Design-Time Power with Control Editors, Part 2 of 2
(Rod Stephens) The first part of this article provided a detailed description of a StateSelector control that lets users select a state from a map. The map itself is a control property named Map. In the Visual Studio Properties window, the article showed how to use a type converter to display a spec
A Visual Basic Developer Is a Terrible Thing to Waste
(William R. Vaughn) I spoke at the local .NET User Group a couple of weeks ago and saw some strangers in the audience. I asked them to introduce themselves and they said they were there recruiting for a consulting company that was doing some work for Microsoft. I asked them to highlight the qualific
Creating Custom Reports for SSMS
(Greg Larsen) With the release of SQL Server 2005 SP2, Microsoft added a new feature to SQL Server called “Custom Reports”. ). These RDL files are rendered as tabbed documents within SSMS. Reporting Services reports are rendered without even having Reporting Services installed. This new feature allo
Handle conditional data and data conversion using SQL Server 2005 Integration Services
(Tim Chapman) Converting data and splitting data are at the core of almost any type of data application. This tutorial presents an example that details how to perform data conversion and conditional data splitting using SQL Server 2005 Integration Services (SSIS).
OPTIMIZE FOR query hint in SQL Server 2005
In this post, we will discuss a new query hint that was introduced in SQL Server 2005 which is called the “OPTIMIZE FOR” query hint. This is another way to address the parameter sniffing problem in SQL Server. This option ties in with the usage of the plan guides or can be used independently to alte
DB2 DBA: Ultra Availability
(Robert Catterall) When it comes to DB2, I’ve often wondered just how far you can you take application availability (see my 2004 column “Taking High Availability Higher”). What’s the ultimate in terms of uptime and data loss protection?
Webcasts, Webcasts, Webcasts
Latest Shows to Watch Watch: SQLonCall: How to Hire a DBA – Part 3/3 – The Interview. Questions to ask, answers to look for, interpreting the responses, making the decision. Watch: SelectViews – Replication, Part-Time DBAs, 60-Second Tip of the Day Watch: SQLonCall: How to Hire a DBA – Part 2/3 – How to review resumes, what to look for, […]