(John Kilgo) I recently completed a small custom content management system for a client to facilitate frequent editing of a 1,200 page manual. The manual is viewable on a large intranet and the client wanted a specific type of search mechanism for employee use. Since regular expressions and I don’t
Author: SSWUG Research
Store View State in a Persistent Medium, the Proper Way
(Bilal Haidar) In his article, Understanding ASP.NET View State, Scott presented a section about storing the ASP.NET view state into a persistent medium, instead of storing it in the page itself. He used the system file system, mainly a simple text file to store the page’s view state. However, Sco
Using XML features in MS Word for content migration
(Apoorv) I’d talked about content migration in the ECM Offshoring piece recently. The content people often use Microsoft word to create unstructured content and then publish this content to their existing system. This changes after we finish implementing a new CMS for them as the content that is ent
Upgrade Your Performance, Serviceability, and Communication Services with the Latest WebSphere Application Server
(Rikki Kirzner) In a March, 2006 survey on WebSphere.org, over 80 percent of users polled* indicated they were still running older versions of WebSphere Application Server in their company. Whether or not you are among the majority of those who responded that they plan to upgrade to WebSphere Applic
Implementing Parent-Child ComboBoxes in VB.NET
(Yildirim Kocdag) Parent-Child ComboBoxes is one of the classical problems for almost all projects. As a brief of this problem is, –There are two combos, –One of them is parent and another is child combo. –After the parent one is fired(selected value changed), child combo should be taken
SQL Question: Pivots, Analytics and the judicious use of Row_Number()
(Lewis R Cunningham) A few days ago I answered a question from brat about converting 1 field into multiple rows. We solved that question but now we want to handle multiple rows in our source table.
Diagnosing SQL Server performance issues using sp_lock
(Tim Chapman) A common misconception among IT pros is that “locks are bad,” and you must do everything possible to ensure database locking doesn’t prevent processes from running. In order to ensure a consistent database environment, the database engine must use a mechanism to acquire exclusive use o
Membership, Roles and Profile – An Example (Part 2)
(Bipin Joshi) In Part 1 we learnt about customizing the CreateUserWizard control, adding the newly registered user to a default role and storing data in Profile properties. Going further this article will explain how to develop an administrative page that manages User-Role mapping. We will also disc
Roll Your Own SQL Server 2005 Database Diagrams
(John Paul Cook) Database diagrams are indispensable tools for understanding the structure of a complex database. SQL Server 2000 and SQL Server 2005 provide useful yet rudimentary diagrams that show only the relationships between tables. Some third-party diagramming solutions go beyond table relati
A Database Journal Guide to MySQL 5 Certification
(Ian Gilfillan) Last year I wrote a two-part series entitled the Database Journal Guide to MySQL certification. Part one covered the core certification, and part two the professional certification. Those two articles covered the MySQL 4 certification. Although it is still possible to achieve MySQL 4