(Scott Stephens) Programmers often use the same technique for handling SELECT statement exceptions, so it’s wise to pick a technique that is efficient and readable. The author takes the four most commonly seen techniques for handling the exception no data found and compares their performance.
Other News
Oracle Ships ‘Tsunami’ Content Management Platform
(Lisa Vaas) Oracle quietly unveiled the shipping version of its next-generation enterprise content management platform, previously code-named Tsunami, at the AIIM On Demand show in Philadelphia.
Threat Modeling Web Applications
(J.D. Meier, Alex Mackman and Blaine Wastell) This guidance presents the patterns & practices approach to creating threat models for Web applications. Threat modeling is an engineering technique you can use to help you identify threats, attacks, vulnerabilities, and countermeasures that could affect
Article: Oracle 10g vs PostgreSQL 8 vs MySQL 5
(Lewis R Cunningham) This is my comparison of installing and getting started with Oracle 10g, PostgreSQL 8 and MySQL 5. This is what I consider the comparison of state of the art for three categories of DB: Commercial vs. Academe vs. Internet Model. This is a comparison from the view of a new user w
Get metadata on MySQL databases
(Edward Tanguay) Getting information about databases if essential if you want to write generic and scalable applications. This code shows you how to get information such as all databases on the server, all tables in each database and all field and field info for each table. Even if you do not need t
Seven key types of security auditing
Establishing a proper security posture involves risk assessment, threat analysis, and formulation of an organizational policy. But the job doesn’t end there–once your policy and controls are in place, you must make sure your protection remains effective as company needs and business conditions chan
What the IT Decision-Maker Needs to Know About SQL Server Performance Tuning
(Kurt Survance) This article is written for someone with a working knowledge of information technology, but with little specific SQL Server expertise. The typical reader would be an IT manager or executive who needs background information to properly evaluate all the performance tuning suggestions b
The -skipperrors Distribution Agent parameter for SQL Server 2000 may skip more commands than expected
The Distribution Agent may skip all the transactions in a batch and all the commands that correspond to the transaction if all the following conditions are true: • A subscription to a transactional publication contains articles that have user-defined triggers. These triggers are defined at the su
Data Flow: DefaultMaxBufferRows and DefaultBufferSize
(Ashvini Sharma) There’re two properties on the Data Flow task that have piqued enough interest to cause this post. Note that while I’m describing numbers below, the SSIS team reserves the right to change them in response to our performance testing. There’re no secrets here, most of this information
Measure, Improve, Repeat
(Scott Hayes) Use this tuning methodology for accurate input to the DB2 Design Advisor and optimum performance results.