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

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

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

   ► KBDBA Knowledge Base  Print This    All Groups  

DBA, Databases, & Data Tech Articles

These Articles are contributed by you (our online community members). They are organized by our knowledge base topics. Specifically, by the DBA sub-topics.

Contribute an Article

33 DBA, Databases, & Data Articles

Group: DBA, Databases, & Data


Topic: ANSI SQL Scripting

When you have a concatenation of two or more CHAR or VARCHAR fields in a SELECT statement, and one of the fields is NULL, the resulting value will be NULL.
Posted By Scott Wehrly, Post #100030, KB Topic: ANSI SQL Scripting
  +Add Comment  (1 Comments)

To find duplicate values in the same field, you need to use an alias with the same table twice.
Posted By Mike Prestwood, Post #100061, KB Topic: ANSI SQL Scripting
  +Add Comment




Topic: DBA & Data

Reference of common table structures
Posted By Mike Prestwood, Post #100054, KB Topic: DBA & Data
  +Add Comment

Corporate database admin standard first published by Prestwood Software in 1996.
Posted By Jeffrey K. Tyzzer, Post #100055, KB Topic: DBA & Data
  +Add Comment

This paper articulates the standard for naming data elements (entity attributes).
Posted By Jeffrey K. Tyzzer, Post #100058, KB Topic: DBA & Data
  +Add Comment  (3 Comments)

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

Posted By Joshua Delahunty, Post #100362, KB Topic: DBA & Data
  +Add Comment

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 By Jeffrey K. Tyzzer, Post #100059, KB Topic: DBA & Data
  +Add Comment

List of common field names, along with suggested field type and length. These are only suggestions and shouldn't be taken as gospel. Use as a starting point.
Posted By Mike Prestwood, Post #100002, KB Topic: DBA & Data
  +Add Comment

Which databases Prestwood Software prefers - and why.
Posted By Wes Peterson, Post #100406, KB Topic: DBA & Data
  +Add Comment  (1 Comments)

Description of dBASE IV field types
Posted By Mike Prestwood, Post #100056, KB Topic: DBA & Data
  +Add Comment  (2 Comments)

For several years now, Object Relational databases have intrigued many developers, myself included. Most of us also rely on more traditional RDBMS systems. Well, a debate is raging, and you're invited to join.
Posted By Wes Peterson, Post #100583, KB Topic: DBA & Data
  +Add Comment

You can automate the installation and configuration of Oracle software, either fully or partially, by specifying a response file when you start the Oracle Universal Installer.
Posted By swawsji, Post #101294, KB Topic: DBA & Data
  +Add Comment

Tip about renaming tables in SQL Server 2005
Posted By Joshua Delahunty, Post #100363, KB Topic: DBA & Data
  +Add Comment

Tips on use of SQL Server 2005 Database Diagramming Tool
Posted By Joshua Delahunty, Post #100364, KB Topic: DBA & Data
  +Add Comment

Tips on setup of SQL Server Express
Posted By Joshua Delahunty, Post #100361, KB Topic: DBA & Data
  +Add Comment




Topic: Desktop Databases

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 By Wes Peterson, Post #100816, KB Topic: Desktop Databases
  +Add Comment

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 By Wes Peterson, Post #100818, KB Topic: Desktop Databases
  +Add Comment  (1 Comments)

Overview of DDE.

Posted By Mike Prestwood, Post #100146, KB Topic: Desktop Databases
  +Add Comment

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?
Posted By Wes Peterson, Post #100544, KB Topic: Desktop Databases
  +Add Comment  (3 Comments)

For a while, now, Windows has supported a new mechanism for installing applications: MSI. This is quite a bit different than the familiar setup.exe, and here we begin exploring the differences - and the significance of MIS installations.
Posted By Wes Peterson, Post #100817, KB Topic: Desktop Databases
  +Add Comment  (2 Comments)

21. singledate

plumber toronto | plumber mississauga | plumbing companies toronto | plumbing services toronto | plumbing toronto | plumbing mississauga | plumbers near me toronto | plumbers near me mississauga | Plumbing Repair Toronto | plumbing companies mississauga | plumbing services mississauga | Drain Repair Toronto | Drain Cleaning Toronto | Clogged Drain Toronto | Emergency Plumber Toronto | Basement Waterproofing Toronto | Water Line Upgrade Toronto | Sewer Backup Toronto | Plumbing Services Scarborough | Plumbing Services Etobicoke | Plumbers Scarborough | Plumbers Etobicoke | Plumbing companies Etobicoke | Plumber Near Me in Etobicoke | Plumbers in Etobicoke | Emergency Plumber Etobicoke | Plumber Etobicoke Toronto | Plumbers MississaugaPlumber Mississauga | Plumbing Mississauga | Best Plumbers Mississauga | Plumbing Contractors Mississauga | Mississauga Plumbers | Plumbing Companies Mississauga | Plumbing Company Mississauga | Plumbing Repair Mississauga | Mississauga Plumber | Plumbing Services Mississauga | Plumbing Service Mississauga | Drain Repair Mississauga | Drain Cleaning Mississauga | Drain Cleaning Mississauga | Drain Service Mississauga | Clogged Drain Mississauga | Clogged Toilet Mississauga | Drains Blockage Mississauga | Drain Inspection Mississauga | Sewer Line Replacement Mississauga | Water Line Replacement Mississauga | Drain Experts Mississauga | Emergency Plumber Mississauga | Sewer Backup Mississauga | Floor Drain Backup Mississauga | Clogged Drain Repair Mississauga | Basement Waterproofing Mississauga | Sump Pump Installation Mississauga | Sump Pump Installation Mississauga | Backwater Valve Installation Mississauga | OYO | OYO BOOK | OYOBOOK | Free ads Posting | Free Listing Business | free business listing sites | top free business listing sites | indian business listing sites | Australia business listing sites | US business listing sites | USA business listing sites | UK business listing sites | Free Classifieds | Business directory | business directory in india | business directory in Australia | business directory in USA | business directory in US | business directory in UK | business e-commerce | business listings | business website | business marketplace | companies business listings | companies database india | companies database Australia | companies database USA | companies database UK | companies database US | companies directory | companies directory india | companies directory Australia | companies directory US | companies directory USA | companies directory UK | directory of companies | directory of indian companies | directory of Australia companies | directory of UK companies | directory of US companies | directory of USA companies | e-commerce in india | e-commerce in Australia | e-commerce in UK | e-commerce in USA | e-commerce in US | free business marketplace | online marketplace | online business directory | yellow pages | Call Girls in Agra | VIP Call Girls in Agra | College Call Girls in Agra | Celebrity Call Girls in Agra | Independent Call Girls in Agra | Housewives Call Girls in Agra | High profile Call Girls in Agra | OYO Rooms in agra | OYO Hotel in agra | OYO Hotels in agra | OYO Rooms agra | OYO Hotel agra | OYO Hotels agra | Call Girls Agra | VIP Call Girls Agra | College Call Girls Agra | Celebrity Call Girls Agra | Housewives Call Girls Agra | Independent Call Girls Agra | High profile Call Girls Agra | Escorts in Agra | VIP Escorts in Agra | College Escorts in Agra | Celebrity Escorts in Agra | Independent Escorts in Agra | Housewives Escorts in Agra | High profile Escorts in Agra | Escorts Agra | VIP Escorts Agra | College Escorts Agra | Celebrity Escorts Agra | Independent Escorts Agra | Housewives Escorts Agra | High profile Escorts Agra | Agra Call Girls | VIP Agra Call Girls | College Agra Call Girls | Celebrity Agra Call Girls | Independent Agra Call Girls | Housewives Agra Call Girls | High profile Agra Call Girls | Call Girls in bengaluru | VIP Call Girls in bengaluru | College Call Girls in bengaluru | Celebrity Call Girls in bengaluru | Independent Call Girls in bengaluru | Housewives Call Girls in bengaluruHigh profile Call Girls in bengaluru | OYO Rooms in bengaluru | OYO Hotel in bengaluru | OYO Hotels in bengaluru | OYO Rooms bengaluru | OYO Hotel bengaluru | OYO Hotels bengaluru | Call Girls bengaluru | VIP Call Girls bengaluru | College Call Girls bengaluru | Celebrity Call Girls bengaluru | Housewives Call Girls bengaluru | Independent Call Girls bengaluru | High profile Call Girls bengaluru | Escorts in bengaluru | VIP Escorts in bengaluru | College Escorts in bengaluru | Celebrity Escorts in bengaluru | Independent Escorts in bengaluru | Housewives Escorts in bengaluru | High profile Escorts in bengaluru | Escorts bengaluru | VIP Escorts bengaluru | College Escorts bengaluru | Celebrity Escorts bengaluru | Independent Escorts bengaluru | Housewives Escorts bengaluru | High profile Escorts bengaluru | bengaluru Call Girls | VIP bengaluru Call Girls | College bengaluru Call Girls | Celebrity bengaluru Call Girls | Independent bengaluru Call Girls | Housewives bengaluru Call Girls | High profile bengaluru Call Girls | Call Girls in dehradun | VIP Call Girls in dehradun | College Call Girls in dehradun | Celebrity Call Girls in dehradun | Independent Call Girls in dehradun | Housewives Call Girls in dehradun | High profile Call Girls in dehradun | OYO Rooms in dehradun | OYO Hotel in dehradun | OYO Hotels in dehradun | OYO Rooms dehradun | OYO Hotel dehradun | OYO Hotels dehradun | Call Girls dehradun | VIP Call Girls dehradun | College Call Girls dehradun | Celebrity Call Girls dehradun | Housewives Call Girls dehradun | Independent Call Girls dehradun | High profile Call Girls dehradun | Escorts in dehradun | VIP Escorts in dehradun | College Escorts in dehradun | Celebrity Escorts in dehradun | Independent Escorts in dehradun | Housewives Escorts in dehradun | High profile Escorts in dehradun | Escorts dehradun | VIP Escorts dehradun | College Escorts dehradun | Celebrity Escorts dehradun | Independent Escorts dehradun | Housewives Escorts dehradun | High profile Escorts dehradun | dehradun Call Girls | VIP dehradun Call Girls | College dehradun Call Girls | Celebrity dehradun Call Girls | Independent dehradun Call Girls | Housewives dehradun Call Girls | High profile dehradun Call Girls | Call Girls in delhi | VIP Call Girls in delhi | College Call Girls in delhi | Celebrity Call Girls in delhi | Independent Call Girls in delhi | Housewives Call Girls in delhi | High profile Call Girls in delhi | OYO Rooms in delhi | OYO Hotel in delhi | OYO Hotels in delhi | OYO Rooms delhi | OYO Hotel delhi | OYO Hotels delhi | Call Girls delhi | VIP Call Girls delhi | College Call Girls delhi | Celebrity Call Girls delhi | Housewives Call Girls delhi | Independent Call Girls delhi | High profile Call Girls delhi | Escorts in delhi | VIP Escorts in delhi | College Escorts in delhi | Celebrity Escorts in delhi | Independent Escorts in delhi | Housewives Escorts in delhi | High profile Escorts in delhi | Escorts delhi | VIP Escorts delhi | College Escorts delhi | Celebrity Escorts delhi | Independent Escorts delhi | Housewives Escorts delhi | High profile Escorts delhi | delhi Call Girls | VIP delhi Call Girls | College delhi Call Girls | Celebrity delhi Call Girls | Independent delhi Call Girls | Housewives delhi Call Girls | High profile delhi Call Girls | Call Girls in gurgaon | VIP Call Girls in gurgaon | College Call Girls in gurgaon | Celebrity Call Girls in gurgaon | Independent Call Girls in gurgaonHousewives Call Girls in gurgaon | High profile Call Girls in gurgaon | OYO Rooms in gurgaon | OYO Hotel in gurgaon | OYO Hotels in gurgaon | OYO Rooms gurgaon | OYO Hotel gurgaon | OYO Hotels gurgaon | Call Girls gurgaon | VIP Call Girls gurgaon | College Call Girls gurgaon | Celebrity Call Girls gurgaon | Housewives Call Girls gurgaon | Independent Call Girls gurgaon | High profile Call Girls gurgaon | Escorts in gurgaon | VIP Escorts in gurgaon | College Escorts in gurgaon | Celebrity Escorts in gurgaon | Independent Escorts in gurgaon | Housewives Escorts in gurgaon | High profile Escorts in gurgaon | Escorts gurgaon | VIP Escorts gurgaon | College Escorts gurgaon | Celebrity Escorts gurgaon | Independent Escorts gurgaon | Housewives Escorts gurgaon | High profile Escorts gurgaon | gurgaon Call Girls | VIP gurgaon Call Girls | College gurgaon Call Girls | Celebrity gurgaon Call Girls | Independent gurgaon Call Girls | Housewives gurgaon Call Girls | High profile gurgaon Call Girls | Call Girls in haridwar | VIP Call Girls in haridwar | College Call Girls in haridwar | Celebrity Call Girls in haridwar | Independent Call Girls in haridwar | Housewives Call Girls in haridwar | High profile Call Girls in haridwar | OYO Rooms in haridwar | OYO Hotel in haridwar | OYO Hotels in haridwar | OYO Rooms haridwar | OYO Hotel haridwar | OYO Hotels haridwar | Call Girls haridwar | VIP Call Girls haridwar | College Call Girls haridwar | Celebrity Call Girls haridwar | Housewives Call Girls haridwar | Independent Call Girls haridwar | High profile Call Girls haridwar | Escorts in haridwar | VIP Escorts in haridwar | College Escorts in haridwar | Celebrity Escorts in haridwar | Independent Escorts in haridwar | Housewives Escorts in haridwar | High profile Escorts in haridwar | Escorts haridwar | VIP Escorts haridwar | College Escorts haridwar | Celebrity Escorts haridwar | Independent Escorts haridwar | Housewives Escorts haridwar | High profile Escorts haridwar | haridwar Call Girls | VIP haridwar Call Girls | College haridwar Call Girls | Celebrity haridwar Call Girls | Independent haridwar Call Girls | Housewives haridwar Call Girls | High profile haridwar Call Girls | Call Girls in jaipur | VIP Call Girls in jaipur | College Call Girls in jaipur | Celebrity Call Girls in jaipur | Independent Call Girls in jaipur | Housewives Call Girls in jaipur | High profile Call Girls in jaipur | OYO Rooms in jaipur | OYO Hotel in jaipur | OYO Hotels in jaipur | OYO Rooms jaipur | OYO Hotel jaipur | OYO Hotels jaipur | Call Girls jaipur | VIP Call Girls jaipur | College Call Girls jaipur | Celebrity Call Girls jaipur | Housewives Call Girls jaipur | Independent Call Girls jaipur | High profile Call Girls jaipur | Escorts in jaipur | VIP Escorts in jaipur | College Escorts in jaipur | Celebrity Escorts in jaipur | Independent Escorts in jaipur | Housewives Escorts in jaipur | High profile Escorts in jaipur | Escorts jaipur | VIP Escorts jaipur | College Escorts jaipur | Celebrity Escorts jaipur | Independent Escorts jaipur | Housewives Escorts jaipur | High profile Escorts jaipur | jaipur Call Girls | VIP jaipur Call Girls | College jaipur Call Girls | Celebrity jaipur Call Girls | Independent jaipur Call Girls | Housewives jaipur Call Girls | High profile jaipur Call Girls | lawyer in ghaziabad | advocate in ghaziabad | Bets lawyer in ghaziabad | Bets advocate in ghaziabad | criminal lawyer in ghaziabad | criminal advocate in ghaziabad | Bets criminal lawyer in ghaziabad | Bets criminal advocate in ghaziabad | family lawyer in ghaziabad | family advocate in ghaziabad | Bets family lawyer in ghaziabad | Bets family advocate in ghaziabad | lawyer in Noida | advocate in Noida | Bets lawyer in Noida | Bets advocate in Noida | criminal lawyer in Noida | criminal advocate in Noida | Bets criminal lawyer in Noida | Bets criminal advocate in Noida | family lawyer in Noida | family advocate in Noida | Bets family lawyer in Noida | Bets family advocate in Noida | lawyer in Delhi | advocate in Delhi | Bets lawyer in Delhi | Bets advocate in Delhi | criminal lawyer in Delhi | criminal advocate in Delhi | Bets criminal lawyer in Delhi | Bets criminal advocate in Delhi | family lawyer in Delhi | family advocate in Delhi | Bets family lawyer in Delhi | Bets family advocate in Delhi | lawyer in hapur | advocate in hapur | Bets lawyer in hapur | Bets advocate in hapur | criminal lawyer in hapur | criminal advocate in hapur | Bets criminal lawyer in hapur | Bets criminal advocate in hapur | family lawyer in hapur | family advocate in hapur | Bets family lawyer in hapur | Bets family advocate in hapur | lawyer in bulandshahr | advocate in bulandshahr | Bets lawyer in bulandshahr | Bets advocate in bulandshahr | criminal lawyer in bulandshahr | criminal advocate in bulandshahr | Bets criminal lawyer in bulandshahr | Bets criminal advocate in bulandshahr | family lawyer in bulandshahr | family advocate in bulandshahr | Bets family lawyer in bulandshahr | Bets family advocate in bulandshahr | lawyer in India | advocate in India | Bets lawyer in India | Bets advocate in India | criminal lawyer in India | criminal advocate in India | Bets criminal lawyer in India | Bets criminal advocate in India | family lawyer in India | family advocate in India | Bets family lawyer in India | Bets family advocate in India | Call Girls in mumbai | VIP Call Girls in mumbai | College Call Girls in mumbai | Celebrity Call Girls in mumbai | Independent Call Girls in mumbai | Housewives Call Girls in mumbai | High profile Call Girls in mumbai | OYO Rooms in mumbai | OYO Hotel in mumbai | OYO Hotels in mumbai | OYO Rooms mumbai | OYO Hotel mumbai | OYO Hotels mumbai | Call Girls mumbai | VIP Call Girls mumbai | College Call Girls mumbai | Celebrity Call Girls mumbai | Housewives Call Girls mumbai | Independent Call Girls mumbai | High profile Call Girls mumbai | Escorts in mumbai | VIP Escorts in mumbai | College Escorts in mumbai | Celebrity Escorts in mumbai | Independent Escorts in mumbai | Housewives Escorts in mumbai | High profile Escorts in mumbai | Escorts mumbai | VIP Escorts mumbai | College Escorts mumbai | Celebrity Escorts mumbai | Independent Escorts mumbai | Housewives Escorts mumbai | High profile Escorts mumbai | mumbai Call Girls | VIP mumbai Call Girls | College mumbai Call Girls | Celebrity mumbai Call Girls | Independent mumbai Call Girls | Housewives mumbai Call Girls | High profile mumbai Call Girls | Call Girls in noida | VIP Call Girls in noida | College Call Girls in noida | Celebrity Call Girls in noida | Independent Call Girls in noida | Housewives Call Girls in noida | High profile Call Girls in noida | OYO Rooms in noida | OYO Hotel in noida | OYO Hotels in noida | OYO Rooms noida | OYO Hotel noida | OYO Hotels noidaCall Girls noida | VIP Call Girls noida | College Call Girls noida | Celebrity Call Girls noida | Housewives Call Girls noida | Independent Call Girls noida | High profile Call Girls noida | Escorts in noida | VIP Escorts in noida | College Escorts in noida | Celebrity Escorts in noida | Independent Escorts in noida | Housewives Escorts in noida | High profile Escorts in noida | Escorts noida | VIP Escorts noida | College Escorts noida | Celebrity Escorts noida | Independent Escorts noida | Housewives Escorts noida | High profile Escorts noida | noida Call Girls | VIP noida Call Girls | College noida Call Girls | Celebrity noida Call Girls | Independent noida Call Girls | Housewives noida Call Girls | High profile noida Call Girls | Call Girls in pune | VIP Call Girls in pune | College Call Girls in pune | Celebrity Call Girls in pune | Independent Call Girls in pune | Housewives Call Girls in pune | High profile Call Girls in pune | OYO Rooms in pune | OYO Hotel in pune | OYO Hotels in pune | OYO Rooms pune | OYO Hotel pune | OYO Hotels pune | Call Girls pune | VIP Call Girls pune | College Call Girls pune | Celebrity Call Girls pune | Housewives Call Girls pune | Independent Call Girls pune | High profile Call Girls pune | Escorts in pune | VIP Escorts in pune | College Escorts in pune | Celebrity Escorts in pune | Independent Escorts in pune | Housewives Escorts in pune | High profile Escorts in pune | Escorts pune | VIP Escorts pune | College Escorts pune | Celebrity Escorts pune | Independent Escorts pune | Housewives Escorts pune | High profile Escorts pune | pune Call Girls | VIP pune Call Girls | College pune Call Girls | Celebrity pune Call Girls | Independent pune Call Girls | Housewives pune Call Girls | High profile pune Call Girls | Call girls in gurgaon | Call girls gurgaon | gurgaon Call girls | Escorts in Gurgaon | Call girls in Gurgaon | Call girls gurgaon | gurgaon Call girls | Escorts in Gurgaon | Call girls in Haridwar | Call girls in Dehradun | Call girls in Gurugram | Call girls Gurugram | Call girls in Gurugram | Escorts in Gurugram | Call girls in Gurgaon | Call girls Gurgaon | Call girls in gurgaon | Escorts in Gurgaon | Call girls in Delhi | Call girls in Jaipur | Call girls in Noida | call girls noida | Call girls in dehradun | Call girls in Noida | Call girls in Gurgaon | Call girl in Mumbai | CP ESCORTS SERVICE | Call Girls in CP | Call girls in Rishikesh | Call girls in Dwarka

Posted By singledate, Post #104891, KB Topic: Desktop Databases
  +Add Comment

Is there a right way to handle version information in our projects? Could we do a better job of it?
Posted By Wes Peterson, Post #100404, KB Topic: Desktop Databases
  +Add Comment  (2 Comments)




Topic: Interbase

Interbase database and field specifications
Posted By Mike Prestwood, Post #100057, KB Topic: Interbase
  +Add Comment




Topic: Microsoft SQL Server

Learn how to make an easy SQL Server Script that will automatically back up all your databases in a simple way.

Posted By Bryan Valencia, Post #102439, KB Topic: Microsoft SQL Server
  +Add Comment  (1 Comments)

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 By Wes Peterson, Post #102563, KB Topic: Microsoft SQL Server
  +Add Comment  (2 Comments)




Topic: MS SQL 2005

SQL Server 2005 as an Embedded Database Choice in your Application
Posted By Adam Lum, Post #100892, KB Topic: MS SQL 2005
  +Add Comment

SQL Server 2005's available management tools make moving databases from one machine to another a snap. This article describes the steps
Posted By Joshua Delahunty, Post #100372, KB Topic: MS SQL 2005
  +Add Comment

Whether you're a total newbie to databases, and need of a good foundation, a seasoned pro that wants a little review, or a developer that wants to help educate his clients, a series of well executed training videos is a great way to go.
Posted By Wes Peterson, Post #100633, KB Topic: MS SQL 2005
  +Add Comment




Topic: MS SQL 97 / 2000

The preferred technique for transferring an MS SQL database is to do a complete backup and restore.
Posted By Mike Prestwood, Post #100264, KB Topic: MS SQL 97 / 2000
  +Add Comment

Have you installed SQL Server 2005, set all the right SQL Server settings, and still can't browse the server? If you're running XP Pro service pack 2 or later, you may have forgotten to fix this issue at the FIREWALL! (doh!)

Posted By Joshua Delahunty, Post #100374, KB Topic: MS SQL 97 / 2000
  +Add Comment




Topic: SQL Servers

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 By Bryan Valencia, Post #102126, KB Topic: SQL Servers
  +Add Comment

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 By Bryan Valencia, Post #102088, KB Topic: SQL Servers
  +Add Comment  (3 Comments)

The installation of the SourceGear Vault client control appears to trash SQL Server Management Studio and Visual Studio.

Here's the fix that worked for me.

Posted By Wes Peterson, Post #102298, KB Topic: SQL Servers
  +Add Comment  (1 Comments)


Follow PrestwoodBoards on: 


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