words from Azhar

Introduction: A join is used to combine rows from multiple tables. A join is performed whenever two or more tables is listed in the FROM clause of an SQL statement. There are different kinds of joins. Let's take a look at a few examples. Inner Join (simple join) Chances are, you've already written an SQL statement that uses an inner join. It is the most common type of join. Inner joins return all rows from multiple tables where the join condition is met. For example SELECT suppliers.supplier_id, suppliers.supplier_name, orders.order_dateFROM suppliers, ordersWHERE suppliers.supplier_id = orders.supplier_id; This SQL statement would return all rows from the suppliers and orders tables where there is a matching supplier_id value in both the suppliers and orders tables. Let's look at some data to explain how inner joins work: We have a table called suppliers with two fields (supplier_id and supplier_ name).It contains the following data: We have another table called orders wit

You may get this error when trying to browse an asp.net application. The debug information shows that "This error can be caused by a virtual directory not being configured as an application in IIS." This error occurs probably in these 2 scenarios. 1- When you create an new web application using visual studio.net, it automatically creates the virtual directory and configures it as an application. However, if you manually create the virtual directory and it is not configured as an application, then you will not be able to browse the application and may get the above error. The debug information you get as mentioned above, is applicable to this scenario. To resolve it, Right Click on the virtual directory - select properties and then click on "Create" next to the "Application" Label and the textbox. It will automatically create the "application" using the virtual directory's name. Now the application can be accessed. 2. When you have sub-

Letters 'a', 'b', 'c' &'d' do not appear anywhere in the spellings of 1 to 99 Letter 'd' comes for the first time in Hundred Letters 'a', 'b' & 'c' do not appear anywhere in the spellings of 1 to 999 Letter 'a' comes for the first time in Thousand Letters 'b' & 'c' do not appear anywhere in the spellings of 1 to 999,999,999 Letter 'b' comes for the first time in Billion And Letter 'c' does not appear anywhere in the spellings of entire English counting

Introduction: The DISTINCT clause allows you to remove duplicates from the result set. The DISTINCT clause can only be used with select statements. The syntax for the DISTINCT clause is: SELECT DISTINCT columnsFROM tablesWHERE predicates; Example #1 Let's take a look at a very simple example. SELECT DISTINCT categoryFROM ebooks; This SQL statement would return all unique categories from the ebooks table. Example #2 The DISTINCT clause can be used with more than one field. For example: SELECT DISTINCT category, publisherFROM ebooks; This select statement would return each unique category and publisher combination. In this case, the distinct applies to each field listed after the DISTINCT keyword.

Introduction: The SELECT query/statement allows to retrieve records from one or more tables in database. The syntax for the SELECT statement is: SELECT [ columns] FROM [tables] WHERE [predicates]; Example #1 Let's take a look at how to select all fields from a table. SELECT *FROM ebooks WHERE author = 'Azhar'; In our example, we've used * to signify that we wish to view all fields from the ebooks table whose author is 'Azhar'. Example #2 You can also choose to select individual fields as opposed to all fields in the table. For example: SELECT name, ISBN FROM ebooks WHERE ebookid > 1000; This select statement would return all ebooks' name and their respective ISBN values from the ebooks table where the ebookid value is greater than 1000. Example #3 You can also use the select statement to retrieve fields from multiple tables. SELECT category.name,ebooks.ebookid, ebooks.name FROM category,ebooks WHERE category.categoryid=ebooks.categoryid; The result set wo

A data type is an attribute that specifies the type of data that the object can hold for example integer data, character data, date and time data, binary strings, and so on. SQL Server supplies a set of system data types that define all the types of data that can be used with SQL Server plus you can define your own data types in Transact-SQL or the Microsoft .NET Framework. Data types in SQL Server are organized into the following categories: 1 - Exact numerics bigint numeric bit smallint decimal smallmoney int tinyint money 2 - Approximate numerics float real 3 - Character strings char varchar text 4- Unicode character strings nchar nvarchar ntext 5 - Binary strings binary varbinary image 6 - Date and time date datetimeoffset datetime2 smalldatetime datetime time 7 - Other data types cursor timestamp hierarchyid uniqueidentifier sql_variant xml table

Before you edit the registry, export the keys in the registry that you plan to edit, or back up the whole registry. If a problem occurs, you can then follow the steps how-to restore the registry to its previous state. How to Export Registry Keys Click Start, and then click Run. In the Open box, type regedit, and then click OK. On the File menu, click Export. In the Save in box, select the boxs at the bottom the bottom according to weather you want to export all or only selected branches of the registry. Next select a location in which to save the backup .reg file. In the File name box, type a file name, and then click Save. How to Restore the Registry To restore registry keys that you exported, double-click the .reg file that you saved. 

Hey again, this is a real quick guide for anyone interested to get a movie onto there PSP without any trouble Movie - approx 40 minutes - dvd Saved to hard drive - 2.6 GB, Using DVD Decryptor (free program)  you can Download from this link  http://www.megaupload.com/?d=Z3Z6M9TR Transfered to avi format - 377MB- using Super DVD Ripper (9 FREE trial uses) then you must buy Transfered to MP4 - 37MB - using the (basically free) Image convertor 2 Average movie breakdown - using above as a guide only. so im guessing the average movie may be 4.5 GB for example saved to 800MB CONVERTED TO 70-80MB Ok use DVD decryptor to save the movie to your hard drive eg. C:\[Your Folder] When completed find the folder C:\[Your Folder] on your computer and find the vob file in that folder - generally the largest one and right click and play it with your dvd program to see what part it is. If its the correct movie part you now know thats the one you need. Once you have located the vob file you want to transf

A service-level agreement (SLA) is a document that spells out two or more parties' rights and obligations under a contract for work (such as between a company and its service provider). The main purpose of an SLA is to spell out the level of service that will be provided under the agreement. An internal IT services organisation may also provide an SLA to its internal business “customers.” The classic example of an SLA is with a software solution provider, where the document depicts like what penalties the provider will incur if its performance falls short of specified qualityand functionality levels. Usually, in this case, the penalties will follow a stepped schedule — for example, “If the software is found to have reported bug, then customer is entitled to a x percent refund of its software cost he paid for; and if the mutually agreed deadline passed then x percent of software cost will be deducted/refunded and so on. Why is it important to have an SLA? It is as important to have

 This reg file automatically ends tasks and timeouts that prevent programs from shutting down and clears the Paging File on Exit. 1. Copy the following (everything in the box) into notepad. QUOTE Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management] "ClearPageFileAtShutdown"=dword:00000001 [HKEY_USERS\.DEFAULT\Control Panel\Desktop] "AutoEndTasks"="1" [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control] "WaitToKillServiceTimeout"="1000" 2. Save the file as shutdown.reg 3. Double click the file to import into your registry. NOTE: If your anti-virus software warns you of a "malicious" script, this is normal if you have "Script Safe" or similar technology enabled.

Its been observed that many people around who most of the times hesitate to make a public speech. Many of the times it happens because those people really have fear in their minds for public speaking. I have personally experienced the feeling of inferiority or fear of not having much knowledge about the topic of speech. These are the major reasons for having public speaking fear. And after a lot of hard work and continuous practice I managed to overcome my public speaking fear. Here I logged 5 tips for you people who want to get rid of their public speaking fear. 1- Don't get scared to make mistakes: Yes when it comes to public speaking you are bound to make some minor or major mistakes. But it is the part and parcel of public speech. Don't be afraid of doing mistakes during your public speech. Only thing is that you should learn from your mistakes and try not to make those next time when you are presenting. Even if you make a mistake during your speech then don't get pani

The practice of enterprise architecture (EA) is to support the business decision making process by providng information about complex organizations' structures, their functions, and technology supports requirment for accomplishment of that functions. Considering EA as an IT job only will not be fair because it is far broader than that.It must be considered that, in most cases, increasing complexity in IT drives the need for adopting EA. EA is the model that helps in identification of relationships between the business and technology in such a way that key dependencies are exposed from the underlying complexity and so can be used to support decisions. E.g. by ascertaining which business processes are supported by a given software application, and then which platform the application runs on, it is possible to calculate the impact on the business of hardware obsolescence. From the same model, it would also be possible to examine, the cost of replacing the application, or which process

It’s a tough challenge to track your projects in hands. It all about handling and observing people, equipment, time, money and materials to complete your project on time. To do it successfully, you need to keep an eye on 5 key areas of your project. 1. Time and Cost Put an hour aside every week to determine if you are likely to complete the project on time. To do this, identify any tasks that are running late and determine whether they are likely to delay the overall project. Then look for ways that you can save time by; finishing tasks earlier, delaying non-critical tasks to after the project has been completed, or gaining approval from your Sponsor to remove tasks altogether. You also need to review the total spend of the project to date against the original budget set. Identify ways to reduce costs by allocating cheaper resource, reducing the project scope, or boosting the efficiency of your team. 2. Resource Allocation You need to keep a constant watch on the percentage of time tha

An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.Hosting.HostingEnvironmentException: Failed to access IIS metabase. The process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC). For information on modifying metabase permissions, please see http://support.microsoft.com/?kbid=267904 . This Error Caused Because You Not Have Register ASP.Net with IIS.Please Follow Following Step to Regiser ASP.Net With IIS. -> Go to Start - > Run -> Cmd. -> GO to Your System Drive Mostly C Drive. -> Type C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis -i Just wait And Message comes Successfully Register.

Follow the following steps 1. Open notepad.exe, type "del c:\windows\prefetch\ntosboot-*.* /q" (without the quotes) & save as "ntosboot.bat" in c:\ 2. From the Start menu, select "Run..." & type "gpedit.msc". 3. Double click "Windows Settings" under "Computer Configuration" and double click again on "Shutdown" in the right window. 4. In the new window, click "add", "Browse", locate your "ntosboot.bat" file & click "Open". 5. Click "OK", "Apply" & "OK" once again to exit. 6. From the Start menu, select "Run..." & type "devmgmt.msc". 7. Double click on "IDE ATA/ATAPI controllers" 8. Right click on "Primary IDE Channel" and select "Properties". 9. Select the "Advanced Settings" tab then on the device or 1 that doesn't have 'device type' greyed out select 'n

There Are Mainly One of the Two Reason Why you Got this Error Message. 1. If you Have Not configured your asp.net application in IIS. If you have not Configure your application to run on IIS First Configure your Site to Run on IIS.For that Create Virtual Directory From IIS and Give Permission to Application (Read,Write) 2. If Above is Not Problem Then There are Mainly Problem of Two or many Web.Config Exists on your Site.When you Open Some Site and if Software Crate Backup of that Application then Software mainly Do Create Subfolder and Copy All Files + Web.Config in Application.Just Remove this Subfolder web.config from Subfolder.

Most hosting companies offer a variety of bandwidth options in their plans. So exactly what is bandwidth as it relates to web hosting? Put simply, bandwidth is the amount of traffic that is allowed to occur between your web site and the rest of the internet. The amount of bandwidth a hosting company can provide is determined by their network connections, both internal to their data center and external to the public internet. Network Connectivity The internet, in the most simplest of terms, is a group of millions of computers connected by networks. These connections within the internet can be large or small depending upon the cabling and equipment that is used at a particular internet location. It is the size of each network connection that determines how much bandwidth is available. For example, if you use a DSL connection to connect to the internet, you have 1.54 Mega bits (Mb) of bandwidth. Bandwidth therefore is measured in bits (a single 0 or 1). Bits are grouped in bytes which for

The Project Charter describes the project vision, objectives, scope, organization and implementation plan. It helps you to set the direction for the project and gain buy in from your stakeholders as to how the project will be organized and implemented. It will also help you to control the scope of your project, by defining exactly what it is that you have to achieve. To define a Project Charter, these are the steps which needs to be taken carefully: Step 1: Identify the Project Vision Vision : The first step taken when defining a Project Charter is to identify the project vision. The vision encapsulates the purpose of the project and is the defined end goal for the project team. Objectives : Then based on the vision, list three to five objectives to be achieved by the project. Each objective should be Specific, Measurable, Achievable, Realistic and Time-bound (SMART). Scope : With a clear view of the Vision and Objectives of the project, it's time to define the project scope. Th

Inorder to define the scope of a project, you need to be a mind reader and need to have excellent analystical skills. The reason is that definition of Project scope comes early in the project,when no one really knows what the are the doables and undoables so everyone has a different opinion when asked. But if you don't define the scope early on, it will change during the project. You'll have moving goalposts which make it impossible to shoot for a success. So read these tips to get benefit from... The "project scope" covers all of the deliverables that must be produced to complete a project. You need to describe them in depth as early in the project as possible, so everyone knows what needs to be produced. Take these 5 Steps to scope your projects: Step 1: Set the Direction Start off by setting the direction for the project. Do you have an agreed Project Vision, Objectives and Timeframes? Are they specified in depth and has your customer agreed to them? Does everyon

Sometimes it happens that you dont get proper reward and recognition comparable to your efforts you put in your organization, may be it just cause by your strong focus on the projects you carry out, keeps you away from conveying the value you providing to your company. Inorder to get and sustain the repute of a successful Project Manager, you need to make and boost your personal brand so that others see you in the same way as you do yourself. Here I m stating 10 most important tips which can help you in acheiving your this particular goal. 1. Right relationship management with in the Organization The first step is to identify that from whom do you want recognition? is it your Manager or CEO? or someone else who has the stakes, you need to build your relationship with them, ideally on both a personal and business level. Make them aware of your role, how critical it is to the business and why they should care. 2. Build and follow their expectations Let them realize why your deadlines ar

To be a successful Project Manager you need to do more than just delivering projects on time and under budget. You need to deliver the business benefits expected by the customer from the project. The purpose of a Business Case is to justify the project expenditure by identifying the business benefits you're going to deliver. Here's how to create a Business Case in 4 simple steps: Step 1: Identification of the Business Problem Projects are undertaken to solve a particular business problem or opportunity. So you need to investigate that business problem or opportunity and describe what it is, how it's come about and the timeframes in which it needs to be addressed. Only with this knowledge, will you truly understand the purpose of the project and the timeframes for delivery. Without this knowledge, it's like building a house without a solid foundation. Step 2: Identification of the Solutions Now that you understand the business problem/opportunity in depth, it's time

As a Project Manager, now that the New Year has started you will need to report on the status of your projects. Your Project Sponsor will want to know if you're on track and when their project will be complete. To help you do this, read these... Project status: Create a weekly Project Status Report to show your actual vs. planned effort, percent complete and actual vs. forecast spend. Specify the number of open risks, changes and issues, and state whether action by your Sponsor is required to resolve them. Also show the forecast amount of time, effort and money required to finish the project. Always try and forecast as accurately as possible. Never forecast optimistically, always conservatively. Task completion: You need to regularly show your Sponsor your progress against the tasks listed on your schedule. Create a summarized view of your project plan and update it to reflect the percent complete for every task. Then append this summary view to your Project Status Report. This w

Congratulations !!! you've got a new project. What do you do next? How do you start up the new project quickly and efficiently? Read on to find out tips and hints on how to start a new projects Every time you're given a new project, take these steps to ensure you're on the right track from the start: Taking Responsibility: Before you agree to take on the responsibility of managing a project, make sure there is adequate sponsorship, and that you have adequate funding and resources to complete it on time. Your gut feel should be that the project is achievable and that whatever happens, you'll have the full support of your Sponsor through the project. If it's not feasible or you lack support, then solve these two problems first, before you start out. Clarifying the Scope: The next step is to review the scope of the project to ensure that all of the deliverables to be produced during the project are adequately defined. You don't want to get part way through the pro

Are you interested in using project standards and best practices for your projects? It's not as easy as you might think. While there are a variety of standards on the market, they are usually published as a book which makes it harder to implement. So read on, to find out: A Project Standard is a documented set of guidelines to follow for undertaking projects. The two most popular Worldwide Standards are PMI® and Prince2® . They provide generic guidelines for all types of projects, regardless of the industry. These two Standards use different terminology and have different Project Life Cycles, so we suggest choosing only one standard to follow for your projects. To help you choose which standard to follow, PMI® Standard was written initially with the American target market in mind, so use this Standard if you are an American-based culture. Whereas Prince2® was written initially with the UK market in mind, so if you're an English-based culture, use Prince2®. Once you've mad

There are lots of methods and tricks which a Project Manager can apply to boost his/her team performance as success in completing a project in cost and time effective manner depends upon performance of the team lead by the their manager. So if you are a project manager and want to improve your team performance, then read these effective 10 tips : Tip 1: Share vision of the project with your team mates People only perform well in a role if they understand what it is that they need to deliver and why. For this reason, we suggest you get your team together to reinforce the project vision, objectives, timeframes and deadlines. Make your team feel wanted and needed by showing them that the project is critical to the success of the business. You will gain their buy-in and their commitment going forward. Tip 2: Meet them individually Besides having a collective team meeting, take each team member aside and tell them what it is that you need from them to help you deliver the project. Make sure

There are certain reasons or pitfalls in your proposal that can let your impression down in front of the contracting officer(s), taking explicit care of these deficiencies can minimize the chances of absolute failure. These are as follow Your proposal is not complying with the instructions mentioned in RFP like · Organization of the proposal and flow of the content presentation. · Format of Sections and Subsections · Mandatory Information Requirements · Specifications regarding Fonts’ family, size and color etc. · Specifications regarding number of pages · Deadline (in terms of Date and Time) for submission. · Proposal Evaluation Criteria ( The criteria mentioned explicitly for grading of the proposal) if mentioned in the RFP · Problems’ domain knowledge explanation · Expected solution designs requirements · Presentation of complete solution development life cycle (how and whom will carry out what). · Reasonab