This tutorial shows how to calcuate column values, use checkboxes in columns, and, have Excel take rows from one sheet that meet varying criteria and put those rows into other sheets.
It can be frustrating to discover that you cannot perform Windows Updates using Windows Update. This shows how to take care of that situation.
Recently encountered a legacy Windows 2000 server. Take a look at a blast from the past - it has come a long way since then.
Typing text along a path (such as typing text around a circle) can be useful; this tutorial shows you how with Photoshop CS5.
Using Illustrator CS5 convert graphic images to vector-ready .AI files that could be, for instance, used with laser fabrication.
Learn how to add multiple mailboxes to your Outlook client, in this case Exchange's postmaster account.
Project on cloning a hard drive in a netbook. Hard drives to fail, so why invest in lots of software and configuration time, if you don't have a good recovery strategy?
Project on the M11XR2 gaming netbook and examining applications for useability.
Project on modifying the Acer Aspire One Netbook and examining applications for useability.
Project on recognizing a browser-based virus alert false-alarm and removing it.
ASP / ASP.NET
Dealing with disabling a .NET submit button after it is clicked on.
Project on creating a solution file for a Visual Studio 2008 project when it does not exist.
Project tutorial on how to setup SMTP relaying to send email messages from a website.
Project tutorial on how to fix the SGEN error you may get involving a project with web services under Visual Studio 2008.
Project containing snippets of ASP.NET code that perform useful functions.
Project on constructing a web service from scratch using ASP.Net 3.5, .Net AJAX and JScript. Forget about the complexities of WSDL, XML/SOAP, ecetera because you'll never touch it; .Net will do it all for you!
Project on constructing a simple RSS reader using ASP.Net 3.5.
Project on working with master pages under the ASP.Net 3.5 umbrella.
Project on constructing a simple bot (crawler) to retrieve a webpage.
Project on redirecting users to another website and rewriting the URL while preserving protocol and query string data.
Project on getting all Active Directory user object and group object data and performing auditing using legacy ASP with a webpage.
Project on printing a PDF document to a primary printer or fail-over printer on your network.
Tips on setting up the full source version of the screwturn wiki so that you can use the SQL capability it has.
Project on working with Team Foundation Server 2008 AND Team Architect 2008 of Team Suite 2008.
Provide a calendar date and get a lot of data back such as # weeks in month, week the date falls on, first/last day, name of the day the date falls on, future date generation based on the date and more. All easy with the ASP.NET 3.5 class; free download!
Project on using the JSON-based graph API offered by Facebook.
Project on using the JSON-based graph API offered by Facebook in order to get wall posts of a public group wall in ASP.NET.
Project on generating RSS or XML feeds of the wall of a public group in ASP.NET; updated for the timeline layout without the graph API.
A lot of jQuery is simple to understand. Things get more complex with client-server tasks; this tutorial shows how to send/receive xml, json with jQuery and use authentication.
Project on conditional CSS and conditional comments and how that relates to CSS.
Php / mySQL
Creating a database, table, performing an insert and selecting data from a table in mySQL from PHP.
Working with the mySQL PDO in PHP is pretty straight-forward and helps eliminate SQL injections; tutuorial also shows working with encryption.
This tutorial shows how to upload, resize, save and display images with PHP and mySQL.
Website availability and diagnostic http/https tool with alert capability; monitor SSL certificates, expiration dates and websites.
Guide on how Drupal (open source CMS) and Ubercart interact in order to add categories, products and configure the shopping cart.
Guide on how Drupal (open source CMS) and Themekey interact in order to use multiple page templates (themes) on your website.
Project on working with PHP and a web service using XML-RPC.
Project on modifying your Wordpress blog to extend showing recent posts on PHP pages not recognized by Wordpress.
Project on setting up logon and password authentication on folders of a website with PHP.
Project on uploading a CSV, reading a CSV and sending a CSV to the web browser.
Windows Server 2003+
This tutorial shows how to secure different sections of Windows Server 2008 such as RDP, FTP, SSL, various injection methods and more.
This tutorial shows how to perform an installation of SQL Server 2008 and set it up so other servers/systems can communicate with it on the network.
This tutorial shows how to use various options of URL Rewrite under Windows Server 2008 for websites.
This tutorial shows how to install PHP, mySQL, Imagick on to Windows Server 2008 R2, 64-bit along with some useful maintenance commands.
Dealing with the Windows Server 2008 RDP time-out issue and one possible fix.
Create AD user accounts from a CSV, enable disabled AD user accounts, and, change AD user account passwords.
When a web server is showing nothing out of the ordinary that would result in websites being sporatically available, you may have a network issue. This tutorial shows how to isolate a website on the server from the network so you can find out.
Set of tutorials from installing Sharepoint 2010 with PowerPivot to development.
Project on measuring availability of computers by seeing logged on users using Powershell, communication over https and a data receiver.
Tips on creating a virtual directory on a website under Windows Server 2008 and IIS7.
Tips on working with Windows Server 2008 to remove offline file caches that are "stuck" (from a disconnected file server) so it will resolve to the new file server.
Tips on working with Windows Server 2008 in a cluster environment with DFS (distributed file system) and NLB (network load balancing).
Tips on installing Windows FTP 7.5 for IIS 7 on Windows Server 2008 in a clustered environment with shared configuration files.
Tips on importing SSL certificates to Windows Server 2008/IIS 7, repairing and exporting for backup and importing to other servers.
Project on editing the Microsoft IIS Metabase.xml file so a website can accept upload streams greater than 200kb.
A variety of linux command-line commands that may be used frequently.
Example bash script that monitors and gathers performance data on running processes like mysqld.
Example of cron job scripting in bash (Bourne) under Linux flavors Debian and Ubuntu.
Setting up a LAMP server inside of VMWare Workstation 9x. Why waste time setting up physical?
After building the base LAMP VM, time to clone it and work from the clones for further customization.
With the LAMP server cloned, this tutorial covers installing Zend Server and working with Zend Studio.
Setup a master repository for Git under Windows with existing source code.
Project on setting up mySQL Jet Profiler query analyzer to a mySQL database in Amazon RDS.
Setting up mySQL with SSH to RDS and connecting EC2 to RDS.
Create an AMI Image and new EC2 Instance from the snapshot of an existing EC2 Instance.
Detailed paper on web applications, vulnerabilities and methods to mitigate the attack surface.
In depth discussion of the "Project Tactical", an integral component of technology management.
Project on using Adobe Photoshop through a webpage to create images on a web site.
Project on selectively playing movie clips in a scene and detecting when a movie clip has finished.
Project on applying alpha (transparency) to a dynamically created text field located inside of a dynamically created movie clip.