Author Archive

Android App Development: Using Themes and Styles in Android | Mobile Orchard

Friday, September 2nd, 2011

Android App Development: Using Themes and Styles in Android | Mobile Orchard.

This was a life-saver today. Thank you!!

WPF ShaderEffect Generator

Tuesday, June 14th, 2011

Just wanted to put a quick note out there for those that may stumble on this issue. I was trying to modify an FX file in order to add an Effect to one my images in my WPF application. I was trying to do this by using a .fx file that was part of one of Nick Darnell‘s projects. Specifically HeatColorizer.fx. It wasn’t clear to me how to convert this file into the .ps file that my WPF application needed, and then I found WPF ShaderEffect Generator. I installed it, tried to run it and VS 2010 immediately crashed. Then I tried it on a VS 2008 project and it failed silently. I was stumped. Then, after more reading about PixelShaders, I realized that I needed the DirectX SDK. Well, maybe I didn’t “need” it – but it sure seemed like it would help. Sure enough – it was a huge help. VS 2010 no longer crashes and my .ps files appear to be properly generating. Hope this helps someone else out there.

Thanks for the code and efforts for the programming community Nick!

BBC News – Google to abandon older browsers

Friday, June 3rd, 2011

BBC News – Google to abandon older browsers.

This will really help us keep costs down as we will only have to target the same browsers that Google targets. We can adjust our QA processes and slim down the scope of testing. This is great. I wonder why they didn’t do this sooner. They have such a strong powerful influence on the marketplace.

SQL Fragmented Index Query

Wednesday, April 20th, 2011

I put together this query on SQL Server 2008 to help me organize the fragmented indexes and thus get me pointed in the right direction for troubleshooting.

SELECT dbps.database_id, dbps.OBJECT_ID, dbps.index_id, sysi.name,
dbps.avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS dbps
INNER JOIN sys.indexes AS sysi ON dbps.OBJECT_ID = sysi.OBJECT_ID
AND dbps.index_id = sysi.index_id
WHERE dbps.database_id = DB_ID()
AND dbps.index_id > 0
ORDER BY dbps.avg_fragmentation_in_percent DESC
GO

Many of our systems automatically defrag in overnight tasks, but when things stop working, this helps me get systems back up and running.

Using the SQL Server Performance Dashboard Missing Indexes Report

Tuesday, April 19th, 2011

Using the SQL Server Performance Dashboard Missing Indexes Report – Driving The Database Engine – Site Home – MSDN Blogs.

I NEEDED this article today. We are on the hunt for missing indices and we don’t always have access to sql management studio or other tools that should be part of our workbench. The query in this article fit the bill perfectly. Thanks!!

Life saver today – VNC / Snow Leopard

Thursday, February 10th, 2011

http://lifehacker.com/#!319528/remote-control-leopard-with-tightvnc

This post was exactly what I needed today. Our current setup allows us to Remote into a PC on our business network, and then VNC to any other Mac or PC on the network. It is remarkably fast, and keeps things fairly secure.

SharePoint tips, #1

Wednesday, June 2nd, 2010

We’ve been doing alot development with SharePoint these days. Mostly our work has centered around Lists. Added a few workflows, a few statuses that manage the views and it is working well. Pushing data into the lists has been a little bit of a struggle, but here is what we learned:

If you want to figure out what field names to run a “query” on, and they aren’t always named the same as the name the field was created with, then you’ll need to dig into the list details. I recommend running a query that looks something like this:
SELECT tp_Title, tp_Description,
CAST(tp_Fields AS xml) AS Fields
FROM DS_SP_WSSContent.dbo.AllLists
WHERE (tp_ID = 'LIST_GUID')

This way you can see the columns that are used and really get a feel for what the column name is called “under-the-hood”. This will be useful to you when you get the results in “rs:data” and have a “z:row” item with an attribute that is prepended with “ows_”.

Another tip is that if you are updating or adding new items to a list, make sure the fields you need to query are part of the view that you pass in. If you query a view that doesn’t have the right fields, you won’t get those fields in the results and they may be vital to the logic.

SEO – Bridging the gaps

Friday, April 16th, 2010

I haven’t talked about SEO in a while – but it is getting more and more complex. Not so much in the common sense side of things – from that perspective it is all good. But there is alot of different technologies involved in creating a full-scope SEO round of updates.

  • Content – Affects CMS, plugins, server capabilities
  • Geolocation – everyone uses GPSs (almost) but who spends the time analyzing
    lats/lons and geocoding? Only the techies.
  • Page Load times – this affects everyone on the technology side and
    has little, to nothing, to do with the writers and content makers. If you use WordPress
    - you are relying on other people. albeit they are highly qualified and highly skilled, but we
    have to recognize that we are not in complete control (unless you hire your own programmer to
    cut out the parts you don’t need from that system)
  • PPC – getting a good ROI takes experience and skills that the average
    business/website owner might not have. Or will spend a fortune learning.
  • The list could go on. There are so many technologies to learn about that it can be overwhelming. Even for us proclaimed SEO guys and gals.