• Credit Card Database Compliance

    Updated: 2013-05-30 06:00:40
    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 from ...Read Full Post

  • Writing Stored Procedures

    Updated: 2013-05-28 06:59:48
    Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable blocks. Some of the core benefits of ...Read Full Post</p

  • Free Edition of MSSQL 2012

    Updated: 2013-05-23 06:59:21
    Microsoft SQL Server 2012 Express Edition is a free, compact version of the popular enterprise database server. The Express Edition is ideal for database professionals seeking a desktop testing environment ...Read Full Post

  • SQL INTERSECT Queries

    Updated: 2013-05-21 06:57:30
    SQL's INTERSECT operation allows you to identify the rows that appear in multiple source tables. This set of common rows is known as the intersection of the two tables. ...Read Full Post

  • 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 ...<pRead 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

Current Feed Items | Previous Months Items

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