Microsoft Live Share Extension

With Microsoft’s recent release of Azure DevOps, Microsoft is bringing modern DevOps to the enterprise.   To improve deployment frequency and achieve faster time to market, developers can take advantage of Microsoft’s recent Live Share Extension in VS Code.  Our DevOps team has put together a whitepaper detailing the Live Share Extension and how it can improve developer collaboration, bug fixes, and deployment.

Correcting Impersonated Custom Identity in SharePoint Designer

Recently, I have done a lot of work with SharePoint Designer 2013 and External Content Types (ECT).  In a previous blog, SharePoint Online to Azure SQL Database: Part 1, I covered how to work with ECTs.  Since, writing that blog, I ran into an unexpected issue that caught me by surprise.  I was adding a data source for my ECTs in a new environment and made a mistake when entering the credentials for the Secure Store Application ID.  This blog is not meant to be long or mind blowing.  It is meant to save you some time.  The following is what to do if you enter the wrong credentials for the Secure Store Application ID in SharePoint Designer 2013. What…

Lessons Learned: Improving Business Connectivity Services Performance

by John Bonfardeci Are you developing a client-side JavaScript application on the SharePoint platform? Is your data in an external database such as Azure or SQL Server? Are you using views and/or stored procedures to join two or more tables? If you’ve answered “yes” to these questions, this lessons learned article is for you. It’s relatively simple to create external content types in SharePoint Designer via Business Connectivity Services (BCS) and many articles have been published covering the steps. Furthermore, you can filter data with the REST `$filter` parameter. However, SQL server will return all the data in a view or table and only then will SharePoint filter the results. For example, if a view returns 10,000 rows and you…

Microsoft Gold Partnership for Data Analytics

Definitive Logic is pleased to announce reaching Microsoft Gold Partner status for Data Analytics.  Our new status adds to our existing Gold Application Development and Collaboration and Content status. This is a result of 10+ years of delivering successful Microsoft Solutions. Contacts us today for a free consultation in how Microsoft can help you.

The Do’s and Don’ts of PowerPivot – Excel 2016 and SharePoint 2013

When you do development for many years in one platform it gives you the chance to learn a thing or two about all the different limitations across all its different versions. The same rule applies to SharePoint. Recently our team had to develop in a SharePoint 2013 environment using PowerPivot on a SQL Server 2012 environment.  For about three months our work was going well, until we went from Office 2013 to Office 2016.  Several PowerPivot files began to get an error “Call to Excel Services Returned Error” during their scheduled refresh.  If we opened the file in Excel 2016 and refreshed the file, it refreshed with no issue. Our team got a hold of the ULS logs and while…

Practical Considerations for Machine Learning in Healthcare

Continued uncertainty and risk in the healthcare industry is pressuring healthcare executives to keep a steady focus on reducing costs and transforming delivery models to improve the patient experience. Artificial intelligence (AI) manifested through machine learning algorithms is already transforming a variety of healthcare applications including medical imaging diagnosis, drug discovery and personalized medicine. The McKinsey Gold Institute estimates that applying big-data strategies to better inform decision making could generate up to $100 billion in value annually across the US health-care system, by optimizing innovation, improving the efficiency of research and clinical trials, and building new tools sets for physicians, consumers, insurers and regulators to meet the promise of more individualized approaches.   How Machine Learning Analyzes Data  The healthcare industry sits on a goldmine of data that is generated from many sources:  research and development (R&D); physicians and…

Definitive Logic is now an approved Cloud Service Provider (CSP)

Definitive Logic Corporation now acts as a one-stop shop for Microsoft solutions for Enterprises and Federal Government Agencies, offering full service of the industry-leading products, such as Azure, Office 365, Microsoft 365, and Dynamics 365. Definitive Logic, a multi competency Microsoft Gold Partner supplier of transformative digital services, is proud to become a Microsoft Tier 1 Cloud Solution Provider in both Azure Government and Commercial.

Microsoft Gold Partnership for Application Development and Collaboration and Content

Definitive Logic is pleased to announce reaching #Microsoft Gold Partner status for Application Development, in addition to our Collaboration and Content Partnership. This is a result of 10+ years of delivering successful Microsoft Solutions. Contacts us today for a free consultation in how Microsoft can help you. #modernization #IT

SharePoint Online to Azure SQL Database: Part 1

"When we first set out to setup SharePoint Online to integrate with an Azure SQL Database with Business Connectivity Services (BCS), I thought it was going to be very quick and easy.  It probably will be from now on, but we had to work our way through some challenges.  We did our research and felt pretty confident that it was going to be very easy.  To be honest, the steps to setup BCS in SharePoint Online aren’t exactly rocket science.  But there are a few gotchas and if you’re not careful, they will get you.  In this article we will walk through the steps to setup SharePoint Online to integrate with Azure SQL Database via BCS." SharePoint Online BCS to…

Increasing Healthcare Business Intelligence Impact with Enterprise Architecture

Information Technology (IT) is at the heart of every organization and healthcare organizations are no different.  Having a well-defined enterprise architecture (EA) framework and strategy is key to driving cost savings and interoperability across a healthcare agency or system.  Many brilliant enterprise architects have spent countless hours investigating, inventorying, analyzing dependencies, and building highly insightful EA views of their organizations only to find that their masterpieces sit on the shelf and are rarely updated or used.  There are several accepted EA frameworks in the industry (TOGAF, DODAF, FEA) that characterize, in “view” format, the who, what, why, when, where, and how of each component or aspect of an enterprise.  These EA views (capability, operational, system, data, etc.) are crucial to…