PCTeachME

So how do we manipulate images in Photoshop? ...well hang on a second, what you need to be is be very careful, as any changes to the image are destructive to the base image. This video will introd...

Layer masks are the bread and butter of merging layers together. In this video we shall look at how to perfom a basic layer mask which will transform a late evening image into an early morning vist...

This instructional video will teach you how to create 3D text within Photoshop CS4. This is one of many videos which can be seen at PCTeach.me. Come join the gang!

One of the most common requirements nowadays is to "stich" images together. Simply put this allows you to overlay multiple images together to create a larger image.

If like me you have a point ...

So what do you do when you only want a selective part of the image? Well...you could use the marquee tools (which most people do), but what is better is to use the crop tool. This tool is pretty ...

When you get down to altering your images it is important to work out the differences between certain tools. In this video we shall tackle the differences between the "Clone Stamp" and the "Healin...

With SSIS the first thing you need to understand in the basic concept of what "Work Flow" and "Data Flow" are.

This video will discuss the differences at a basic level ready for some more chall...

With any data that your going to import into a database there are problems with the way the data has been entered down to calculations displaying values to too many decimals.

To correct this you...

One of the transitions from a beginner to an intermediate developer in SSIS is the ability to configure packages that you have created en mass. This can be done in a variety of ways but the best wa...

When either importing data or ETL (Extract, Transform & Load) for a data warehouse, you quite often need to assign key values to your data so you can use these values to join/link on. For example, ...

With the any kind of database import there are always going to be data problems. Why? Well, it generally down to human beings. A computer is logical, a human is not. A computer does what its told...

A question was raised by one of our subscribers asking about variables and how they are used. So here we are! This video explains the basics of what variables are and how to configure and more im...

With the basics of variables discussed from our previous video we can now give you an example of how this all fits together. This video will show you how to use system and user variable to produce...

We are slowly getting there! Our packages are coming along quite nicely but then DISASTER! You are getting errors all of sudden. After you have ran around the office screaming for 5 minutes and g...

You will get to a point when uploading data to a database can get repetitive. The same structure of files needs to be imported over and over again. Instead of creating multiple data flow tasks yo...

Okay, this is a weird concept to understand to start with but after a couple of attempts makes a whole lot of sense!

The history brush is a way to retain all the changes you made but allow you t...

So with the basics of cloning and the healing brush discussed in a previous video. Its time to raise the bar. This video deals with how you can control the many aspects of the clone tool. In the ...

Photoshop make creating perspective editing a joy rather than a hassle!

"In perspective" editing is the ability to transform images without you having to worry about altering the size of brush, ...

Images can sometime not come out as expected. For example your in an underwater aquarium and take a few snaps of the fish but the image never looks good, either they are milky due to the camera lo...

If your like me, you sometimes have a great picture which from no fault of your own is a bit fuzzy. I have some great pictures but they never look as good as when you were there!

Sharpening ima...

This video will discuss briefly how you would produce your own action scripts which you can apply to an image or series of images. Creating Actions is quite a vast area so please treat this as a s...

Following a rather spectacular PC issue. I have had to build a new PC and reinstall all my software again. To this end I thought it was a good idea to record the installation of SQL Server 2008 R...

If you want to return values from any SQL source you need to understand the most fundamental statement.

The select statement by and large is quite easy to understand but bit by bit, line by line...

Following on from our previous video of how to display results from SQL by use of the select statement. We are now going to discuss the basics of filtering our information by use of the "where" cl...

When it comes to data manipulation there is only so much you can do. Most of the options on data manipulation stem from three sources:

1. Field Manipulation (the likes of case statements, if st...

The more data you start interrogating the more records you will return. Its always the same, you start off with basic criteria and before you know it you are referencing several tables to obtain th...

So if your here on this post you're after understanding the mysteries of Primary/Foreign key relationships. Well let me tell you they are an art form not an exacting science something at first you ...

"Before you can run you must walk". Never a more a true word said! If your intention is to produce reports for small to large businesses you need to ensure you have configured the server properly...

So, you have your server configured and ready for "Report Consumers" (posh way of saying users!). Where do you start I hear you asking? Well, if your a novice your best place to start is by using...

As we now have a report created in "BIDS", it will probably be a good idea to get it onto the Report Server which we configured a few videos back (see "Reporting Services - Configuration"). So how...

We have configured, designed (albiet by wizrd) & deployed our first report. Ready to create a report from scratch? Well this video will cover the basics of creating a report without the aid of a ...

The dataset,datasource and table are present on your report but something is missing.....I know formatting! You cannot have a report that does not have borders,font stylings and shading on can you...

With your report well underway, the next hurdle is ensuring your report is able to change its results depending on the criteria the user wants. this is accomplished by putting report parameters on...

Welcome to the start of a very exciting journey. You have chosen to discover how B.I. works from Microsoft viewpoint. The following video describes what SSAS prerequisite material you need to have ...

So, our first stop is to get to know the database we will be creating a cube from and also understand how we connect to it through Analysis Services.

What is a Data Source ?

A Data Source is ...

With our data source created we can now focus on the Data Source View.

What is a Data Source View ?

A Data Source View allows the developer to create a logic view of the data to be placed in ...

So we have created our logical view of our data it's now time to create our cube...or is it?

Can I create a Cube So Soon?

The Microsoft textbook response is you can tackle Cube creation head ...

After building our first Cube it becomes clear that the wizard although useful in creating quite a lot of the mundane/repetitive configurations, is let face it a little too basic for our tastes. Fo...

This fundamental video will describe how to navigate around the Excel Spreadsheet. Most users of Excel are self taught and as a result they can do most of thier day to day work with no problem. H...

The most basic thing you would do with a spreadsheet is create a calculation to add some values together. Well, its a relativley simple affair to do but there is a BIG gotcha if your not careful.....

So where to start? Okay, we have discussed what formulas are (see previous video), these are calculations that you perform on an individual cell basis.

For example "=A1+A2+A3".

Your soon goin...

With the basics of formulas and functions covered, you are going to need to copy these calculations across your spreadsheet. All well and good until you notice that in some cases the formula isn't...

After a while of using spreadsheets you get to a point where you need better control on how data is being presented to the end user. Quite often this requires you to make "interpretations" of the d...