Recover SQL database components in simple steps
Microsoft SQL is a relational database management system that is widely used in organizations to store data for customers and for accounting etc. MS SQL Server database is designed around the tables, each having several columns. SQL Server uses MDF file to save the records, views, triggers, primary keys, foreign keys, indexes and other SQL [...]
How to Restore SQL Database Easily Without Any Difficulty?
MS SQL is an application produced by Microsoft which is used broadly for efficient data management by many organizations around the world and has really become an indispensable need of users all over. SQL or the Structured Query Language helps the users to query the databases and also to easily retrieve information from databases that [...]
Caching Oracle Data for ASP.NET Applications
For building scalable and high-performance Web based applications, ASP.NET provides a feature called data caching. Data caching enables programmatic storing of frequently accessed data objects in memory. This feature can be extended to vastly improve performance for ASP.NET applications that query data stored in an Oracle database. This article describes a strategy for caching [...]
Creating an Ajax Process Using PHP and Oracle
For some time now, Ajax (Asynchronous JavaScript and XML), has been all the rage in the Web development world. Coming to the forefront with some of Google's features (Suggest, Maps, Gmail, and so on), Ajax performs server requests without the user having to submit a form or click on a link. In other words, the [...]
Database-Based Authentication for PHP Apps, Part 2
In Part 2, you will expand on the example authentication and user entry solution constructed previously. Whereas the current solution treats all users as equals, the idea of users accessing all things equally is unusual in real applications. Rather, your users probably have roles and privileges limiting their access to data based on their position [...]
Database-Based Authentication for PHP Apps, Part 1
Managing secure access to Web pages and applications is a common problem. You want to enable those you trust to access data while preventing unauthorized ones from gaining access to it. In most cases, database-based authentication is the solution. Authentication systems contain an Access Control List (ACL) that lists your user credentials and matches them [...]
Introduction to Legacy Modernization in Oracle
In this article by Tom Laszewski and Jason Williamson, we have outlined five methods of modernization: SOA Integration, Re-architecture, Platform Migration, Replacement, and Data Modernization as well as some key factors to be considered for each option.
Introducing SQL Developer Data Modeler: Part 2
Working with diagrams and their components You can waste away many hours laying out the elements on a diagram. Therefore, this aspect of modeling can be time consuming. However, a model serves as documentation and a communication device. Therefore, taking the time to make sure it is well annotated and clearly designed is important. Most [...]
Introducing SQL Developer Data Modeler: Part 1
Oracle SQL Developer Data Modeler is available as an independent product, providing a focused data modeling tool for data architects and designers. There is also a Data Modeler Viewer extension to SQL Developer, which allows users to open previously created data models and to create read-only models of their database schemas. SQL Developer Data Modeler [...]
Working with the Report Builder in Microsoft SQL Server 2008: Part 2
In the previous part of the article, we had a look at the Report Builder overview and described the Report Builder 2.0 interface. In this part by Jayaram Krishnaswamy, we will discuss about Enabling and reviewing My Reports, and will see how to Modify a basic report.