(Marc Billette) I chose to talk about a technique I used at a client’s site to report the topmost space-wasting objects in an Oracle database. I was looking for a way to detect these objects without having to run some expensive analyze statements or dbms_stats jobs. I found out that I can use the db
Author: SSWUG Research
Back to basics: anti-joins and semi-joins
(Eddie Awad) I almost forgot that the Oracle Joins series is not complete yet. So here is the last episode, a quick and easy anti-join and semi-join refresher.
Why use ‘Included’ columns in SQL Server 2005
(Roman Rehak) Recently I was working on an application where I got a lot of mileage out of using a new feature of SQL Server 2005 called included columns. When you add a column as an “included” column, it gets stored at the leaf level of the index and it is not part of the index key. This only works
IBM Application Development and Problem Determination Tools V7 for System z (APA, DT, FA, FE, FM, WS)
(Joe DeCarlo, Amintore de Nardis, Mark Duckworth, Jennifer Nelson and Adrian Simcock) This comprehensive suite of powerful yet easy-to-use tools helps developers efficiently build, test, and service applications while minimizing errors and increasing cost-effectiveness. The tools allow users to quic
SQL Server 2005 Deployment Guidance for Web Hosting Environments
(Alex DeNeui) SQL Server 2005 is an ideal database platform for use in shared and dedicated Web hosting environments. This paper provides best practices for configuring SQL Server 2005 to optimize security, tenant isolation, and the performance of your hosted SQL Server 2005 deployment. Sample scrip
Using the Policy Injection Application Block in ASP.NET
(Alex Homer) One technique becoming increasingly popular with developers is the adoption of an Aspect-Oriented Programming (AOP) model. AOP provides techniques for changing the behavior of business objects and other classes through the application of policies, making it easier to implement common cr
How to Construct a Reusable Silverlight ASP.NET User Control
(Chad A. Campbell) Silverlight opens the door for exciting new ways to provide more productive, engaging, and innovative experiences across multiple platforms. Excitingly, developers are able to leverage existing development skills to create these experiences.
Ruby on Rails is hot … learn how to exploit it with DB2
(Leon Katsnelson) Ruby on Rails continues its meteoric rise in popularity. From virtually unknown just two years ago, Ruby has become the language to learn. According to April statistics on TIOBE.com Ruby is not only staying on the top ten programming languages list after getting there earlier this
Showing Tooltips for GridView Items using ASP.NET AJAX
(Bipin Joshi) ASP.NET AJAX has opened several possibilities to make your web applications richer and more user responsive. In this article I will show you how to develop a popup tooltip for items in data bound controls such as GridView with the help of ASP.NET AJAX.
Windows Communication Foundation’s hosting environment
(John Charles Olamendy) Windows Communication Foundation (WCF) applications need to have a runtime environment for the management of its object’s lifecycle. The host process models allows is a new concept in WCF referring to WCF hosting environment which can have several services, and the same servi