Mendapatkan informasi database 13 February 2009
Posted by igenx in SQL Server.add a comment
Kita bisa dapatkan informasi mengenai database dan informasi file nya dengan catalog view. Ada 6 catalog views yang berhubungan dengan database dan informasi file.
1. Sys.databases.
Berisi informasi mengenai database. Dengan hasil kolom database name, database id, owner_sid, and creation_date.
2. Sys.database_files.
Berisi informasi file database yang sedang digunakan. Hasil kolomnya file_id, file type, logical file name, and physical file name.
3. Sys.backup_devices
Informasi mengenai backup device hampir sama dengan procedure sp_adddumpdevice. Kolom yang dihasilkan name, type, type_description, physical name for each backup device.
4. Sys.database_mirroring
Menghasilkan informasi status database mirroring. Jika database offline or mirroring disabled, akan menghasilkan nilai NULL untuk semua kolom kecuali database_id.
5. Sys.master_files
Menghasilkan informasi yang sama seperti sys.database_files tetapi yang dihasilkan semua database termasuk database system.
6. Sys.database_recovery_status
Memberikan informasi mengenai recovery status untuk semua database.
Internals Viewer for SQL Server 13 February 2009
Posted by igenx in SQL Server.add a comment
SQL Internals Viewer is a tool untuk melihat lihat ke dalam SQL Server storage engine dan melihat data bagaimana disimpan atau lainnya.
Internals Viewer for SQL Server dapat di download dari http://www.codeplex.com/InternalsViewer
dari situ kita pilih untuk Sql Server yang diinginkan
Crystal Report Viewer 14 January 2009
Posted by igenx in Uncategorized.Tags: Reporting
add a comment
With Crystal Reports Viewer, you can:
- Empower report users to make better business decisions
- Explore reports interactively and minimize the number of reports generated
- Refresh reports hosted on SAP BusinessObjects servers
- Easily share your reports with co-workers, customers, and vendors
- Lower your report deployment cost and reduce IT support
- Support all new features in Crystal Reports
-Get free access to crystalreports.com-our on-demand reporting solution
- Open RPT files in Windows and on Macs
http://www.sap.com/solutions/sapbusinessobjects/sme/reporting/viewer/index.epx
harus registrasi dulu baru bisa di unduh.
Koneksi dari PHP ke Database MS SQL Server 23 October 2008
Posted by igenx in programming.7 comments
Pertama dibutuhkan php_mssql.dll
File php_mssql.dll tersebut berada pada paket PHP pada directory extension atau ext. Sebelum menggunakan extension SQL Server tersebut, Anda harus memodifikasi file php.ini karena biasanya file php_mssql.dll pada bagian extension masih di-disable atau diberi remark. Hilangkan tanda remark (;) yang ada pada baris yang berisi “extension=php_mssql.dll” kemudian simpan kembali file php.ini tersebut dan kemudian restart kembali service Apache Anda dengan mengetikkan perintah “net stop apache” dan kemudian “net start apache” dari DOS prompt Anda.
Untuk menguji apakah extension PHP php_mssql.dll sudah di-load dengan sempurna, maka Anda bisa memeriksanya dengan fungsi phpinfo()
Pada PHP telah tersedia fungsi untuk melakukan koneksi ke SQL Server yaitu fungsi mssql_connect. Fungsi-fungsi lainnya juga tersedia misalnya untuk melakukan query dan lain sebagainya (mssql_query(), mssql_fetch_array() dan lain sebagainya).
Berikut ini adalah contoh koneksi ke SQL Server dengan fungsi mssql_connect().
<?php if (mssql_connect('localhost', 'sa', '')) { echo 'Koneksi ke SQL Server sukses'; } else { echo 'Koneksi ke SQL Server gagal'; } ?> Koneksi ke SQL Server dan kemudian akan menampilkan informasi seputar server SQL Server dengan memanggil stored procedure sp_server_info. <?php if ($conn = mssql_connect('localhost', 'sa', '')) { $result = mssql_query("EXEC sp_server_info", $conn); while ($row = mssql_fetch_array($result)) { echo $row['attribute_name'] . ': ' . $row['attribute_value'] . '<br>'; } } else { echo 'Koneksi ke SQL Server gagal'; } ?> untuk SQL Server 2005 gunakan driver dari Microsoft sendiri http://www.microsoft.com/downloads/ details.aspx?familyid=85f99a70- 5df5-4558-991f-8aee8506833c& displaylang=en sumber penting : PHP Manual http://blogs.msdn.com/sqlphp/ http://www.phpindonesia.com/ http://devzone.zend.com/public/view
How to print all files in a folder in a single command? 22 October 2008
Posted by igenx in tips and tricks.add a comment
We can print one document in Windows XP. But how to we print all files in the folders? Ok. If one folder has 10 files we can open all files and then give print command. If 100 files are there and you have to take a printout of all of them what can we do? Here only notepad comes to our help here we can write a batch file and command it to print from a right place.
Lets see briefly how is this done.
First of all open note pad, through Start, All Programs, Accessories, Notepad then type the following code without fault.
@echo off
dir%1/-p/o: gin>
“%temp%\listing”
Start/wnotepad/p”%temp%\listing”
Del”%temp%%\listing”
exit
Save the file as printdir.bat, then save it in c:\windows folder. A small tip: – you can save this file in any name but you must give the extension as .bat only. Now you have successfully created a file to print. Now, let’s see how to print all files in a folder,
1) First double click the My Computer icon.
2) Select Folder options from the Tools menu
3) Then Click File types tab, it will be in the upper side of the screen.
4) You will find a file type below” Registered file types”
5) Select it and click Advanced Tab
6) This opens Edit File Type. In this you can see a button “New” click it
7) New action dialog box opens
8)Type print directory in action tab
9) Browse for c:\windows\printdir.bat through browse button at application used to perform action
10) Click ok and close all the dialog boxes
If lot of files is to be printed we can create a folder and put them inside it, now right click on the folder and select print directory option in it, if you select this all files in the folder will be printed.
