Thursday March 6, 2014
Administrators may wish to take advantage of SQL Server's backup compression capabilities. Backup compression technology uses mathematical algorithms to shrink the size of database backups.
Read more: SQL Server Backups
Tuesday March 4, 2014
It's hard to cut through the noise and understand what you really need in a Business Intelligence and Analytics solution. Peter Sondergaard, senior vice president at Gartner said: "Information is the oil of the 21st century, and analytics is the combustion engine," which is a great analogy to get your head around what a Business Intelligence software can offer. Because analytics is the engine that drives businesses to make the smartest and most accurate decisions, the software you choose for analysis is like picking out a car: there's a lot to consider and a big difference between the engine of a BMW and the engine of a Ford Pinto.
Read our guest post by Saar Bitner of SiSense
: Choosing a BI Solution
Thursday February 27, 2014
Password protecting an Access database allows you to protect your sensitive data from prying eyes. Encrypted databases require a password to open. Users attempting to open the database without the correct password will be denied access. Additionally, users attempting to directly access the database's ACCDB file will not be able to view any of the data contained within it, as the encryption obscures the data from view by those without the proper password.
Read the full story: Encrypting Access 2013 Databases
Tuesday February 25, 2014
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 Access using the built-in Label Wizard. We begin with a database containing the address data and walk you step-by-step through the process of creating and printing your mailing labels.
Read the full story: Printing Mailing Labels in Access 2013