databasedesign-resource.com

Please wait for loading...




      (391):

    /
     1  +5 2014 aug 02mysql nice -MySQL Tuning: General hints and tricks, and examplesMySQL Tuning: General guidelines for tuning a MySQL database, with thorough ... These processes are “ nice ” and let other processes use cpu and memory ...
     1  +5 2014 jul 29sql server dba tutorialBeing a SQL Server DBA : Common tasks and solutionsWelcome to the SQL Server DBA section of this site. ... This article provides a step -by-step tutorial on Import and Export in SQL Server ; Today's database systems ...
     3  ~ 2014 jul 30data design terminologyDatabase Glossary - Database Design ResourceDatabase Glossary. Important database design terms in database design defined .
     4  +1 2014 oct 05server maintenance planSQL Server Maintenance Plan - Keeping your database in shapeThe only way to be ready for a disaster is to plan ahead and ensure that the SQL Server maintenance plan a nd disaster recovery measures you have in place ...
     4  +4 2014 oct 02sql server transaction logSQL Server Transaction log - A short how-toThis is where we rely on backups and the SQL Server transaction log to help recover from any problems that may have occurred while the database was in ...
     6  +68 2014 aug 15sql server dbaSQL Server DBA : Common tasks and solutions. Welcome to the SQL Server DBA section of this site. In this section, you will find a set of common tasks needed ...
     6  +3 2014 jul 20mysql if condition triggerMySQL Triggers : An instruction guide - Database Design ResourceMySQL Triggers : How to write secure updating mechanisms and populate tables within a ... first sale, and this meets the 'ELSE' condition of our “ IF ' statement .
     8  -1 2014 sep 30sql server maintenanceThese routine tasks include SQL Server maintenance jobs that will not only keep the data and the engine performing at satisfactory levels, but will also keep the ...
     8  +4 2014 sep 10mysql triggerMySQL Triggers : How to write secure updating mechanisms and populate tables within a modification of other tables.
     8  +15 2014 aug 24mysql trigger performanceMySQL Triggers : How to write secure updating mechanisms and populate ... the sales table, the salesperson's totals must be updated in the performance table.
     9  +26 2014 aug 24database analysis designThe Analysis phase - The starting point of effective Database DesignThe Analysis phase - The starting point of effective Database Design . This is series of articles adressing different issues in the database analysis phase.
     9  +13 2014 aug 16manage users ms sqlAdding users in SQL Server : An illustrated how-toSQL Server provides an effective method for adding users and for managing ... it is critical that you start adding users in SQL Server so that people needing .... The names MS Access/ MS SQL Server are trademarks of Microsoft Corporation.
     9  +83 2014 aug 12sql manager import dataImport and export in SQL Server : How to set it upIn order to use the import and export in SQL Server Data functions, right click on the server in Enterprise Manager that you would like to use as a basis for the ...
     9  +92 2014 aug 10dba sql server
     9  +51 2014 jul 23uninstall sql serverUninstall SQL Server : Detailed how-to - Database Design ResourceUninstall SQL Server : Detailed how-to instructions on how to rebuild a SQL Server database after a failure.
     10  +91 2014 jul 20sql server exportSQL Server provides to those who use it, the ability to import and export in SQL Server to many different formats. This can be extremely useful for someone ...
     11  +64 2014 aug 31sql server export dataFor example, an agency that sells mailing lists could easily export the data from a SQL Server database to a format that could be burned onto a CD and ...
     11  +33 2014 aug 22sql normal formsThe 5 Normal forms in Database Design - Database Design ResourceThe formal definition of the five Normal Forms as a foundation for sound database ... a lot of procedural coding (PL/ SQL in Oracle, VB/C# in Microsoft products).
     12  -1 2014 oct 01html server maintenance
     12  -1 2014 sep 20mysql database designMySQL Database Design : General hints and tricksMySQL Database Design : General guidelines for designing database tables in MySQL.
     13  +1 2014 sep 16sql server jobsSQL Server jobs - Database Design ResourceSQL Server jobs - Using jobs in SQL Server to getting the job done.
     13  ~ 2014 aug 06export database to htmlImport and export in SQL Server - Database Design ResourceFor example, an agency that sells mailing lists could easily export the data from a SQL Server database to a format that could be burned onto a CD and ...
     13  +88 2014 jul 29export sql database
     13  +88 2014 jul 23sql server export database
     14  +13 2014 sep 27sql server log fileSQL Server stores its data in files that are maintained by the database engine. ... This is where we rely on backups and the SQL Server transaction log to help ...
     14  +87 2014 jul 27db design in mysqlMySQL Database Design : General guidelines for designing database tables in MySQL .
     14  +87 2014 jul 25sql server database administrator
     15  +5 2014 sep 30oracle alter tableEnabling and disabling Oracle constraints: Short how-toIf you define a constraint but do not explicitly enable or disable it, ORACLE enables it by default. ... alter table tablename drop constraint someconstraint;.
     15  +6 2014 sep 30sql server log files
     15  -7 2014 sep 18dba notesAs a DBA , you will very likely need to move bulks of data from one database to another, or make a copy of your data. This article provides a step-by-step tutorial  ...
     15  +2 2014 sep 01helene malmsio ebooksThe eBook on how to create your own eBook !Do you know what it takes to create an eBook (and a cover, like the one to the right)? ... How to produce PDF eBooks at no cost whatsoever. .... Helene Malmsio ,
     15  +86 2014 aug 02export database sql
     15  -3 2014 jul 29bank transactions table designMySQL Transactions - Database Design ResourceTransactions ensure that if there is a power outage or a server crashes, those thousands of interrupted operations will not leave the bank's database tables in an ...
     16  +6 2014 oct 03mysql database designer
     16  -2 2014 sep 11grant create session to userAdding users in Oracle databases: A simple guide.All users in Oracle are required to have the CREATE SESSION privilege in order to access the database. Each user must be granted the CREATE SESSION  ...
     16  ~ 2014 aug 20sql server administrationThe SQL Server Database system from Microsoft Corporation has gained popularity over the last years, and it is believed to be one of the few surviving relational ...
     16  +70 2014 aug 04alter constraint oracleEnabling and disabling Oracle constraints : Short how-toIf you define a constraint but do not explicitly enable or disable it, ORACLE enables it by default. Any SQL INSERT, UPDATE or DELETE command applied to a ...
     16  +43 2014 jul 28create user oracleAll users in Oracle are required to have the CREATE SESSION privilege in order to access the database. Each user must be granted the CREATE SESSION ...
     16  +43 2014 jul 25mysql trigger examplesMySQL Triggers : How to write secure updating mechanisms and populate tables ... When a user on a website makes a purchase, for example , the first action that ...
     16  +3 2014 jul 17best hosting companies sbiSBI Website Design: The ultimate website building and hosting tool.SBI Website Design: A methodically approach to a successful Internet Business. ... site is called SBI ! by Sitesell, Inc. It is a Canadian Web design tools and hosting company , and much, ... Please, for your own best , read all of the links beneath.
     17  ~ 2014 oct 01design mysql database
     17  +1 2014 sep 27mysql removing stored proceduresMySQL Stored Procedures : General hints and tricksMySQL stored procedures are program units that are not only stored, but executed on the MySQL server. They are, for the most part, logic that has been removed  ...
     17  -2 2014 sep 27oracle constraintEnabling and disabling Oracle constraints can also be done with the ENABLE and DISABLE keywords of the CONSTRAINT clause. If you define a constraint but ...
     17  +84 2014 aug 16triggers in mysql
     17  +6 2014 aug 01laser targeted contentAdvertising on database design resource: laser - targeted marketing!It has an established reputation in the IT/DB world: The content of www. ... These pages are containing laser - targeted themed content that hit right into the core of ...
     17  +79 2014 jul 21high performance database serverapplication-architecture - Database Design ResourceDatabase application architecture - High performance software. Database ... The client is your PC, hooked up to a server (a computer far away). So the ...
     18  +19 2014 sep 08make my own ebook websiteRecommended resources for building your own web site ... This eBook shows you my method for creating your own eBook without sending me, or others, ANY  ...
     18  +44 2014 aug 19sbi website designSBI Website Design : The ultimate website building and hosting tool.SBI Website Design : A methodically approach to a successful Internet Business.
     19  +3 2014 oct 05sql server logs
     19  -13 2014 oct 01how to start business guide or program or course ebook affiliateDetailed instructions on how to structure and write your own eBook (s)
     19  -2 2014 sep 27drop constraintEnabling and disabling Oracle constraints can be accomplished by using. Drop constraint command; Disable constraint command. Constraints specified in the ...
     19  +9 2014 sep 06ebooks affiliate paymentseBook affiliate program : A chance to earn my own Internet income!eBook affiliate program Join my eBook affiliate program : If you own a website, you can start selling my eBooks within minutes! I have many webmasters who ...
     19  +9 2014 aug 15sbi web design
     20  ~ 2014 aug 26how export mssql database
     20  +13 2014 aug 16software routine mysqlMySQL stored procedures are program units that are not only stored, but executed on the MySQL server. They are, for the most part, logic that has been removed ...
     21  +4 2014 sep 27executing stored procedure in mysqlMySQL stored procedures are program units that are not only stored, but executed on the MySQL server. They are, for the most part, logic that has been removed ...
     21  +80 2014 sep 11oracle backupOracle Backup - Database Design ResourcePerforming an Oracle Backup : A simple guide to backing up an Oracle Database .
     21  +43 2014 aug 26mysql databases for saleMySQL Triggers: An instruction guide - Database Design ResourceMySQL Triggers: How to write secure updating mechanisms and populate tables ... Imagine a database that tracks the sales records of three salespeople at a ...
     21  ~ 2014 aug 10access export to sqlSQL Server provides to those who use it, the ability to import and export in ... The source type can be SQL Server, Access , Oracle or any other data store that can ...
     21  ~ 2014 jul 31create trigger in mysqlUsing the CREATE TRIGGER statement, we've initiated the trigger, naming it ' sales_bi_trg'. MySQL triggers can fire before or after an INSERT, UPDATE or ...
     22  +6 2014 sep 30sql server log
     22  ~ 2014 sep 06alter table oracle
     22  ~ 2014 aug 28drop table cascadeDROP Constraint command Drop an integrity constraint. Syntax: ... DROP UNIQUE column [ CASCADE ] ... alter table tablename drop constraint someconstraint;.
     23  +62 2014 aug 09sql import toolThe Advantage of the Import and Export in SQL Server Tools . While SQL Server can be used to house the data that your company maintains on a daily basis and  ...
     23  +78 2014 aug 08user database designAdding users in SQL Server - Database Design ResourceOnce the database is designed , configured and implemented, it is critical that you start adding users in SQL Server so that people needing access to the data or ...
     23  +56 2014 jul 29free affiliate ebookeBook affiliate program: A chance to earn my own Internet income!Join for free as an affiliate for this eBook affiliate program: A chance to earn extra income from your website!
     24  +61 2014 sep 11oracle change column typeRedefining Oracle objects : Changing database objects in real-time.However, the ability to make substantial changes by redefining Oracle objects ... add columns , remove columns , rename columns , change data types , change  ...
     24  +30 2014 aug 20oracle role resourceAdding users in Oracle databases - Database Design ResourceWhen new users in Oracle are added, some rights are assigned to that user so that actions are performed on the database either directly or through roles .
     24  ~ 2014 aug 03simple data backup
     25  +13 2014 aug 13database designer for mysql
     25  ~ 2014 aug 01drop table in oracle
     26  +3 2014 sep 08mysql database ebookMySQL Database Design: General hints and tricksMySQL Database Design: General guidelines for designing database tables in MySQL . ... Subscribe to my newsletter and get my ebook on Entity Relationship ...
     27  -2 2014 sep 14database designing using phpmyadminMySQL Database Management - Database Design ResourceMySQL Database Management: How to administer and define your MySQL database system. ... If you want to insert data using phpMyAdmin that is easy as well.
     27  ~ 2014 sep 03server setup and maintenenceThese routine tasks include SQL Server maintenance jobs that will not only keep ... So what is a database maintenance plan and how can you configure a good ...
     27  +29 2014 aug 21oracle dba basicsOracle DBA - Database Design ResourceOracle DBA : Common tasks you have to master in your work as an Oracle DBA . ... The articles are basic level, and some are graphic intensive, so you will need ...
     27  ~ 2014 jul 29transaction sql server
     28  +2 2014 sep 27make your own ebooksFree eBook: The eBook on how to create your own eBook ! All you need to know to make and sell an Internet product! free of charge!
     28  +73 2014 sep 15database designerThe Database Design Resource CenterA database design resource center for DB Professionals seeking solutions to database design details in relational databases.
     28  +36 2014 aug 02block table mysqlTo demonstrate how MySQL triggers work, let's set up two simple tables on a ... need to set a different delimiter to let MySQL know when our code block is over, ...
     28  +73 2014 jul 28ebook affiliate siteJoin for free as an affiliate for this eBook affiliate program : A chance to earn extra income from your website!
     29  +1 2014 sep 19mysql query execution orderMySQL Tuning: General guidelines for tuning a MySQL database, with ... indexes to perform MySQL Tuning in order to speed up your MySQL queries . ... The time it takes the query to execute will show at the bottom after the results appear.
     29  ~ 2014 aug 26move sql databaseMoving the database : SQL Server detach and attach functionalityIf you need moving the database to another location, the attach and detach functionality is indispensable. As many of you may or may not know, SQL Server is a ...
     29  +72 2014 aug 18ebook affliate programs
     29  +72 2014 aug 14write your own ebookMy offer to you is a result of my self-developed process for writing my own eBooks . During my work, I have built a no-tech method for creating, publishing and ...
     29  +72 2014 aug 13free database designereBook lectures in database design - Database Design ResourceeBook lectures in database design with emphasis on performance, ... My eBook section is intended to supply you with affordable and/or free ebooks in our field ...
     29  +72 2014 aug 11writing your own ebook
     29  +25 2014 aug 01ebook cover clickbankMy affiliate program, run by ClickBank , pays out 75% commission to you for each ... You can use these eBook covers wherever you want for your own promotion ...
     29  +51 2014 jul 22mysql database design tutorialA basic tutorial on MySQL Database Design . This article will take a look at several areas of MySQL Database Design to consider when creating an application ...
     30  +5 2014 sep 17database design
     30  +13 2014 jul 23mysql quick adminMySQL Backup: A quick guide on MySQL DBA tasksThis script connects to the mysql server with the username joe, who must have administrative privileges for the database “dbname”. By default, mysqldump  ...
     31  ~ 2014 sep 02speed up serverSQL Server indexes - Speeding up performance in the databaseSQL Server indexes are used for many reasons.Some of those reasons are listed below: To ensure data integrity; To ensure data accuracy; To speed up data ...
     31  +33 2014 aug 20increase mysql tunerMySQL Tuning : General hints and tricks, and examplesMySQL Tuning : General guidelines for tuning a MySQL database, with thorough ... Indexes can greatly increase the speed of database reads by mapping a ...
     31  ~ 2014 jul 28import oracle databaseOracle Import : Loading data into your Oracle Database .Oracle Import inserts the data objects extracted from one Oracle database by the Oracle Export utility into another Oracle database . Oracle Export dump files can ...
     32  -3 2014 oct 04ebook affiliate programm
     32  +15 2014 sep 10mysql id shiftMySQL Database Design: General guidelines for designing database tables in ... worker name; id number; department; gender; number of units completed per ... the hours worked, the shift worked, supervisor and date need to tracked daily.
     32  ~ 2014 aug 21database normalization examplesDatabase Normalization Techniques - EssentialsMastering database normalization techniques: Essentials for high performance ... documented with graphical Entity Relationship and Server Diagram examples .
     32  +15 2014 aug 13mysql db designer
     32  ~ 2014 aug 01data base design
     33  -1 2014 sep 27sql log fileSQL Server stores its data in files that are maintained by the database engine. ... These transaction log files are stored just like the data files used in SQL Server.
    1 2 of 4 pages