Databases Sitemap - Page 4 2013-05-22
Primary and Foreign Keys in Databases
Primary and Foreign Keys in Databases
Modifying an Expense Tracking Database
Modifying an Expense Tracking Database
Access 2010 Product Walkthrough
Access 2010 Product Walkthrough
Converting from Access to Excel
Converting from Access to Excel
Grouping Values in a Report
Grouping Values in a Report
BCP For a Specific Timeframe
BCP For a Specific Timeframe
Free Practice Test for Microsoft MCTS Exam 70-433
Free Practice Test for Microsoft MCTS Exam 70-433
Using Access for a Complex Database
Using Access for a Complex Database
Designing SQL Server Tables
Designing SQL Server Tables
SQL Server Database Maintenance
SQL Server Database Maintenance
Saving Access Reports as PDF Files
Saving Access Reports as PDF Files
Database Relationships Explained
Database Relationships Explained
Access 2007 Form Appearances
Access 2007 Form Appearances
SQL Server 2008 Authentication Modes
SQL Server 2008 Authentication Modes
Working with Access 2010 Tabs
Working with Access 2010 Tabs
Table Partitioning in SQL Server
Table Partitioning in SQL Server
Installing MySQL on Mac OS X 10.7 Lion
Installing MySQL on Mac OS X 10.7 Lion
MySQL Stored Procedures
MySQL Stored Procedures
SSMS Custom Folder Add-In
SSMS Custom Folder Add-In
Getting Started with SQL?
Getting Started with SQL?
Earning a Database Certification
Earning a Database Certification
Learning SQL Commands: A Collection of Tutorials and Introductions
Learning SQL Commands: A Collection of Tutorials and Introductions
Buying Microsoft SQL Server 2008: Which Edition Should I Choose?
Buying Microsoft SQL Server 2008: Which Edition Should I Choose?
SQL Server Performance Optimization
SQL Server Performance Optimization
Movie Collection Database
Movie Collection Database
Charitable Contributions Database
Charitable Contributions Database
Pivot Tables in Google Spreadsheets
Pivot Tables in Google Spreadsheets
Pivot Tables in Excel 2010
Pivot Tables in Excel 2010
Introduction to Pivot Tables
Introduction to Pivot Tables
Data Control Language
Data Control Language
Printing Barcodes
Printing Barcodes
SQL Server Versions
SQL Server Versions
Pivot Tables Tutorial
Pivot Tables Tutorial
SQL Server Constraints
SQL Server Constraints
What File Format Does Microsoft Access Use?
What File Format Does Microsoft Access Use?
Transferring Data Between Access and Excel
Transferring Data Between Access and Excel
Creating an Access Database from a Template
Creating an Access Database from a Template
SQL Server 2008 Replication
SQL Server 2008 Replication
Sending E-mail from a Microsoft Access Form
Sending E-mail from a Microsoft Access Form
Microsoft Access 2010 Fundamentals
Microsoft Access 2010 Fundamentals
Creating a Query in Microsoft Access 2010
Creating a Query in Microsoft Access 2010
Access Error: The Search Key is Not Found in Any Record
Access Error: The Search Key is Not Found in Any Record
SQL Server 2008 Database Auditing
SQL Server 2008 Database Auditing
Access 2010 Database Passwords
Access 2010 Database Passwords
What is an MDB File?
What is an MDB File?
Access 2010 Database Templates
Access 2010 Database Templates
MAX and SUM Aggregate Functions
MAX and SUM Aggregate Functions
Naming Database Objects
Naming Database Objects
Creating Reports in Access 2010
Creating Reports in Access 2010
Converting a Database to Access 2010
Converting a Database to Access 2010
SQL Server 2008 Log Shipping
SQL Server 2008 Log Shipping
Managing SQL Server Transaction Logs
Managing SQL Server Transaction Logs
What is an ACCDB File?
What is an ACCDB File?
Access 2010 Expression Builder
Access 2010 Expression Builder
SQL Server 2012 Licensing, Pricing and Features
SQL Server 2012 Licensing, Pricing and Features
Sequentially Numbering Database Queries
Sequentially Numbering Database Queries
Creating and Immediately Using a Database
Creating and Immediately Using a Database
Complex SQL Query
Complex SQL Query
Normalizing a Table
Normalizing a Table
Microsoft SQL Server Foreign Keys
Microsoft SQL Server Foreign Keys
Visitor Contact Database
Visitor Contact Database
Change Data Capture (CDC) in SQL Server
Change Data Capture (CDC) in SQL Server
BCP and Wildcards
BCP and Wildcards
Mailing Labels in Microsoft Access 2010
Mailing Labels in Microsoft Access 2010
Installing MySQL on Windows 7
Installing MySQL on Windows 7
Installing SQL Server 2008 R2 Express Edition
Installing SQL Server 2008 R2 Express Edition
Backing Up Databases in Access 2010
Backing Up Databases in Access 2010
Adding Passwords to Access 2010 Databases
Adding Passwords to Access 2010 Databases
SQL Server Pattern Matching
SQL Server Pattern Matching
Dividing Access 2010 Databases
Dividing Access 2010 Databases
CASE Database Queries
CASE Database Queries
Help a Soldier with a Database
Help a Soldier with a Database
SQL Server Distributed Management Framework
SQL Server Distributed Management Framework
Free Genealogy Database
Free Genealogy Database
Getting the Most Out of Microsoft Access
Getting the Most Out of Microsoft Access
Open Exclusive in Microsoft Access
Open Exclusive in Microsoft Access
Backup Compression in SQL Server 2012
Backup Compression in SQL Server 2012
Service Desk Database
Service Desk Database
Timestamping Database Records
Timestamping Database Records
Counting SQL Result Rows
Counting SQL Result Rows
Atomicity, Consistency, Isolation, Durability (ACID) and You
Atomicity, Consistency, Isolation, Durability (ACID) and You
Tracing SQL Queries
Tracing SQL Queries
Introduction to SQL Server 2012
Introduction to SQL Server 2012
SQL Server Migration Assistant
SQL Server Migration Assistant
Choosing a Database Certification Program
Choosing a Database Certification Program
Databases for Newcomers
Databases for Newcomers
Migrating from Excel to Access
Migrating from Excel to Access
Combining SQL Query Results
Combining SQL Query Results
Database Queries with Date Ranges
Database Queries with Date Ranges
SQL Server Management
SQL Server Management
Access 2010 Books for Beginners
Access 2010 Books for Beginners
Timestamps on Edited Rows
Timestamps on Edited Rows
Installing SQL Server 2012 Express Edition
Installing SQL Server 2012 Express Edition
SQL Server Stored Procedures
SQL Server Stored Procedures
Open Exclusive in Access 2010
Open Exclusive in Access 2010
Databases and PCI DSS
Databases and PCI DSS
SQL Database Auditing
SQL Database Auditing
Data Import/Export in SQL Server Management Studio
Data Import/Export in SQL Server Management Studio
TRY...CATCH Error Handling
TRY...CATCH Error Handling
Abandoning ACID in Favor of BASE
Abandoning ACID in Favor of BASE
Purchase Order Database
Purchase Order Database
Introduction to NoSQL
Introduction to NoSQL
SQL Server 2008 Certifications
SQL Server 2008 Certifications
Creating Accounts in SQL Server 2008
Creating Accounts in SQL Server 2008
Microsoft SQL Server 2012 Certification Programs
Microsoft SQL Server 2012 Certification Programs
Creating a SQL Server 2012 Database Account
Creating a SQL Server 2012 Database Account
SQL Server Auditing Tools
SQL Server Auditing Tools
SQL Server Agent Automation
SQL Server Agent Automation
Calculating Expiration Dates
Calculating Expiration Dates
Introducing Access 2010
Introducing Access 2010
Naming SQL Server Instances
Naming SQL Server Instances
Database Keys: Primary vs. Foreign Keys
Database Keys: Primary vs. Foreign Keys
Microsoft Access Technical Document Database
Microsoft Access Technical Document Database
MySQL 5 Certification Programs
MySQL 5 Certification Programs
Moving to Access Services in Office 365
Moving to Access Services in Office 365
Installing MySQL on Mac OS X 10.8 Mountain Lion
Installing MySQL on Mac OS X 10.8 Mountain Lion
Moving Access Databases to the Web
Moving Access Databases to the Web
Learning SQL for Free
Learning SQL for Free
Optimizing SQL Server Performance
Optimizing SQL Server Performance
SQL vs. NoSQL
SQL vs. NoSQL
Hiding Access 2010 Tabs
Hiding Access 2010 Tabs
Building Database Relationships
Building Database Relationships
Analytics Databases
Analytics Databases
Using Pivot Tables in Excel
Using Pivot Tables in Excel
Designing Multi-Page Access Reports
Designing Multi-Page Access Reports
Backing Up Microsoft Access
Backing Up Microsoft Access
Calculating Elapsed Dates
Calculating Elapsed Dates
Creating Stored Procedures in MySQL
Creating Stored Procedures in MySQL
Buying Microsoft SQL Server 2012: Which Edition Should I Choose?
Buying Microsoft SQL Server 2012: Which Edition Should I Choose?
Functions and Stored Procedures: Which Should I Use?
Functions and Stored Procedures: Which Should I Use?
SQL Server Import and Export Wizard
SQL Server Import and Export Wizard
Google Docs Pivot Tables
Google Docs Pivot Tables
SQL Server in Amazon Web Services
SQL Server in Amazon Web Services
Regular Expressions
Regular Expressions
Sharing Data Between Access and Excel
Sharing Data Between Access and Excel
Understanding SQL Server Constraints
Understanding SQL Server Constraints
Pivot Tables in Excel and Google Apps
Pivot Tables in Excel and Google Apps
Referential Integrity
Referential Integrity
SQLCMD Utility
SQLCMD Utility
DETA in SQL Server 2012
DETA in SQL Server 2012
Microsoft Access MDB Files
Microsoft Access MDB Files
Passwords on Access Databases
Passwords on Access Databases
Access Database Query Creation
Access Database Query Creation
Using Access Database Templates
Using Access Database Templates
Entity-Relationship Diagrams
Entity-Relationship Diagrams
Deleting Information from a Database
Deleting Information from a Database
Running MySQL for Free in Amazon EC2
Running MySQL for Free in Amazon EC2
Entity-Relationship Diagrams
Entity-Relationship Diagrams
SQL Server Password Strength
SQL Server Password Strength
Managing SQL Server Transaction Logs
Managing SQL Server Transaction Logs
Access 2010 Expression Builder
Access 2010 Expression Builder
Creating a Table with SQL Server 2012
Creating a Table with SQL Server 2012
Creating Database Traces with SQL Server 2012
Creating Database Traces with SQL Server 2012
Taking Courses for Database Education
Taking Courses for Database Education
HIPAA Compliance and Databases
HIPAA Compliance and Databases
Error: Could Not Delete from Specified Tables
Error: Could Not Delete from Specified Tables
Expense Report Database Template
Struggling with expense report tracking for your business or organization? Microsoft offers free expense report database templates for Microsoft Access that
Database Normalization Tutorial
Interested in normalizing your database? About Databases offers a series of articles designed to introduce you to this important topic: Database
Defending Against SQL Injection
The vast majority of databases in use today have some form of web interface, allowing internal and/or external users easy access through familiar browser
Create an Access Database Using a Template
Microsoft provides quite a few prebuilt database templates to assist you in jumpstarting your database development process. In this tutorial, we'll walk
Microsoft Access Database Templates
These database templates will help you kick-start your database development. Why reinvent the wheel when you can begin your project using a pre-built template?
Oracle RAC Real Application Clusters
Oracle 10g now offers Real Application Clusters, a technology known as Oracle RAC. This shared-everything approach breaks the one database/one server
Databases for Beginners
In our Databases for Beginners section, we provide a series of articles introducing you to the basic principles of relational databases. You'll learn how to
Restricting Oracle Access with Virtual Private Databases
Virtual private databases (VPDs) allow you to take Oracle row-level security to the next level. This technology allows you to dynamically add a WHERE clause to
Tab Forms in Access
In a recent forum posting, Andrew wrote: If anyone can help me with the following I'd be very grateful. I'm creating a form in Access97 and 3/4 of the
Backing Up Access 2002 to a CD
In a recent forum posting, Bernie wrote: Does anyone know how to copy Access 2002 to a CD? I need to make a backup copy of my database in case my computer
Choosing a Database for Your Business
Oracle, SQL Server, Microsoft Access, MySQL, DB2, Paradox. There are quite a variety of database products on the market today, making the selection of a
MCITP Database Developer Learning Plan
Interested in pursuing certification as a Microsoft Certified IT Professional in the Database Developer track? Microsoft's customized learning plan tool can
Database NULL Values: An Introduction
Users new to the world of databases are often confused by a special value particular to our field – the NULL value. This value can be found in a field
Help With a Complex Access Report
In a recent forum posting, gsurber wrote: Ok, I have a database with multiple tables: one table that lists a selection of ITEMS and a bunch of them that
Use Windows themes in controls on forms
Did you know that you can take advantage of Windows themes in Microsoft Access? You can instruct Access to make your database leverage the user's current
Converting Time Durations from FileMaker Pro to Access
In a recent forum posting, Mimi wrote: I have a FileMaker 5 database I've been using to track my swimming time. I now have a new PC and have switched to XP
Create a Microsoft Access 2007 Database from Scratch
In an earlier article, we reviewed the process for creating an Access database from a template. While this is certainly an agreeable, easy approach to building
Should You Upgrade Your SQL Server Cluster to 2005?
Are you still running an older version of SQL Server? If so, you're not alone. Many organizations have put off this potentially costly upgrade as they
Alpha Five Tutorial
Looking for information on the Alpha Five database platform? This introductory tutorial provides you with an introduction to the platform along with details on
Mailing Labels in Microsoft Access
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
Top-Ranked Database Software
Desktop databases offer simple, flexible solutions for data storage and retrieval. They're often quite sufficient to meet uncomplicated database requirements
Tab Forms in Microsoft Access
In a recent forum posting, Andrew Ralton wrote: I'm creating a form in Access97 and 3/4 of the way through inputting data in the form I figured that it
Top SQL Server Performance Issues
SQL Server databases serve as the back end of many critical applications and have the potential to act as a performance bottleneck. According to Microsoft,
What Database Should I Use?
You've finally buckled down and decided that it's time to purchase a database solution for your home or business. What type of database do you need? It's
New Databases Glossary Definitions
We've added the following new definitions to our Databases Glossary: Inference PL/SQL SQL Injection Transact-SQL For the definitions of other terms,
Normalization Tutorial for Databases
If you've been working with databases for a while, chances are you've heard the term normalization. Perhaps someone's asked you Is that database normalized?
Using Stored Procedures in Microsoft SQL Server
Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable
Help with Access Forms
In a recent forum posting, Chad Thomas wrote: I have set up a form using a query. While I can enter data and the data does go to the table, when I close and
Perl vs. PL/SQL
In a recent blog posting, John Russell compares the Perl and PL/SQL languages. It's an interesting comparison for anyone with a background in Perl programming
Primary Keys and Foreign Keys in Databases
As you may already know, databases use tables to organize information. (If you don’t have a basic familiarity with database concepts, read What is a Database?)
New Databases Glossary Definitions
We've added the following new definitions to our Databases Glossary: Database Relationships One-to-One Relationships One-to-Many Relationships
Creating Relationships in Microsoft Access 2007
The true power of relational databases lies in their ability to track relationships (hence the name!) between data elements. However, many database users don’t
Time Card Database Template
Looking for a database to track employee time and payroll? The time card Access database template from Microsoft offers a great starting point. This free
Microsoft Access Database Security: Encryption and Password Protection
Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process of
Oracle Security Basics
In a recent article on Oracle.com, the company provides seven steps for getting started with Oracle security. The high-level summary includes: Learn common
Railroad Database
In a recent forum posting, Thomas Agnew wrote: My name is Thomas Agnew, and I am new to these forums. Railroads are my passion and I use Microsoft Train
Create an Access 2007 Form
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn’t always an appropriate tool for every data entry situation.
Deleting Records from a MySQL Database
In a recent forum posting, Dave wrote: Hi, I wrote an online prayer page script for my church and all is working well except for the fact of deletions. I
What's New In Access 2007?
Trying to decide if you should make the switch and upgrade to Microsoft Access 2007? With a hefty pricetag, it's a decision you should consider carefully.
Databases Lessons for Beginners
Are you new to the world of databases? Wondering where to get started? In this series of articles, we introduce you to the basics of database technology and
Updating Access through VBScript ADO
In a recent forum posting, Ray Reynolds wrote: I am using vbscript to make a connection to an access database using ADODB. When I run the script in VB6 the
What Database Should I Choose?
You've finally buckled down and decided that it's time to purchase a database solution for your home or business. What type of database do you need? It's
Customizing the Quick Access Toolbar in Access 2007
The Quick Access Toolbar provides you with immediate access to commonly used functions in Microsoft Access 2007. In this tutorial, we explore the process of
Oracle Space Management with Segment Advisor
Having trouble managing space utilization in your Oracle database? The Oracle segment advisor may be just the tool you need. Introduced in Oracle 10g, the
Searching Access Reports
In a recent forum post, yeppy12 writes: Hi. I am wondering if there is a way to search a report created in Access. I have a report that is about 50 pages
CUBE and ROLLUP SQL Statements
Looking for a quick, efficient way to summarize the data stored in your database? The SQL ROLLUP and CUBE commands offer a valuable tool for gaining some quick
Editing a String in Access
In a recent forum posting, KristinWhite2001 wrote: I have a string that contains unwanted data at the end. Example: Name/Domain I want to remove the
Microsoft Announces SQL Server 2008 Beta Program
At TechEd 2007, Microsoft announced the availability of the first Community Technology Preview (CTP) of SQL Server 2008 (formerly codenamed Katmai). There
Autonumber and Combo Boxes in Access
In a recent forum posting, Brian Buchanan wrote: I am trying to figure out if there is a way to link the format of an autonumber to a choice made in a combo
Creating Tables in Microsoft SQL Server
SQL Server databases rely upon tables to store data. In this tutorial, we explore the process of designing and implementing a database table in Microsoft
SQL Server 2005 Express Edition
If you're looking for a serious database platform, but don't want to shell out the big bucks for SQL Server, you might want to consider SQL Server 2005 Express
Subscribe to the About Databases RSS Feed
If you're involved in databases and would like our latest content pushed directly to you, I'm pleased to announce that About Databases now offers an RSS feed
Are You Testing SQL Server 2008?
Did you download the SQL Server 2008 Community Technology Preview yet? I'm in the process of writing SQL Server 2008 For Dummies, so I've been playing with it
Help with SQL MAX() Function
In a recent forum posting, Anand wrote: I am trying to select vendors with last date of their transaction (accounting date). For this I have joined vendor
Importing a Delimited File
Recently, RinkRat37 visited our forum and posed the following question: I am trying to import an ansi, .dat, delimited file and am having trouble becuse it
Introducing Microsoft Office Access 2007
Are you using Microsoft Access 2007? If you're contemplating switching to the new version, but haven't yet made the plunge, you might be interested in these
Creating Databases and Tables Using SQL
Are you ready to begin creating databases and tables with the Structured Query Language? Join us as we explore the process of creating tables and databases
Substituting Text for Values in Access Reports
In a recent forum posting, BeeMarie wrote: I want to change the way some of the fields in my report show the data. I have a field for example that puts a
Retention Reports
In a recent forum posting, Adam wrote: I am looking to create a retention report in access for customers who have not renewed their yearly passes.
Microsoft SQL Server Data Types
Selecting appropriate data types is one of the most important considerations when designing a SQL Server database. Choices you make in the database design phase
Automatically Deleting Data in MySQL
In a recent forum posting, Dave wrote: Hi, I wrote an online prayer page script for my church and all is working well except for the fact of deletions. I
Primary Keys and Foriegn Keys in Databases
As you may already know, databases use tables to organize information. (If you don’t have a basic familiarity with database concepts, read What is a Database?)
Creating a Database with Alpha Five
In this video tutorial, Alpha Five's developers walk you through the process of using their platform to quickly create a database for a fictitious dog-washing
Oracle Security Patches
Oracle issued a major Critical Patch Update last week, announcing the availability of 45 patches for a variety of Oracle products. Oracle stresses the
Database Backups in Microsoft Access 2007
Backing up your Microsoft Access databases is an important part of protecting your critical data. In this tutorial, we walk through the process of backing up
Time-Based SQL Queries
In a recent forum posting, Legrooch wrote: I have a problem with specific query. I don't know how to write it... :/ I have: Time_stop | Time_Start
SQL Server Virtualization and Licensing
Enterprises are increasingly taking advantage of virtual machines to run enterprise systems, including databases. This technology introduces interesting
Expense Report Database for Microsoft Access
Microsoft offers a free expense report database template for Microsoft Access 2003. This template allows you to track expense reports by employee and expense
3-D Visualization Database Performance
In a recent forum posting, zima73 wrote: I have created a visualization software using VB.NET. The tool retrieves geometrical information stored in MS
Warehouse Inventory Database System
In a recent forum posting, Tammy wrote: I am looking for a good set-up for an internal inventory/warehouse tracking. I will need this to do reports, and
Creating Access Reports in PDF Format
Adobe Acrobat (.PDF) offers a great method of sharing data across the Internet while preserving formatting. It's simple to generate these files from an Access
Choosing Between SQL Server Compact Edition and SQL Server Express
Microsoft now offers two free versions of SQL Server designed for use on the desktop: SQL Server Compact Edition and SQL Server Express. Is one of these free
Filling Out Government Forms Automatically from an Access Database
In a recent forum posting, Mike wrote: I have a rather large db that I am needing to pipe information to an acrobat file. I am not looking to a straight
Data Mining in SQL Server 2008
Donald Farmer, Microsoft's Principal Program Manager for SQL Server Business Intelligence, offers a video preview of SQL Server 2008's data mining
Choosing a Database
Database management systems (or DBMSs) can be divided into two categories -- desktop databases and server databases. Generally speaking, desktop databases are
Averaging Columns By Group
In a recent forum posting, Beginner Olive wrote: I need to find the average of a column for every hour for each group. The range table has data for every 30
SQL Self-Joins
You can use a self-join to simplify nested SQL queries where the inner and outer queries reference the same table. These joins allow you to retrieve related
SQL Server Upgrade Stories
Interested in the experiences other enterprises had upgrading their Microsoft SQL Server installations? Microsoft offers a number of case studies detailing the
Codd's Rules for Relational Database Design
In 1985, database pioneer Dr. E.F. Codd laid out twelve rules of relational database design. These rules provide the theoretical (although sometimes not
Search and Replace in Access
In a recent forum posting, Deb SC wrote: I have created a monthly report that has quite a few calculations based on a query. Every month I create a new
SQL Server Users Conference, September 18-21
Looking for a great professional development opportunity? The Professional Association for SQL Server hosts its 2007 PASS Community Summit from September
Conditional Logic in Access Reports
In a recent forum posting, Manfran wrote: I have a report based on a query. It's meant to display a complete order, which is based on two tables,
Hiding Microsoft Access Tabbed Documents View
Access 2007 introduces the tabbed document format found in other Microsoft Office products. In some cases, you may wish to hide these tabs to change the look
Oregon Court Database
In a recent forum posting, Steven Henry wrote: I will be purchasing the data contained in OJIN(Oregon Judicial Information Network) from The State of
How Many Database Platforms Is Too Many?
In a recent forum posting, JohnRte66 wrote: I have a client that is purchasing a new server-based DB app. But a division of that company, which is quite
SQL Server High Availability Webcast
Looking for more information on Microsoft SQL Server's high availability features? Microsoft offers a free, online webcast covering: Database server failure
Database Relationships in Microsoft Access: For the Dogs?
In a recent forum posting, CedarFarm wrote: I am new at Access and have a situation I don't know how to deal with. I have a table called DOG. Each record is
Stored Procedures vs. Functions in Microsoft SQL Server
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
SQL Interface Data Security
In a recent forum posting, accondios wrote: I would like to initiate a discussion regarding a client for a SQL db. Specifically, I want to have all users
Microsoft SQL Server Tops Oracle in Security Showdown?
Recently, an industry analyst posted the results of security study comparing three top databases: Microsoft SQL Server, Oracle and MySQL. Based upon those
Microsoft SQL Server and Oracle Interoperability
Microsoft recently announced that Oracle's PeopleSoft, Siebel and JD Edwards products are now available for Microsoft SQL Server 2005. This interoperability
Reporting in Alpha Five: Video Tutorials
Interested in learning more about Alpha Five's reporting capabilities? The company now offers two video tutorials, totalling 38 minutes in length, that walk
SQL Server Transaction Isolation Models
Normally, it's best to allow SQL Server to enforce isolation between transactions in its default manner; after all, isolation is one of the basic tenets of the
Access or SQL Server?
In a recent forum posting, jChappy wrote: We are currently using MS Access as our main dbase management system. However, due to expansion and greater
Converting Numbers to Dates in Access
In a recent forum posting, GrinderJoe wrote: Someone just gave me an old database to work on, and the dates are all stored in text fields with values like
Queries Taking Too Long in Microsoft Access 2007
In a recent forum posting, Mark Nichol wrote: I have setup a Point of Sale (POS) system. It queries and calculates nine different totals and displays them
Downloading the Northwind Sample Database
Looking for a copy of the Northwind sample database for Microsoft Access? This database provides you with a great opportunity to practice your database skills
Track Your Home Inventory In Microsoft Access
If you're looking to create an inventory of your possessions for insurance purposes, this home inventory database template provides an excellent starting point.
Oracle Certified Associate (OCA) Preparation
In a recent forum posting, Richa Kulkarni asked: I'm preparing for OCA 1Z0-007 paper. Can anyone guide me on how to start? Do you have any advice for
Partitioning a SQL Server Database Table
Looking to optimize the performance of your SQL Server database? If your database contains very large tables, you may benefit from partitioning those tables
Finding Gaps in Date Ranges using Transact-SQL
Auditors and accountants often use date range gaps to detect missing data in financial records. For example, if a log of database transactions shows no activity
Help with Access SQL Query in Visual Basic for Applications
In a recent forum posting, Gary Tu wrote: I am using Access 2003 and I have a problem executing some SQL code in VBA. The code I need to run is: Set dbs =
Convert an Access 95 Database into an Access 2007 File
Do you have an old Access 95 MDB database that you'd like to bring into Access 2007? You can't directly convert from Access 95 format to the ACCDB format used
SQL Server Binary Large Object (BLOB) Data Types
SQL Server offers a variety of formats for storing large binary objects. In our article SQL Server Data Types, we explore the various data types available to
Table Import Security in Microsoft Access
In a recent forum posting, Shmuel wrote: I have developed a database in MS Access which I wish to distribute but I have a security issue. It is language
SQL Server Backup Types and Scopes
One of the major advantages that enterprise-class databases offer over their desktop counterparts is a robust backup and recovery feature set. Microsoft SQL
Gartner 2007 Magic Quadrant for Databases
Earlier this month, Gartner released their well-known Magic Quadrant analysis of the data warehouse database management systems market in 2007. If you're not
Partitioning Data Warehouse Tables
In a recent forum posting, Cooper Austin wrote: How do I partition an EXISTING very large SQL Server table that is a fact table in a DW Schema. I want to
Using SharePoint with Microsoft Access
Looking to easily share and manage data in your organization with Microsoft SharePoint Services? In addition to using this collaboration tool for traditional
Normalizing Relational Databases
If you've been working with databases for a while, chances are you've heard the term normalization. Perhaps someone's asked you Is that database normalized?
Creating Alerts with SQL Server Agent
SQL Server allows you to automatically notify database administrators when unusual circumstances occur. This powerful alerting mechanism enables 24-hour
SQL Server 2008 Platform Vision
SQL Server 2008 is coming soon! Microsoft released the most recent Community Technology Preview (CTP) in July and I've heard rumors from several industry
SQL Server 2008 November CTP Coming Soon!
Microsoft announced at TechEd this week that The November Community Technology Preview (CTP) for Microsoft SQL Server 2008 is available for customer download
When Should I Use a Function Instead of a Stored Procedure?
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
Summing Multiple COUNT Queries
In a recent forum posting, Sarah wrote: I have multiple Count queries in a database and need to write a query that will allow me to sum the results of the
SQL Server Recovery Models
SQL Server provides three different recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster.
New Record Button Disabled in Microsoft Access
In a recent forum posting, Access.Ignorant wrote: I'm new to Access and I am totally lost. I am trying to add a new record, but the New Record button is
SQL Server 2008 November CTP (CTP5) Released
Microsoft released SQL Server 2008 CTP5 to beta testers last week. It's now available for download on the Microsoft Connect site. This CTP includes a number
Time Values in Textbox Controls
In a recent forum posting, Kurtis Lee wrote: I hope someone can help me with this small problem. I would like to know how to program a textbox control to
What's New in SQL Server 2008?
In a recent interview, SQL Server MVP Brad McGehee offered some observations about Microsoft's pending release of SQL Server 2008. His thoughts, in a nutshell,
Expanding the Detail Section in Access Forms
In a recent forum posting, Lesley wrote: I've got an Access database with a form where the detail section is really small. It looks a bit like when in excel
SQL Server Transaction Log Shrinking and Truncation
The transaction log plays a critical role in a SQL Server database: it maintains an ongoing record of database activity crucial for the restoration of recent
Payroll Database in Microsoft Access
In a recent forum posting, Bright wrote: I have been trying to come up with a simple payroll system using Microsoft Access. Is there a template or anyone
SQL Server 2008 Certification Webcast Wednesday
Interested in what the coming release of SQL Server 2008 means for your Microsoft certifications? The Microsoft Certification group is hosting two Live Meeting
Updating an Access Database with Excel Data
In a recent forum posting, JustinWH wrote: We have an established database that we currently use with our marketing programs. Some of these marketing
Top N By Group SQL Query
In a recent forum posting, LJBC asked: I have a query listing indivuals with various amounts assigned to them. I am trying to find the top 5 values by
Access 2007 Service Pack 1 Available
Are you using Microsoft Access 2007? If so, be sure to take a look at the recently released Microsoft Office 2007 SP1. This service pack contains a number of
Book Review: Rational Guide to Access 2007 Templates
Zac Woodall's book provides an excellent introduction to creating and sharing Microsoft Access database templates. It's a wonderful reference for anyone who
Try Out SQL Server 2008 with Virtual Labs
In an effort to promote the upcoming release of SQL Server 2008, Microsoft TechNet is providing users with access to Virtual Labs that allow you to try out the
SQL Server 2008 Learning Portal
Microsoft recently posted the SQL Server 2008 Learning Portal, providing a single reference point for access to SQL Server education resources. The portal
Sorting Roman Numerals in Access
In a recent forum posting, Georgia Alexiou wrote: I have a database of employees and their assignment levels, rated Roman Numerals I-IX. I need to give the
Accessing Oracle, SQL Server and MySQL Data Sources in Alpha Five
Did you know that Alpha Five offers the Alpha Data Access Objects (AlphaDAO) technology, enabling you to draw upon external data sources that might exist within
Top 5 Microsoft Access 2007 Books for Beginners
So, you'd like to learn more about Microsoft Access 2007 and you don't know where to begin. I've selected five of my favorite introductory-level Access books
SQL Server's Simple Recovery Model
The simple recovery model is just that: simple. In this approach, SQL Server maintains only a minimal amount of information in the transaction log. SQL Server
FoxPro Application Development
In a recent forum posting, Eric wrote: I developed a FoxPro database application over 15 years ago for my father. He now needs that application rewritten
Strikethrough in Microsoft Access
In a recent forum posting, Steve Cone wrote: I need to be able to create a score sheet that will allow a strike through using a forward slash. The sheet
Determining Database Storage Requirements
Wondering how much space you should allocate for your database? There are two commonly used techniques. Both start by determining the size of a typical row
Choosing a Database for a Car Dealership
In a recent forum posting, Jim wrote: My spouse originally created an Excel workbook with multiple monthly spreadsheets to manage back end sales and profits
Study Finds Oracle Patches Go Unapplied
A recent study by Sentrigo, a database security firm, revealed that most Oracle DBAs don't apply Oracle Critical Patch Updates, according an article in
PCI DSS for Database Professionals
The Payment Card Industry Data Security Standard (PCI DSS) sets forth the security requirements for organizations that store, process and/or transmit credit
Microsoft Delays SQL Server 2008 Release Date
On Friday, Microsoft announced that they will delay the release of SQL Server 2008 until the third quarter of 2008. They're not canceling the February launch
Forms with Tab Control
In a recent forum posting, Wil wrote: I created a form with the tab control button and have 2 tabs: A & B. On the A screen, I have a command button that
Regression Analysis
Regression is the oldest and most well-known statistical technique that the data mining community utilizes. Basically, regression takes a numerical dataset and
Multiple Linked Excel Tables in Access
In a recent forum posting, ADICAPRI1 wrote: Hi, I am trying to find out some information to search multiple linked excel files and spit out a report based
SQL Server 2008 Date and Time Data Types
With the introduction of SQL Server 2008, Microsoft answered the pleas of many database professionals by introducing revamped date and time . These new data
Selecting a Random Database Record
In a recent forum posting, GoodGraces3 asked: Is there a way to display a record at random in Microsoft Works Database? Do you have any advice for
Classification Analysis
Working with categorical data or a mixture of continuous numeric and categorical data? Classification analysis might suit your needs well. This technique is
Nutrition Database in Microsoft Access
The nutrition database allows you to use Microsoft Access to track your dietary and exercise habits, track and chart your weight over time and plan your meals.
Including Attachments in an Access Database
Microsoft Access allows you to include attachments in database tables. You may store photos, graphics, documents and other files in your Access database using
Access Database Passwords
Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process of
Fundraising Database Template for Non-Profits
Microsoft's Office Online provides a charitable contributions database template for Access 2007 that allows you to track your fundraising campaign. Organized
Update Queries in Access
In a recent forum posting, ASherbuck wrote: Hello, I am relatively new to Access and I have a question regarding Update Queries. I have a database full of
"Feature Complete" SQL Server 2008 CTP Released
Microsoft recently released a feature complete Community Technology Preview (CTP) of SQL Server 2008. This release marks the first true, fully functional
Classroom Management Database Template
The free Classroom Management Database Template available from Microsoft allows Access 2003 (and later) users the ability to manage all aspects of a school's
Moving an Access Database
In a recent forum posting, RitaJack wrote: How do I move an Access database from my old computer to my new one? I am working with Access 2000. I copied
Date and Time Stamps In Microsoft Access
There are many applications where you may wish to add a date/time stamp to each record, identifying the time that the record was added to the database. It’s
Service Call Management Database Template
Looking for a database to track service calls for your business? Microsoft offers a free Service Call Management Database Template for users of Access 2003 (or
Merging from Microsoft Word into an Access Database
In a recent forum posting, Nate wrote: Ok, so I'm trying to merge only certain text into Access but I can't seem to get them in the right columns in my
Are We Ready for SQL Server 2008?
SQL Server Magazine recently published an interesting discussion with Microsoft's Ted Kummert questioning the world's readiness for SQL Server 2008.
Using COUNT and COUNT(*) in SQL
SQL provides the COUNT function to retrieve the number of records in a table that meet given criteria. We can use the COUNT(*) syntax alone to retrieve the
Collecting Information for an Access Database by E-mail
Microsoft Access allows you to collect information from individuals and update your database automatically based upon their replies. Access includes a wizard
SQL Punctuation
In a recent forum posting, ArchSeeker wrote: Over the past few weeks I have independently been researching and practicing SQL with postgreSQL, MySQL, Open
Negotiating Contract Terms with Oracle
In a recent article on SearchOracle, Barney Beal provides some good advice for negotiating contract terms with Oracle. His basic advice falls into three
Reports Disappearing in Access
In a recent forum message, Jim wrote: I'm new to this particular forum, but have been around the graphic design, desktop publishing site for a while, which
Meeting Tracker Database Template
The Meeting Tracker sample database for Microsoft Access 2007 allows you to track all of the details associated with your meetings. It includes the ability to
SQL Server Backup Compression Test Results
In a recent post on the SQL Server Customer Advisory Team blog, Lindsey Allen and Thomas Grohser report the results of testing SQL Server 2008's backup
Help with VBA User Input
In a recent forum posting, Scott wrote: I'm working on a complex database and I'm having some trouble. Can someone help or point me in the right direction?
SQL Server Upgrade Advisor
Microsoft provides the SQL Server 2008 Upgrade Advisor (SSUA) to help you detect upgrade issues before they occur. This tool examines your SQL Server 2000 and
Common SQL Server Security Vulnerabilities
Kevin Beaver provides an interesting article on SearchSQLServer detailing the most commonly overlooked SQL Server security vulnerabilities. Some highlights
Relationship Management Software for Microsoft Access
In a recent forum posting, Dean asked: Is there a program (or way) either in Access or by a third party that deals with relationship management? For
Top Access 2007 Books
So, you'd like to learn more about Microsoft Access 2007 and you don't know where to begin. Here are my five favorite introductory-level Access books for your
Oracle Fine Grained Access Control
Oracle's Fine Grained Access Control (FGAC) provides a row-level security mechanism that's built-in to the Oracle database engine. FGAC allows you to
Purging Duplicate Survey Responses in Access 2003
In a recent forum posting, Dann wrote: I am relatively new to Access 2003. I have a web survey that exports to an access database. The survey is designed
Creating Traces with SQL Server Profiler
Traces allow you to track the specific actions performed against a SQL Server databases. They provide valuable information for troubleshooting database issues
Implementing User Level Security in Microsoft Access
User-level security is quite powerful. It allows you to control the types of data that a user might access (for example, prohibiting sales personnel from
Displaying ODBC Dialog Boxes to Access Users
In a recent forum posting, Brainhose wrote: Anyone have a code snippet for calling the ODBC dialog so an Access user can select the DSN they wish to use? I
Database Hacking Techniques: SQL Injection
The vast majority of databases in use today have some form of web interface, allowing internal and/or external users easy access through familiar browser
Music Collection Database Template
This music collection database template from Microsoft's Office Community allows you to track your music collection by recording name, artist, genre, label,
Additions to Access Function Library: EuroConvert, Exp, and FV
We've added information and examples of three new functions to our Microsoft Access Function Library. Check out the new pages on: EuroConvert() Exp() FV()
Refreshing the Access 2007 GUI
In a recent forum posting, Brainhose wrote: I sometimes run code to maintain data which deletes tables or queries and then recreates them. The Access 2007
Reinstalling Help in Microsoft Office
In a recent forum posting, Brainhose wrote: I did an install of Access 2000 on my PC that already had Word and Excel 2000. Even though I selected to
Credit Card Security for Databases (PCI DSS)
The Payment Card Industry Data Security Standard (PCI DSS) sets forth the security requirements for organizations that store, process and/or transmit credit or
Creating Database Links in Oracle
Many times, database administrators find it necessary to link two remote databases to each other for the purpose of sharing data. Oracle provides database
Transferring Checkboxes from Excel to Access
In a recent forum posting, Sue wrote: I have a report that when transferred to Excel does not show the checkboxes. Other reports work fine. I am using
Testing Web Applications for SQL Injection Vulnerabilities
SQL Injection attacks pose tremendous risks to web applications that depend upon a database backend to generate dynamic content. In this type of attack,
Creating Relationships in Microsoft Access 2007
The true power of relational databases lies in their ability to track relationships (hence the name!) between data elements. However, many database users don’t
Matrix Data Storage in Microsoft Access
In a recent forum posting, Rjones_17 wrote: I’m new to Microsoft Access and need some advice. I’m currently attempting to map out the offsets of ships,
Microsoft Access Database Security: Encryption and Password Protection
Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process of
Slowly Changing Dimensions in SQL Server 2005
In a recent article on SQL Server performance, Dinesh Asanka provides a helpful introduction to the use of slowly changing dimensions (SCD) in SQL Server 2005.
Streaming Media Database
In a recent forum posting, krnoble wrote: We recently changed the format on a commercial radio station that we operate. The previous format was wildly
Compact and Repair an Access Database
Over time, Microsoft Access databases grow in size and unnecessarily use disk space. Additionally, repeated modifications to the database file may result in
Databases for Beginners
In our Databases for Beginners section, we provide a series of articles introducing you to the basic principles of relational databases. You'll learn how to
Top Ten Things to Do While Waiting for SQL Server 2008
Are you tired of waiting for SQL Server 2008? I just posted a list to my Amazon Author's Blog of the Top Ten Things to Do While Waiting for SQL Server 2008.
Forms in Access Databases
In a recent forum posting, Priya_23 wrote: I'm pretty new to using Access. I have just created a database in access by importing the data on my excel
Introduction to MySQL
Database professionals around the world are heralding the release of MySQL 5, just in time for the holiday season! This major release of the popular open-source
Access 2007 Compatibility Issues?
In a recent forum posting, Sue Hopkins wrote: I created a database using Access 2003. When a user opened it with Access 2007, most of the switchboard was
Additions to Access Function Library: Hex(), Hour() and IIf()
We've added information and examples of three new functions to our Microsoft Access Function Library. Check out the new pages on: Hex() Hour() IIf()
SQL Server Agent Alerts
SQL Server allows you to automatically notify database administrators when unusual circumstances occur. This powerful alerting mechanism enables 24-hour
SQL Server 2008 Release Candidate 0 (RC0) is Here!
This week, Microsoft released SQL Server 2008 RC0. This major step in the development of the new product indicates that we're not far away from seeing the
Free Databases: Too Good to be True?
In a recent forum posting, Dan wrote: It seems a lot of the information I've come across says that server database can run an expensive bill. But, I was
Using the Ribbon in Access 2007
If you’re switching to Microsoft Access 2007 from an earlier version, you’re bound to immediately notice some major changes in the user interface. Microsoft
Too Many Reports and Queries in Access
In a recent forum posting, Emilia wrote: I seem to have too many reports and queries. For example, I have several reports each slightly different with its
Using TRY…CATCH to Handle SQL Server Errors
The TRY…CATCH statement in Transact-SQL allows you to detect and handle error conditions gracefully within your database applications. This statement is the
Credit Card Security for DBAs (PCI DSS)
The Payment Card Industry Data Security Standard (PCI DSS) sets forth the security requirements for organizations that store, process and/or transmit credit
Real Estate Investment Database
In a recent forum posting, picako wrote: Hello all, I am a very new user to Microsoft Access and I'm not sure if I can do what I want to with it. I
Access Database Copying Itself!
In a recent forum posting, Beth wrote: I have a Access database loaded on a company shared folder and when my end user closes the database a new one is
Oracle Database Pricing
Oracle recently announced new U.S. price lists for commercial and government customers of the following products: Oracle Technology Products Oracle
SQL Database Normalization
If you've been working with databases for a while, chances are you've heard the term normalization. Perhaps someone's asked you Is that database normalized?
Conditional Triggers
In a recent forum posting, Mustafa wrote: I have a checkbox and button on my form and a Trigger(for insert) on one of my database tables called Table1. If
Additions to Access Function Library: InStr(), InStrRev() and Int()
We've added information and examples of three new functions to our Microsoft Access Function Library. Check out the new pages on: Int() InStr() InStrRev()
Access Database Backups
Backing up your Microsoft Access databases is an important part of protecting your critical data. In this tutorial, we walk through the process of backing up
SQL Server Replication Scenario
In a recent forum posting, RAS wrote: We connected two SQL Server Standard Edition servers using replication. Let me call the first one as the Main Server
Database Jobs: Career Opportunities in Databases
If you've been reading the IT industry's help wanted ads recently, there's no doubt you've come across a number of ads seeking professional database
Bookmarks Database Template for Microsoft Access
The Bookmarks Database Template for Access 2007 allows you to easily organize, rate and categorize websites for future reference. It's available for free from
Joining Data from Three or More Tables with an SQL INNER JOIN
You can use SQL JOIN statements to combine data from three or more tables. In an earlier article, we took a look at using inner joins and outer joins to combine
Accounting Ledger Database Template for Microsoft Access
The Accounting Ledger Database Template for Access 2003 allows you to create a basic chart of accounts and transaction ledger. It's available for free from the
Oracle Patches Numerous Security Holes with July CPU
As part of its quarterly Critical Patch Update (CPU), Oracle released 45 security fixes for a wide range of products, including the 9i, 10g and 11g Oracle
Patient Database
In a recent forum posting, mbuffet wrote: I have a PatientID field in 2 different tables (General Information and Diagnosis) so that I can make a
Merging Access Databases
In a recent forum posting, Sam wrote: Is it possible to merge lots (200 or more) of individual Access files into one single file? Each one will contain an
Database Certifications
Are you a database professional seeking to polish your resume in the hopes of landing a better gig? Perhaps you're just getting started in database
Sorting out SMALLDATETIME, DATETIME and TIMESTAMP in SQL Server
SQL Server 2005 offers three different data types that all sound like likely candidates for storing time values: DATETIME, SMALLDATETIME, and TIMESTAMP. Here's
Upsizing from Access to SQL Server
In a recent forum posting, Data Analyst wrote: I am trying to use the upsizing wizard to upsize an Access database to an SQL Server database. However, the
PDF Reports from an Access Database
Adobe Acrobat (.PDF) offers a great method of sharing data across the Internet while preserving formatting. It's simple to generate these files from an Access
Creating a Mailing List in Microsoft Access
One of the most common uses of a Microsoft Access database is generating labels for mass mailings. In this tutorial, we examine the process of creating mailing
Microsoft Certified Application Specialist (MCAS) Program Requirements
If you use Microsoft Access 2007 as a regular part of your job, or you hope to gain employment in the field of user-level databases, you may wish to consider
Help with the MAX() function
In a recent forum posting, aoneistheman wrote: I'm a SQL newbie, and am creating this crazy view of other views. I need help using the MAX() function. I
SQL Server 2008 is Here!
Earlier this month, Microsoft announced the release to manufacturing (RTM) of SQL Server 2008. You can download a 180-day evaluation edition of SQL Server 2008
Oracle 11g Certification Programs
In this article, we'll take a brief look at the Database Administrator track and the three possible certifications you can earn on your way to Master status.
Access to SQL Server Replication
In a recent forum message, ICCLEARLY wrote: We are looking for a way to set up replication between several remote MS Access databases and a central MS SQL
Highlight Search Results in Access 2007
Allan Browne recently posted an Access form he developed that allows users to search for data within a database and then highlight the results, Google-style.
Choosing a SQL Server Authentication Mode
Microsoft SQL Server 2008 offers administrators two choices of performing user authentication: Windows authentication mode and mixed authentication mode. Making
Volunteer Opportunities in Databases
In a recent forum message, Don asked whether anyone knows of any volunteer opportunities for database professionals. He wrote: Who or what parties/outfits
Developing Access Programs in C and C++
Are you a software developer interested in leveraging the database capabilities of Microsoft Access in your programs? A recent white paper by Microsoft's
Creating a Backup of an Access Database
In a recent forum message, cscheible wrote: Hello -- I am needing to backup Microsoft Access 2002 database before I upgrade it to Access 2007. I have never
New Databases Glossary Definitions
We've added the following new definitions to our Databases Glossary: Authentication Database Relationships One-to-One Relationships One-to-Many
Call for Proposals: MySQL Conference and Expo
Done something interesting with MySQL recently? Want to share your experiences with the MySQL community? The 2009 MySQL Conference and Expo may be the perfect
Constraints in Microsoft Access
In a recent forum message, TJ McDevitt asks: I am using Microsoft Access to build a database that will store employee data. I am using VBA to write macros
Choosing the Right Editon of Microsoft SQL Server 2008
SQL Server 2008 is the latest release in Microsoft’s enterprise relational database platform series. In this substantial upgrade, they've packed the new
Isolation Models in Microsoft SQL Server
Normally, it's best to allow SQL Server to enforce isolation between transactions in its default manner; after all, isolation is one of the basic tenets of the
Tracking Employee Training in a Database
In a recent forum posting, Doc wrote: I am new to the forum and a greenhorn at access. I have tinkered with it some but see it is a powerful tool. I am
Ten Commandments of Microsoft Access
Have you read the Ten Commandments of Microsoft Access? This collection of gems from Dev Ashish includes such pearls of wisdom as: Thou shalt choose a
Multiuser Databases in Microsoft Access
In a recent forum posting, blewis70 wrote: I am very new to using Access but have created a database that I would like to use at the office. There are