(Don Schlichting) This article focuses on the SQL Server 2005 Maintenance Plan Wizard for creating Database Backup operations. The Maintenance Plan Wizard is a graphical interface for creating a variety of database housekeeping tasks. In addition to Backup operations, maintenance items such as reorg
Author: SSWUG Research
MS SQL Server Trim function
(Svetoslav Marinov) When programming on different languages one may expect one functionality to be present in other languages too. For example PHP has a TRIM() function which deletes leading and trailing white spaces.
Partner TechTip: Blend SQL and RPGLE to Make Better Tools
(Kevin Forsythe) One of the weak links in IBM’s SQL support is the lack of an ad hoc “RUNSQL” type of command that lets us easily execute an SQL statement from a command line or from within a CL program. However, programmers who are so inclined can fill in this gap by writing just a little code of t
Mean Mr. Modeler
(ddelmoli) With apologies to the Beatles. I read a post by Tom Kyte the other day about a data model that had passwords as clear-text, unique keys on a table and even used them as foreign keys! After reading it, I was reminded of a conversation I had with my wife, Wendy, about how she’s seeing a r
Atlas Controls
(Wallace B. McClure, Scott Cate, Paul Glavich and Craig Shoemaker) This chapter introduces the concept of the Microsoft Atlas controls. These controls function like other ASP.NET server controls. Once rendered, these controls provide the HTML necessary to communicate back to the server from the cli
Using Views to Enforce Business Rules
(David Moloney) A view is most commonly thought of as a SELECT statement. Most developers will simply create a view to “group” complex SELECT statements for reuse within another view or stored procedures. It makes typing easier! But the really power of views is their ability to implement business ru
Is XML the Future of UI Development?
(Jonathan Allen) Or is it JavaScript? A common trend in the new crop of desktop UI frameworks is that they are XML based with some sort of support for JavaScript. We take a brief look at AJAX, WPF/XAML, Flex/MXML, and Firefox’s Gran Paradiso.
Oracle Application Express 3.0 a credible alternative to Microsoft Access?
(Donal Daly) I hope most people know by now that Oracle Application Express (APEX) 3.0 has gone production, is available for download from OTN and our hosted instance, apex.oracle.com had also been upgraded to 3.0.
Emulating Analytic (AKA Ranking) Functions with MySQL
(Stéphane Faroult) One of the most hailed extensions brought to SQL in recent years has been these functions that Oracle calls analytic functions, DB2 calls OLAP functions, and SQL Server 2005 calls ranking functions–but which MySQL, so far, still lacks. The good news is that they can be (relativel
Ajax RSS reader
(Jack D Herrington) Learn how to build an Asynchronous JavaScript and XML (Ajax) Really Simple Syndication (RSS) reader, as well as a Web component that you can place on any Web site to look at the articles in the RSS feeds.