• GROUP BY SQL Queries

    Updated: 2013-01-31 05:50:27
    You may use basic SQL queries to retrieve data from a database but this often doesn't provide enough intelligence to meet business requirements. SQL also provides you with the ability ...Read Full Post

  • Mailing Labels in Access

    Updated: 2013-01-29 05:49:38
    One of the most common uses of a database is generating mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft Access using the built-in ...Read Full Post

  • PCI DSS Database Security Requirements

    Updated: 2013-01-24 05:48:46
    The Payment Card Industry Data Security Standard (PCI DSS) sets forth the security requirements for organizations that store, process and/or transmit credit or debit card transactions. These requirements stem ...Read Full Post

  • Upsizing from Access to SQL Server

    Updated: 2013-01-22 05:48:04
    Is your Access database growing too large or unwieldy? Perhaps you need to allow more robust multiuser access to the database? Converting your Access database to Microsoft SQL ...Read Full Post

  • SQL Server Foreign Keys

    Updated: 2013-01-17 04:46:45
    Foreign key constraints allow you to create relationships between data elements stored in multiple database tables. In addition to facilitating cross-table database queries (called JOINs), these relationships also ensure ...Read Full Post

  • Calculating Time Periods

    Updated: 2013-01-15 05:34:15
    In a recent forum message, a user wrote: "Hi, I am new in the forum and also new in building databases. I need help to calculate the time between the DeliveryDate ...Read Full Post

  • Facts vs. Dimensions

    Updated: 2013-01-10 05:45:47
    Facts and dimensions form the core of any business intelligence effort. These tables contain the basic data used to conduct detailed analyses and derive business value. In this article we ...Read Full Post

  • Getting Started with Business Intelligence

    Updated: 2013-01-08 05:44:52
    Embarking upon a business intelligence initiative is a major decision for an organization. It involves the coordination and cooperation of technical professionals, functional experts and the organization's leadership, all aligned ...Read Full Post

  • ★ SQL Developer/APEX Listener Bug and The Power of Social Networking in Action

    Updated: 2013-01-03 21:15:40
    Have you installed or recently upgraded to Oracle APEX Listener 2.0? Have you used SQL Developer 3.2 to manage APEX Listener settings? If you answered yes to both questions then you are in for an unwelcome surprise. The surprise is that you’ll get a “500 – Internal Server Error” whenever you upload a file via [...]

Current Feed Items | Previous Months Items

Dec 2012 | Nov 2012 | Oct 2012 | Sep 2012 | Aug 2012 | Jul 2012