(Jean Georges Perrin) The first day of a conference is always fun: a keynote announcing exciting new things, the joy of retrieving old friends and discovering some new, finally putting a face on e-mailers or even some anonymous e-mail aliases.
Author: SSWUG Research
Getting rid of runaway temporary tablespace – 8 Gb reclaimed
(Lucas Jellema) Even though we keep telling ourselves that iron these days is cheap, I was having difficulties with my laptop’s hard disk. It was almost full – to the brim. I discovered a while back that my Oracle database files took up an alarming amount of diskspace, especially given the pathetica
On storing hierarchical data
(René Nyffenegger) The canonical approach to store hierachical data is to create a self referencing table…
Applied reflection: Write 80 percent less access code when interacting with a database
(Zach Smith) Database interaction is old hat to enterprise application developers. If you are a .NET developer, chances are you have used the SqlParameter, SqlCommand, and SqlConnection classes. There is also a high probability that you have noticed how monotonous and time consuming it is to use the
Master Pages Tips and Tricks
This demonstration (slides and code) provides several tips and tricks that can be used when working with ASP.NET Master Pages. Samples include referencing Master Pages from content pages, updating Master Page content dynamically, storing Master Pages in the GAC so that they can be shared across mult
Surface Area Configuration and other security tools in SQL Server 2005
(Eric Brown) SQL Server developers and administrators need to be in the know about available features once they install SQL Server 2005. This latest SQL Server version embraces an improved security model allowing finer grain control over the database server, and the database objects therein. In this
How do I… Install, configure and integrate PHP and MySQL on Windows?
(Scott Lowe) PHP and MySQL are a powerful combination when it comes to providing dynamic content to your user base. Get the step-by-step instructions for installing and configuring these products in a Microsoft Windows environment.
Managing a Heterogeneous Enterprise
(Tony Erwin) The challenge of managing a heterogeneous enterprise is one of the most daunting problems facing IT professionals today. The sheer number of resources (systems, applications, network devices, etc.) in a single environment can be quite large and ever-changing, and a typical administrator
Oracle block corruptions, DBV vs RMAN
(Paul Moen) Dear Diary, Is that a whiff of decay in the air, the pungent odour of corruption? No… not me, the database.
Building an ASP.NET 2.0 Web Part for Deployment to WSS V3.0 and MOSS 2007 – Part 2
(Gayan Peiris) The next step is to add the web part to the web part gallery. Adding the web part to the web part gallery will make the web part available in the SharePoint site when you want to use it.