Regression Analysis
Thursday January 31, 2008
Regression is the oldest and most well-known statistical technique that the data mining community utilizes. Basically, regression takes a numerical dataset and develops a mathematical formula that fits the data. ... Read More
Forms with Tab Control
Tuesday January 29, 2008
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 ... Read More
Microsoft Delays SQL Server 2008 Release Date
Sunday January 27, 2008
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 party (hey, why ... Read More
PCI DSS for Database Professionals
Thursday January 24, 2008
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 ... Read More
Study Finds Oracle Patches Go Unapplied
Tuesday January 22, 2008
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 InformationWeek this week.
The survey reached 305 ... Read More
Choosing a Database for a Car Dealership
Sunday January 20, 2008
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 (F&I) for a motor vehicle dealership. ... Read More
Bulk Logged Recovery Model in SQL Server
Thursday January 17, 2008
The bulk-logged recovery model is a special-purpose model that works in a similar manner to the full recovery model. The only difference is in the way it handles bulk data ... Read More
Determining Database Storage Requirements
Tuesday January 15, 2008
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 (based upon ... Read More
Strikethrough in Microsoft Access
Sunday January 13, 2008
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 will ... Read More
SQL Server's Simple Recovery Model
Thursday January 10, 2008
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 truncates the transaction log ... Read More
FoxPro Application Development
Tuesday January 8, 2008
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 since it will not ... Read More
Top 5 Microsoft Access 2007 Books for Beginners
Sunday January 6, 2008
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 for your perusal.
Read Top ... Read More
Accessing Oracle, SQL Server and MySQL Data Sources in Alpha Five
Thursday January 3, 2008
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 your organization? AlphaDAO ... Read More
Sorting Roman Numerals in Access
Tuesday January 1, 2008
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 Roman Numerals a ... Read More