• Access 2013 Backups

    Updated: 2013-09-26 06:22:42
    Backing up your Access 2013 database is an important step to preserve the integrity and availability of your important data. In this tutorial, we walk through the process of backing ...Read Full Post

  • Stored Procedures in MySQL

    Updated: 2013-09-24 06:21:45
    Are you looking for a convenient way to reuse code among MySQL applications? With the release of MySQL 5, developers may now take advantage of a powerful tool once ...Read Full Post

  • SQL Server 2012 Edition Differences

    Updated: 2013-09-19 06:20:37
    Microsoft's SQL Server 2012 enterprise database management platform marks a major evolution in this popular product. The new release includes major feature enhancements to SQL Server's business intelligence, auditing and disaster recovery functionality, among other upgrades. Read the full article: Microsoft SQL Server 2012: Choosing the Correct Edition...Read Full Post

  • Access 2013 Certification

    Updated: 2013-09-17 16:18:35
    Microsoft offers a variety of professional certification programs, including a database certification for users of Microsoft Access 2013. If you use Microsoft Access as a regular part of your ...Read Full Post

  • Access 2013 Reports

    Updated: 2013-09-12 22:11:49
    While databases allow you to use queries to retrieve data quickly and easily, you may want to display your data in a more friendly format. That's where database reports enter ...Read Full Post

  • Stored Procedures vs. Functions

    Updated: 2013-09-10 21:58:30
    . Computing Databases Search Databases Database Basics Learning SQL Using Databases Share Free Databases Newsletter Sign Up Discuss in my forum Stored Procedures vs . Functions By Mike Chapple About.com Guide September 10, 2013 My Bio Headlines Forum RSS Follow me : on SQL Server user-defined functions and stored procedures offer similar functionality . Both allow you to create bundles of SQL statements that are stored on the server for future use . This offers you a tremendous efficiency benefit , as you can save programming time : by Reusing code from one program to another , cutting down on program development time Hiding the SQL details , allowing database developers to worry about SQL and application developers to deal only in higher-level languages Centralize maintenance , allowing

  • Creating an Analytics Database

    Updated: 2013-09-05 06:59:05
    Analytics databases are optimized to be used for retrieval, aggregation, tabulation, dissemination, and analytics, under the general banner of business intelligence (BI). They deliver benefits in a BI environment because ...Read Full Post

  • Excel Pivot Tables

    Updated: 2013-09-03 05:59:00
    Read Full Post

Current Feed Items | Previous Months Items

Aug 2013 | Jul 2013 | Jun 2013 | May 2013 | Apr 2013 | Mar 2013