Prestwood eMag
Our monthly opt-in coupons+newsletter.
|
 portal.prestwood.com
|
|
| 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 myHostCafe.com. 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.
 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).
Normalization
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:
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:
http://www.oracle.com/database/berkeley-db/xml/index.html
Error: 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.
Explanation: 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:
Question: How do you store BLOBs (Binary Large Objects) in Microsoft SQL Server?
Answer: 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.
|
|
|
DBA
Print This
DBA 
