The SQL Server 2005 Data Mining Add-ins for Office 2007 allow you to uncover hidden patterns and relationships in your data and then put them to work to enhance the quality of your analysis. To use the Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2007, you must be connected to a SQL Serv
Author: SSWUG Research
XAML: Rethink How You Code UIs
(Kathleen Dollard) Developers at Microsoft have been busy revolutionizing how we program of late. Nowhere are these changes more evident today than when creating user interfaces (UIs), where, instead of CodeDOM generation of untouchable files, you’ll program with the intrinsically declarative model
Five months with MySQL Cluster
(Brian Moon) So, the whole world changed at dealnews when Yahoo! linked us. We realized that our current infrastructure was not scaling very well. We had to make a change.
Comparing Tables Organized with Clustered Indexes versus Heaps
(Burzin Patel and Sanjay Mishra) In SQL Server 2005, any table can have either clustered indexes or be organized as a heap (without a clustered index.) This white paper summarizes the advantages and disadvantages, the difference in performance characteristics, and other behaviors of tables that are
Boosting DB2 9 for z/OS Performance
(David Beulke) DB2 9 for z/OS has many new features that give database and application designers greater flexibility to solve business problems. I recently helped a client with an application design review and saw first hand how implementing many of these features can immediately and dramatically im
Mini-Tip #11: Synonyms
(Lewis Cunningham) Today I am going to talk about synonyms and what you should NOT do with them. Since this is a MINI tip, it will be short and sweet. I will not cover every aspect of synonyms.
USER_TS_QUOTAS’s new column in Oracle 10gR2 and XE
(Flavio Casetta) I just noticed that view USER_TS_QUOTAS, giving the list of tablespace quotas on the granted tablespaces, in version 10GR2 comes with an additional column called “DROPPED”, containing a YES/NO flag.
IBM DB2 9 on AIX 5L with NFS, iSCSI, and FCP using IBM System Storage N series
(Alex Osuna, Nailah Bissoon, Sunil Kamath, Jawahar Lal, Augie Mena and Roger Sanders) Currently, Ethernet bandwidth is eclipsing Fibre Channel and the cost of Ethernet is becoming more affordable than Fibre Channel. One question that has arisen is how NFS and iSCSI perform in comparison to FCP. This
Build DocBook XML in Eclipse
(Nathan A. Good) DocBook XML is a library of standard XML tags you can use to write stylesheets for generating almost any output. However, because DocBook has been around for quite some time, many stylesheets already exist for generating different types of documentation. Learn how to use DocBook XML
Partition Pitfalls in Oracle
(Steve Callan) Table partitions in Oracle can be extremely useful and becoming proficient in managing them doesn’t take too long to accomplish. The benefits of using partitions (and you should realize them since you must pay extra for this feature) are listed in various places, but the short and swe