Recently I was given a task to move a custom application developed on top of SQL Server 2005 to SQL Server 2014 (yes a big jump!). One of the tasks was to move the reports over to the new server. The server was already built and an empty reporting services instance was Continue Reading
Mehmet Ozdemir
TSQL pattern matching as part of a table join
OK so anyone with some fundamental SQL knowledge will be able to read the following SQL statement and understand what it’s returning, let’s take a look:
1 2 3 4 5 6 |
SELECT DC.LastName, DC.FirstName, FIS.TotalProductCost FROM FactInternetSales FIS INNER JOIN DimCustomer DC ON FIS.CustomerKey = DC.CustomerKey |
To summarize we’re joining the FactInternetSales table to the DimCustomer table via the foreign key called CustomerKey. From the DimCustomer table we’re returning Continue Reading
Connecting the CRM Email Router to a CRM Online deployment
Here’s a quick tip for connecting the CRM Email Router to a CRM Online Deployment. If you’re following along with the documentation from Microsoft: Microsoft Dynamics CRM Email Router Installing Guide for use with Microsoft Dynamics CRM Online The section that describes connecting to a CRM Online deployment states: If Continue Reading
Optus Cable 100Mbps Unlimited, Well not really
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 Continue Reading
CRM 2015 (Update 1) filter a sub grid to show data based on hierarchy using fetchxml
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 Continue Reading
Moving from MS Azure hosted WordPress to WPEngine
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 Continue Reading
Adding a new field to an SSRS Report and seeing #Error on preview
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 Continue Reading
SQL Server Table Designer can’t save changes
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: Continue Reading
CRM 2015 Hierarchies are cool!
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 Continue Reading
Need to search strings inside your SQL Objects? Try this utility
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 Continue Reading