Who Gives a .... Anyway

Yesterday afternoon after 6 years of solid uninterrupted service my hard drive on my SBS 2003 server failed. I was pissed, the server had been telling me for about 3 months that it was coming, and I had just ordered a drive to mirror the system volume, and it had failed 2 days too early. My BAD. After calming down I thought well I better pop out and get a new SATA drive (or 2, to do the mirror). I had been backing up; using standard NTBackup, to an external drive (which I was alternating) and the backup has been reporting success. I also use SyncToy to backup the critical data to an external drive attached to my Laptop, so I was confident the critical data could be recovered. I saw a mountain ahead to climb as I was a bit worried about all the settings for: users firewall, RRAS, VPN, SSL certificate for Active Sync access mailbox data on Exchange my SQL Express data and the internal websites Once I had purchase a drive, I started loading the SBS box again. I googled to see if there wer...

I recently wanted to import data from an existing system that is written in Access. The system allows for XML imports. Since I needed to do some background programming on the system, I opted to rather to it programmatically than use the standard export, since I would have to do it a few times, and also manipulate the data once it was imported and then exported. I struggled to find information on how to do this, so eventually decided to figure it out myself and this is how I did it: In Visual Studio I created a new project I added Connected to Access database using the Database Explorer, this created a link in the App_Data folder Then on the default page I allowed the user to place the file name, I then added a new DataSet, created a new TableAdapter, put the query I needed in there and Then in my code I exported to XML So the in Default.aspx It looks like this: File to Export to: < asp : TextBox  ID ="tbxCustomersToXML"  runat ="server" Width =...

We are using Twitter to send out news, and would like to post that one a page on our website, so off I went reading about what and where to do.  On the Twitter dev page I found, the below: Web Applications Being browser based, a web application or service is able to use the full web-based  OAuth process  which means the user has the smoothest of the authentication methods. To authenticate your web application with Twitter you must use OAuth. Requests to use xAuth will be declined. Web applications often support multiple users so it is important you manage the association of OAuth tokens to user identities carefully. The way you do this will be dependent on your application and setup. Search API The search API does not require authentication. Streaming API The streaming API supports both basic and OAuth authentication. For the time being there is no date on which basic authentication will be turned off for the streaming API so you are free to choose ...

There are three R's in lots of things, the three R's I am talking about here are Reuse, Recycle and Reduce. Reduce impact using eco friendly paints: Here is a list of eco friendly paints: How much energy is saved per item Here is one that compares the environmental impacts of plastic vs Paper: PaperVsPlastic All though I do not agree with everything in this article, it is worth reading: Myths debunked Wanna recycling in Cape Town Recycling in cape town

Looking for what to go see at the movies yesterday I stumbled across two sites that are well worth a look. The first is: http://www.moviesite.co.za/ , they have a review of the current movies and have a click through to the new and now much better Ster Kinekor website, where you can now actually book with out being as frustrated as a serial shopper is in the middle of bush. For this site I found a link to Film and Publication Board of South Africa . The link I have here, lists all the movies they have rated. I could not find a search engine, which would have been cool. I now use that site to check out the ratings for movies on TV, I real help. Enjoy the movies, even if you have to pay R55.00 for two waters and a pop corn there.

I am busy migrating an Access system, and documenting, so I need a way to document the SQL Queries and Table details. After initially trying to get Access's documentation tool to give me what I needed, I started looking for alternatives. The below code is partly mine and based on the websites mentioned in the comments. Essentially it exports Query and Table information into 3 files in the tmp directory. I tried to do the SQL queries using CSV but even using "'" and """ did not work, so change it to TABS. This means that you can get most of the details for structures in a usable format (not like the Database Documenter which provides unusable details) so here is the code that I ended up with, thought I would share it: Public Sub GetQrysAndTbls() ' Using a few items found on the internet write query and table definitions ' to a text file including field detail for tables ' Original posts found at: ' http://www.techrepubli...

Seem as there are a few forums out there that I had to scan through to find this I thought I would post this so that people can see how to get their VBA code from previous versions of Outlook across when they upgrade to Outlook2010. Macros and the Visual Basic Editor Now that you know something about how Office 2010 applications expose their object models, you are probably eager to try calling object methods, setting object properties, and responding to object events. To do so, you must write your code in a place and in a way that Office can understand; typically, by using the Visual Basic Editor. Although it is installed by default, many users do not know that it is even available until it is enabled on the ribbon. Opening the Developer Tab All Office 2010 applications use the ribbon. One tab on the ribbon is the  Developer  tab, where you access the Visual Basic Editor and other developer tools. Because Office 2010 does not display the  Developer  tab by default, you must enable it b...