(Kevin Burton) This is a hack I’ve heard about a couple times now: Paul wrote a script that reads from the logfile the queries that are going to be executed moments later. He parses the queries and constructs new select queries that populate the cache with the data that speeds up the upcoming wri
Author: SSWUG Research
Disaster recovery features in SQL Server 2005
(Hilary Cotter) Disaster recovery refers to the ability of a company to continue operations after an event interrupts normal business functions. For example, many businesses in New York City faced considerable disruption during the power failure in the summer of 2003, and of course in the aftermath
Implement Parallel Execution in SSIS
(Runying Mao) SQL Server Integration Services (SSIS) allows parallel execution in two different ways. These are controlled by two properties as outlined below.
Made to order: Eirik’s Hi-Lo Chart in SQL – extending the SQL Chart Palette (Pie, Stacked Bar Chart, Gauge, Gantt,…)
(Lucas Jellema) With the series on SQL based Charts, I can now safely commit any crime in the firm knowledge that an insanity plea will undoubtedly be accepted. After spending way too much time on pretty nonsensical exercises like the Gauge and Stacked Bart Chart in SQL, I had decided not to do it a
Frequently Asked Questions in .NET 2.0
(Uday Denduluri) The questions and answers discussed in this article are the common questions programmers encounter in interviews. Most of the questions are basic questions of .NET and some of them are from ASP.NET 2.0.
Implementing Real-World Data Input Validation using Regular Expressions
(Francis Norton) This article explains how to use .NET regular expressions to enforce the kind of logically complex input validation requirements that we sometimes confront in real specifications. This will allow us to start with basics and go on to exploit some fairly advanced features.
Understanding roles in Oracle stored procedures
(Bob Watkins) One of the trickiest parts of Oracle’s security model is the way that roles (collections of database privileges) interact with stored procedures, functions, and packages. Object privileges in Oracle can be granted directly to the user or indirectly via a role.
Delivering Next Generation User Interfaces Using AJAX
(Rado Kotorov) By any reckoning, the Internet and the World Wide Web have already remade the way we do business. The ascendance of the Web-based enterprise has come to be seen as inevitable. But anyone who takes a hard look at the serious limitations of first-generation Web applications is likely to
Rational Data Architect and DB2 9: Using the SQL Editor
(Paul Zikopoulos) In an article called “Rational Data Architect and DB2 9: Building an SQL Statement”, I introduced you to the IBM Rational Database Architect (Rational DA) product and its SQL builder feature. Specifically, I showed you how easy it is to build an SQL statement using the Rational DA
Index on Expressions [DB2 9 for z/OS]
(Craig Mullins) DB2 9 for z/OS offers, for the first time, the ability to create an index on data that is not technically in the table. At this point, you may well be asking “What does that mean?” and “Why would I do that?” I’ll attempt to answer both of those questions.