Some articles as i collect them are:

• Actually referencing and making diff. levels work together
  • same recommendation as the link above (w. 433 upvotes) – useLegacyV2RuntimeActivationPolicy
  • and again but with a little more if you scroll down (I see a pattern here)
  • a few good links exist with this article as to what useLegacyV2RuntimeActivationPolicy does
    • msdn article on  <startup useLegacyV2RuntimeActivationPolicy…>
    • why it was done
• Background on CLR (major release and side-by-side) vs. upgrade to a CLR (inplace upgrade)

Putting HTML in bulleted lists seems quite straightforward until you try it. The items only accept text and html is rendered as text so you don’t get the html – you SEE the html. OK – so some digging turned up the following useful links. These are good for the same items but I need dynamic html different in one item than the other so I am doing it with html and a div or something.

These links will no doubt prove useful for repeating items that are the same.

• General Discussion telling you what control to use and when
• Using SQL as a datasource (which is what I am doing anyways)
• Good article for more than just repeaters – Five ASP.NET Controls You Might Be Craving

Google had informed them “recently received a notification from Google stating that our website has unnatural links pointing towards [zoho]. This has really damaged our Keyword rankings on Google …” and to remove the links. It was my recent article on a topic about them and some links to them that solved – what should be quite simple but it is QUITE HARD actually and I had been victorious.

Here is an article to help with a redirect that made me clear up Google crawling errors.

What? No – I am not going to remove any links! This is a website is all about STORING LINKS for myself and others reading this. Continue reading →

Optimizing these large tables DOES NOT WORK. It corrupts them and you have to talk to tech support to get backups restored. Even when you ssh into the server and do it “command line.” I reminded myself of this yesterday when I optimized a table forgetting the better way.

First, back up the sluggish table. It had lots of overhead – this is a hint. Another way to back it up, is to copy it to a new table. Here’s how (don’t do this from phpmyadmin because it will for sure time out). I use a mac so I have sequel_pro AND SET THE TIMEOUT  TO 1000 seconds or more in the preferences. If you have access to ssh into the machine – even better.

[sql]</pre>
CREATE TABLE xxx_backupddd_nnn LIKE xxx;
insert into xxx_backupddd_nnn SELECT * FROM xxx;

RENAME TABLE xxx TO xxx_overheadddd_nnn;
CREATE TABLE xxx LIKE xxx_overheadddd_nnn;
INSERT into xxx SELECT * FROM xxx_backupddd_nnn;
<pre>

[/sql]

In my case xxx is the table and ddd_nnn the date and attempt such as 20140303_1.  I run each command line by line and carefully look at the output. Sometimes the server times out even after 1/2 seconds so be watchful.

No tech support phone call or $15 backup recovery fee required. Really – that is not bad for a recovery fee.

So I have had LOTS of attempts to get into a password protected MS 2010 Access database and most people online say it cannot be done (the advice in many google’ed articles) , however one guy gave me the hint to get this solved for me in “Answer 4”.

Scenario:

1. I am connected to SSMS on domain #1 called F which is a SQL Server on Domain D
2. MS Access file is on Domain D on the c drive c:\Temp\dB123.accdb (this c: drive is the one where the SQL Server is running)
3. In SSMS, I made a new Linked Server using the GUI Continue reading →

I need to zip files and add a timestamp to the zip filename, or I don’t have a backup system (I just have a copy of the latest files whether or not they are correct). This is TOTALLY related to my article on scripting out my SQL table data contents. This is run as a scheduled task – but I had to take a copy of the solution on my LOCAL drive- not a network copy or else the scheduled tasks does not work. See my article to reduce frustrations on Scheduled Tasks.

Using c# – here is the code snibbet (read the whole article though) Continue reading →

So, there is this process, that if the user could click a button themselves would save a lot of stress on everyone – the person who has to run the powershell script AND the people who have to ask (who wants to pester someone all the time?)

So in prep – I did a test – I didn’t know anything about powershell scripting so I hit google. I found a simple copy/paste of a file script and modified it to copy a file from one directory to another (and it echos something to the command line). Since it is the www – I made a share location so that it could be run from the network instead of my “C:\temp” directory because C: means MY c:\ and MY will change depending on who hits the button.

Next, I went and copied and pasted an example from someone else, found out which “using” statements are required, hooked up a following DLL manually required to get this working and presto – it worked in about 1/2 hour. Here are the steps: Continue reading →

There is hope to not log in all the time right from filemaker. I am choosing to use the extended privileges option. See this link (gotten from here).