Optus Cable 100Mbps Unlimited, Well not really

By Mehmet Ozdemir | April 18, 2015 | 2 Comments

After being an extremely happy customer of TPG on the TPG Unlimited ADSL2 service for about 2 years, I noticed Optus was doing what looked like a cracker deal (I was wrong). Optus were going to provide: Unlimited Cable Internet Unlimited Phones Calls Fetch TV box with a 1TB PVR and with a bit sweet talking an…

CRM 2015 (Update 1) filter a sub grid to show data based on hierarchy using fetchxml

By Mehmet Ozdemir | March 30, 2015 | 9 Comments

Code Sample Updated for CRM 2015 Update 1 Scenario Let’s say you have three Contracts in CRM defined for three Customers (Account). Contract 1: Customer 1 Contract 2: Customer 2 Contract 3: Customer 3 And Customers 1 – 3 are in Parent Child relationships. Customer 1 Customer 2 Customer 3 We add a sub grid to…

Moving from MS Azure hosted WordPress to WPEngine

By Mehmet Ozdemir | December 30, 2014 | 0 Comments

In an earlier post I wrote about Azure WordPress performance compared to a Linux VPS hosted instance for WordPress, with the later completely trouncing the Azure hosted instance. While I really wanted the Azure environment to be a success, until the database performance increases we’ll be hosting our WordPress sites elsewhere. To start with let’s…

Adding a new field to an SSRS Report and seeing #Error on preview

By Mehmet Ozdemir | December 8, 2014 | 2 Comments

I don’t know how many times I’ve done this, the scenario goes something like this, your boss emails you asking for some new field to be added to a report. You spend quite a bit of time adding the necessary logic to the underlying dataset, everything looks great from SQL side of things. Next you update the…

SQL Server Table Designer can’t save changes

By Mehmet Ozdemir | December 8, 2014 | 0 Comments

I come across this warning/error message every time I do a fresh install of SQL Server on my laptop and despite having set this option back more times than I care to remember, I end up spending a few minutes looking for the setting in the Management Studio options. Figure: Warning saving changes would result…

CRM 2015 Hierarchies are cool!

By Mehmet Ozdemir | December 4, 2014 | 1 Comment

CRM 2015 Hierarchies are a really cool feature that let users navigate records by visually seeing parent child relationships. Out of the box Accounts, Positions, Products, and Users entities get hierarchies baked in. Hierarchies can be added to other built-in entities and to all custom entities. Figure: CRM 2015 Hierarchy Visualization To make working with…

Need to search strings inside your SQL Objects? Try this utility

By Mehmet Ozdemir | December 4, 2014 | 0 Comments

While performing a migration from SQL Server 2000 to SQL Server 2014 (wow what a big jump), I needed to find all stored procedures that made a call to an extended stored procedure that was being replaced with functionality that is baked into more recent versions. So what to do? Stack Overflow had a few good suggestions,…

Installing a Dynamics CRM 2015 for Demo Environment

By Mehmet Ozdemir | December 4, 2014 | 8 Comments

With Dynamics CRM 2015 now available on MSDN for download I thought I’d get on top of it right away and setup a demo VM. With most MS products this is pretty easy, but Dynamics has a higher requirements list. The prerequisites include: Windows Server Active Directory (yep you’ll need to setup a domain controller)…

Dymanics CRM 2015 and Dymanics GP 2015 now on MSDN

By Mehmet Ozdemir | December 3, 2014 | 0 Comments

Head over to msdn.microsoft.com (needs msdn subscription) to get the downloads. Really looking forward to getting CRM 2015 up and running and playing with some of the new features like: Enhanced Business Processes Enhanced Business Rules Fields: Calculated and Roll-up Hierarchy Visualization

Azure WordPress Performance vs Linux VPS

By Mehmet Ozdemir | December 3, 2014 | 2 Comments

I’m sure there’s probably more to this, but here are some numbers on an Azure WordPress installation compared to a Linux VPS. The Azure hosting details are: Instance: Large 4 Cores, 7 GB RAM, ClearDB 1GB MySQL Venus Plan, hosted US West Linux VPS, 4 Cores, 2GB RAM, 1 GB Swap, Local MySQL Install, hosted US…