(Zach Smith) In the enterprise world you rarely come across any in-house application that will allow plugins to be written and imported without any changes to core application code. I believe one of the reasons for this is that in the past it was difficult to implement the type of architecture that
Author: SSWUG Research
Data Quality and Real-World Things
(Wayne Kurtz) Data represents real-world things and is described by metadata. It needs to be fit for its purpose. Data that is not fit is considered invalid or of low quality needs to be either cleansed or discarded. Uncleansed data can be seen as being either incomplete or inaccurate, or both. Ther
Installing and Configuring Oracle Database 10g on the Linux Platform
(Chetan) This paper will walk you through the steps of installing Oracle Database 10g release 2 (Oracle version 10.2.0) in a Linux environment. About 90% of the material presented here applies to other platforms as well. Everything you read in this paper is hands on, roll-up-your-sleeves-and-get-bus
Microsoft’s Lineup of SQL Server Related Webcasts for December 2006
Six new webcasts are scheduled for December, covering such topics as Retail Customer Experience with SQL Server 2005, SQL Server 2005 Report Builder and more.
Asynchronous execution of federated queries in WebSphere Federation Server V9.1
(Anjali Betawadkar-Norwood, Simon Harris and Susanne Englert) In prior releases of WebSphere Federation Server (WFS), previously called WebSphere Information Integrator, many federated queries execute in a single-threaded manner. This means that even if multiple remote sources participate in a query
SQL Server 2005: Partitioning
(Dipal Choksi) Partitioning allows storage of data within a table to be organized in multiple units that can be spread across more than one filegroup in a database. Using this feature, data is partitioned by rows and various defined subsets of rows are split into separate units. From the point of vi
SQL Server query design: 10 mistakes to avoid
(Jeremy Kadlec) With the substantial and sustained data growth of SQL Server databases, coupled with the sub-second response times expected by users, it is critical to avoid poorly written queries. In this tip we will outline 10 common query design mistakes to avoid. Take a look to make sure you are
Custom Reports in Management Studio
(Paul A. Mestemaker II) Many Object Explorer nodes in SQL Server Management Studio display a set of standard reports created by Microsoft which summarize typically requested server information. Starting with SQL Server 2005 service pack 2, SQL Server Managemetn Studio lets administrators run custom
Merge / Upsert statement
(Chris Eaton) I wanted to cover off the MERGE statement in this weeks posting (as I’m sure many of the American readers will be merging some turkey and some mashed potatoes later this week 🙂
Make the most of XForms repeats
(Jan J. Kratky and Steve K Speicher) XForms provides many powerful mechanisms for working with XML data. One such mechanism is the “repeat” element, which allows you to quickly and easily implement iteration over homogeneous data sets in your XML. In addition, you can format the presentation of such