I have just discovered that my favourite function exists in SQL. Select Case is to me, the best thing ever. Elegant, simple and powerful. Makes short work of processing and sorting in most scripts and programs. And today – whilst writing some queries for reports, I have now found that it exists in SQL! My
Continue reading T-SQL Case function
Removing All Users Desktop using Group Policy
This is one of those really frustrating finds, which if only the title mentioned the right words, would have been done in minutes. Setting up a group policy for use with some on-screen tests that we wanted to perform. We wanted a custom desktop with only the icons that they required. Little did I know
Continue reading Removing All Users Desktop using Group Policy
HP Z600 Workstation
Just received my new PC for home. After finally getting rid of all most of my old stuff. I had a rough outline of what I wanted – a single computer, capable of running 2-3 virtual machines concurrently, good sound, and good upgrade capabilities. Also I have been promising myself since completing my MCSE that I could
Continue reading HP Z600 Workstation
Wireless Network Channels
I have recently been reviewing placement of the WAP’s on our network, and the channels that we use. Until very recently, we had a mix of fixed AP’s in some areas, and mobile AP’s on laptop trolleys. In short, this didn’t work well. If someone moved a mobile AP into an area where it interfered
Continue reading Wireless Network Channels
SharedServices1 (Unprovisioning) – Delete the SSP failed.
Just had to do a restore of our Sharepoint server. Someone had deleted a load of resources from our room bookings site, but also deleted from the Recycle Bin. We use Symantec Backup Exec 12 with the Sharepoint agents installed. Took a backup of the current state of the server (after all, it does work,
Continue reading SharedServices1 (Unprovisioning) – Delete the SSP failed.
Could not access OWA using HTTPS – Error 404
Symptoms here are: Unable to access OWA Outlook 2007 reports that it is unable to change any Out Of Office settings; server unavailable. The enviroment: Microsoft Exchange 2007 running on Microsoft Windows Server 2008. One other symptom, which I don’t know if this resolved or something else did, is that the Free/Busy information was not
Continue reading Could not access OWA using HTTPS – Error 404
SharePoint_Config_Log file size is 78GB
Been doing a routine check of my servers, and noticed that our SharePoint server was lacking some free space. A little unusual, given our SharePoint installation is quite small. And although this server also acts as a Streaming Media server using Windows Media Services, I didn’t think that we had that much streaming media. Turns
Continue reading SharePoint_Config_Log file size is 78GB
POS for .NET & Star Micronics Printer
Slightly different topic today: Programming a POS application. I have been working on a lettings management program with built in till for use in our Sports Lettings. Couldn’t find anything out there that met all of our needs at a suitable price. So, I have took it upon myself to develop an application that does
Continue reading POS for .NET & Star Micronics Printer
For Sale: Compaq DeskPro EN
Having a bit of a clearout at the minute. Got 7 of these machines which I used for my MCSE and general systems testing, (even had one stand in as a temporary web server at work!). All in full working order and run very reliably. One has a crack in the front fascia. Intel Pentium
Continue reading For Sale: Compaq DeskPro EN
ISA 2006: Re-design
Just been working on our ISA infrastructure. We have 2 ISA servers, 1 for staff, and 1 for students. Main reason for the separate servers is that each ‘group’ have to go through a different upstream proxy server. (Bit of a pain, but that’s what we have to do.) Simple task this morning, block a
Continue reading ISA 2006: Re-design