(Bob Watkins) SQL Tuning Sets (STS) are a part of Oracle 10g’s SQL Tuning Advisor feature. Each tuning set contains one or more SQL statements, plus the context information needed to interpret them correctly. A tuning set is used as input to the SQL Tuning Advisor, which examines the statements and
Other News
Breaking the DB2 Platform Barrier
(Jim Wankowski) Are you supporting DB2 on multiple platforms? The author covers the key architectural and administrative differences between DB2 for Linux/Unix/Windows and DB2 for z/OS in this Quest white paper. (R)
Oracle debuts free Information Lifecycle Management tool
(Mark Brunelli) Oracle unveiled its new Information Lifecycle Management Assistant, a free tool for the growing number of Oracle Database users who want to do a better job of cost-effectively complying with data-retention regulations such as the Sarbanes-Oxley Act. (R)
How to Use the ListBox Control in ASP.NET 2.0
(Jayaram Krishnaswamy) Any developer who is using the Listbox control in his applications needs to be aware of how data binding has changed from VS 2003 to ADO.NET 2.0. This article will explain the changes. It appears to be an improvement over the previous techniques used.
Extending ASP.NET 2.0 Menu Control To Have Tabs With Rounded Corners
(Mike Clark) Ever get tired of the square tabs on the .Net Menu Control? I did. This article combines several cool works done by others on the web to extend the .Net 2.0 Menu control to produce rounded tabs using no images for the corners.
SQL Injection Attacks on Databases
(Mike Chapple) The vast majority of databases in use today have some form of web interface, allowing internal and/or external users easy access through familiar browser software. If you’re security-conscious, you’ve undoubtedly spent a significant amount of time setting appropriate security permissi
Maintenance Plan Changes in SQL Server 2005 SP2
(Paul Mestemaker) Users of SQL Server 2005 maintenance plans should be aware of a change in SP2 that affects existing cleanup tasks until updated using SQL Server SP2 tools.
Working with MyLittleAdmin – Management Tool for SQL Server 2005
(Bilal Haidar) When you register for a shared hosting plan you are typically provided with the IP address of the Remote SQL Server that you can connect to using your own SQL Server Studio Management tool. Sometimes your ISP might not have given you access to the port that is used to connect to a rem
SqlCredit – Part 2: Creating the Database, Tables, CRUD Procedures
(Rob Garrison) This is part 2 of a series. If you have not read part 1, you can find it here.
ASP.NET Tip: Adding Tracing to an Application
(Eric Smith) For some applications, such as console or Windows Forms applications, it’s fairly easy to step through them to debug an issue. However, tracing down errors in web applications and services can be difficult, especially if they happen only in production environments where debugging isn’t