(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.
Other News
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
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
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
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
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.
Reporting Space-Wasting Objects in Oracle
(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
Three ways to avoid Case Not Found errors in PL/SQL
(Bob Watkins) PL/SQL has a rich CASE functionality. The selector CASE statement lets you test the value of an expression (much as the DECODE function does), and it also lets you execute one or more statements for the first matching value. The searched CASE statement lets you test multiple expression
SQL for MySQL Developers: A Comprehensive Tutorial and Reference
(Rick F. van der Lans) The GROUP BY clause groups rows on the basis of similarities among them. For example, we could group all the rows in the PLAYERS table on the basis of the place of residence. The result would be one group of players per town. From there, we could query the number of players in
How to warm up the Analysis Services data cache using Create Cache statement?
(Eric Jacobson and Cristian Petculescu) This document describes how to build Create Cache commands. Create Cache for Analysis Services (AS) was introduced in SP2 of SQL Server 2005. It can be used to make one or more queries run faster by populating the OLAP storage engine cache first.