Recently, we've come across poor SQL performance on a very powerful SQL box and we were having trouble identifying the exact cause. After some talks with the software vendor and Microsoft, we were pointed to the TokenAndPermUserStore cache.
There are an increasing amount of articles online that speak about this cache, …
Read MoreAppleScript is so fun! That and Folder Actions are two of the reasons I love OS X.
So I recently had something come up where I had to make sure anything that was copied into one folder was immediately copied into another. Folder Actions made this simple.. now I haven't added the functionality to make sure that anything …
Read MoreDisclaimer: This method works well, but I have not researched all of the details of an export -- primarily what's exported, what's not and what are the consequences of using - versions. These are mostly my notes, quick and dirty style.
A task as basic as moving a whole site from one site collection to another should be …
Read More- Firesheep got me thinkin' that I should probably do a little more to beef up the security of my Internet connection on public networks. PPTP has always been a favorite of mine, because it hides traffic well enough to deter most people and it's easy to setup on both Linux and Windows. I ran a Windows PPTP server for …
Read More - Installing a SQL Server 2008 Failover cluster is actually fairly easy, once you have the Windows Cluster set up. I experienced an issue adding the failover node, which is now a separate process compared to how it was done in SQL Server 2005. I'm not going to cover the entire process in this post, but I wanted to share …
Read More I recently installed BizTalk 2006 and 2009 on a few servers at work. I found the process to be very painful for some reason.
In regards to the BizTalk 2006 installation, I was running into an issue where the installer would error out. I eventually tracked it down to my Virus Scan software blocking the installer from …
Read More- Recently, I noticed errors occuring daily at 2:00AM on my SQL Cluster. The errors showed Windows logins being routed to the wrong named instances, along with errors from SQL Browser not being able to service client requests. I noticed that all of the instances being affected were SQL Server 2008, but never any of my …
Read More - If you find yourself on a really restrictive network but still want to connect to a remote VPN, consider this solution. It allows you to connect a Mac OS X OpenVPN client to an OpenVPN server using a static key. I figured it out using a combination of webistes, including dd-wrt's OpenVPN wiki, OpenVPN's documentation, …
Read More - In all my years of web programming, I've never used an Oracle database... until now. I was recently tasked with converting an Access database form into a web application using ASP.NET. The twist is that the data in the Access form is linked to an Oracle database. It would be an understatement to say that Oracle is …
Read More In an effort to protect DBAs and developers from themselves, Microsoft has introduced a new default setting in SQL Server Management Studio. This setting prevents you from saving almost any change to db tables and throws out the following error:
Saving changes is not permitted. The changes that you have made require …
Read More