SQL Server 2005 – Using Database Snapshots

SQL Server 2005 – Using Database Snapshots In this tutorial you will learn about Using Database Snapshots in SQL Server 2005, Effect of the Update Pattern on Database Snapshot Growth, Metadata About Database Snapshots, Limitations on the Source Database, Limitations on Database Snapshots, Database Snapshots with Offline Filegroups and Best Practices for Creating Database Snapshots. Snapshots are read only static views of the database. This is a new feature introduced into SQL Server 2005 Enterprise edition to enable DBAs report on the database or revert to the source database if… Read More

SQL Server 2005 – Disaster Recovery

SQL Server 2005 – Disaster Recovery In this tutorial you will learn about Disaster Recovery in SQL Server 2005, Recovery Models, Managing Backup Media, Running a Base-Functionality Script and Ensuring Disaster Readiness. Disaster Recovery in SQL Server 2005 Most enterprises have mission critical data which is the very backbone of the business. The loss of such data would be disastrous to the business and may even result in closure. In such circumstances it is not surprising that organizations are very concerned about Disaster Recovery procedures. SQL Server 2005 provisions for… Read More

SQL Server 2005 – Managing Certificates

SQL Server 2005 – Managing Certificates In this tutorial you will learn about Managing Certificates in SQL Server 2005, SQL Server 2005 makes significant improvements in two areas—Native encryption and certificates. Encryption is a mechanism that is intended to protect data using a specially designed algorithm for converting content into a format different from the original. Reversal of the process requires an appropriate decryption key and algorithm that converts the data back into its original content. The key and the algorithm required for encryption and decryption may be identical or… Read More

SQL Server 2005 – Managing Permissions

SQL Server 2005 – Managing Permissions In this tutorial you will learn about Managing Permissions in SQL Server 2005. Authorization features determine the level of access rights once the user’s logon process is successfully completed. A significant aspect of SQL Server 2005 authorization mode is the user-schema separation. The schema forms the namespace boundaries and no two objects residing in the schema can have the same name. The objects also have four distinct parts—ServerName, DatabaseName, SchemaName and ObjectName. Secondly all objects within the schema have the same owner. The schema… Read More

Managing SQL Server 2005 Security

Managing SQL Server 2005 Security In this tutorial you will learn about Managing SQL Server 2005 Security. Microsoft has consciously invested in the creation of a precise and flexible security model of the database platform with security features that include surface area reduction, data encryption, native encryption, authentication and granular permissions and user and schema separations. This is part of the Trustworthy Computing initiative. SQL Server 2005 Security Overview The Trustworthy Computing initiative provides a framework for secure computing. Confidentiality, integrity and availability of data and systems are the cornerstones… Read More

SQL Server 2005 – Using the Database Tuning Advisor

SQL Server 2005 – Using the Database Tuning Advisor In this tutorial you will learn about Using the Database Tuning Advisor in SQL Server 2005, Using the DTA, Open the Database Engine Tuning Advisor GUI, Set the tool options, Hide and unhide the Session Monitor, Tune a workload Transact-SQL script file, View tuning recommendations, Starting the dta command prompt utility and viewing Help and Tuning a simple workload with the DTA command prompt utility. Using the DTA The first condition to launching the Database Tuning Advisor graphical user interface is… Read More

SQL Server 2005 – Tuning a Database

SQL Server 2005 – Tuning a Database In this tutorial you will learn about Database Tuning Advisor overview, Database Engine Tuning Advisor Features, Improved Workload Parsing, Enhanced Scalability, Integrated Tuning, Multiple Database Tuning, Offload of Tuning Overhead to Test Server, Drop-Only Tuningm, XML Support, User-specified Configuration and "What-if" Analysis Support, Analysis Reports, Tuning Sessions, Database Engine Tuning Advisor Tuning Capabilities and Tuning SQL Server 2000 and 2005 databases with DTA. Database Tuning Advisor overview In SQL Server 2005 the Database Tuning Advisor has been introduced in place of the Index… Read More

SQL Server 2005 – Defining Indexes

SQL Server 2005 – Defining Indexes In this tutorial you will learn about Defining Indexes in SQL Server 2005 – clustered and non clustered indexex, The Query Optimizer, to create an index, To create a unique index, To create a clustered index, To create full-text indexes, To change index properties, To rename an index, to delete an index, To specify a fill factor for an index, To create an XML index and To delete XML Indexes. When data volumes increase, organizations are faced with problems relating to data retrieval and… Read More

Maintain indexes in a SQL Server 2005 database

Maintain indexes in a SQL Server 2005 database In this tutorial you will learn about maintaining Indexes in a SQL Server 2005 database – Dealing with Fragmented indexes, Reorganizing an Index, Rebuilding an Index, Disabling Non-clustered Indexes to Reduce Disk Space During Rebuild Operations, Rebuilding Large Indexes, Setting Index Options, Page Splits and Performance Considerations, Max Degree of Parallelism, Online Index Operations, Partition Index Operations, Statistical Information, Asynchronous Statistics Updates, Disabling Automatic Statistics, Statistics after Upgrading a Database to SQL Server 2005, Bulk copy options and Index operation logging. The… Read More

SQL Server 2005 – Database Backup

SQL Server 2005 – Database Backup In this tutorial you will learn how to take database backup in SQL Server 2005. The database created above can be backed up at periodic intervals using the Backup Database dialog box in SQL Server Management Studio. The file gets stored in the .abf format. To display the Backup database dialog box right click a database in the Object Explorer and select Tasks > backup. The following dialog box appears The Database is the name of the currently selected Analysis Services database. They type… Read More

SQL Server 2005 – Populating the Database

SQL Server 2005 – Populating the Database In this tutorial you will learn how to populate the database in SQL Server 2005. One method of populating the tables in a database is to right click on a table and select ‘Open Table’ and entering the data in the visual mode that is displayed. Another method is to use the INSERT statement to add rows to a table. The syntax would be as under: INSERT [INTO] table_or_view [(column_list)] data_values   The SELECT subquery in the INSERT statement can also be used… Read More

SQL Server 2005 Configuration Manager

SQL Server Configuration Manager In this tutorial you will learn about SQL Server Configuration Manager, Manage Server & Client Network Protocols, To start the default instance of SQL Server, To start an instance of SQL Server with startup options, To stop the default instance of SQL Server, To connect to another computer with SQL Server Configuration Manager, To connect to another computer with Windows Computer Management, To stop the default instance of SQL Server using net commands, To set an instance of SQL Server to start automatically and To start… Read More

SQL Server 2005 – Using the Sqlcmd Utility

SQL Server 2005 – Using the Sqlcmd Utility In this tutorial you will learn about SQL Server 2005 – Using the Sqlcmd Utility, Running the sqlcmd utility, Sqlcmd rules – Quoted Strings, Code Page Conversion Rules and Interactive sqlcmd Example. The interactive execution of T-SQL statements and scripts is enabled by the Win32 Command prompt utility called sqlcmd utility. This utility can be used to build scripts to be run by sqlcmd users or to interactively enter T-SQL statements into the utility in a manner that is similar to working… Read More

Using the SQL Management Objects

Using the SQL Management Objects In this tutorial you will learn about Using the SQL Management Objects, Unsupported namespaces, Programming SQL Server Management objects, Setting Default Initialization Fields, Definitions, Capture mode, Linked servers and SMO methods and properties. SQL Server Management objects (SMO) exposes the functionality of SQL Server database and replication management. SMO can be used to automate repetitive tasks or commonly performed administrative tasks. The SQL SMO is implemented as a .NET assembly and the model extends and replaces the SQL Server Distributed Management object (DMO) of the… Read More

Using SQL Sever Management Studio – Part 2

Using SQL Sever Management Studio – Part 2 In this tutorial you will learn further more about Using SQL Sever Management Studio, Registered Servers, To Register a server, Server Groups, The Summary Page, The Database Engine Administration, The tasks of a Database Administrator Registered Servers Registered servers can be viewed in the Registered servers window. Servers can be created and registered, renamed or removed in the SQL Server Management Studio. Information on frequently accessed servers will be stored in the Management Studio on Registration. To Register a server Right click… Read More

Using SQL Sever Management Studio – Part 1

Using SQL Sever Management Studio – Part 1 In the tutorial you will learn about Using SQL Sever Management Studio, The features of the Management Studio, Starting SQL Server Management Studio, The Object Explorer and also Default. Optional connection settings. A Database Administrator typically grapples with tasks relating to accessing, configuring and administrating the components of the SQL Server. To assist the Administrator in this task, SQL Server 2005 provides a graphical user interface called the SQL Server Management Studio. The SQL Server Management Studio combines graphical user interface with… Read More

Oracle Reports 6i

Oracle Reports 6i In this tutorial you will learn about Introduction to Oracle Reports Builder, Report file storage formats, Oracle Reports Builder Tools, Report Wizard, Triggers in Reports, Types of Triggers and Case Study – Creating a Tabular report. Introduction to Oracle Reports Builder Oracle Reports Builder is a powerful enterprise reporting tool used to build reports that dynamically retrieve data from the database, format, display and print quality reports. Reports can be stored in File or Database (Report Builder Tables). Report file storage formats .rdf Report • Binary File… Read More

SQL Server 2005 – Using Event Notifications

SQL Server 2005 – Using Event Notifications In this tutorial you will learn about SQL Server 2005 – Using Event Notifications, Creating Event Notifications, Creating an Event Notification, Creating the Target Service, Creating /Dropping / modifying the Event Notification and Using Metadata Views. DDL statements or SQL Trace events execute Event Notifications. The information is sent to a Service Broker Service. These event notifications help in logging and reviewing changes occurring in databases. They perform action in response to an event in an asynchronous manner. They can be said to… Read More

Servlets Advanced

Servlets Advanced After describing some basic programming of servlets, we will describe some advanced topics of servlets in this tutorial, viz., Session Tracking, Servlet Filters, Servlet Life Cycle Events, Including, forwarding and redirecting, Servlet Chaining and Applet Servlet Communication. Session Tracking HTTP is a stateless protocol which means that each request done using HTTP is independent from each other. This is a restriction in HTTP since some applications like e-commerce sites require to hold state information. One of the traditional examples of state is a shopping cart. In this tutorial,… Read More

SQL Server 2005 – Using DDL Triggers

SQL Server 2005 – Using DDL Triggers In this tutorial you will learn about DDL Triggers vs DML Triggers, Syntax for creating a DDL Trigger, Designing a DDL Trigger, The EVENTDATA() Function, Implementing a Database-Scoped DDL Trigger, Implementing a Server-Scoped DDL Trigger, Event Notifications vs. DDL Triggers and General Trigger Considerations. DDL triggers fire stored procedures in response to DDL Statements which begin with CREATE, ALTER and DROP. The DDL triggers require that the DDL statements that trigger them are run and these triggers cannot be used as INSTEAD OF… Read More

SQL Server Monitoring Tools – Server Profiler

SQL Server Monitoring Tools – Server Profiler In this tutorial you will learn about SQL Server Profiler, To start SQL Server Profiler in SQL Server Management Studio, To start SQL Server Profiler in Database Engine Tuning Advisor, Security, Space Requirements, To change the TEMP environment variable in Windows operating systems, Using SQL Server Profiler and Analysis Services, Replay for Queries, Discovers and commands SQL Server Profiler SQL Server Profiler is a graphical tool that helps in the monitoring of an instance of SQL Server Database Engine or Analysis Services. The… Read More

SQL Server 2005 – Testing Troubleshooting

SQL Server 2005 – Testing Troubleshooting In this tutorial you will learn about Testing and Troubleshooting, SQL server services: Distributed Transaction Coordinator, Registry settings, SQL server settings, Configuring SQL server internal settings, Configuring Network Protocols. Testing and Troubleshooting Components of SQL Server may fail individually or individual components may fail when the SQL Server is run. This may be due to installation problems or other errors. A best practice that is followed is to enable the Error and usage Report settings at the time of installation. In SQL server 2005… Read More

SQL Server 2005 – Upgrading from earlier versions of SQL Server

SQL Server 2005 – Upgrading from earlier versions of SQL Server In this tutorial you will learn about SQL Server 2005 – Upgrading from earlier versions of SQL Server. SQL Server 2005 permits the upgrading from version 7.0, 2000 (with service pack 3) and 2003. SQL Server 6.5 will have to be upgraded to SQL Server 7.0 with service pack 7.0 and then to SQL Server 2005. The process of upgrading to these various versions requires a lot of careful planning. Data, Data Transformation Services packages, agent jobs, replication setup,… Read More

SQL Server 2005 – Unattended Installations

SQL Server 2005 – Unattended Installations In this tutorial you will learn about SQL Server 2005 – Unattended Installations, How to perform a silent installation of SQL Server, To Create .iss file, Basic Header Information for Our Script Files, Checking for the Parameters within the Script, Sample of the Combination of the .iss File within the Batch File, To set the security modes use the following code. Unattended installation is an installation of SQL Server that is done entirely using a script embedded in an .ini file. This file can… Read More

Servlet Basics

Servlet Basics Servlets are Java programs running on a web server that produce results viewed remotely on a web server. Servlets has the same purpose that CGI or PHP had in the past. We shall describe how Servlets works with some examples. You will also learn about Servlet Request and Response Model, Servlet Life Cycle, Servlet Scope Objects and Error Handling. Servlet Request and Response Model Note that although there are two types of servlets (GenericServlet and HttpServlet), we will discuss here only HttpServlet since GenericServlet can be used for… Read More

J2EE Overview

J2EE Overview J2EE is a technology that aims to simplify the design and implementation of enterprise applications. In this tutorial you will learn what J2EE is, its benefits, J2EE main components, Evolution of Enterprise Application Frameworks, Why use J2EE, J2EE Platform Architecture, J2EE APIs and Technologies and J2EE Reference Implementation. Before continuing our J2EE discussion lets define what an enterprise application is. Enterprise application is an application which probably has legacy existing applications and databases that you want to continue using them while adding or migrating to a new set… Read More

Metrics Used In Testing

Metrics Used In Testing In this tutorial you will learn about metrics used in testing, The Product Quality Measures – 1. Customer satisfaction index, 2. Delivered defect quantities, 3. Responsiveness (turnaround time) to users, 4. Product volatility, 5. Defect ratios, 6. Defect removal efficiency, 7. Complexity of delivered product, 8. Test coverage, 9. Cost of defects, 10. Costs of quality activities, 11. Re-work, 12. Reliability and Metrics for Evaluating Application System Testing. The Product Quality Measures: 1. Customer satisfaction index This index is surveyed before product delivery and after product… Read More

Syllabus for Certified Software Tester

Syllabus for Certified Software Tester In this tutorial you will learn about Syllabus for Certified Software Tester, Skill Categories, Test Principles and Concepts, Tester’s Role in Software Development and Acquisition, Test Management, Build the Test Environment, Risk Analysis, Test Planning Process, Test Design, Performing Tests, Defect Tracking and Correction, Acceptance Testing, Status of Testing, Test Reporting. The Certified Software Test Exam concentrates more on the following areas: Knowledge on the Test Environment. Ability to plan tests. Ability to execute tests, design test cases, use test tools, etc. Ability to develop… Read More

Software Quality Management

Software Quality Management This article gives an overview of Software Quality Management and various processes that are a part of Software Quality Management. Software Quality is a highly overused term and it may mean different things to different people. You will learn What is Software Quality Management?, What does it take to Manage Software Quality?, Quality Planning, Quality Assurance, Quality Control, Importance of Documentation and What is Defect Tracking? The definition of the ISO 8204 for quality: “Totality of characteristics of an entity that bears on its ability to satisfy… Read More

Software Project Planning

Software Project Planning This article explores the various aspects of Software Project Planning and Scheduling. Project planning is an aspect of Project Management, which comprises of various processes. The aim of theses processes is to ensure that various Project tasks are well coordinated and they meet the various project objectives including timely completion of the project. What is Project Planning? Project Planning is an aspect of Project Management that focuses a lot on Project Integration. The project plan reflects the current status of all project activities and is used to… Read More

Software Cost Estimation

Software Cost Estimation This article aims to study the process of Software Cost Estimation and its impact on the Software Development Process. We also highlight the various challenges involved in Software Cost Estimation and common solutions to navigate through these challenges. Background: Software Cost Estimation is widely considered to be a weak link in software project management. It requires a significant amount of effort to perform it correctly. Errors in Software Cost Estimation can be attributed to a variety of factors. Various studies in the last decade indicated that 3… Read More

Keep it Simple And Secure with Java

Keep it Simple And Secure with Java This article goes into details of how Java as a development technology can help developers to keep their applications simple and secure. Simple mean all way – it should be simple to code, modify, maintain, fix and deliver. Also we are going to cover security aspects of Java technology. Simple to Develop So let us first analyze how can we make it simple to develop applications, integrate them, modify them, maintain them and deliver them with ease. Some people have misunderstanding that Java… Read More

Performance Tuning of Java Applications

Performance Tuning of Java Applications Ever since the first version of Java Technology hit the streets, performance has been an important issue for Java developers. Java has improved dramatically and continually but, performance tuning is very essential to get the best results, especially when we think of J2EE applications. Introduction: Java Performance Tuning (abbreviated as JPT), 2nd edition provides a comprehensive guide to eliminate all the types of performance problems. By considering real-life examples JPT shows how to get rid off all the types of performances problems. For example JPT… Read More

SQL Server 2005 Installation – Maintenance Plan Without Using Wizard

SQL Server 2005 Installation – Maintenance Plan Without Using Wizard Earlier you learnt about Maintenance Plan Using Wizard, In this tutorial you will learn about Maintenance Plan Without Using Wizard. You will also learn how to change the tasks in the Maintenance Plan Wizard.   Creating a Maintenance Plan without using the Wizard. 1. In Object Explorer, expand a server, and then expand Management. 2. Right-click Maintenance Plans and select New Maintenance Plan. 3. In the New Maintenance Plan dialog box, type a name for the plan. 4. The Toolbox… Read More