Here we go with another installation and configuration post for out local server;
this time for MySQL, the well known and widely popular free database server.
[You may want to read Installing
Web Server on your PC, Installing
Apache and PHP on your PC and Configuring
Apache Web Server and PHP]
In this post, we’ll learn to set-up MySQL server on our own local server
and see how we can connect to it from our scripts.
Since the last few posts we have been having problems implementing data storage/retrieval
from files, we thought it was the right time to start using database for that
purpose. However before we can use database connectivity from our scripts, we
need to install a database server, we’ve chosen My SQL. In spite of MySQL
database server bein
Job Description
Support medium to large scale critical applications in production, development and test environments.
Hands-on experience with database installation, configuration, backup/recovery, migration, maintenance activities.
Job Description
Providing L-1 & L-2 troubleshooting support.Monitoring logs for firewalls and intrusion-detection systems.Handling day-to-day management of the server operating system, file structure, and directory services.Backup and Recovery.Monitoring servers.
The Logical Database Builder then saves you work by using components that you have already defined to generate proposals for other components. Some of the most important attributes of a logical database are set when you define its structure. When you have defined the structure, the Logical Database Builder automatically generates a proposal for the selection include. The system then generates an input mask for the database program, based on the structure of the logical database and the selections. These generated proposals allow you to create a working logical database quickly. However, you must program refinements such as authorization checks and performance optimization yourself. • Database tables. The table must be active in the ABAP Dictionary. Tables always have a flat structure. T
Open Source Database Populer
Deskripsi dari Publisher
NOTE: This alpha release, as any other pre-production release, should not be installed on production level systems or systems with critical data. It is good practice to back up your data before installing any new version of software. Although MySQL has worked very hard to ensure a high level of quality, protect your data by making a backup as you would for any other software beta release. MySQL generally recommends that you dump and reload your tables from any previous version to upgrade to 6.0.
The new Falcon transactional storage engine ("The Falcon Storage Engine")
Optimizer enhancements for faster subqueries and joins, including batched index access of table rows for sequences of disjoint ranges by the MyISAM and InnoDB storage e
Software ini bisa digunakan untuk memperbaiki file ms Access yang corrupt
Deskripsi dari publisher:
Access Database Mechanic is a free tool from aadconsulting.com. this tool will automaticaly attempt to recover a corrupt MS Access database, using three operations: compact & repair, decompile, and complete rebuild of an .mdb. The applet also features a fail-safe mechanism that creates a uniquely named back-up copy of the .mdb before any recovery operation is attempted. This Versions Works on Access2000/2002/2003.
Version 1.1 adds:
Support for the Microsoft JET Compact Repair Utility
Now features rebuild for addtional objects: Import/Export Specifications, References, and Custom CommandBars
File download is one-fifth the size of v1.0 with a new and faster Install set.
Publisher :
VBA ADO Code for using Excel as DatabaseThough many database systems have come , still there is a need to use Excel as Backend database. The reasons might be many -- you get Excel sheets as a Report and do not want to import that into Access or SQL ServerHere is a simple code that will allow you to do exactly thatSub Excel_ADO()Dim cN As ADODB.Connection '* Connection StringDim RS As ADODB.Recordset '* Record SetDim sQuery As String '* Query StringDim i1 As LongDim lMaxRow As Long '* Last Row in the SheetDim iRevCol As Integer '*Dim i3 As IntegerOn Error GoTo ADO_ERRORSet cN = New ADODB.ConnectioncN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Orginal.xls;Extended Properties=Excel 8.0;Persist Security Info=False"cN.Connectio
Shutdown Microsoft SQL Server 2000, and then run Rebuildm.exe. This is located in the ProgramFiles\Microsoft SQL Server\80\Tools\Binn directory.In the Rebuild Master dialog box, click Browse.In the Browse for Folder dialog box, select the \Data folder on the SQL Server 2000 compact disc or inthe shared network directory from which SQL Server 2000 was installed, and then click OK.Click Settings. In the Collation Settings dialog box, verify or change settings used for the masterdatabase and all other databases.Initially, the default collation settings are shown, but these may not match the collation selected duringsetup. You can select the same settings used during setup or select new collation settings. When done,click OK.In the Rebuild Master dialog box, click Rebuild to start the process.
Pada tutorial kali ini saya akan menjelaskan bagaimana cara memanipulasi data menggunakan SQL Statement di Visual Basic. Tujuan tutorial ini adalah agar pembaca bisa memahami bagaimana cara menggunakan SQL Statement untuk memanipulasi data di Visual Basic oleh karena itu tutorial ini dibuat se-jelas dan se-sederhana mungkin tetapi tidak mengesampingkan pemahaman pokok tentang operasi DML dengan SQL Statement.
Buat sebuah File Database menggunakan Microsoft Access, simpan di c:\Sample dengan nama DBSample.mdb
Buat sebuah table dengan nama Products dengan struktur sebagai berikut :
ProductID Text(20)
Description Text(50)
Price number(Double)
Masuk ke Visual Basic, buat sebuah project Standard.EXE simpan di c:\Sample dengan nama SQLDML.vbp
Tambahkan tiga buah Textbox : txtPi
How to improve Oracle database performance on HP-UX 11iv2 On HP-UX 11iv2 we consulted System performance guru and what we heard was outstanding. Our consulted told us that HP doesn't provide best practices when it comes to HP-UX tuning to get best performance for running Production oracle database.
One of the advise was lower the dba_max_pct from the default value of 50, which is too high and it becomes very I/O intensive based on a very busy oracle database environment.
HP-UX bosdbx B.11.23 U ia64 3641685621 unlimited-user license
root@bosdbx:/> kctune dbc_max_pct
Tunable Value Expression Changes
dbc_max_pct 50 Default ImmedOn this oracle database server which is running HP-UX 11iv2 by default dbx_max_pct is set to 50 which is too high, lowering this value to 25 is re
URGENT NEED FOR Oracle Database Administrator
TITLE: Oracle Database Administrator
LOCATION: Minneapolis, MN
TYPE: 7+ months with strong possibility of extension.
OUR CLIENT:
Our client is a...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
Click to enlarge
FoxPro Move to Another FoxPro Database 7.0
Transfer data (tables) from one FoxPro database to another quickly. Simply provide the file location for both databases to connect,decompiler for foxpro. No SQL knowledge is required.foxpro for dos
Transfer data (tables) from one FoxPro database to another quickly.
Author Company: Sobolsoft
Price: $19.82
File Size: [...]
WeBecome is a Singapore headquartered IT consulting and Executive Search Company. We are looking for “Mainframe Database Administrator” to join one of our clients on a fulltime basis in India....
For more info on latest job openings and other career related information visit my site
Hi,We have an Urgent openeing with one of our MNC Client for Pune Location.Below is the Requirement:Client: ADPLocation: PuneMainframe DB2 Database Administrator-No of Open Positions - 3 - Location- PuneSkills Set-DB2, MVS z/OS navigation, SQL, QMF, DDL, JCL, SDSF, Tivoli OMEGAMON tools3 years of DB2 and mainframe experienceExperience- 1 to 5 YearsIf you are interested in this requirement and location, please send me your updated resume ASAP to sowjanya.s@mobitecglobal.com.Also, see to it that you have not submitted to this company before 6 months directly or through any other consultancy.Awaiting for your response.Thanks and Regards,Sowjanya.S
Ada beberapa metode untuk menghubungkan Visual Basic dengan Database MS SQL Server saya akan memberikan penjelasan 2 metode diantaranya yaitu koneksi dengan menggunakan komponen DataEnvironment dan koneksi dengan menggunakan kode Program. untuk tutorial ini saya menggunakan Visual Basic 6 dan MS SQL Server 2000.
1. Koneksi menggunakan DataEnvironment
Buat Project Standard EXE
Klik menu Project | Add Data Environment, maka akan ditampilkan jendela Data Environment seperti ini :
Untuk membangun koneksi dengan Database SQL Server, Klik kanan objek Connection1 kemudian pilih Properties maka akan muncul jendela Data Link Properties.
Pada jendela Data Link Properties pilih driver untuk koneksi ke MS SQL Server, yaitu Microsoft OLE DB Provider for SQL Server. kemudian klik Next
I
A little more then a year ago I wrote a post presenting three different methods to transfer a mysql database. The third method suggested in that post was copying the mysql database files directly from one server ( or location ) to another. This involved locking the tables with a read lock or even shutting [...]
Primary school children should be put on the national DNA database if their behaviour suggests they will become criminals, a senior Scotland Yard expert said yesterday. Gary Pugh, the director of forensic science and the new DNA spokesman for the Association of Chief Police Officers, called for a debate on the measures required to identify future offenders. He said: "If we have a primary means of identifying people before they offend, then in the long term the benefits of targeting younger people are extremely large. "We have to find who are possibly going to be the biggest threat to society." But critics said this was a step towards a police state that would risk stigmatising youngsters who had yet to commit a criminal act. The details of more than 4.5 million people, inc
Click to enlarge
ESF Database Convert 5.8.13
This database software allows you to easily and quickly convert between various database formats. It can directly connect to Oracle, MySQL, SQL Server, PostgreSQL, Access, Excel, Visual Foxpro, FireBird/InterBase, Paradox, Lotus, dBase, Text and other formats, and convert between these formats (eg: Access to Oracle, Oracle [...]
Oracle Database Ajax & PHP Web Application Development (Oracle Press) (Paperback)By Lee Barney
Buy new: $36.4929 utilised and new from $27.88 First tagged “ajax” by Chris Rueblinger Customer tags: database(2), php, ajax, [...]
Christopher Miller read article of SQL SERVER Database Coding Standards and Guidelines Complete List Download and came up with wonderful SQL Server Script to rename all their database constraint with more organized constraint names, which helps to easily identify the constraint database exist on.
Christopher Miller - “When we submit our schema updates internally, we usually [...]
The small shell script below copies a given database from a remote host to the local host. Just fill in the variables and run it to copy the whole database: #!/bin/bash # Copy a remote database to a local one REMOTE_HOST='' ...
We have opening for Database Professionals with our esteemed organization.
Location : Pune
Experiance : 4+yrs
Qualification : Any Degree
Skill Sets:
1. Min 4 years on DataStage / Teradata Relevant...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
We have opening for Database Professionals with our esteemed organization.
Location : Pune
Experiance : 4+yrs
Qualification : Any Degree
Skill Sets:
1. Min 4 years on DataStage / Teradata Relevant...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
Yesterday I wrote about SQL SERVER - Find Table in Every Database of SQL Server. Today we will see another method how we can achieve the same result using Information_Schema view. Refer my previous article here for additional information.
CREATE PROCEDURE usp_FindTableNameInAllDatabase
@TableName VARCHAR(256)
AS
DECLARE @DBName VARCHAR(256)
DECLARE @varSQL VARCHAR(512)
DECLARE @getDBName CURSOR
SET @getDBName = CURSOR FOR
SELECT name
FROM sys.databases
CREATE TABLE #TmpTable (TABLE_CATALOG VARCHAR(128), TABLE_SCHEMA VARCHAR(128), TABLE_NAM
By Christopher SternApril 29, BloombergBarack Obama's supporters are giving him more than just record amounts of cash. They also are providing personal information that may make his donor list the most powerful tool in U.S. politics.Even if the Democratic presidential candidate doesn't succeed in his White House bid, this data will make Obama a power broker in the party for years to come. For the interest groups or Democratic candidates he chooses to sell it to, it would provide a gold mine of information and access to potential donors.Almost 2 million people have entered personal information on Obama pages on social-networking Web sites such as Facebook, MySpace and his campaign's mybarackobama.com, offering home addresses, phone numbers, their views on specific issues and the names of fr
Just a day ago, one of the Jr. Developer requested that if I can help her with finding one particular table in every database on SQL Server. We have many Database Server and on some of the Database Server we have nearly 200 databases on it. The requirement was to find out one particular table [...]
We're talking, of course, about the on-line database and Web site that was the main source of information for Sunday's story about teacher misconduct in the St. Petersburg Times. Pinellas union chief Jade Moore (left), who was quoted in the...
Icons-Tools database is a collection of royalty-free Pret-icons for use in various database products, including software applications, web sites of information and presentations.The icons have been carefully drawn pixel by pixel by professional artists. They shine with brilliant colors, smooth and well-rounded. These icons willing to contribute to a developer, a professional feel really on the project, interfaces, without the necessity of setting a designer or even days or weeks and on the design of icons on his.Our Products Web and database software is modern and attractive icons Tools database. Color formats include Windows XP and 8-bit formats. Available sizes are 16x16, 24x24, 32x32, 48x48 and 20x20. The symbol consists of database of symbols: Change record, record add, remove, registr
Solving Customer queries by providing Technical Support through chat and e-mail. To monitor on a day to day to day basis the incoming tickets. Adding of the customers data to the tool. Ensuring the...
For more info on latest job openings and other career related information visit my site
MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits) (Paperback)By Dejan Sarka
Buy new: $38.3940 utilised and new from $26.02 Customer Rating: First tagged “microsoft” [...]
Allows you to create a database without any special knowledge or skills
Brilliant Database Professional allows you to create a database without any special knowledge or skills.
According to its actual users' opinions and comments, Brilliant Database perfectly fits the purpose of maintaining a database, which can contain the information about the personnel, customers, goods, and important
"Being a WordPress devotee, the shocking thing about Drupal is that it doesn’t have a backup utility built into the core system. Any content management system that relies upon a back-end database should provide a way to back that database up regularly. Shockingly, Drupal doesn’t. But it does have a dedicated community, and there are a number of options out there for backing up your database. The one which I’ve been using lately is the Backup/Migrate module."[via scribble design]
Hello,
For taking backup of you database you have to make sure that you database is good enough. with shell access you can take the database backup in .sql format with following command
#mysqldump user_databasename > database.sql
As you are having database backup and want to restore it then use following command
#mysql user_databasename < database.sql
Database Tour Pro 5.7.0.1053It is a convenient and powerful database program, which includes different db utilities and tools like SQL tool, reporting tool, data converting, exporting, importing utilities and much more. The program works with data through the Borland Database Engine (BDE) or Microsoft ActiveX Data Objects (ADO). This allows using the program as a cross-database tool. So, to use Database Tour you need to install BDE 5.0 or above or ADO 2.1 or above. ADO is included in Windows 2000 and above. For other Windows systems, you may download and install MDAC from Microsoft web site.Download:
Pro Oracle Database 10g RAC on Linux: Installation, Administration, and Performance (Expert’s Voice in Oracle) (Paperback)By Julian Dyke
Buy new: $56.7023 utilised and new from $45.59 Customer Rating: First tagged “unix” by Hans Forbrich [...]
Modern Database Management (Paperback)By Jeffrey A. Hoffer
1 utilised and new from $35.00 First tagged “database” by chicagobooks Customer tags: textbook, database, databases, school
Technorati Tags: textbook, database, databases, school
Creating a Database in Plesk Control PanelPlesk gives you the ability to create MySQL databases in both its Linux and Windows forms; if you purchase the necessary add-ons then it can also connect to PostgreSQL and MSSQL servers to create both types of database; PostgreSQL is only normally found on Linux, and MSSQL is for [...]
IndoBilling merupakan salah satu aplikasi billing yang cukup populer digunakan olehberbagai warnet, rental, game center maupun café-café hotspot. Indobilling termasukaplikasi yang bersifat client-server artinya ada aplikasi yang bertindak sebagai server dan aplikasi lainnya sebagai client dalam hal ini komputer yang digunakan operator adalah IndoBilling server sementara pengguna menggunakan IndoBilling client.Untuk mengatur informasi berupa tarif, lama durasi serta paket2 menarik yang ditawarkan termasuk juga administrasi server yang meliputi setting tarif, manajemen operator dsb dibutuhkan aplikasi database. Database sendiri merupakan aplikasi yang berfungsi menyimpan data-data dan melakukan query terhadap data-data itu sendiri.Salah satu contoh aplikasi database yang cukup populer yait
MySQL Workbench is a cross-platform, visual database design tool developed by MySQL. It is the highly anticipated successor application of the DBDesigner4 project.
This tool helps you to see the relations, indexes, tables of your MySQL database as a clear snapshot. With its simple yet effective interface, you can easily get used to MySQL Workbench.
For any [...]
I would like to start this week with free stuff! You are maybe wondering… with what?With hundred of free fonts! Free fonts are always welcome, I think you agree with me about that, they are very helpful to create different documents and they are also useful for make unique websites or blogs. You can use them to make banners, headers, images, etc, etc.So, there is a website called Font Cubes which has an enormous database of free fonts, for Mac and Windows. This website it’s perfect, it has a font preview page referent to the font you have selected, it has also a support to know where and how to install the fonts. Well, you have too see this website!Homepage: fontcubes Thanks Tony!
Databases are getting faster every day. But they’re still a significant bottleneck for many Web applications or Web sites. Why? Mechanical hard drives, impeded by the laws of physics, bog down the relational databases that read and write to them.
Terracotta Inc.’s namesake software is an open-source Java clustering solution.
According to CEO Amit Pandey, the [...]
For some reason SQL Server doesn't have an easy way to "Create TO" for database diagrams, unlike stored procedures, functions ,etc.
Here is how you can achieve moving a database diagram (or copying a database diagram) in SQL Server 2005
use Old_Database
go
--this will copy your database diagrams into a temporary table
select * into dbo.#tempsysdiagrams from sysdiagrams
use New_Database
go
insert into sysdiagrams ([name],principal_id,version,definition)
select [name],principal_id,version,definition from dbo.#tempsysdiagrams where [name]='Name_of_your_Diagram'
That's it, so easy.
Hedge Funds DatabaseQ&A: Hedge Funds Database SubmissionsI got this hedge funds database related email yesterday afternoon and it is a question that often comes from either startup hedge funds or established hedge funds that want to make sure they are on the radar of all the big hedge funds databases.Richard, I've been reading your blog for 4-5 months now and I run a global macro hedge fund based in New York. I have a quick question for you. In which databases should we be posting our hedge fund performance figures in? I would makes sure your hedge fund performance data and portfolio construction process are detailed within these databases:Cogent HedgeHedgeFund.netEurekahedgeHedgeCo.netInvestor ForceMercerMorningstar- RichardSubscribe To this Blog via Email | Or RSSArticles Related t
It is commonly believed that cursor are Database Objects. I have always given the definition of cursor as SQL Server cursors are database objects used to manipulate data in a set on a row-by-row basis.
Just a few days ago - Imran one of the active reader of blog asked me question if cursor is database [...]
Regular reader of SQLAuthority.com blog Madhaiyan Seenivasan has send email with one very interesting script. This script generates all the foreign key addition script for your database. Many times there are situations where one need to drop all the foreign key and add them back. This SQL Script can be used for the same purpose.
You [...]
ChurchInfo is a free church database program to help churches track members, families, groups, pledges and payments. Our feature set is comparable to expensive church management software packages. Our users are supported by an open-source community of people who volunteer their time and energy to make this technology available to all churches.Naturally Networked ChurchInfo runs on any server that supports PHP and mySQL. The server may be in-house or at an ISP anywhere on the Internet. Any number of people may access the database simultaneously. Family A family is a group of people who are treated as a unit. The obvious example would be a married couple and perhaps their children. The family members do not need to have the same last name, but they should live at th
Zakat Database Register SystemDatabase ini dibuat menggunakan Microsoft Access 2000. Jadi untuk mengaksesnyadibutuhkan aplikasi Microsoft Access 2000. Ketika mengeksekusi file ini. Anda akan langsung dihadapkan pada menu utama. Untuk merubah susunan Tables, Query, Report, dan Form, tekan Shift + Enter untuk melihat Database Window dan anda akan bisa mengaksesnya secara manual.Sistem ini sangat sederhana, bahkan tanpa menggunakan kode-kode Visual Basic, andabisa mengotomatisasi semua kegiatan/aktivitas dengan Macro dan Expression Builder.Database ini dibuat berdasarkan kebutuhan Masjid atau Bait Al Maal yang bersangkutan.Silakan mengubahnya menurut kebutuhan.Download Program Perhitungan Zakat
If you ever lose the drive that contains your log file, your database will become suspect and will stop working. Notice that you cannot expand the database. If you do, you will get an error message. You do not need to restore the backup in such a crash. If you do, you will lose everything since your last BACKUP. All you have to do is to detach the database and reattach it without the log. SQL Server 2005 does allow you to do this. You can reattach the database by following these simple steps: first, you need to detach the suspect database: The “detach database” dialog appears, click ok. You might get an error just ignore it and the database will be detached. You will have to refresh the database list to remo
More and more people are meeting their dates online as technology advances and people become more receptive to social networking. I have met a few friends who actually tied the knot after a period of online dating. It sounds too good to be true but it is really happening.But before you think this is a fairy tale story, there are also unhappy and unfortunate cases where online dating has caused hearts to break and souls depressed. I believe this is the reason why relationship and dating expert, Stephany Alexander has set up WomanSavers, with the intention to allow women to conduct their "research and rate BEFORE they date". This is the world's largest database rating men website which targets abusive and cheating men. There are lots of articles related to relationship and dati
Job Career Recruitment-Lowongan Kerja terbaru :BUSSAN AUTO FINANCE, PTWe, an established joint venture multifinance company which is having more than 124 branches throughout Indonesia, are looking for high quality persons to fill positions asIT DATABASE( Jakarta )Requirements: * Single, Male / Female, below 28 years old. * University degree (S1) majoring in Information technology with minimal GPA 2.8. * Experience min. 2 years in tuning SQL performance, backup & restore, batch jobs monitoring, review and control access users, manage and maintain production on database. * Strong communication skills, good written & verbal English is required. * Able to work as team work. * Hard working, attention to detail, curiosity, integrity and honest.If you meet the above qualifications,
From time to time, we get into situation when we would like to know just how-to import big database in phpmyadmin?
The problem is that most of the php.ini - the PHP configuration file on server (that is your host, if you are on shared hosting) is limiting maximum file upload size to 2mb.
In that case [...]
(Images by Apple iPhone School)
The newest version of RemoteNote (1.0.0) comes with some beautiful visual changes (the main screen, the web browser, and alternating note colors).
Not only visual, but functional updates have been made as well. You are now capable of downloading your entire notes database, thus being able to restore your notes at a [...]
CTA DatabaseQ&A Know of Any CTA Databases?Hello Richard,Thank for the tips, much appreciated. I was hoping you could help connect me with a list of CTA funds or point me towards an online CTA database. Do you have one of these for free or know where I can purchase one possibly?Yes, I do know of one in-depth CTA database that you can download into your ACT, Salesforce.com or Excel data management system at your firm. Click Here to get this database.- RichardSubscribe To this Blog via Email Or RSSArticles Related to "CTA Databases"1. Top 9 Hedge Fund Database Tips2. Hedge Fund Marketing3. Hedge Fund Due Diligence4. Outsourcing Hedge Fund Marketing5. Third Party Marketing6. Hedge Fund ResearchPermanent Link: CTA DatabaseTags: CTA Database, CTA Databases, Database of CTA Funds, CTA Fund Da
Over the weekend, I was supposed to be preparing for my second Toastmaster's speech which is "organizing your speech." I really dislike public speaking and that was the primary reason I joined up - basically facing my fears. I did the “Icebreaker” speech about three months ago and decided it was time to do another one a couple weeks ago. Predictably, I found everything else in the world to do, except preparing for my speech. All of sudden, I decided it was "time" to setup a MySQL server, Apache webserver, FTP server, PHP and another CMS interface. I have wanted to install another instance of my website on a local box, but I guess I just needed an impetus (i.e. speech preparation avoidance) to get it done. I performed the setup twice because I had some issues with the initial run and
Over the weekend, I was supposed to be preparing for my second Toastmaster's speech which is "organizing your speech." I really dislike public speaking and that was the primary reason I joined up - basically facing my fears. I did the “Icebreaker” speech about three months ago and decided it was time to do another one a couple weeks ago. Predictably, I found everything else in the world to do, except preparing for my speech. All of sudden, I decided it was "time" to setup a MySQL server, Apache webserver, FTP server, PHP and another CMS interface. I have wanted to install another instance of my website on a local box, but I guess I just needed an impetus (i.e. speech preparation avoidance) to get it done. I performed the setup twice because I had some issues with the initial run and
This Python script was written for a friend in Australia, for part of his Ph.D project. The script will parse the Apache server log into sqlite3 database.
Apache server log like this
1
23.13.171.152 - - [26/Sep/2007:21:20:36 +0800] "GET /forum/Themes/BlueStory/images/bbc/ftp://ftp.gif HTTP/1.1" 200 191 " "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.7) Gecko/20070914 Firefox/2.0.0.7"
could be parse to an [...]
We live in a high tech society fueled by caffeine. Not many of us make it through the day without drinking something caffeinated. But have you checked to see how much caffeine is in your daily cup of coffee or other energizing beverage?
The Caffeine Database has an extensive list of beverages and their caffeine content. [...]
Dopo aver visto come stabilire una connessione con un database su AS400/iSeries usando ODBC vedremo un approccio pratico usando OpenOffice per leggere i dati dal database collegato. Prima di proseguire è necessario aver installato l’iSeries Access e configurato un DSN ODBC.
Configurazione della fonte dati ODBC
Faremo utilizzo di OpenOffice.org DataBase che troviamo nel menu Applicazioni, Ufficio [...]
Dopo aver visto come stabilire una connessione con un database su AS400/iSeries usando ODBC vedremo un approccio pratico usando OpenOffice per leggere i dati dal database collegato. Prima di proseguire è necessario aver installato l’iSeries Access e configurato un DSN ODBC.
Configurazione della fonte dati ODBC
Faremo utilizzo di OpenOffice.org DataBase che troviamo nel menu Applicazioni, Ufficio [...]
Build Your Own Database Driven Website Using PHP & MySQL - 3rd Edition‘Build Your Own Database Driven Website Using PHP & MySQL’ is a practical hands-on guide to learning all the tools, principles and techniques needed to build a fully functional database driven Website using PHP & MySQL.This book covers everything from installing PHP & MySQL under Windows, Linux, and Mac through to building a live Web-based content management system.While this is essentially a beginners book, it also covers more advanced topics such as the storage of binary data in MySQL, and cookies and sessions in PHP. It comes complete with a set of handy reference guides for PHP & MySQL which include:* MySQL Syntax* MySQL Functions* MySQL Column Types, and* PHP Functions for working with MySQL.* And more
Cheat Book Database 2008If you're an avid gamer and want a few extra weapons or lives to survive until the next level, this freeware cheat database can come to the rescue. Covering more than 14200 Games , this database represents all genres and focuses on recent releases.Games are listed alphabetically in the left-hand window. When you click on a game name, the relevant cheat is displayed in a editor window, with convenient buttons that let you print the selection or save any changes you've made. In the latest past many users of the CheatBook- DataBase and readers of the monthly being published magazine have sent to us small error messages and suggestions for improvement again and again.Many of the suggestions which we received are now realized in the new version 2008.- comfortable adding
Author(s): Denise Gosnell, Matthew Reynolds, Bill ForgeyPublisher: WroxYear: 2001ISBN: 1861005555Language: EnglishPages: 688File type: PDFSize (for download): 5.8 MBAll software is based on the principle of manipulating data. Whether it's the code that runs inside your VCR to start recording at a specific time, or air traffic control software, code is always working with data in one form or another.Today, we find that sophisticated applications store their data in a "database", a central repository of data overseen by a Database Management System, or DBMS. A DBMS does two things. Firstly, it handles the storage of the data. Secondly, it provides mechanisms for retrieving data as well as adding, removing, and changing data. A DBMS endeavors to do this in the most efficient way possible.Over
So you been working on your website for a few weeks. You now got your blog or forum going. Now it is time to start thinking about backing up your database. You may not feel the need, because you...
[[ Visit the link to read more ]]
Previously I have written two different ways to find database collation SQL SERVER - 2005 - Find Database Collation Using T-SQL and SSMS. One of blog reader jwwishart has posted another method for doing the same.
SELECT collation_name
FROM sys.databases
WHERE name = ‘AdventureWorks’
Reference : Pinal Dave ()
Not too sure what happened the other day when my database just decided to blow up and not produce anything to my readers. Yesterday my blog was bombarded with traffic because of one specific post. Several traffic sources resulted into it and I my database just decided to give up.
I was going to update my blog later last night and when I tried to login I had a database issue and I was furious! I immediately called up my hosting provider and asked for immediate help. I swear my service providers’ customer support is so useless - they can not tell me anything except test the domain then create a ticket - WTF! Luckily Twitter was on my side and Nate Whitehill and Shawn Collins came to the rescue. I called up my service provider about 3 times to see what the updates were and what the issu
Blog reader Donald Crowther has posted following comment. I have not tested this solution and when I tried to test it, it did not work for me. However, I have received email from two of my Jr. DBA who have done experiment about this and they are suggesting it works.
If you have tried everything and [...]
CrunchyFrog is a database explorer and query tool for GNOME.
Currently PostgreSQL, MySQL, Oracle, SQLite3 databases and LDAP servers are supported for browsing and querying. More databases can be added using the plugin system.
This application requires GTK+ version 2.12.x. Other dependencies include:
For a (almost) complete list of dependencies see
Shutdown Microsoft SQL Server 2000, and then run Rebuildm.exe. This is located in the ProgramFiles\Microsoft SQL Server\80\Tools\Binn directory.In the Rebuild Master dialog box, click Browse.In the Browse for Folder dialog box, select the \Data folder on the SQL Server 2000 compact disc or inthe shared network directory from which SQL Server 2000 was installed, and then click OK.Click Settings. In the Collation Settings dialog box, verify or change settings used for the masterdatabase and all other databases.Initially, the default collation settings are shown, but these may not match the collation selected duringsetup. You can select the same settings used during setup or select new collation settings. When done,click OK.In the Rebuild Master dialog box, click Rebuild to start the process.
One question I received quite often. How to change the order of the column in database table? It happens many times table with few columns is already created. After a while there is need to add new column to the previously existing table. Sometime it makes sense to add new column in middle of columns [...]
Can we look forward to East-West battles fought in cyberspace?
Never mind MySpace and Facebook. Some major mainstream acts are creating their own social networks—in what is actually a savvy way to better control their digital marketing.
At first, I kind of rolled my eyes when Billboard and Reuters reported that folks as diverse as 50 Cent [...]
Access databases are the most easily prone database to get corrupted. Generally an error occurs in the binary file format of any database which results into unusable database. The .mdb database corruption is very common, minor and generally unknown to the user. The user eventually comes to know about it when this corruption gets worse. The most common causes of access database corruptions are hardware failures, software crashes, JET software crash, multi-user access, inefficient database design, virus attacks, password protections, unexpected system shutdowns and power failures.You can definitely prevent the access databases from being getting corrupted by following some simple measures;Perform backup of the corrupt file as soon as possible before using any recovery utility on the damaged
Any entrepreneur’s goal should be SUCCESS! If you aim for success, you must do everything within your means to achieve that. You just don’t go on sitting there in your house complaining about not getting as much profit as you expect. You have to keep moving. You have to pour in and invest enough time, money and effort to have profitable results.In doing internet business, you must aim just the same. You should maximize all of your internet marketing strategies, given the wide market that your business will be exposed to. Imagine the whole online community as potential clients!Now, one of the best marketing tools that you can use in your online business is building a list. An opt-in list is the best, most effective and smartest option that you can make to make it big. It is one thing to
Just received question from one of the DBA
Question: I do not have full backup of my database. My .mdf and .ldf are corrupted. Is there any way I can restore database now?
Answer: Sorry. I do not think there is any way you can do it. Try attaching this files to database using db_attach but if [...]
Tutorial Delphi ini berisi panduan untuk membuat aplikasi sederhana untuk menampilkan grafik penjualan sebuah produk per periode tertentu menggunakan Delphi. Tujuan tutorial Delphi ini adalah untuk memberikan panduan atau gambaran tentang bagaimana cara menggunakan komponen DBChart di Delphi. karena tulisan artikel ini cukup panjang dan mengandung banyak screenshoot, maka saya membaginya menjadi 3 bagian yaitu Persiapan, Koneksi DBChart ke Database SQL Server, dan Coding supaya tidak membingungkan dan loading halaman tidak terlalu lama.
Aplikasi ini akan menampilkan grafik penjualan sebuah produk tertentu dan per periode tanggal tertentu berdasarkan inputan dari user yang berupa nama produk dan periode penjualan. Agar lebih mudah maka untuk tutorial Delphi kali ini saya menggunakan tiga
Setelah tahap persiapan sudah selesai, tahap selanjutnya adalah menghubungkan ADSPenjualan, ADSProduk ke Database SQL Server melalul komponen ADOConnection dan kemudian menghubungkan DBChart1 ke ADSPenjualan.
Ubah properties Connection ADSPenjualan dan ADSProduk menjadi SQLServerConn agar kedua komponen ini bisa terhubung dengan Database SQL Server. sebagai tambahan kamu juga bisa menggunakan properties Connection String masing-masing komponen ADSPenjualan dan ADSProduk untuk koneksi ke Database, tetapi untuk menghemat koneksi ke-server maka saya menggunakan sebuah komponen ADOConnection sehingga jika ada komponen DBAware yang lain yang akan menggunakan koneksi yang sama, cukup kita hubungkan dengan komponen ADOConnection ini.
masukan sql statement berikut pada properties CommandText
Coding
Setelah Tahap persiapan dan menghubungkan DBChart ke komponen ADODataset dan Database SQL Server selesai, sekarang kita akan menuju tahap penulisan kode Program (Coding).
Kita akan mengambil data nama produk dari table Products, kemudian akan kita masukkan ke komponen Combobox1 ketika aplikasi pertama kali dijalankan. Untuk itu kita perlu menambahkan beberapa baris perintah pada event OnCreate Form1. Caranya dobel klik Form1 kemudian tambahkan kode perintah berikut ini kedalam Code Editor :
if not sqlserverconn.Connected then
sqlserverconn.Open;
ADSProduk.Close;
ADSProduk.CommandText := 'select productname from products group by productname';
ADSProduk.Open;
while not ADSProduk.Eof do
begin
combobox1.Items.Add(ADSProduk.FieldValues['productname']);
ADSProduk.Next;
end;
ADSPr
I have written 14 best practices here, read them all and let me know what is as per your opinion should be the 15th best practice.
1. Store relevant and necessary information in the database instead of application structure or array.
2. Use normalized tables in the database. Small multiple tables are usually better than one large [...]
The Database Engine Tuning Advisor (DTA) is a new tool in SQL Server 2005 that enables you to tune databases and improve the performances of your queries. DTA examines how queries are processed in the databases you specify and then it recommends how you can improve performance by suggesting the creation of indexes and statistics. It replaces the Index Tuning Wizard from Microsoft SQL Server 2000. You can use DTA to tune a database by using workload (trace files) that were previously created with the profiler or you can tune a Query directly in Management Studio. A workload is a set of Transact-SQL statements that execute against the database that you want to tune. The Database Engine Tuning Advisor use trace files, trace tables, or Transact-SQL scripts as workload input when t
Typed Data Object is a .NET source code generator (C#/VB) for data layers based on Microsoft SQL Server 2000/MSDE/2005/Express.
TDO allows .NET Framework 2.0 developers, to have the source code automatically generated for MS SQL Server databases.
Download Typed Data Object
Database in the SkyUsing a web service as your database can save you lots of time, money and frustration. Link - Wed, 02 Apr 2008 00:00:00 GMT - Feed (1 subs) Sent using SendMeRss.com. Visit here to unsubscribe from Entrepreneur.com E-Business . Recommended Feeds/Actions Subscribe MSNBC.com: Top MSNBC Headlines
Pro Oracle Database 10g RAC on Linux: Installation, Administration, and PerformanceApress | 824 pages | August 4, 2006 | ISBN: 1590595246 | PDF | 58 MbReal Application Clusters (RAC) and the Grid architecture are Oracle's strategy for scaling out enterprise systems to cope with bigger workloads and more users. Many books limit themselves by conceptualizing and theorizing about RAC technology, but this book is the first to portray implementing and administering an Oracle 10g RAC system in a Linux environment. This book features basic concepts underlying Linux and Oracle RAC, design strategies, hardware procurement and configuration, and many other topics.The RAC-specific technologies described include configuration of the interconnect, OCFS, ASM, Cluster Ready Services, and Grid Control. Th
Apache server log like this23.13.171.152 - - [26/Sep/2007:21:20:36 +0800] "GET /forum/Themes/BlueStory/images/bbc/ftp://ftp.gif HTTP/1.1" 200 191 " "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.7) Gecko/20070914 Firefox/2.0.0.7"could be parse to an sqlite database, with the class below.class Parser: def __init__(self, serverLog, db): if db.strip() == "": db = "log.db" try: conn = sqlite3.connect(db)
Apache server log like this23.13.171.152 - - [26/Sep/2007:21:20:36 +0800] "GET /forum/Themes/BlueStory/images/bbc/ftp://ftp.gif HTTP/1.1" 200 191 " "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.7) Gecko/20070914 Firefox/2.0.0.7"could be parse to an sqlite database, with the class below.class Parser: def __init__(self, serverLog, db): if db.strip() == "": db = "log.db" try: conn = sqlite3.connect(db)
Access Database Mechanic is a free tool from aadconsulting.com. this tool will automaticaly attempt to recover a corrupt MS Access database, using three operations: compact & repair, decompile, and complete rebuild of an .mdb. The applet also features a fail-safe mechanism that creates a uniquely named back-up copy of the .mdb before any recovery operation is attempted. This Versions Works on Access2000/2002/2003.
Version 1.1 adds:
Support for the Microsoft JET Compact Repair Utility
Now features rebuild for addtional objects: Import/Export Specifications, References, and Custom CommandBars
File download is one-fifth the size of v1.0 with a new and faster Install set.
Visit Site
Download Now