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
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 Wizard
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
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 Avatar
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 Access
Friday May 9, 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
Tuesday May 6, 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 Business
Thursday May 1, 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. Databases
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 2012
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 Databases