21 Oct
Posted by jj as Database, SQL Server
This IBM® Redpaper gives a example of procedures to restore the Microsoft® SQL 2000 and 2005 using SnapManager®.There are options discussed that depend on the type of disaster, the type of data recovery, and the type of system on which the disaster applies.
Read the rest of this entry »
Microsoft Operations Manager (MOM) 2005 eases administration associated with managing today’s IT infrastructure environment. MOM 2005 helps simplify identification of issues, streamlines the process for determining the root cause of problems, and facilitates quick resolution to restore services and to prevent potential IT problems.
Read the rest of this entry »
The Forest Service has the capability to access data residing in Oracle and other databases with Office 2000. Microsoft Access is part of the Office 2000 suite and has a strong ability to “link” to tables in other databases including Oracle. The purpose of this paper is to explain how to configure a PC for the linkage and illustrate how to make the connection. The primary benefit of using Access to manipulate data is its rich interface to quickly design queries, reports, and forms for data entry.
Read the rest of this entry »
An attacker’s location in the application space and/or the network will largely define how they would approach breaking into a SQL Server 2000 machine from a remote location. If their attacks go through SQL Injection via a web server then their ‘cursus incursi’ will be considerably different from those when direct access can be gained to the SQL Server. Consequently, this paper will be split into four main sections. The first section will cover attacks that do not require the attacker to have a user ID and password for the SQL Server, that is, the attacks are unauthenticated. The second section will cover those attacks that do require authentication; to succeed the user must be logged onto the SQL Server. The third section will consider those attacks that can be launched from a compromised server.
Read the rest of this entry »
05 Sep
Posted by jj as Database, Oracle, SQL Server
This paper will examine the differences between the security posture of Microsoft’s SQL Server and Oracle’s RDBMS based upon flaws reported by external security researchers and since fixed by the vendor in question. Only flaws affecting the database server software itself have been considered in compiling this data so issues that affect, for example, Oracle Application Server have not been included. The sources of information used whilst compiling the data that forms the basis of this document include:
Read the rest of this entry »
This tutorial is all about implementing a Web-based calendar using open source technology. Specifically Java Servlets, Tomcat Server and MySQL database. All tools used to create and implement this project are open source projects and are free for the download under the GNU License Agreement. The freeness of open source projects allows practitioners to explore new technologies without incurring a huge investment. Furthermore, the software gets better as the project evolves which benefits everybody, end-users and developers a like.
Read the rest of this entry »
To install PHP on an NT/2000/XP Server running IIS 4 or newer, follow these instructions. You have two options to set up PHP, using the CGI binary (php.exe in PHP 4, or php-cgi.exe in PHP 5) or with the ISAPI module. In either case, you need to start the Microsoft Management Console (may appear as ‘Internet Services Manager’, either in your Windows NT 4.0 Option Pack branch or the Control Panel=>Administrative Tools under Windows 2000/XP). Then right click on your Web server node (this will most probably appear as ‘Default Web Server’), and select ‘Properties’.
Read the rest of this entry »
In this tutorial, I will dive into the nitty gritties of MYSQL 5 Application Development using the MYSQL Connector for .NET for Visual Studio.NET 2005 and build a simple Database Application using VC# and MYSQL 5.
This tutorial is a Level 200 session, which means that pre-requisite knowledge of the products is necessary.
System Requirements:
A basic P4 Machine with 512 MB RAM and about 40 GB HDD, a pointing device,
A keyboard and a monitor.
Software Requirements.
Development Software
Windows 2000 and above.
Read the rest of this entry »