Your full service technology partner! 
-Collapse +Expand
Search DBA Group:

-Collapse +Expand DBA Store

Prestwood eMagazine

January Edition
Subscribe now! It's Free!
Enter your email:

   ► eMag   Print This    All Groups  
View Group Edition:
Full Edition Your Edition || Prev Next || Subscription Center

Prestwood IT Newsletter Apr 2015 Issue - DBA Edition


Start subscribing now! It's free!

Each month on or after the 1st, and only once a month, we will send you content from up to 5 community groups. If you select this DBA group, you'll receive the following content below mixed in with the other groups you elect to include.

Prestwood eMag
Our monthly opt-in coupons+newsletter.
  April 2015 - DBA Edition Year 17 Issue 4  
Your full service technology partner!

Expert guidance from working professionals!
Web & Marketing Services Info topic:
Domain Transfer
by Gerald Renton

Transfer domain to One or more years is added to your domain registration usually at $9.99/year (i.e. .com price). A minimum of only 1 year needs to be added to transfer.

Coding Services Info topic:
Project Management
by Mike Prestwood

Project management. Generally project management ranges from 10% to 30% of a project budget. However, the amount of project management required depends on the project.

IT Water-Cooler for Power-Users topic:
Windows GREP - Great Tool
by Wes Peterson

You know (or think) the file is out there.  You have a pretty good idea about one or two things that are (or ought) to be in it.  Find it fast with Windows GREP.

 DBA Group Top 
Visit Group | My Group Settings
Desktop Databases topic (classic post):
MAPI - or Something Better
by Wes Peterson
Most development tools give us easy access to MAPI. Some offer MAPI as the ONLY easy way to send email. Still, is MAPI the best way to go?

DBA & Data topic (classic post):
Data Normalization - The Normal Forms
by Jeffrey K. Tyzzer

by Jeffrey K. Tyzzer. In 1970, Dr. E.F. Codd's seminal paper "A Relational Model for Large Shared Databanks" was published in Communications of the ACM. This paper introduced the topic of data normalization, so-named because, at the time, President Nixon was normalizing relations with China.

Data normalization is a technique used during logical data modeling to ensure that there is only one way to know a fact, by removing all structures that provide more than one way to know the same fact as represented in a database relation (table). The goal of normalization is to control and eliminate redundancy, and mitigate the effects of modification anomalies -- which are generally insertion and deletion anomalies. (Insertion anomalies occur when the storage of information about one attribute requires additional information about a second attribute. Deletion anomalies occur when the deletion of one fact results in the loss of a second fact).

There are six generally recognized normal forms of a relation: first normal form, second normal form, third normal form, Boyce/Codd normal form, fourth normal form, and fifth normal form, also called projection/join normal form. Other normal forms (e.g., Domain/Key) exist but will not be discussed here. The normal forms are hierarchical, i.e., each normal form builds upon its predecessor. Although many people consider a relation to be normalized only when it is in third normal form, technically speaking, a relation in only first normal form can be considered...

 Monthly DBA Lesson
Microsoft SQL Server Topic:
Code Snippet of the Month

In MS-SQL, to move an object such as a table or view from one schema to another, use alter schema.

alter schema [ToSchema] transfer FromSchema.[Object] 


For example, the following moves the Orders table from the user1 schema t the dbo schema.

alter schema [dbo] transfer user1.[Orders] 
DBA & Data Topic:
Definition of the Month: Optimistic Locking
A locking mechanism that allows other users to edit a record that is currently being edited. Essentially, last in wins or edits are discarded usually with an error.
DBA & Data Topic:
Download of the Month: Oracle Berkely DB XML
MS SQL 2008 Topic:
Documented Error of the Month: MS SQL 2008 Saving Changes Not Permitted

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.


In MS SQL 2008, if you get a Saving Changes Not Permitted error, you can easily fix this error in Management Studio. Uncheck the Prevent saving changes that require table re-creation option. 

Desktop Databases Topic:
Resource Link of the Month: Icon plug-in for Photoshop and Paint Shop Pro

When we create applications, we usually need one or more icons. We'll definitely want a main program icon - in several sizes. We may also want another icon for our setup program.

Sometimes our client supplies icon files, but often they do not.

There are some great tools available for creating and managing Icons. One of my favorites, IconLover, is available at the site this link is about.

But most out-of-the-box, general purpose graphics editors lack support for the Windows .ICO file format. The solution is at this link, and it's free: It's a plug-in for Photoshop and Paint Shop Pro (even some version of Photoshop Elements).

At the bottom of this link's page, you'll find an entry for "Icon Plug-In for PhotoShop." Simply download the zip file, unzip, and follow the instructions in the ReadMe.txt file.

Your favorite, general purpose graphics editor will now be able to deal with ICO files!

MS SQL 2005 Topic:
FAQ of the Month: MS-SQL Binary Large Objects
Question: How do you store BLOBs (Binary Large Objects) in Microsoft SQL Server?


BLOBs (Binary Large Objects) are collections of data that can be stored as a single entity in a database. In Microsoft SQL Server, BLOBs are stored using the text, ntext, and image data types.

  • The text data type stores a variable length of non-unicode data up to 231 - 1 characters.
  • The ntext data type stores a variable length of unicode data up to 230 - 1 characters. The storage size, in bytes, is twice the amount of characters.
  • The image data type is used to store image files smaller than 231 - 1 bytes.

Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site:

©1995-2022 Prestwood IT Solutions.   [Security & Privacy]