(Daniel Turini) So, you are now the leader of a SQL Server based project and this is your first one, perhaps migrating from Access. Or maybe you have performance problems with your SQL Server and don’t know what to do next. Or maybe you simply want to know of some design guidelines for solutions usi
Other News
Use XML Query Definitions in .NET Applications
(David Clark) The Command objects in ADO.NET (such as OleDbCommand and SqlCommand) are a central aspect of the .NET database access strategy. When used properly, they provide excellent performance and security.
Mozilla, Opera Join Forces For New W3C Proposal
(Sean Michael Kerner) Two of Microsoft’s rivals in the browser space have joined forces on a standards proposal slated to be presented to a W3C workshop. The Mozilla Foundation and Opera Software collaborated on the document, which represents their “consensus” opinion in the context of standards
HOW TO: Automate Replication over a Dial-Up Connection
This article describes the process for automatically initiating replication over a dial-up connection. The process involves using a scheduled job to establish the dial-up connection and then perform the synchronization. This procedure is described in more detail in the “More Information” section of
Records Management: Hello IBM DB2 Records Manager!
(Naga Ayachitula, Andrew Bradfield and JoAnn Brereton) This is an introductory article on programming with IBM DB2 Records Manager. In this article we will walk through a simple exercise of logging in to a Records Manager engine. For the purposes of this article, it is assumed that the Records Manag
MDX(-Ray) of Excel
(John Lynn) A well-designed SQL Server 2000 Analysis Services data warehouse can yield significant information when you analyze the data warehouse cubes, and many excellent client tools are available to help you navigate OLAP cube data. Business intelligence (BI) tools such as ProClarity Analyti
Compliance’s Bright Side
(David Beulke) Regulatory requirements such as the United States’ Health Insurance Portability and Accountability Act (HIPAA) and Sarbanes-Oxley Act of 2002 are causing extensive changes within corporations. Some of the changes alter database system fundamentals; all of them require data management
ToDoList 3.6 (RC2) – A simple yet effective way to keep track of your current programming tasks
(Dan G.) You know how it is – you start work on one project and halfway through you find one or two side-projects crop up that have to be solved before you can continue on the original project. This is one such project with the added twist that it too started its life as a side-project.
JDeveloper 10g Is For PL/SQL Developers Too!
You’ve probably noticed by now that JDeveloper 10g Production has now been released on OTN. Congratulations to Brian Duff, Steve Muench, Shay Shmeltzer, Gerard Davison and all other others in the JDeveloper product team who worked on this release. Steve Muench wrote a couple of articles recently
Oracle Tip: Use the CSSCAN utility before character set migration
Oracle DBAs may try to import a full database export–only to get warnings about character set incompatibilities. This problem is compounded because the default database character set is ASCII, yet the recommended character set for international databases is one of the Unicode character sets, such a