Monthly Archives: November 2011

Automate your test data with Red Gate SQL Data Generator

Just about every developer out there has encountered a scenario where they need to load test the application they are creating, but simply cannot come up with enough load to make it happen. I’m not going to go down the rabbit hole that is load testing an application in this post, but I do want to talk about one component of load testing, which is working with a lot of data. I seem to always run into the situation where I’m developing an application for a client, and when it comes time to test the application in a real world scenario and need real world data, the only viable solution is to back up data from a production server and massage it to “fit” into my applications database. Bad idea. Yes, there are times when this is unavoidable, but in general, do you really want to make multiple copies of sensitive data? Also, in most cases I cannot just copy and paste the data into my database. In the past I’ve created a number of data migration utilities, data population scripts, and used a number of tools just to populate my application with data that I can use to test it. All of this takes time, and effort.

Posted in SQL | Tagged , , | Leave a comment

Transactional Replication Filters

I recently needed to replicate a small portion of a database to a separate server hosting SharePoint. Only a small amount of our total user base would be able to access this site, so we decided to use Transactional replication to replicate only the users with the proper roles. This presented a few unexpected challanges, as the filters did not work as you might expect.

Posted in Replication, SQL | Tagged , , | Leave a comment

SharePoint 2010 XML Navigation with Selected Highlighted Tabs

So you’ve got you XML Navigation set up and ready to go on your SharePoint 2010 Site. You log into your site and now you noticed that the XML has no idea what site you are on and so the Top Navigation Tab isn’t selected (highlighted) when you click on a site and some of your end users use this as a queue to know what site they are on because it stands out a little more than the site title. The Steps below will get you your XML Navigation implemented onto the Master Page and all of the tools that will help you control the behavior of your navigation.

Posted in SharePoint 2010, SharePoint Designer, Visual Studio | 2 Comments

SharePoint 2010 Master Page with Footer That Stays at the Bottom of your SharePoint 2010 Site

In SharePoint 2007 it was easy to have a footer sit at the bottom of your master page and stay at the bottom.  You simply added another row to your table at the bottom of your master page and that is where your footer would sit.

Posted in SharePoint 2010, SharePoint Designer | Leave a comment

SharePoint Information Architecture Diagram Using PowerShell and Visio

Having a well-planned Information Architecture is critical for the success of a SharePoint implementation. Sometimes, as we all know, our environments get away from us and site owners start running frantic – sites are created without our knowledge or placed where they shouldn’t. You have had enough and it’s time for reorganization (and perhaps a new security model) – but how do you know what you have now in order to thoroughly plan things out? Technology to the rescue! Let’s use the “power” of PowerShell and Visio to do this for us.

Posted in Administration, PowerShell | Tagged , , , | 18 Comments

Google Maps V3 Example


Posted in JavaScript | Leave a comment

Sitecore Media Security

I recently had a request to provide custom security for Sitecore media items.  Basically, I needed to provide a way to intercept the media requests, redirect to the login page (if needed), and redirect to an access denied page if the user did not have proper rights.

Posted in Development, Sitecore | Leave a comment