Temporary Tables vs. Table Variables in SQL Server

An SQL Server Game Changer One day, I discovered the ease and utility of creating a temporary table in SQL Server. I thought it was a game changer. I used it everywhere, for any occasion, and was pretty quick to throw data into temporary tables for ease of querying later. I have since learned there

By | December 17th, 2016|Categories: Enterprise IT, IT Infrastructure|Tags: , , |

Part 1: Building Cloud-Scale Enterprise Apps – Our Take on Microsoft Service Fabric

Microsoft just changed everything about enterprise app development with their announcement that Service Fabric will be released as part of Windows Server 2016. For years, our enterprise customers have requested the features of commercial Software as a Service (SaaS) applications in their enterprise. They want fault tolerance, high availability, resilience, elasticity, and near-zero downtime. In

Part 2: SharePoint 2013 Business Connectivity Services, Search and Profile Page Demo

Back to Part 1 Create the External Content Type External Content Types are similar to regular content types in that they contain several fields that make up that particular content type. The main difference is that these fields are mapped to columns in the SQL database in this case. We are only going to be

By | January 22nd, 2014|Categories: Enterprise IT, SharePoint Solutions|Tags: , , |

Part 1: SharePoint 2013 Business Connectivity Services, Search and Profile Page Demo

This topic will be separated into 3 posts. It will cover a demo with step by step instructions for SharePoint 2013 Business Connectivity Services, Search and Profile Pages. The second post will go over creating the external content types and creating the Business Data Connectivity Service. The third post will cover customizing search and profile

By | January 3rd, 2014|Categories: Enterprise IT, SharePoint Solutions|Tags: , , |