(Karl Moore) The Task window in VB.NET is a great way of keeping track of tasks that are related to your project. For example, if you have code issues or compile errors, VB.NET will automatically list them here.
Author: SSWUG Research
UNPIVOT, Normalization, SQL Server 2000 and SQL Server 2005
(Dennis Forbes) I’ve come across this question quite a few times. I have rows with lots of columns, and would like to split it out so that each column is a row.
Surveying Your Application Needs
(Raj Mattamal) As a product manager for Oracle Application Express (formerly Oracle HTML DB), I often want to gather feedback on workshops or training sessions I deliver. Using Oracle Application Express to quickly create surveys has proven to be so useful that I figured I’d write about it. Even tho
Advance to Go
(Howard Fosdick) Have you considered taking IBM’s advanced DBA exam? IBM certified DB2 DBAs need only pass one test (#704) to attain the highest DB2 DBA credential.
SQL Injections in PHP with MySQL
(Adam Plocher) SQL injections are a major security risk in many PHP applications. Injections are caused when a web developer allows the end-user to manipulate a variable that is being inserted into a database query string, generally through the $_GET, $_POST or $_SESSION superglobals. When a value i
Take control and make better Web sites with ASP.NET 2.0 Web parts (Sample Chapter)
(Michael A. Kittel and Geoffrey T. LeBlond) Web Parts are the new building blocks of personalization in ASP.NET 2.0. A Web part consists of an ASP.NET server or user control that takes advantage of the Web Parts control set, which is a group of structural components found in ASP.NET 2.0. (pdf)
The BindingSource component to disable Windows Forms controls associated with ReadOnly properties
(Michael Bosch) Windows Forms databinding has greatly improved in .NET 2.0. Microsoft has enhanced our object-oriented toolbox by allowing Windows Forms controls to databind to our custom objects’ properties. This new functionality is centered around the new BindingSource component. Although this co
Is AJAX the new Web?
(James Hayes) The underlying technologies behind most Web applications (such as HTML) are pretty simple and straightforward to use. This simplicity, however, comes with a certain cost. Classic HTML pages don’t maintain a connection with the Web Server (stateless) and it is therefore difficult for We
Using a SectionHandler for Painless BizTalk 2004 Configuration
(Jeffrey Juday) As a busy BizTalk 2004 developer, your product’s configuration settings are often your last considerations as you complete development. Yet, thoughtful, organized, self-documenting configuration settings are one of the “little things” that keep you in good graces with a product’s adm
SQL Server Stored Procedures
(Chris Kemp) SQL Server Stored Procedures are SQL statements saved in a database as an object. They can be called interactively through the Query Analyzer, and by other stored procedures.