(Craig) This is a description of how to set up a secure tunnel between your MySQL Server and a locally running MySQL Administrator using Putty. By creating a secure tunnel to your MySQL server using Putty, you can grant localhost access to powerful applications like MySQL Administrator while at the
Other News
Maintain Scroll Position on Postback in ASP.NET 2.0
(Yogesh) This article shows how to allows pages to automatically maintain the current scroll position across postbacks.
The instance of SQL Server 2000 performs slowly when you use SQL Profiler to perform a client-side trace of the events in the instance
Consider the following scenario: • You have a computer that is running an instance of Microsoft SQL Server 2000. • You use SQL Profiler to perform a client-side trace of the events in the instance of SQL Server 2000. • You run SQL Profiler on the computer that is running the instance of SQL S
CPU Pressure is Huge, But Where is the Wait?
(Linchi Shea) SQL Server waits enable you to identify where SQL Server is spending a lot of time doing nothing but waiting. This allows you to quickly zoom in and focus on the problem areas that are most relevant to the root cause, and will most likely help cut down time you may otherwise waste on,
ADF BC – Fun with Bind Parameters Part Four – Choosing between various Pre-Canned Queries by leveraging the View Link bind-parameter
(Lucas Jellema) In this article on bind parameter usage in ADF Business Components, we will discuss a feature that I recently found out about and that I think offers a lot of potential. Unfortunately I do not think I quite grasp all the possibilities yet. However, since my understanding is enough to
Implementing Real-Time Language Translation Using .NET Control Adapters
(Bob Reselman) A fundamental tenet of programming is that you separate behavior that’s subject to a high degree of change from behavior that won’t change much over time. Sometimes this is easier said than done, particularly if you’re working with web applications. If you have full access to the code
Add, Edit, and Delete in DataGridView
(Jayant Kulkarni) The article, or rather a code snippet, demonstrates a simple application that inserts, updates, and deletes by using DataGridView. The application uses asynchronous architecture for most calls to database. This shows that, without hanging the UI, you can allow a user to continue wi
Master .NET’s Text Tricks
(Rod Stephens) Drawing text in Visual Basic 6 was all very simple—both the process and the results. First, you would set a form or PictureBox’s CurrentX and CurrentY properties and then call the Print method.
Data partitioning in SQL Server 2005 – Part V
(Muthusamy Anantha Kumar) In Part IV of this article series, we have seen how to partition an existing table based on certain range of dates.
Best Practices for Migrating to IBM WebSphere Portal 6
(Philip Monson, William Trotman, Dominic Glennie, Misao Ishikawa, Simon McNab, Rob Holt, Frederic Delos and Brian Cheng) IBM WebSphere Portal Version 6.0 is an enterprise portal solution for organizations that want to improve the effectiveness of their operations. WebSphere Portal is the industry’s