JOEL LIPMAN Systems / Automation / AI

Knowledge base / Since 1999

Microsoft Tutorials & Guides

Practical Microsoft tutorials, troubleshooting notes and implementation guides from real projects.

Advanced search

91 entries / Microsoft

Clear filters
Set up Desktop SlideShow in Windows 7
Windows OS

Set up Desktop SlideShow in Windows 7

Applies to Windows 7. Requires a Vogonian environment of red tape and bureaucracy. This is an article to describe an alternative method then "right-clicking on the desktop", "selecting Personalize", "clicking on Desktop Background", "browsing to the Picture Location". The problem happens when browsing to the picture lo...

Read note 35,575 hits
About 5 seconds worth of fun
SharePoint

About 5 seconds worth of fun

Really not work related but if you know your sharepoint site: Custom Error http:///_layouts/MySite.aspx?Error=You%20are%20a%20jerk%20and%20SharePoint%20does%20not%20share%20with%20jerks. Installer?

Read note 19,112 hits
Sync Outlook 2007 Shared Calendar with SharePoint 2007
SharePoint

Sync Outlook 2007 Shared Calendar with SharePoint 2007

I misunderstood what was going to happen when I started this. We have a SharePoint 2007 site and we have been asked to migrate links and calendar from an existing system. I was worried when following other instructions because I thought my personal calendar in Outlook 2007 would be completely shared with everyone who h...

Read note 39,749 hits
UNC Paths in Sharepoint 2007 links
SharePoint

UNC Paths in Sharepoint 2007 links

I've been tasked with adding links to files located on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. I could map the UNC path to a drive letter and then link to it (eg. I:\myFile.doc)but what if other users haven't mapped the same drive letter to the path? Then they won't be able t...

Read note 22,926 hits
Print Directory Contents to a File
Windows OS

Print Directory Contents to a File

We can do this by adding an entry to the context menu (when you right-click on an object). The following is a method of adding this as a single command similar to how we add the "Command prompt from here" option (now built-in to Windows 7). I added this option for him in Windows 7 Ultimate using the system registry (se...

Read note 31,707 hits
Select unique values in Microsoft Excel column
Excel

Select unique values in Microsoft Excel column

Thought I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000<>"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to A1000 and excludes the blank/empty cells. Display all Unique...

Read note 21,173 hits
How to change local folder for TFS
Team Foundation Server

How to change local folder for TFS

I installed Business Intelligence Development Studio 2008 (BIDS) and connected it to a Team Foundation Server 2010 (TFS) instance and set my working local folder to my home directory. When the rest of my colleagues installed it however, they decided to use a common local directory for all workstations so configuration...

Read note 59,746 hits
Returning Oracle Stored Procedure Resultset in SSRS
SQL Server Reporting Services

Returning Oracle Stored Procedure Resultset in SSRS

So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than "fun" as most of the examples on the net are either half-complete or par...

Read note 163,278 hits

Working principle

Our Purpose

This site exists as a practical knowledge base built from real-world experience across systems, platforms, and technologies since 1999. Much of the content documents solutions, edge cases, and working patterns that were learned through investigation where documentation was incomplete or absent, and is shared to reduce the same friction for others.

27 Years in IT
1021 CRM clients
810 Site articles
29.7m+ Reads / hits

Knowledge base

Search notes

Find matching words in article titles and content.