• UNION Queries in SQL

    Updated: 2013-05-16 06:08:48
    SQL's UNION command allows you to combine the results of two or more database queries that are not necessarily linked through a database relationship. For example, imagine that you have ...Read Full Post

  • SQL Plan Stability and CBO Statistics Myths Busted

    Updated: 2013-05-14 15:30:04
    Carlos Sierra: Since lack of Histograms or freezing CBO Statistics do not guarantee Plan Stability, do not rely on these two myths. If what you are looking for is Plan Stability use then SQL Plan Management available since 11g or SQL Profiles available from 10g. ★ © Eddie Awad's Blog, 2013. | Permalink | Add [...]★

  • Migrating to SQL Server with the Access Upsizing Wizard

    Updated: 2013-05-14 06:07:46
    Many database users begin their adventure in the world of databases by creating a Microsoft Access database that meets the basic requirements of their organizations. Often, this is a ...Read Full Post

  • Faith, hope, and clarity

    Updated: 2013-05-10 15:23:51
    Some principles of enterprise IT messaging. 0. Decision makers are motivated by two emotions above all — fear and greed. In the case of enterprise IT, that equates roughly to saying they want to buy stuff that: Is safe. Will confer benefits. 1. For a marketing message to succeed, whatever its goals are, the “confer [...]

  • User Login Screens in Microsoft Access

    Updated: 2013-05-09 06:13:02
    In a recent forum message, a user wrote: "I have a database system(2007) which i have designed. however i am unable to create a user log in screen which would prompt ...Read Full Post

  • Notes on pricing

    Updated: 2013-05-07 10:40:25
    Vendor clients often ask me about pricing. Everybody knows that there usually are: A low-quantity list price. A standard volume discount (typically 50%ish, assuming negligible cost of goods sold). The real negotiated price. But the whole process has to start with some concept of a single-unit price. What kind of price? Well, for appliances, you [...]

  • Problem Splitting Access Databases

    Updated: 2013-05-04 17:12:40
    In a recent forum message, a user wrote: "I went ahead and split the database once I had all the tables and most of the queries constructed and filled, along with ...Read Full Post

  • Top 5 Tips for Database Beginners

    Updated: 2013-04-26 06:26:49
    Just getting started with databases? Here's a rundown of the top things that I wish I knew before I got started in the field. These facts are guaranteed to make ...Read Full Post

  • just::thread Pro: Actors Edition released

    Updated: 2013-04-23 09:35:12
    : : , J ust S oftware S olutions Call Us on 0845 053 0 350 Or email us for Custom Software Development Buy just : thread C++0x Thread Library . Download and get started today About the Company Home Page Our Ethos Contact us Custom Software Development Website Development Free Libraries to Download Technical Writings Published Articles and Presentations Recent Blog Entries Reviews Multithreading and Concurrency C++ Web Design Software Design Database Design Subscribe to Blog Subscribe by RSS Enter your details below to receive updates by email Name : Email : We respect your email privacy Blog Archives May 2013 1 April 2013 2 March 2013 1 2012 6 2011 11 2010 24 2009 25 2008 41 2007 26 2006 13 Search Enter your search terms Web this site Submit search form Photo shows Sennen Beach , which

  • Migrating to SQL Azure

    Updated: 2013-04-23 06:26:17
    SQL Server Migration Assistant (SSMA) provides database administrators with a smooth way to transition from their existing database platform to Microsoft SQL Server. The migration assistants are able to transfer ...Read Full Post

Previous Months Items

Apr 2013 | Mar 2013 | Feb 2013 | Jan 2013 | Dec 2012 | Nov 2012