Database Table
56 Stories
Prevent Outlook from adding the country field in Word
Techguide Writing letters in Word should be a breeze; however, Outlook may throw a snag in the process. Mary Ann Richardson walks you through the steps of how to block Outlook from automatically adding the country field to your letters.
Tags: Microsoft Outlook
Create and format picture bullets in Word
Techguide Find out how easy it is to create and format picture bullets using Word's AutoFormat feature.
Tags: Software, Personal applications, Microsoft Office
Create a survey form in Word
Techguide One of the best ways to gauge user responses and collect data is with a survey. In this Word tip, Mary Ann Richardson explains how to create a customized survey form, step by step.
Prevent Excel from turning fractions into dates
Techguide Excel can recognize cell entries as fractions if the appropriate fraction format is applied to the cell before data is entered.
Tags: Microsoft Office, Fraction, Cell, Printer, Microsoft Excel, Printing, Microsoft Corp., Microsoft PowerPoint, Microsoft Access, database table
Perils of adding fields to database tables
Techguide Adding a field to a database table can cause all sorts of problems, if you’re not careful. Read about two such scenarios, and how you can plan for their occurrence.
Tags: Databases, Database management, Storage, Field, Table, Database, Database Table, Sales, Database Table Sale, ProductCode
Policy-Based Management in SQL Server 2008
Techguide New to SQL Server 2008 is Policy-Based Management, which gives administrators more control over their database procedures.
Tags: Servers, Databases, Microsoft SQL Server, Database, Policy, Database Table, stored procedure, DDL, Condition, Facet
Use an Excel array function to create an AverageIf function
Techguide Excel has SumIf and CountIf, but no AverageIf. However, with a little array magic, you can get Excel to average values, conditionally.
Tags: Microsoft Office, Microsoft Corp., Database, Tool, Database Table, clip art, Mouse, Microsoft Excel, Microsoft Access, dialog box
Teradata: Fending off rivals with focus on data warehousing
Techguide Teradata has been increasingly mentioned by the likes of Oracle and Hewlett-Packard so much so you have to wonder what all the hubbub is about.
Tags: Data Management, Data centers, Databases, Medicare, Wells Fargo & Co., data mining, entertainment, data warehouse, Teradata, Data centers
Enhance the administration interface when storing images in SQL Server
Techguide This ASP.NET article offers one approach to providing a useful interface that provides all features necessary to properly maintain data.
Bulk importing data into SQL Server
Techguide If you work with databases, at some point, you’ll deal with inserting data into SQL Server from outside data files.
Preserve log table entries using autonomous transactions in Oracle
Techguide Developers can use autonomous transactions in Oracle to "step outside" the main transaction and do work that commits independently.
Create secure virtual private databases in Oracle
Insight Oracle's virtual private database table feature allows for the creation of customized data objects that don't physically exist but can be virtually generated out of objects that do. Here's how to implement it.
Let Word 2007 proofread documents with a mouse click
Techguide Need a proofreader? Word 2007 comes with a feature that can check your spelling, grammar, and style. Mary Ann Richardson tells how you can set up Word Options to catch errors with a single command.
Tags: Microsoft Office
Oracle Tip: Choosing an efficient design for Boolean column values
Techguide When designing a database table structure, it's important to choose an efficient strategy for storing a logical Boolean that you can use in many programming environments. Find out how from this Oracle expert.
Tags: Database management, Databases
Consider MD5 checksums for application passwords
Techguide Learn to combat the risk of unauthorised access to application passwords by storing a checksum or hash key for a username/password combination.
Tags: Security, Authentication and encryption, Databases
