(Brian Brewder) Application security is important, but how secure is secure enough? If you are writing an online Advent calendar, security probably isn’t that important. On the other hand, if you are writing software that triggers a nuclear device, security will probably be the primary feature (it p
Author: SSWUG Research
Influence query optimization with optimization profiles and statistical views in DB2 9
(Kenneth K. Chen) Most major relational database management systems such as IBM DB2, Oracle and Microsoft® SQL Server rely on a cost-based optimizer design to choose an optimal SQL execution plan among the many possible alternative plans, under a set of often changing conditions within a database se
Gotcha: Don’t use
(Scott Guthrie) Recently I’ve helped a few developers who have been having some weird JavaScript issues (both when using ASP.NET AJAX and with some other custom JavaScript routines they were using). The culprit was that they had automatically migrated a VS 2003 Web Project to VS 2005, and still had
Actions in Analysis Services 2005: The URL Action
(William Pearson) In this article, we will gain some familiarity with the URL Action – how it works and some of its capabilities – and then get some hands-on exposure to creating a URL Action within the sample AdventureWorks development environment, which can be installed with MSSQL Server 2005.
Working with xsl:choose in XSLT
(Jagadish Chaterjee) This is the second article in a series focusing on developing XSLT-oriented applications using ASP.NET 2.0. Even though the series is based on ASP.NET 2.0, I use it only as a transformation engine. The entire focus will be on working with XSLT. You can use any transformation eng
Automating MySQL Best Practices Management
(Robin Schumacher) One thing I learned fairly early in my DBA career was that if I was ever going to excel in managing the databases under my care, I needed to do one thing: smartly automate as much of my job as I could. This became particularly important in my last full-time DBA spot where one othe
Index Build strategy in SQL Server – Part 2: Offline, Parallel, No Partitioning
(Lyudmila Fokina) The type of parallel index build plan in SQL server depends on whether or not we have a histogram available with necessary statistics. Therefore, there are two broad categories of parallel index plans: –Histogram available: –No histogram
Combining Web Services and SQL Server Data Utilizing Business Objects Business View Manager – Part 2
(Eric Landes) As mentioned in Part 1 of this article, there are many times your customers may want reports that combine data from different sources. In this article we will concentrate on putting the data together in Business Objects Business Views.
Consider Oracle 10gR2’s Instant Client Light for application deployment
(Bob Watkins) Client/server applications can communicate with an Oracle database in several ways. The most common of these is a middleware layer called the Oracle Call Interface (OCI). As you install Oracle’s server software on the database server machine, you must install some sort of client softwa
Load Text Files to CLOB then Write Back Out to Disk – (PL/SQL)
(Jeff Hunter) The following example is part of the Oracle LOB Examples Collection.