(James F. Koopmann) Performance in Oracle is directly related to the SQL workload that is submitted. Often it is not the change in the SQL that degrades performance but instead is the access path to that data. This article will help you understand when new access paths have been introduced in your e
Author: SSWUG Research
Restore basics: How to restore using T-SQL commands
(Greg Robidoux) Another approach to SQL Server backup and restore, aside from using Enterprise Manager as discussed in my previous tip, is to use T-SQL commands. Enterprise Manager can be a quick and easy way to run backups or restores, but T-SQL offers a lot more flexibility. With T-SQL you can scr
The Next Web?
(Simon St. Laurent) The only things more annoying than the broken tools of today are the better tools of tomorrow which aren’t here yet. Technologists often pass quickly through cycles of delight with a new toy and frustration with its limitations, looking for the next new thing as soon as they’ve f
AJAX from Scratch: Implementing Mutual Exclusion in JavaScript
(Bruce Wallace) This AJAX from Scratch series of articles describes fundamental techniques needed to develop AJAX Rich Internet Applications in JavaScript from scratch. Each article focuses on a particular (usually little-covered) aspect of developing browser-side functionality without the use of co
FIX: The MSDE writer is not included when you try to use the Vssadmin.exe tool to list subscribed volume shadow copy writers
Consider the following scenario. On a Microsoft Windows Server 2003 x64-based computer that is running Microsoft SharePoint Team Services, you try to use the Volume Shadow Copy Service (VSS) administrative command-line tool (Vssadmin.exe) to list subscribed volume shadow copy writers. You may notice
A Step-by-Step Guide To Using MySQL with ASP.NET – Part 3
(Ziran Sun) When it was written, part two was designed to be the end of the article. However, since then I’ve received a number of email messages requesting additional information. Therefore this part will attempt to address the questions raised in those messages and share what I’ve found while rese
Service Oriented Architecture
(Joydip Kanjilal) Service Oriented Architecture is one of the most popular architectural paradigms today, but without any standardized reference model. It is an architecture that provides seamless Enterprise Information Integration between loosely coupled distributed applications or services over th
Using the Enterprise Library Data Access Block for .NET 2.0
(Thiru Thangarathinam) ADO.NET provides many rich features that can be used to retrieve and display data in a number of ways, but even given such flexibility, sometimes developers find themselves repeating the same code again and again. For example, every data-driven application requires access to a
How to create columns dynamically in a grid view
(SaidevKumar) This article describes about how to create columns dynamically in a grid view. Many times we have the requirement where we have to create columns dynamically. This article describes you about the dynamic loading of data using the DataTable as the datasource.
Types and Objects in Python
(David M. Beazley) All the data stored in a Python program is built around the concept of an object. Objects include fundamental data types such as numbers, strings, lists, and dictionaries. It’s also possible to create user-defined objects in the form of classes or extension types. This chapter des