(Michelle Gutzait) If you are a database administrator, you probably wish you could keep track of the badly performing commands within SQL Server instances in order to analyze them, or even send them to the development teams on a regular basis. (R)
Author: SSWUG Research
CASE function in SQL Server – part I
(Muthusamy Anantha Kumar) In SQL Server, the CASE functions evaluate a list of conditions and then return one or many results. In this article, I am going to illustrate the various uses of CASE functions in SQL server, in different places.
J2EE Applications: Maintenance and Monitoring
(Sam Alapati) In this final article of a six-part series, you will learn how to deploy, maintain, and monitor J2EE applications. You’ll also review the content of all of the parts; a self-test is included at the end.
Working with ReportViewer control Of ASP.NET 2.0
(Bipin Joshi) Reporting is one of the common requirements of any data driven business application. Since version 1.x, ASP.NET was lacking this important feature. In spite of add ons such as Crystal Report Viewer the .NET framework always lacked native support for reporting engine. Fortunately, .NET
Health Monitoring in ASP.NET 2.0: Notifications via Email
(Scott Mitchell) The Health Monitoring system in ASP.NET 2.0 is designed to monitor the health of a running ASP.NET application in a production environment. It works by recording event information to a specified log source. The .NET 2.0 Framework includes a variety of built-in events that can be use
The clones are coming, the clones are coming… with DB2 9
(Willie Favero) No, we’re not talking about Dolly the sheep. And yes, I know that isn’t all that funny, but it’s the best I can do from a hotel room with all the noise going on tonight. What I’m actually going to talk about this evening are the DB2 9 for z/OS cloned tables, a feature that will be ex
Secure Configuration Enhancements with Oracle 11g
Hello! This is Dennis MacNeil. After 10 years working with Java technology and developers, I’ve changed my focus to databases and security. Today, I am a product marketing director for database security products, including Oracle Advanced Security, Oracle Database Vault and the upcoming Oracle Au
Non-blocking checkpoints in Informix Dynamic Server
(Scott Lashley) IBM Informix Dynamic Server (IDS) uses memory (bufferpool) to cache application transaction updates (inserts/updates/deletes). This improves performance dramatically because the server does not need to flush transactions to stable storage (disk) upon commit. The updates are also logi
Develop and deploy J2EE Web services using WebSphere Application Server Community Edition
(Manu T. George) Java 2 Platform, Enterprise Edition (J2EE) 1.4 supports two types of Web service endpoints: Plain Old Java Object (POJO) and Enterprise JavaBeans (EJB) endpoints. IBM Websphere Application Server Community Edition (also referred to as Community Edition in this tutorial) is a J2EE 1.
Comparison Between VB 6.0 and VB.NET Objects Part III
(Hannes du Preez) In Comparison between VB6 and .NET Objects Part I and Part II, I covered the differences in the Properties Windows and in the Toolboxes respectively. With this article, I will concentrate on the differences in the Visual Basic 6 Project Explorer and the Visual Basic.NET Solution Ex