MySql View Technique for Grouping Crosstab Column Data3/12 Learn a technique to fetch column data for MySQL crosstabs by emulating views. By replacing tables with a subquery subset, the resulting view will contain a limited dataset that has been filtered for that column field.
Survey of MySQL Storage Engines3/11 MySQL has an interesting architecture that sets it apart from some other enterprise database systems. It allows you to plug in different modules to handle storage. What that means to end users is that it is quite flexible, offering an interesting array of different storage engines with different features, strengths, and tradeoffs.
Open Source NoSQL Databases Ramp Up3/10 NoSQL databases offer an alternative to traditional relational databases, but they might not be the right fit for everyone.
Eight Reasons Why Oracle's Acquisition of Sun isn't All Bad3/10 Much has been said about why Oracle acquired Sun, how it will be the demise of the free world and produce a one-world database monopoly. While there is probably a little truth in the statement, we should keep in mind that much of what is happening can be beneficial for the end customer.
Toad 10 from Quest Software
Toad 10, the latest version from Quest Software, with four different suites for Oracle 10 products, is designed to support both developers and DBAs.
Myths and Pitfalls of Data Mining
Data mining is the concept of searching through corporate data looking for patterns and trends. Before you start data mining, you need to understand the myths and pitfalls of data mining.
Benefits and Challenges using Solid-State Drives
Solid-State drives might be considered the silver bullet when it comes to improving I/O. However, keep in mind solid-state technology is expensive and needs to be configured appropriately to provide maximum performance. Read this research paper to make sure you know the advantages and disadvantages and the different deployment models for rolling out Solid-State drives in your environment.
What Does it Take to be a Best-in-Breed BI Shop
There are a number of things, which best-in-breed BI shops are doing, to set them apart from the rest. By reading this research paper, you will have a better understand of what you are doing or need to do so your organization can be amongst the industry leaders when it comes to providing BI solutions to your company decision makers.
Increase Revenue by Improving Data Quality
Improve your companies bottom-line by improving data quality. This white paper discusses best practices around how to manage and improve the quality of your data.
Complete Data Warehousing Solution using Oracle 11g With Known Hardware Providers
Oracle provides the best of breed software when it comes to building Data Warehouses. Now Oracle has collaborated with hardware vendors to provide a scalable performance oriented hardware and software solutions for supporting a data warehousing. By providing these collaborated deployment models, Oracle simplifies the designing and configuration aspects of your data warehouse environment.
Introducing WCF RIA Services By Dan Rigsby
Published March 2, 2010
Get a jumpstart on using Windows Communication Foundation (WCF) RIA Services to easily build robust and secure data driven Silverlight applications.
Plotting Map Markers Using the Google Maps API By Jason Gilmore
Published February 17, 2010
Learn how to add Google Maps markers and store their coordinates in a database using a blend of jQuery, PHP and MySQL
PHP & JavaScript Using JSON By Jason Gilmore
Published February 4, 2010
Build powerful AJAX-driven Web applications by passing databetween the client and server using PHP, JavaScript and the JSON data format.
Master & Detail Lists in SharePoint 2010 By Joe Mack
Published January 19, 2010
Learn how to make a solid user interface using the master and detail lists in Microsoft Sharepoint 2010.
