Mike Chapple's guide to databases.


The links below take you to the About Databases web site. This is a free off site content service. We're not responsible for the linked content. If nothing displays below, the About Databases blog or news channel is currently unavailable, please try again later.

About Databases

Databases

INTERSECT Statements in SQL

Tuesday, May 27, 2014 · 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. The INTERSECT operation is related to the UNION operation that provides a listing of all of the rows that appear in any of the subject tables. Read more: SQL INTERSECT Queries INTERSECT Statements in SQL originally appeared on About.com Databases on Tuesday, May 27th, 2014 at 06:45:30.Permalink | Comment | Email this

Access Upsizing Wizard

Thursday, May 22, 2014 · 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 dramatic improvement from an unwieldy collection of spreadsheets, text files or other documents that the organization previously used to manage information. However, eventually the business may outgrow that Access database and need to make the move to a more advanced database product. Read the full story: Migrating to SQL Server with the Access Upsizing WizardAccess Upsizing Wizard originally appeared on About.com Databases on Thursday, May 22nd, 2014 at 06:44:53.Permalink | Comment | Email this

SQL Server Stored Procedures

Tuesday, May 20, 2014 · 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 this technology include: Precompiled execution Reduced client/server traffic Efficient reuse of code Programming abstraction Enhanced security control Read the full story: SQL Server Stored Procedures SQL Server Stored Procedures originally appeared on About.com Databases on Tuesday, May 20th, 2014 at 06:44:21.Permalink | Comment | Email this

PCI DSS and Your Database

Thursday, May 15, 2014 · 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 a series of affecting databases of consumer credit information over the past decade. What does PCI DSS mean to you as a database professional? If you review the PCI DSS standard, you'll find seventeen pages packed with detailed requirements for securing cardholder information. If your organization processes transactions, it's a good idea to review the entire standard and ensure you're meeting all of those requirements. Read the full article: PCI DSS for Database Professionals Photo by AvatarPCI DSS and Your Database originally appeared on About.com Databases on Thursday, May 15th, 2014 at 05:43:45.Permalink | Comment | Email this

Shortcut Keys in Microsoft Access

Tuesday, May 13, 2014 · As a user gets familiar with Microsoft Access it is likely they will want to start using shortcut keys. Shortcut keys make it faster to execute queries and enter data without the user having to remove their hands from the keyboard. Instead of having to move the cursor to the different menus, a user can simply press a couple of keys. While shortcut keys are not for everyone, knowing what the defaults keys are and how to create unique shortcuts can make users more efficient. Read the full story: Shortcut Keys in Microsoft AccessShortcut Keys in Microsoft Access originally appeared on About.com Databases on Tuesday, May 13th, 2014 at 05:41:03.Permalink | Comment | Email this

Using Criteria in Microsoft Access Queries

Friday, May 09, 2014 · Are you familiar with the use of criteria in Microsoft Access database queries? If you want to target certain data, criteria can be very helpful. By adding criteria to the query, the user can focus on information that has key text, dates, region, or even add wildcards to cover a wider range of data. Read the full story: Using Criteria in Microsoft Access Queries Using Criteria in Microsoft Access Queries originally appeared on About.com Databases on Friday, May 9th, 2014 at 06:42:33.Permalink | Comment | Email this

Using Microsoft Access in Your Small Business

Tuesday, May 06, 2014 · Most companies are familiar with what can be done in Microsoft Word and Excel, but understanding what Microsoft Access can do is a bit harder to grasp. The idea of creating databases and trying to maintain them seems like an unnecessary use of resources. However, for small businesses this program can provide several distinct advantages, particularly when it comes to managing growth and organization. Read the full article: Using Microsoft Access in Your Small BusinessUsing Microsoft Access in Your Small Business originally appeared on About.com Databases on Tuesday, May 6th, 2014 at 05:58:20.Permalink | Comment | Email this

Spreadsheets vs. Databases

Thursday, May 01, 2014 · One of the reasons companies are hesitant to use Microsoft Access is a lack of understanding of the difference between a spreadsheet and a database. This leads many people to believe that tracking client information, purchase orders, and project details in a spreadsheet is adequate for their needs. The end result is that it is difficult to maintain configuration control, files are lost to corruption, and employees accidently overwrite pertinent information. With a little knowledge about the power and many uses of a database, it is easier for small businesses to see when a spreadsheet is enough for a job and when a database needs to be created. Read the Full Article: Spreadsheets vs. DatabasesSpreadsheets vs. Databases originally appeared on About.com Databases on Thursday, May 1st, 2014 at 06:56:54.Permalink | Comment | Email this

Learning SQL Server 2012

Thursday, April 24, 2014 · Microsoft SQL Server 2012 is a full-featured relational database management system (RDBMS) that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration. In this article, we'll cover some of the more frequently used tools: SQL Server Management Studio, SQL Profiler, SQL Server Agent, SQL Server Configuration Manager, SQL Server Integration Services and Books Online. Read the full story: Introduction to SQL Server 2012Learning SQL Server 2012 originally appeared on About.com Databases on Thursday, April 24th, 2014 at 05:56:21.Permalink | Comment | Email this

Database Beginner Tips

Tuesday, April 22, 2014 · 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 your life easier! Read the full article: Top Five Things Beginners Need to Know About DatabasesDatabase Beginner Tips originally appeared on About.com Databases on Tuesday, April 22nd, 2014 at 05:55:25.Permalink | Comment | Email this


· Home

· Databases

· about.com

· Web Links

· Link to us

· Contact

· What's new

· Site map

· Get Help


Most popular:

· Site Feeds

· Database Design Guide

· Google Sitemaps

· smartDataPump

· Spider Support

· How To Link Properly


Free Tools:

· Sitemap Validator

· Simple Sitemaps

· Spider Spoofer

· Ad & Click Tracking



Search Google
Web Site

Add to My Yahoo!
Syndicate our Content via RSS FeedSyndicate our Content via RSS Feed



To eliminate unwanted email from ALL sources use SpamArrest!






Digg this · Add to del.icio.us · Add to Furl · We Can Help You!




Home · Categories · Articles & Tutorials · Syndicated News, Blogs & Knowledge Bases · Web Log Archives


Top of page

No Ads


Copyright © 2004, 2005 by Smart IT Consulting · Reprinting except quotes along with a link to this site is prohibited · Contact · Privacy