(Jeremy Kadlec) Locking is a necessary component of the SQL Server engine to properly ensure transactions are processed accurately with high levels of concurrency. Unfortunately, those locks can quickly become unwieldy and reduce SQL Server from a high concurrent database to a single-user machine wi
Author: SSWUG Research
Upgrading to Oracle Database 10g, concluded
(Kevin Loney and Bob Bryla) Export and Import provide you with an indirect method for the upgrade. You can create an Oracle 10g database alongside your existing database and use Export and Import to move data from the old database to the new database. When the movement of the data is complete, you w
MySQL and Business Objects Forge Close Partnership
Over the last year, Business Objects, the world’s leading business intelligence software vendor with more than 30,000 customers worldwide, and MySQL AB, which develops and supports a family of high performance affordable database products including MySQL, the world’s most popular open source datab
Introduction to monitoring DB2 v8
(Philip Gunning) Regardless of how well a RDBMS performs, the monitoring of SQL statements and resources is required to ensure continued good performance and to identify problem areas. Using the information gathered, adjustments can be made to instance and database configuration parameters, physical
Create Elegant Code With Anonymous Methods, Iterators, And Partial Classes
(Juval Lowy) Fans of the C# language will find much to like in Visual C# 2005. Visual Studio 2005 brings a wealth of exciting new features to C#, such as generics, iterators, partial classes, and anonymous methods. While generics is the most talked-about feature, especially among C++ developers who
AJAX Repeater control
(Jigar Desai) XMLHttp and AJAX can really make your application do tricks which were not possible with plain vanilla HTML, but your code can become messy very quickly if you do not plan your approach properly. I still remember the days when I was writing spaghetti code with classic asp to render tab
Retrieving SQL Server 2005 Database Info Using SMO: Basics
(Jagadish Chaterjee) This article focuses on retrieving SQL Server 2005 information using SMO together with Visual Basic 2005 and Visual Studio 2005.
Advanced Performance Management with the Enterprise Workload Manager
(Connie Cradick) Performance management is becoming more and more important in IT environments. Did you ever wonder why your Web transactions are not completing fast enough? What if I told you that you can identify how much time each middleware application uses when it processes the transaction?
An Assessment of the Oracle Password Hashing Algorithm
(Joshua Wright and Carlos Cid) In this paper the authors examine the mechanism used in Oracle databases for protecting users’ passwords. We review the algorithm used for generating password hashes, and show that the current mechanism presents a number of weaknesses, making it straightforward for an
The open-source techie who means business
(Ingrid Marson) Alan Cox is so well thought of in the open-source community that he can pull together a crowd of eager techies to discuss theoretical software stability on a Sunday afternoon — as he did at last year’s FOSDEM conference in Brussels.