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

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

October 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 Oct 2015 Issue - DBA Edition

Subscribe!

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.
portal.prestwood.com
  October 2015 - DBA Edition Year 17 Issue 10  
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.






 DBA Group Top 
Visit Group | My Group Settings
DBA & Data topic (classic post):
SQL Server Express
by Joshua Delahunty
Tips on setup of SQL Server Express

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:
Definition of the Month: Standard Delimited Format (SDF)
SDF is an acronym for standard delimited format. An SDF is a text file formatted in a particular style. Each field is enclosed in quotation marks and separated by a comma. Each line ends with a carriage return and a linefeed.SDF is an acronym for standard delimited format. An SDF is a text file formatted in a particular style. Each field is enclosed in quotation marks and separated by a comma. Each line ends with a carriage return and a linefeed.
DBA & Data Topic:
Download of the Month: Oracle Berkely DB XML
http://www.oracle.com/database/berkeley-db/xml/index.html
MS SQL 2008 Topic:
Documented Error of the Month: MS SQL 2008 Saving Changes Not Permitted
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: Windows Virtualization
List of resources provided by Microsoft about Windows Virtualization which was introduced with Vista.
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?

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.


Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


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