(William Pearson) The release of MSSQL Server 2005 ushers in a plethora of enhancements over the feature set available within MSSQL Server 2000. Proclaimed as the “BI Release” for good reason, the integrated Microsoft business intelligence solution has witnessed advances in power, scope and user fri
Other News
Improve Your Productivity with Significant Enhancements in DB2 SQL
(Jarek Miszczyk) DB2 UDB for iSeries was the first member of the DB2 family that implemented SQL Procedural Language (SQL PL). The support for SQL stored procedures was first shipped in OS/400 V4R2. Since then, every new release has delivered a number of enhancements and improved functionality, so o
Harnessing the BackPack API – Part I
(Michael K. Campbell) In the “old days” there was a debate that raged between Palm and Windows CE zealots. The focus of the debate was a question of whether Palm, with its simple OS and simple functionality, was better suited to meeting users needs, or whether Windows CE, with all of its complex fun
Introduction to Cascading Style Sheets
(Paul D. Sheriff and Craig Shoemaker) Cascading Style Sheets (CSS) are a powerful way to separate content from design in your Web Forms applications. Effective use of CSS is an easy way to maintain and consolidate the visual aspects of Web development. Cascading Style Sheets are a Web standard that
Oracle 10g Security and Audit
(Lewis R Cunningham) The Oracle 10g database provides a rich set of features to secure and audit an application. Unfortunately, many applications treat security and audit as an after thought rather than a design goal. Security and audit, to be effective, must be an integral part of an application.
An interview with Kent Tegels
(Douglas Reilly) Kent Tegels is the man behind the Enjoy Every Sandwich blog on the SqlJunkies.com web site. He is also an instructor for DevelopMentor, teaching courses on .NET and SQL Server, with emphasis on SQL Server 2005. He is one of the co-authors of Beginning ASP.NET Databases Using VB.NET,
DB2 Spatial Extender performance tuning
(Knut Stolze) In almost every database system it is important to achieve good performance for the workload that is run on the system. With the help of the IBM DB2 Spatial Extender, spatial data can be seamlessly integrated in your database together with any other data you might want to store. The ex
Stored procedure: A simple way to perform crosstab operations
(Brian Walker) This tip continues the system stored procedure series with a routine to perform crosstab operations. (R)
Enhance .NET applications with Excel charts
(Tony Patton) Most development projects leave little room for change; thus, finding development shortcuts can rescue valuable time. One way to efficiently use development time is to take advantage of existing products as opposed to developing everything from scratch.
Views: The Key to Database Agility
(Larry Burns) I always enjoy reading Scott Ambler’s books and articles on Agile Development, and as a DBA, I’m particularly interested in his “agile” approach to data administration (as expressed, for example, in his book Agile Database Techniques). However, there is an important technique for crea