(Xianzhong Zhu) Encryption is a mechanism to help protect data. Encryption helps provide data confidentiality by obfuscating the data so that only authorized people can access and read the data. SQL Server 2005 provides many security-related features that help protect the data in an organization.
Author: SSWUG Research
Speed up SQL Server backup and restore time
(Greg Robidoux) Perhaps the most important tasks that occur on every SQL Server is running backups and restores. Backup copies of your database give you the security that if any issues surface with your production database you have a complete copy to fall back on. In most cases the restore process i
HOWTO: Django on Windows
There has been a proliferation of Python web frameworks lately, possibly due in part to the success of Ruby on Rails. I don’t claim to be an expert in web applications, but I have been playing around two of the frameworks: Django and TurboGears. I don’t think TurboGears could be any easier to instal
Capture changes using Oracle 10g’s new row timestamps
(Bob Watkins) Data warehouses are often populated by multiple source systems, each running their own applications. It can be tricky to determine which rows were recently updated, so that feeds to the data warehouse only include the new data. This is especially a problem with legacy applications that
Loading and Exporting Data
This is a collection of 27 FAQs on Oracle loading data and exporting data. Clear answers are provided with tutorial exercises on saving data as flat files, loading data from flat, exporting and importing database, schema and tables, creating external tables.
Debugging PL/SQL from ASP.NET and Visual Studio
(Christian Shay) Lots of you are using ASP.NET and the Oracle Data Provider for .NET to create web applications that access Oracle. When those applications call a PL/SQL stored procedure, wouldn’t it be great to just step right into the PL/SQL and begin debugging with the live parameter values still
WebBrowserControl for the .NET Framework 1.1
(Paulo Morgado) This article presents an implementation of a web browser control for the .NET Framework 1.1. It’s more of a reference for what it does than how it’s done.
XForms tip: Using multiple, hierarchical forms with XForms
(Tyler Anderson) Standard HTML forms are hard, if not impossible, to nest within each other. They lack the power that XForms has, because XForms uses XML. This tip shows you how to nest multiple, hierarchical forms within an XForm form.
Using Predicates over foreach in Arrays
(Vandita Pandey) Arrays are integral part of our programming languages. They are the data structures that contain a number of variables of the same datatype. Array class has various methods for sorting, searching and manipulating.
The Ins and Outs of XML and DB2 for i5/OS
(Jarek Miszczyk, Robert Andrews, David Andruchuk, Hernando Bedoya and Emily Chun) XML represents a fundamental change in computing. It allows applications to move away from proprietary file and data formats to a world of open data interchange. XML has become ubiquitous not only because of its range