Welcome to Part 5 of our free SQL 101 training series covering the basics in SQL Server 2008 administration. Today we will focus on the UPDATE statement.

Your instructor, Mel Haynes, will be covering the UPDATE statement definition, updates based on a value, nested statements and how to update all rows.

All student files are available for download here.

Let us know what you think about this lesson and the previous videos too.

Click to Play — SQL 101 Part 5: The UPDATE Statement

Read the rest of this entry »

There are a number of Vista certification exams that you can take. One popular choice is exam 70-622: Supporting and Troubleshooting Applications on a Windows Vista Client for Enterprise Support Technicians

I have already outlined the 70-622 exam in one of my previous articles, where I provided an overview of the skills needed for the exam and how to achieve the MCTS certification.

Today I’m going to focus on one area of the 70-622 exam — Deploying Windows Vista segment of the exam, specifically the section that covers analyzing the business environment and selecting an appropriate deployment method.

Deploying Windows Vista

The 70-622 Vista Desktop Support for Enterprise Technicians exam measures a number of different skills and the first section of topics for the exam encompasses the following:

• Analyze the business environment and select an appropriate deployment method
• Prepare a system for clean installation or upgrade
• Deploy Windows Vista from a custom image
• Perform post-installation tasks
• Troubleshoot deployment issues

Read the rest of this entry »

A few weeks ago I talked about Adobe Acrobat replacement along with 7 other must have Windows utilities.

Last week I showed you how to use CCleaner to improve Windows performance. Today I’m going to show you how to speed up your Windows by replacing Acrobat Reader.

What started out as a tiny little utility to allow anyone to view a file the same way it looked on the creator’s computer has turned into a massive piece of bloatware complete with unasked for add-ons, always-on services taking up system resources, and a start time that would make turtles laugh out loud.

Of course, we’re talking about Adobe Acrobat Reader.

Adobe Acrobat — Bigger But Not Better

The current version of Adobe Acrobat Reader weighs in a 32 MB (though you can get a lighter weight version if you pay close attention when selecting your download) and takes up over 130 MB when installed. That seems like an awful lot for a program that most people just need to display PDF files on their computer screen. But, it gets even worse.

Read the rest of this entry »

Welcome to Part 4 of our free SQL 101 training series covering the basics in administration of SQL Server 2008. Today’s video will focus entirely on the INSERT statement.

In case you missed them, here are the previous videos in the series:

Part 1: Intro to SQL Server

Part 2: Database Concepts

Part 3: Intro to Structured Query Language

Note: All student files are available for download here.

Click to Play — SQL 101 Part 4: The INSERT Statement

Read the rest of this entry »

I’ve already introduced you to some of the most common network attacks like the IP address sweep, port scanning, and IP spoofing.

I have also recently covered the ping of death and other network attacks, including the SYN flood, UDP flood, ICMP flood and the teardrop attack.

Now that we have the basic Denial of Service Attacks (aka DoS attacks) and the Reconnaissance Attacks out of the way, let’s talk about other types of network attacks.

Today I’ll focus on:

• Access Attacks
• Worms, Viruses and Trojan Horse attacks
• Application Layer Attacks

I hope that this article, along with my previous ones, will shed some light on vulnerabilities in security and help you with your concerns regarding your network’s security needs. It may even inspire you to get your CCNA Security Certification.

Read the rest of this entry »

CCleaner — Make Windows Faster, More Stable & Free Up Space

Recently, we talked about 8 must have Windows utilities.

Some improved Window’s default functionality via replacement utilities. Some of the top must have utilities improved security and privacy.

But, CCleaner provides a critical function for high-performance Windows computing that doesn’t even exist in a standard Windows installation.

Junk Files, Junk Registry Entries, Junk Cookies — Just Some of What Slows Down Windows

Membership in the group of people who think that Windows is tight, highly-efficient code is limited to those who have spent time in a rubber room. It is no secret that the Windows code-base has bloated over the years. What is less commonly known is just how much junk gets left lying around your PC.

Whether it’s Windows not cleaning up after itself, or other applications littering temp files all over your disk, if you’ve never run a system cleaner before, you’ll be shocked at how much clutter is hampering the performance of your computer. It’s not uncommon to free up hundreds of megabytes of disk space.

Read the rest of this entry »