I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

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

   ► KB ►► Role-Based T...DBA & Data   Print This    All Groups  

DBA, Databases, & Data Most Read KB Posts

Page Contents


Most Read KB Articles Since 3/28/2008

DBA, Databases, & Data Group

  KB Article    

Bryan Valencia
1. Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. ... service-specific error code -2146885628

Error: Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code -2146885628.

The Solution: Opened the "properties" dialog for the service, and on the Log On tab, changed the user from "This Account" to "Local System Account".  Started the service, and bingo.

Posted to KB Topic: Microsoft SQL Server
9 years ago, and updated 8 years ago
(9 Comments , last by Pervez.J )

Error
Nothing New Since Your Last Visit
39475
Hits

Jeffrey K. Tyzzer
2. Data Element Naming Standard This paper articulates the standard for naming data elements (entity attributes).
Posted to KB Topic: DBA & Data
17 years ago, and updated 12 years ago
(3 Comments )

Article
Nothing New Since Your Last Visit
33942
Hits

Bryan Valencia
3. MSSQL Update Trigger Example

This tutorial shows how you would create a trigger in Microsoft SQL Server 2005/2008 that will date/timestamp a column named last_updated everytime any data in the row is updated.

This example assumes a primary key that includes 3 fields.

Posted to KB Topic: MS SQL 2005
11 years ago, and updated 10 years ago
(1 Comments , last by mprestwood )

Code
Nothing New Since Your Last Visit
21934
Hits

Wes Peterson
4. Icon plug-in for Photoshop and Paint Shop Pro http://www.aha-soft.com/products.htm
Posted to KB Topic: Desktop Databases
11 years ago

Link
Nothing New Since Your Last Visit
20658
Hits

Mike Prestwood
5. nmefwmi.exe

Error: nmefwmi.exe has stopped working

Solution: This error is caused by a defect in 11g limited to Windows Vista. The nmefwimi.exe is an Oracle 11g service used by dbconsole (OaracleDBConsoleorcl). You can stop this service to stop this error then set it's Startup Type to Manual to prevent it from returning. Doing so will not affect your database. When you need to use dbconsole, start the service manually.

Also, check with Oracle for an update that fixes this issue.

Posted to KB Topic: Oracle 11g
10 years ago, and updated 10 years ago
(1 Comments , last by jjeffman )

Error
Nothing New Since Your Last Visit
20549
Hits

Jeffrey K. Tyzzer
6. Corporate Database Administration Corporate database admin standard first published by Prestwood Software in 1996.
Posted to KB Topic: DBA & Data
17 years ago, and updated 12 years ago

Article
Nothing New Since Your Last Visit
19467
Hits

Mike Prestwood
7. Char vs NChar What is the differences between Char, NChar, VarChar, and NVarChar?
Posted to KB Topic: Microsoft SQL Server
11 years ago

FAQ
Nothing New Since Your Last Visit
19052
Hits

Wes Peterson
8. Application Virtualization: The Good, the Bad, the Ugly

Virtualization is a concept greatly expanded in Vista. This article discusses the impact of Application Virtualization on you development. It can have a huge impact on how the programs you write will behave when installed on Vista.

Posted to KB Topic: Desktop Databases
11 years ago, and updated 11 years ago
(1 Comments , last by Uta.G )

Article
Nothing New Since Your Last Visit
18548
Hits

Mike Prestwood
9. dBASE Table Specification Description of dBASE IV field types
Posted to KB Topic: DBA & Data
17 years ago
(1 Comments )

KB Post
Nothing New Since Your Last Visit
16183
Hits

Bryan Valencia
10. Geolocation: Step by Step

Think globally, act locally.  How many times have you needed to determine the geographic distance between two places?  This tutorial will show you how to accomplish just that.

All data and functions exist in a SQL Server Database, and can be used in VB.NET, C#.NET, Paradox, Delphi, or any other language that can call a database function.

Posted to KB Topic: SQL Servers
9 years ago, and updated 9 years ago
(3 Comments , last by mprestwood )

Article
Nothing New Since Your Last Visit
16154
Hits



Most Read by Members

DBA, Databases, & Data Group

  KB Article    

Mike Prestwood
1. BDE BDE is an acronym for Borland Database Engine (previously referred to as IDAPI and before that it was ODAPI).
Posted to KB Topic: DBA & Data
16 years ago, and updated 11 years ago

Definition
Nothing New Since Your Last Visit
12046
Hits

Joshua Delahunty
2. Data Migration, Paradox to SQL Server

some tips for data migration, especially with bitfield, or "logical" field types.

Posted to KB Topic: DBA & Data
13 years ago, and updated 9 years ago

KB Post
Nothing New Since Your Last Visit
14462
Hits

Jeffrey K. Tyzzer
3. Data Element Naming Standard This paper articulates the standard for naming data elements (entity attributes).
Posted to KB Topic: DBA & Data
17 years ago, and updated 12 years ago
(3 Comments )

Article
Nothing New Since Your Last Visit
33942
Hits

Wes Peterson
4. Databases: Which are Best? Which databases Prestwood Software prefers - and why.
Posted to KB Topic: DBA & Data
13 years ago, and updated 11 years ago
(1 Entries , last by mprestwood )

Blog
Nothing New Since Your Last Visit
13874
Hits

Wes Peterson
5. Application Virtualization: The Good, the Bad, the Ugly

Virtualization is a concept greatly expanded in Vista. This article discusses the impact of Application Virtualization on you development. It can have a huge impact on how the programs you write will behave when installed on Vista.

Posted to KB Topic: Desktop Databases
11 years ago, and updated 11 years ago
(1 Comments , last by Uta.G )

Article
Nothing New Since Your Last Visit
18548
Hits

Bryan Valencia
6. Geolocation: Step by Step

Think globally, act locally.  How many times have you needed to determine the geographic distance between two places?  This tutorial will show you how to accomplish just that.

All data and functions exist in a SQL Server Database, and can be used in VB.NET, C#.NET, Paradox, Delphi, or any other language that can call a database function.

Posted to KB Topic: SQL Servers
9 years ago, and updated 9 years ago
(3 Comments , last by mprestwood )

Article
Nothing New Since Your Last Visit
16154
Hits

Bryan Valencia
7. General SQL Optimization Tips

In this article, you will be shown a few generic methods to optimize your SQL queries.  This information is not database-specific (other than in a few places) and should apply to any SQL based database.

Posted to KB Topic: SQL Servers
9 years ago

KB Post
Nothing New Since Your Last Visit
7514
Hits

Wes Peterson
8. Application Manifests, Revisited for Vista Since the introducton of XP, Windows programs have benefitted from an application "Manifest." This was covered in an earlier article. This is an update to that information, pertaining to Windows Vista
Posted to KB Topic: Desktop Databases
11 years ago

KB Post
Nothing New Since Your Last Visit
8283
Hits

Jeffrey K. Tyzzer
9. Data Normalization - The Normal Forms

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...

Posted to KB Topic: DBA & Data
17 years ago, and updated 11 years ago

Article
Nothing New Since Your Last Visit
12554
Hits

Wes Peterson
10. Granting Execute Permissions for Stored Procedures

Need to grant EXECUTE permission to a low-permission user for all the Stored Procedures in your database?

The code in this article will do the trick for you.

Posted to KB Topic: Microsoft SQL Server
5 years ago
(2 Comments , last by mcalsky.m )

Article
Nothing New Since Your Last Visit
5017
Hits
Icon Legend:
Recent or not:
- Recent activity (within last two weeks).
- No activity last two weeks.
 Since your last logged visit:
- New to you or updated since your last visit (sign in now to activate).
- NOT new to you since your last visit (sign in now to activate).
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech