Are you experiencing current performance bottlenecks? Designing a new application and want to know how best to structure your schema and index strategy for optimal performance? Interested in how to transform your SQL into faster, more efficient queries? Then this free web presentation is for you! Yo
Author: SSWUG Research
Multithreading in .NET: Your Friend the BackgroundWorker
(Peter Aitken) This is the second of two articles on writing multithreaded applications using the .Net Framework. The first article, which you can find here, covered the managed thread pool. This article deals with the BackgroundWorker class.
XML and Related Technologies certification prep, Part 4: XML transformations
(Brian L Brinker) When an application needs to share data with another system, it is often necessary to transform an XML document into another XML format, governed by a differing XML Schema or Document Type Definition (DTD). When the app is required to share or display XML data to a user, the XML do
Controlling Online Forms with Builder Objects in PHP 5
(Alejandro Gervasio) Mastering some of the most popular design patterns with PHP 5 can be sometimes an overwhelming process that requires hard work and experience. However, if you want to tackle the challenge and expand your existing background on them, this article might eventually find a place on
Multithreading with an Example of .NET Application
(Sandeep Acharya) Threads are also known as lightweight processes. However, if we go into depth then we would know that a thread is not actually a process; rather it provides ways for executing different parts of a program. Now let us discuss what it actually means by multithreading. Multithreadi
Creating Backup Jobs in SQL Server 2005
(Serhiy Snisarenko) The SQL Server 2005 Maintenance Plan feature has been significantly modified in comparison with SQL 2000: now it utilizes new Integration Services. Also, creating database and transaction log backups is not as clear as it was in SQL 2000. This article does not describe all availa
Getting things working on Vista (aka – Dealing with User Account Control)
(Mike) One of my co-workers called me the other night and said, “I’ve got a question about SQL Express SP1 on Vista.” My response, of course, was “Doesn’t work right, does it?” Having had a little laugh at my friends expense, I proceeded to tell him how to get SQL Express SP1 running on Vista. Since
Upload File BLOB to SQL Server with Visual Basic 2005 and ADO.Net
(Mike McIntyre) This source code demonstrates how to use an ASP.NET web page to upload a binary large object (BLOB) and insert it, using a stored procedure, into a SQL Server table text type column.
Test the SQL Server business rule chaining method
(Tim Chapman) There is an age-old debate about where to store application business logic: the business logic layer in the application itself or at the database layer. Strict proponents of the application logic layer suggest that the sole purpose of the database is to only hold data for use by the ap
Information on Demand Global Conference Web 2.0 Personal Planner
(Leons Petrazickis and Grant Hutchison) The IBM Information On Demand 2006 Conference Personal Planner demonstrates the powerful Web application technology available for the DB2 9 pureXML data server. It demonstrates a rich experience using Ajax for the end-user with full access to the 800+ sessions