(Rachel Wireman) Interacting with Microsoft Office (as well as taking advantage of the mountains of built-in classes and functions) can be a powerful addition to your business applications. You can perform highly valued operations using the interoperability assemblies that ship with Office products
Other News
Do comments slow down PL/SQL?
(Rex Baldazo) I’m not sure where this started, but at work there’s this rumour going around that if you put too many comments in an Oracle PL/SQL package, it impacts performance. That is, the more comments in your code the slower it runs.
.NET Framework and Language Enhancements in 2005
(Lars Powers and Mike Snell) The majority of this book focuses on unlocking the productivity promises of the Visual Studio IDE. However, we thought it important to also cover some of the recent advances in the .NET languages and the Framework. These items (the IDE, the languages, and the Framework)
Tip/Trick: Automating Dev, QA, Staging, and Production Web.Config Settings with VS 2005
(Scott Guthrie) One of the questions I get asked fairly regularly is: “how can I can easily change different configuration settings in my web.config file based on whether my application is in a dev, qa, staging or production mode?” The most common scenario for this is one where an application uses
PL/SQL:: New Compound Trigger
(Rajender Singh) The new Compound Trigger make it easier to handle a situation, where we want trigger fired at different point of time to share common data.
Functions as default values…
(Patrick Barel) If you have a program with parameters that have default values and you want the user to be able to change the default values of the parameters, without you having to change the value in the code, then put that data in a table.
Exposing DB2 Version 9 pureXML using WebSphere Integration Developer
(Karen Devlin) IBM offers a set of industry specific Web services that provide operations to expose the native XML capabilities of IBM DB2. These Web services can be accessed in a Websphere Information Developer module that can be used in a work flow to manipulate your FpML data. Follow step-by-step
Safely change firewall rules remotely
(Bjørn Hansen) One of the NTP Pool server operators emailed recently and told that his server was unavailable for a few hours because he had changed some firewall rules remotely and managed to lock everyone out. Oops!
Report Execution Caching I: SQL Server Management Studio Perspective
(William Pearson) In the first article of this sub-series, Black Belt Administration: Caching Options: Report Session Caching, we discussed the fact that a common attribute of enterprise reporting systems is their provision for unified points of maintenance for various aspects of system configuratio
Stored Procedures vs. User Defined Functions in Microsoft SQL Server
(Mike Chapple) SQL Server user-defined functions and stored procedures offer similar functionality. Both allow you to create bundles of SQL statements that are stored on the server for future use.