Sangong Nick Softwares And Latest Windows Hackz: SQL
Contact Us:

If You Have Any Problem, Wanna Help, Wanna Write Guest Post, Find Any Error Or Want To Give Us Feedback, Just Feel Free To Contact Us. We Will Reply You Soon.

Name: *


Email: *

Message: *


Skillblogger

LiveZilla Live Help

Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Sunday, 1 September 2013

Download Oracle Database 10.2.0.1 (Oracle 10g release 2)

Download Oracle Database 10.2.0.1 (Oracle 10g release 2)


Oracle Database 10g is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers. With this architecture, each new system can be rapidly provisioned from the pool of components.

Note:
- Password to unrar if: http://www.oravn.com
- Link Folder versions of Oracle10g on FShare: http://www.fshare.vn/folder/TATM9S3AMT


1. Oracle Database 10g release 2 for Linux 64 bit

~ 740 Mb

Hotfile:

Code: 
http://hotfile.com/dl/161965279/375af96/10201_database_linux_x86_64.cpio.part1.rar.html
http://hotfile.com/dl/162036718/7dfa24c/10201_database_linux_x86_64.cpio.part2.rar.html
http://hotfile.com/dl/162049697/cd47a9b/10201_database_linux_x86_64.cpio.part3.rar.html
http://hotfile.com/dl/162062026/094976a/10201_database_linux_x86_64.cpio.part4.rar.html


Fshare:
Code:
http://www.fshare.vn/file/EVMK1KW25K
http://www.fshare.vn/file/X8UDCNUM9J



2. Oracle Database 10g release 2 for Windows 64 bit

~ 680 Mb

Hotfile:

Code:
http://hotfile.com/dl/161608224/7fcd243/102010_win64_x64_database.part1.rar.html
http://hotfile.com/dl/161615838/035527c/102010_win64_x64_database.part2.rar.html
http://hotfile.com/dl/161925733/17d163c/102010_win64_x64_database.part3.rar.html
http://hotfile.com/dl/161939965/55b0e9d/102010_win64_x64_database.part4.rar.html


Fshare:
Code: 
http://www.fshare.vn/file/1OJBW3RTTQ
http://www.fshare.vn/file/T8APR63U54


3. Oracle Database 10g release 2 for Windows 32 bit

~ 640 Mb

Hotfile:
Code: Select all
http://hotfile.com/dl/162160151/bc335e1/10201_database_win32.zip.part1.rar.html
http://hotfile.com/dl/162177947/6320f9a/10201_database_win32.zip.part2.rar.html
http://hotfile.com/dl/162260890/209554d/10201_database_win32.zip.part3.rar.html
http://hotfile.com/dl/162265336/4844ff1/10201_database_win32.zip.part4.rar.html


Fshare:
Code: Select all
http://www.fshare.vn/file/TH2YN8QS9T
http://www.fshare.vn/file/TTT77CN6NT


Password to unrar if: http://www.oravn.com
CALL: +237 77 81 20 63
 
Download Oracle Database 10.2.0.1 (Oracle 10g release 2)
Last Reviewed by S2Free Blog Team on June 29 2013
Rating: 4.5

Posted By: huikm on Sunday, 1 September 2013

Oracle SQL Developer Release 3.2 Here

Oracle SQL Developer Release 3.2 Here 

 Free by Oracle

Oracle SQL Developer is a free and fully supported graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.
 Note : May Direct Download Links Not Works Means You must accept the OTN License Agreement for SQL Developer to download this software.


Platform  Direct Links
Windows 32-bit - zip file includes the JDK1.6.0_35 Download Download 209 M
Windows 32-bit Download Download 174 M
Windows 64-bit
Download Download 174 M
Mac OS X
Download Download 173 M
Linux RPM
Download Download 173 M
Other Platforms
Download Download 174 M
__________________________________________________________________________________
Download SQL Developer 3.2.2 Patch Here 
Oracle SQL Developer 3.2.2 (3.2.20.09.87)
call: +237 77 81 20 63
November 1, 2012
 Note : May Direct Download Links Not Works Means You must accept the OTN License Agreement for SQL Developer to download this software.

Posted By: huikm on

Sending Automated Job Email Notifications in SQL Server with SMTP

Sending Automated Job Email Notifications in SQL Server with SMTP

 

Sending Automated Job Email Notifications in SQL Server with SMTP
Create Email Job alert for SQL replication successful / failed 
When you have automated backup jobs running on your database server, sometimes you forget that they are even running. Then you forget to check to see if they are running successfully, and don’t realize until your database crashes and you can’t restore it since you don’t have a current backup.
That’s where email notifications come in, so you can see the job status every morning when you are sipping your coffee and pretending you are working.
SQL Server provides a built-in method of sending emails, but unfortunately it requires you to have Outlook and a profile installed on the server, which isn’t necessarily the ideal way to send an email. Thankfully there is another method, that involves installing a stored procedure on your server that will allow you to send email via SMTP.
Download the sp_SQLNotify Stored Procedure here.
You will want to edit one line in the stored procedure to put the IP address of your SMTP server:
EXEC @hr = sp_OASetProperty @iMsg, ‘Configuration.fields(“http://schemas.microsoft.com/cdo/configuration/smtpserver”).Value’, ’10.1.1.10′
Install the stored procedure into the master database, so it can be easily used from wherever needed.
Open up the SQL Server Agent \ Jobs list, and select the properties for the job you are trying to create a notification for:

Click on the Steps tab, and you should see a screen that looks like this:

Click the New button to create a new job step. We will use this step to send the email notification on success.
Step Name: Email Notification Success
Enter this SQL into the Command window as seen below. You will want to customize the email addresses and message subject to match your environment:
exec master.dbo.sp_SQLNotify ‘server@localserver.com’,'admin@localserver.com’,'Backup Job Success’,'The Backup Job completed successfully’

Click OK and then click the New button again to create another step. This will be the failure notification step.
Step Name: Email Notification Failure
SQL:
exec master.dbo.sp_SQLNotify ‘server@localserver.com’,'admin@localserver.com’,'Backup Job Failure,’The Backup Job failed’
Now the idea is to make the items follow a specific workflow. First click Edit on step 1, and set the properties as shown here:

What we are saying is that on success, go to the success step, and on failure, go to the failure step. Pretty simple stuff.
Now edit the second step, the one labled “Email Notification Success”, and set the properties as seen here:

We are saying that if the notification job is successful, then just quit the job without running step 3. If we don’t specify this, then we will end up getting two emails, one with success and one with failure.
Now edit the third step, the one labled “Email notification failure”, and set the properties as seen here:
 
Now your job steps should look like this:

You should now have email notifications in your inbox for either success or failure.

Note: The stored procedure used in this article was found here, although that may not be the original source.
CALL: +237 77 81 20 63
Download the sp_SQLNotify Stored Procedure here.

Posted By: huikm on

Free SQL Server Backup Fast Restore Software

Free SQL Server Backup Fast Restore Software





SQLRestore screenshot



Sql database One-Click SQL Restore

This simple free tool restores full MS SQL server database backups created using BACKUP DATABASE command or



Why use One-Click SQL Restore instead of RESTORE command?

Because One-Click SQL Restore is much faster. It unzips the bak file if necessary, it connects to the SQL server on the start, it selects the right database, it is smart enough to restart the server to drop open connections if necessary - all you have to do is to press "Restore" button.
One-Click SQL Restore is most useful if you restore often. If you are a developer that needs to restore databases a number of times - it will save you tons of time. However it won't replace the RESTORE command in a complicated restore scenario.

Typical Scenario

Let's say you want to restore a backup created using SQLBackupAndFTP or BACKUP DATABASE command
  1. Double-click a *.bak file, or drag-and-drop *.bak or *.zip file onto One-Click SQL Restore
  2. Select a Target database or type a new name
  3. Press "Restore" button.

FAQ

Q: Can I restore not only full, but also differential backups?
A: No. Only Full. Use RESTORE for diff backup restore.
Q: I need other options: transaction log restore, file restore, snapshot, restart, etc?
A: Use RESTORE command instead. One-Click SQL Restore should be used in simple scenarios only.
Q: Do you overwrite the files when restoring to another database?
A: When restoring a backup from database X to database Y, we use "MOVE" option so Y files get overwritten.
Q: Restore errors
A: Most common errors are "The media family on device .. is incorrectly formed", "RESTORE HEADERONLY is terminating abnormally", "The backup of the system database on device .. cannot be restored because it was created by a different version of the server" - they all occur when you try to restore to an older SQL server. You can NOT restore backups from a newer SQL version to an older - the formats of (Microsoft) backup files are different. See our post on this.
Q: Does it have Command Line Interface?
A: Yes. Usage:
SqlRestore <backup file (.bak or .zip)> [options]

Options:
-run - runs the program in automatic (console) mode
-db <target database> - a target database where the backup file will be restored to
-srv <QL Server name> - SQL Server instance name
-usr <SQL Server user name> - SQL Server user name (if not specified, then Windows Authentication will be used)
-pwd <user password> - SQL Server user password (if not specified, then emptypassword will be used)
-help or -? shows this help
Q: Do you guarantee the safety of the data?
A: No (nobody would). Under no circumstances we accept any responsibility for the use and performance of this program. It is provided to you "AS IS" - use at you own risk (See EULA). In general, database backup and restore operations should only be handled by a person who knows what he is doing. It is very easy to overwrite an existing database and loose the data. If in any doubt - don't do it yourself, find a professional that could help.
Q: What license is it under?
A: It is a freeware - free of charge even for commercial use, you can install it on any number of systems, you will not have any proprietary rights, you can distribute it as long as you don't make money, you can not make it part of your program. See full freeware license
CALL: +237 77 81 20 63
 



Click to Download free fastest Sql server database restore
Download One-Click SQL Restore

Posted By: huikm on

Contact Us

Name

Email *

Message *

 

Latest post

About Us

Recent Comment

Copyright © . SkillBlogger. All Rights Reserved.
Designed by :-Way2themes