Category:

So You Thought You Wanted To Be A Teacher?

Exforsys
So You Thought You Wanted To Be A Teacher? It’s never easy when you realize that you went to school to get a degree and learn about something that you end up not liking. There are more people out there that dislike their job that you would think; many of them just don’t want to admit it. It’s hard to admit that you spent all that time (and money!) getting a degree and now you can’t stand what you are doing. Many people who go into teaching deal with this!… Read More

Why On Earth Would You Go Into Retail With A Business Degree?

Exforsys
Why On Earth Would You Go Into Retail With A Business Degree? Sometimes, we pick a major or degree program because it sounds like the ideal degree for us. But, halfway through school, or perhaps even after graduation the realization hits us that we no longer want to do what we set out to do. Well, you need a job to pay the bills, so why not turn to retail? While many people do not consider retail a career, it can be a very lucrative career when you have a… Read More

How The Internet Can Help You Get A Job

Exforsys
The Internet is something that just about everyone has access to, and most of us have access to it every day multiple times a day. The Internet is a huge resource for just about everything from communication to research. The Internet is a great resource for anyone looking for a job regardless of your past experience, current job, education, or the area you live in. If you can get on the Internet, you’ll find that it suddenly becomes easier to prepare for the application process as well as actually finding… Read More

Breaking Into The Entertainment Industry With Your Degree

Exforsys
Just about everyone has dreamt of being a rock star, a movie star, or even a world famous author but not very many people actually get to experience such a life. With the right college degree you can get pretty darn close to these people though, and you can make a decent living, as well. Many people find their way into the entertainment business on accident, but if you plan well you can end up there on purpose and succeed beyond your wildest imagination. You don’t have to have an… Read More

Don’t Like Your Job?

Exforsys
Don’t Like Your Job? So, you went to school and graduated with a great degree and got right into the workforce in record time only to find that you don’t like your current job. Now what? Do you just throw your hands up and decide to be stuck in a job that you don’t like forever? While it’s never a settling thing to change your career, it’s better to do it now, than to wait five, ten, or even fifteen years when you feel even more trapped in your career.… Read More

Take Control Of The Job Search

Exforsys
Searching for a new job can be difficult, but when you take control of the process, it can be a lot less stressful.  Before you begin looking for a job there are several of things you’ll want to plan for to reduce the stress and anxiety often associated with the job search.  If you have a job search plan in place you can take back control and not allow the stress and anxiety to win out.  When you have a job search plan you’ll be able to follow the process… Read More

You Have Your Psychology Degree, Now What?

Exforsys
You Have Your Psychology Degree, Now What? Psychology can be an intimidating field to go into because it’s very competitive, you may have to think about insurance, dealing with sick people, and it costs a lot to get such a degree! Obtaining a psychology degree is probably your biggest achievement to date, so you should be excited about putting your education to good use with a job of your choice. There are many different directions you can take with a psychology degree under your belt; you just have to go… Read More

Don’t Know What To Do With Your English Degree?

Exforsys
Don’t Know What To Do With Your English Degree? An English degree can guarantee you a great career if you know what you will do with it. Yet, many college graduates have a degree in English and aren’t quite sure what to do with it. Unfortunately, an English degree isn’t all that rare, so you won’t find that most employers stop in their tracks when they see that you’ve obtained such a degree. It’s not to say that graduating with such a degree isn’t an awesome achievement, you just need… Read More

Adapting To The Real World After College

Exforsys
Adapting To The Real World After College College students often get so wrapped up in the education process that they cannot see beyond their schooling and this can be a costly mistake. While the education process is important, you need to keep your eye on the prize, which is a great job that you believe you will love. Many college students struggle with the move from the college world to the “real world” of the world that requires them to put their education to good use. The real world often… Read More

What Employers Are Looking For During The Interview Process

Exforsys
What Employers Are Looking For During The Interview Process Interviewing can be difficult, but when you know what employers are looking for the task suddenly becomes manageable. Interviewing well is not just about experience, the ability to do the job, or the skills and education you have acquired it’s also about your ability to sell yourself to your prospective employer. While every employer has specific things that they are looking for in the way of past experience and education, almost all of them look for similar things in the people… Read More

Do You Really Want To Freelance?

Exforsys
Do You Really Want To Freelance? So many writers or those with journalism or English degrees decide that they want to work for themselves or as independent contractors for other people. Freelancing is a good idea in theory to most people, but it’s not as simple as it all seems. Freelancing provides many people with a source of pride and independence that they crave, but other people find that they feel lonely and overwhelmed and just can’t keep up. Freelancing is work just like everything else, but when you aren’t… Read More

Increase Your Earning Potential With Distance Learning

Exforsys
Increase Your Earning Potential With Distance Learning Many people find that they need or want more education once they begin working, yet it can be difficult to fit in more education once you begin working. A lot of people usually settle for the job that they have, the position that they have, and maybe even the pay that they aren’t satisfied with because they don’t know how to fit in the education. Yet, there is a way to further your education without stressing, taking away time from your job or… Read More

Career Tips: How To Get The Job You Want

Exforsys
Career Tips: How To Get The Job You Want There are some great career tips out there that just about everyone can benefit from, if only they had the information. Getting the job that you want doesn’t have to be difficult; you just need to know how to get noticed, what you can do to better your chances of being offered the job you want, and how to advance quickly. The attitude with which you start your career often dictates how successful you’ll be, so start out with the best… Read More

Is The Workplace Really Welcoming To Women?

Exforsys
Is The Workplace Really Welcoming To Women? Women in the career place have really made great strides in the last twenty to thirty years. Many still argue that women are not treated fairly in the workplace, but sadly this can be said about all minorities. The great thing is that today women can find their place in any career that they choose, as long as they have the motivation to succeed. Discrimination and glass ceilings are still very real, but if you know how to confront these issues you can… Read More

What To Do After Graduation

Exforsys
What To Do After Graduation What you do after graduation will depend on whether you already have a job or not. If you have a job you have certain decisions you need to make about whether or not you want to stay where you’re working and if you’ll want to ask for a raise. If you don’t have a job you need to get busy writing a resume and applying for jobs so you can start paying the bills. After graduation you’ll be looking at the beginning of your career… Read More

What To Do When You Don’t Land Your Dream Job Right Out Of College

Exforsys
What To Do When You Don’t Land Your Dream Job Right Out Of College Searching for a job can be very difficult especially when you got through your education with an ideal or dream job in your mind. Unfortunately, your dream job is not always something that just materializes after you graduate. Luckily, even if you are not able to get your dream job right out of school, you can work towards it. You don’t have to say goodbye to the dream job that you wanted, you just might have… Read More

Why You Need A Resume Right Now

Exforsys
Why You Need A Resume Right Now Many professionals believe that they do not need a resume and that they can simply continue to land good jobs through business contacts. Not having a resume is usually a mistake, as it’s a great way to get your foot in the door to bigger and better jobs. A resume is a way to make a first impression with people that you may know or not know and it allows them to consider your professional and educational qualifications and how you can be… Read More

Prepare Your Resume or Have a Professional Do It: The Best Advice For Your Situation

Exforsys
Prepare Your Resume or Have a Professional Do It: The Best Advice For Your Situation As competitive as the job market is today, you need to have a well-written resume. You have to assume that every job that you apply for has 100-1000 other applicants, which means you need a resume that makes a lasting impression on the employer. Without a well-written resume you’ll find it hard to even land a decent interview, let alone a quality job. There are circumstances in which you can probably write your own resume,… Read More

Resume Styles And Rules For Different Careers

Exforsys
Resume Styles And Rules For Different Careers Resumes are tricky because you want to give the best first impression you possibly can to a prospective employer, but you have no way of knowing what that person may expect of you. Knowing what types of rules and styles may be best for your career might help you tailor your resume so that you can impress your prospective employer even if you don’t know what he or she prefers from a resume. Being able to present yourself and your abilities well through… Read More

Does New College Graduate Equal Entry Level Jobs?

Exforsys
Does New College Graduate Equal Entry Level Jobs? Breaking into the career field of your choice after college can be more difficult than some people may imagine. During college all you can think about is the education and getting through the process of receiving that education, and when you graduate you suddenly aren’t sure what direction you should go in and your education doesn’t seem nearly as important as you thought it would be. So many college graduates believe that once they are through with school they have to get… Read More

You Landed A Great Job Interview. Now What?

Exforsys
You Landed A Great Job Interview. Now What? While applying for jobs can be stressful, interviewing for them can be just as stressful. Unfortunately, many people are so focused on actually applying for jobs that they forget all about how to interview well, or they may forget about the whole interview process altogether. Interviewing doesn’t have to be difficult, you just have to feel confident in your education and your experience, as well as know how to sell yourself to potential employers. With some preparation you can not only land… Read More

Applying For The Jobs That You Deserve

Exforsys
Applying For The Jobs That You Deserve So, you’ve finally graduated from college and it’s time to find a job! This is a scary and exciting time, and it can be a bit hard to determine what jobs you should be applying for. Many college graduates actually make the mistake of applying for jobs that they are over qualified for because they are intimidated by the jobs that they actually deserve based on their education. While you should be very confident after graduation, applying for those jobs that you’ve been… Read More

Continuing Education: Moving Up The Corporate Ladder Despite Your Age

Exforsys
Continuing Education: Moving Up The Corporate Ladder Despite Your Age The workplace often gets less comfortable and more competitive as you get older, though it doesn’t seem like it would. With many careers now, employers are able to hire younger employees to do the same job, with more recent education, for less money. This is a great thing for employers, but this is a bad thing for established employees that may not be up to date with education though they have been working loyally for the company for years. Many… Read More

Staying Afloat In The Changing IT World

Exforsys
Staying Afloat In The Changing IT World Jobs in the IT or information technology field almost always guarantee decent salaries, constant work, and an interesting work environment so they are attractive to many college graduates. Unfortunately, the longer you work in the IT field the more you’ll realize that you can easily get lost in the shuffle as new people come in and have more knowledge about newer technologies, standards, and the future of the IT field. The great thing is that you can stay afloat in the IT world… Read More

Breaking Into Your Field Of Interest With Education And No Experience

Exforsys
Breaking Into Your Field Of Interest With Education And No Experience Getting a job after college can be a scary experience for just about everyone, especially if you have little or no experience in your field of interest. However, just because you do not have experience in your field doesn’t mean you should expect to get a less than satisfying job, you just need to plan ahead for every interview and put your best foot forward. Employers know that everyone has to start somewhere, and while most like to see… Read More

Your Personal Appearance Can Help You Land A Job:

Exforsys
Your Personal Appearance Can Help You Land A Job Many of us say that the appearances of other people do not matter, but whether we are willing to admit it or not, someone’s appearance does affect how we perceive them. When we look at someone we instantly form perceptions about who they are, what they are like, and whether they may or may not be worth our time. This couldn’t be truer than when you go to a job interview where everything you do and say is very important. Learn… Read More

Break Out Of The Rookie Mold

Exforsys
Break Out Of The Rookie Mold Breaking into the career of your choice can be difficult when you have had very little experience. College graduates are often thought of as the new kid or the rookie, but there are some things that you can do to avoid this label, because once you’ve been given this label it’s really hard to get rid of it, even if you aren’t the new kid anymore! Your best bet is to go in with the right attitude and avoid the new kid or rookie… Read More

Quieting Job Search Anxiety

Exforsys
Quieting Job Search Anxiety Job search anxiety is very real for many people, especially when you have just graduated college and you feel the need to go out into the real world and prove yourself. A small amount of anxiety is natural, but for many graduates they find the anxiety paralyzing which only makes the search for a job even more difficult. If you put a plan into place you can quiet the anxiety a bit and make the search for a job exciting in addition to all the other… Read More

After Graduation: Where To Look For Jobs

Exforsys
After Graduation: Where To Look For Jobs Searching for a job can be very stressful for many students nearing graduation. Unfortunately, all the education in the world doesn’t teach you how to go out and find the jobs you need and want after college, so you need to know where to look to land that dream job. When you know where to look for a job, the search simply becomes a process instead of something that will stress you out. Many students make the mistake of taking time off after… Read More

Approaching Prospective Employers With Confidence

Exforsys
Approaching Prospective Employers With Confidence A first impression is everything, and by the time you graduate from college and head out into the real world you know this. When you are ready to land your dream job, or even a job that will lead to your dream job, you need to be confident. Sometimes, education isn’t what it’s all about. Some of the most well educated people are not at all confident and they have a hard time finding a job. You need to know yourself and your best attributes… Read More

How An Internship Can Help You Land A Job

Exforsys
How An Internship Can Help You Land A Job Resources and connections are everything when you are a student who is looking to land a decent job after graduation. An internship is a great way to help you learn not only the skills you need to get into the workplace, it can also help you build those all-important connections that you’ll need later on. An internship really is a huge stepping-stone to working in the real world. If you don’t have one yet, get one. If you’ve already started working… Read More

Watch What You Say: Don’t Lie On Your Resume

Exforsys
Watch What You Say: Don’t Lie On Your Resume Writing your resume is one of the most important things you’ll ever do. Your resume needs to be able to speak about who you are, even if you are not present when a perspective employer is reading it. Your resume needs to be professionally formatted and well written, but what is written is just as important as the way it’s written. As tempting as it can be, you should never lie or even exaggerate on your resume. Many people lie or… Read More

Can I Really Get A Job Right Out Of School?

Exforsys
Can I Really Get A Job Right Out Of School? College students are often lectured by professors, parents, and friends that they cannot expect to get a job right out of college. This sets a lot of students up for an anxiety filled graduation year as they scramble to figure out what they are going to do once they graduate. You really can get a job right out of college, in fact you can have that job lined up before you even graduate. Don’t believe what you hear about getting… Read More

Memory Training for Students

Exforsys
Memory Training for Students:  If you are a student, you know how difficult it is to stay up all night and cram for a big exam.  For many people it is very difficult to remember so many definition, terms and names. But, what if you had a great system to remember everything you studied,quick and easy.  Not only would your grades be off the charts, but you could cut your study time by not having to visit over and over information that you have trouble absorbing.  With memory techniques, you… Read More

What is User Acceptance Testing?

Exforsys
What is User Acceptance Testing? Introduction: This article attempts to explain the process of User Acceptance Testing. Once the application is ready to be released the crucial step is User Acceptance Testing. In this step a group representing a cross section of end users tests the application. The user acceptance testing is done using real world scenarios and perceptions relevant to the end users. What is User Acceptance Testing? User Acceptance Testing is often the final step before rolling out the application. Usually the end users who will be using… Read More

System Testing: Why? What? & How?

Exforsys
System Testing: Why? What? & How? Introduction: ‘Unit testing’ focuses on testing each unit of the code. ‘Integration testing’ focuses on testing the integration of “units of code” or components. Each level of testing builds on the previous level. ‘System Testing’ is the next level of testing. It focuses on testing the system as a whole. This article attempts to take a close look at the System Testing Process and analyze: Why System Testing is done? What are the necessary steps to perform System Testing? How to make it successful?… Read More

What is Regression Testing?

Exforsys
What is Regression Testing? Introduction: This article attempts to take a close look at the process and techniques in Regression Testing. What is Regression Testing? If a piece of Software is modified for any reason testing needs to be done to ensure that it works as specified and that it has not negatively impacted any functionality that it offered previously. This is known as Regression Testing. Regression Testing attempts to verify: – That the application works as specified even after the changes/additions/modification were made to it – The original functionality… Read More

Integration Testing: Why? What? & How?

Exforsys
Integration Testing: Why? What? & How? Introduction: As we covered in various articles in the Testing series there are various levels of testing: Unit Testing, Integration Testing, System Testing Each level of testing builds on the previous level. “Unit testing” focuses on testing a unit of the code. “Integration testing” is the next level of testing. This ‘level of testing’ focuses on testing the integration of “units of code” or components. How does Integration Testing fit into the Software Development Life Cycle? Even if a software component is successfully unit… Read More

SQL Server 2005 – Configuring Replication

Exforsys
SQL Server 2005 – Configuring Replication In this tutorial you will learn about SQL Server 2005 – Configuring Replication – New Types of Replication, Peer to Peer Transactional Replication, HTTP Replication, Configuring Replication Configuring Replication Using RMO, Referencing the RMO and SMO libraries and Creating a Subscription Using RMO. New Types of Replication New types of replications have been introduced in SQL Server 2005. The first of these is the Heterogeneous Replication which allows the publication of data from heterogeneous subscribers such as Oracle, DB2 using relevant ODBC drive and… Read More

SQL Server 2005 Replication Enhancements

Exforsys
SQL Server 2005 Replication Enhancements In this tutorial you will learn about Overview of Replication Enhancements, User Interface Enhancements, Merge replication concurrency Enhancements, Programming changes, The Replication Monitor, Performance and Scalability Features, Pre-computed partitions, Updates to unique keys, Transactional parallelism, Download and upload only articles, Reduced contention and Managing replication. Overview of Replication Enhancements The most striking aspects of the enhancements made to SQL Server 2005 replication services are that configuration wizards have been made simpler and shorter and performance and scalability have been improved. User Interface Enhancements The first… Read More

SQL Server 2005 – Mirror Server

Exforsys
SQL Server 2005 – Mirror Server In this tutorial you will learn about Mirror Server in SQL Server 2005 – Preparing the Principal and Mirror Server, Establishing a Mirroring Session, Establishing a Witness Server, Executing Transactions, Simulating Principal Server Failure, Restarting the Failed Server, Terminating the Mirror Session and Configuring Database Mirroring. Preparing the Principal and Mirror Server Database mirroring is easy to set up and can be made self monitoring for automatic failover in the event of the principal server being unavailable. The first step is to configure the… Read More

Unit Testing: Why? What? & How?

Exforsys
Unit Testing: Why? What? & How? In this tutorial you will learn about unit testing, various levels of testing, various types of testing based upon the intent of testing, How does Unit Testing fit into the Software Development Life Cycle? Unit Testing Tasks and Steps, What is a Unit Test Plan? What is a Test Case? and Test Case Sample, Steps to Effective Unit Testing. There are various levels of testing: Unit Testing Integration Testing System Testing There are various types of testing based upon the intent of testing such… Read More

SQL Server 2005 – Introduction to Data Availability

Exforsys
SQL Server 2005 – Introduction to Data Availability In this tutorial you will learn about Data Availability in SQL Server 2005 – Failover clustering, Database mirroring, Log shipping, Replication, Introduction to Database Mirroring and advantages of mirroring. SQL Server 2005 introduces several high availability solutions to improve the availability of servers and databases. These solutions mask the effect of hardware or software failure and maintain the availability of applications so that users perceive a minimum of downtime. The options for creating high availability for a server or a database include:… Read More

SQL Server 2005 – Backing up a Database

Exforsys
SQL Server 2005 – Backing up a Database In this tutorial you will learn about Backing up a Database in SQL Server 2005 – Backup and Restore operations, Restoring System Databases, Media Reliability, Using Checksums during backup and Restore and Backup Media mirroring. Backup and Restore operations. A backup is a copy of the data that is maintained for the purpose of restoration at a later date if a requirement arises due system failure. Failures can occur due to media problems, user errors, hardware failures or natural disasters. Backup of… Read More

Effective Software Testing

Exforsys
Effective Software Testing In this tutorial you will learn about Effective Software Testing? How do we measure ‘Effectiveness’ of Software Testing? Steps to Effective Software Testing, Coverage and Test Planning and Process. A 1994 study in US revealed that only about “9% of software projects were successful” A large number of projects upon completion do not have all the promised features or they do not meet all the requirements that were defined when the project was kicked off. It is an understatement to say that – An increasing number of… Read More

SQL Server 2005 – Using Database Snapshots

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

Exforsys
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

SQL Server 2005 Installation – Maintenance Plan Using Wizard

Exforsys
SQL Server 2005 Installation – Maintenance Plan Using Wizard Maintenance plans can be created using the Maintenance Plan Wizard or using the design surface. The Wizard is useful if the DBA wants to create a basic maintenance plan. If he intends to create enhanced work flow then, it is advisable to use the design surface. Maintenance Plans are displayed only to users connected using the Windows Authentication.   Invoking The Maintenance Plan Wizard from Add/Remove Programs. One method of accessing the Maintenance Plan Wizard is by navigating to the Add/Remove… Read More

Installing a Second Copy of SQL Server 2005

Exforsys
Installing a Second Copy of SQL Server 2005 Multiple instances of SQL Server are supported by SQL Server 2005. Previous versions of SQL Servers can also be upgraded to SQL Server 2005. In this section we shall see how to install a second copy of SQL Server 2005. A little later in this tutorial we shall examine how existing versions of SQL Server can be upgraded. If a version of SQL Server already exists on the computer, the second copy will be installed as a named instance. Insert the DVD… Read More

Planning to Install SQL Server 2005

Exforsys
Planning to Install SQL Server 2005 Different organizations have different application needs and hence installation requirements also vary. The different editions of Microsoft SQL Server cater to the varied needs and accommodate the performance, runtime and price requirements of organizations and individuals. The components that are installed on the server also will depend on the needs defined by the entity. Selecting an edition of SQL Server 2005 to Install SQL Server 2005 is available in a number of editions. However, organizations with mission critical information and large databases often select… Read More

New Features in Java 5 – From Programmers Point of View

Exforsys
New Features in Java 5 – From Programmer’s Point of View With emergence of Java 5, a set of new features is included in Java technology. Many programmers working on Java technology were excited before its release about its new features. In this article, new features of Java 5 are summarized which are important from programmer’s point of view. Language Features Get Rid of ClassCastException With Generics It is very common experience among programmers to face ClassCastException at run time while integrating different parts (modules) of application which are interacting… Read More

New Features In Java 5.0 – From Managers Point of View

Exforsys
New Features In Java 5.0 – From Managers Point of View The much awaited Java 5 has been launched in recent past by Sun. People who are in IT or related to IT industry were interested about its consequences on many factors. People who are developing applications using Java as a developing technology were more interested in new language features and other technological enhancements. But others for whom it is important to manage such process from higher level were more interested in things that are going to change with Java… Read More

Structural and Behavioral Design Patterns

Exforsys
Structural and Behavioral Design Patterns In this tutorial you will learn about Structural Patterns – Adapter, Bridge, Composite and Proxy. You will also learn about Behavioral Patterns – Iterator and Observer.Category : Structural Pattern Design Pattern : Adapter Brief Description : Highlights of the Adapter Design Pattern are: – This is a Structural Design Pattern and focuses on how the objects interact – relationships/interfaces between entities and objects – The key players are Generic Object with its interface Client specific Object with client specific interface Adapter Object that adapts the… Read More

Creational Design Patterns

Exforsys
Creational Design Patterns Creational Design is one of the Design Patterns used with .NET. In this tutorial you will learn about Creational Design Patterns, Factory Method, Abstract Factory, Builder, Prototype and Singleton. Creational Patterns : * Factory Method * Abstract Factory * Builder * Prototype * Singleton Category : Creational Pattern Pattern : Factory Design Brief Description : This being a ‘creational design pattern’ it focuses on how the objects are created. In the Factory design pattern – the client uses a specialized object solely to create other objects. In… Read More

Software Architecture & Design Patterns

Exforsys
Software Architecture & Design Patterns This article reviews some of the architecture Design patterns for Enterprise Applications built using the .NET Platform. Application Architecture: Software Applications come in all shapes and sizes. Based on their design and architecture enterprise applications can be classified into various categories such as: * Distributed Applications * Web Applications * Web Services * Smart Client Applications This article reviews some of the architecture Design patterns for Enterprise Applications built using the .NET Platform. Simply put Application architecture is: – Set of significant decisions about how… Read More

Java for Stand-Alone Applications

Exforsys
Java For Stand-Alone Applications Java programming language was primarily developed to deal with embedded applications. But with the introduction of Swing and other user interface utilities to Java, it made its mark in desktop applications too. Now the trend is to use Java technology in developing large web and enterprise applications. Java is more focused on web then desktop applications. But, in this article, we are going to discuss how useful Java is as a development technology for stand alone desktop application development in present scenario. Java is Suitable for… Read More

Is Ejb really significant in enterprise applications?

Exforsys
Is Ejb really significant in enterprise applications? Ejb was introduced to Java technology to attain some features inherent in enterprise applications. Those features include instance pooling, inbuilt security, declarative transactions, container managed persistence, relationship of business objects and caching etc. Now that many people have built their applications using Ejb, let us go back and analyze if Ejb as a technology is really significant in developing enterprise applications. We are going to analyze both pros and cons of Ejb based on experience of people who have used Ejb. Not Always… Read More

Future of Java Technology

Exforsys
Future of Java Technology When Java was developed initially as OAK even its developers were not sure in which direction the technology will grow. And actually Java has taken an unexpected turn around as a development technology. It started its journey with embedded applications but people found it somewhat slow when compare to C++. Java made foray into web in the form of applets and ruled the world for sometime. But then came enterprise era with crusade of .NET and J2EE. In this article let us examine possible directions where… Read More

.NET and J2EE – A Comparsion Study

Exforsys
.NET and J2EE – A Comparsion Study This tutorial compares .NET and J2EE, discussing various features of both the technolgoies and summarising when and where these technologies are suitable to use for entriprise application.   Competitive or Complementary? Introduction With the introduction of .NET technology Microsoft was focused to enjoy monopoly in market of development of enterprise applications. But later on J2EE even though being an open source technology fought back and made sure that most of enterprise applications are developed over the top of J2EE framework. In this article… Read More

SQL Server 2005 Installation

Exforsys
SQL Server 2005 Installation An interactive set up program helps the setup of SQL Server 2005. The steps have been designed to help the Administrator select the requisite options along the way. The setup screen automatically starts up as soon as the CD/DVD is inserted into the drive. If it does not, the user can start the setup process by browsing the contents of the CD/DVD and double clicking the setup.exe.   The first screen to be displayed is the end user license agreement(EULA). The user is expected to read… Read More

SQL server 2005 Editions

Exforsys
SQL server 2005 Editions The SQL Server 2005 family includes a number of editions—Express, Workgroup, Standard and Enterprise . Each of these editions comes with a range of features. These include high availability, Scalability to high business Intelligence tools—all aimed at empowering the organization and catering to mission critical information streaming down the levels in accordance with the security and authentication policies defined. The low cost mainstream database gives value and functionality and is a dramatic step forward in reducing application downtime. The following table indicates the scalability and performance… Read More

SQL Server 2005 Architecture Overview

Exforsys
In this tutorial you will learn about SQL Server 2005 Architecture, What’s New in SQL Server 2005—Enhancements for Data Base Administrators. indexing capabilities, peer to peer model of replication, Table and index partitioning, snapshot isolation, Replication monitor tool, security model, Encryption capabilities, Secure computing, A new application framework, SQL Server Express Manager (XM), Business Intelligence in SQL Server 2005, Integration services, Analysis Services, Data mining, Reporting services, Windows Server System Common Engineering Roadmap. The innumerable data challenges faced by modern day organizations have leveraged the need for faster and more… Read More

SQL Server 2005 – Management studio interface Summary Page

Exforsys
SQL Server 2005 – Management studio interface Summary Page The summary page appears as the largest window on the Management studio interface. This window presents information about the item selected in the object window. The summary page can be configured to start as soon as SQL Server Management Studio starts or later. When the list mode is selected the summary page shows information about the higher nodes. When lower nodes are double clicked the information with reference to the clicked item is displayed. Clicking on F7 invokes the summary page. The… Read More

C# Language Basics

Exforsys
This article provides an overview of the C# Language. The various elements and building blocks of the C# language are explained. Background What is C# all about? C# was developed at Microsoft. It is an object-oriented programming language and provides excellent features such as strong type checking, array bounds checking and automatic garbage collection. We will explore these and several other features in this article. C# has features that make it an excellent choice for developing robust distributed n-tier Enterprise applications, web applications, windows applications and embedded systems. It is… Read More

SQL Server 2005 – Server Groups

Exforsys
SQL Server 2005 – Server Groups In this tutorial you will learn about Server Groups. As stated earlier, servers can be grouped together. Each group can be assigned a name. The name of the server group can also be changed by right clicking on the group name, pointing to edit and selecting Server Group properties. The name can be changed in the dialog box that opens. 1. Server Groups can be created by right clicking the server type in the Registered servers toolbar. 2. Right click on a server or… Read More

SQL Server 2005 – Registered Servers

Exforsys
SQL Server 2005 – 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 a node in the Registered Server’s Tree and click Update Local Server Registration. This updates the local server registration. If a new server has to be created and registered 1. Click Database Engine in the Registered Servers tool bar… Read More

SQL Server 2005 Administrative Tools

Exforsys
SQL Server 2005 Administrative Tools Using SQL Sever Management Studio 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 a rich script editor, so that administrators can script and administrate from a single window. The SQL Server Management studio harnesses the power of the Enterprise manager and Query Analyzer… Read More

. NET Type Safety

Exforsys
. NET Type Safety   This Article discusses “What is Type Safety?” in the context of .NET, What is Type Safety? How does Type Safety affect us? Why is Type Safety Important? Writing Type-Safe Code. How is Type Safety ensured? What is Verifiable Type Safe Code? Verification process, How to determine if the code is type safe? What if the Code is not verifiably type safe? and What can happen if the Code is not verifiably type safe?   What is Type Safety? Type safe means preventing programs from accessing… Read More