You are here

SQL Server

JSON Support in SQL Server

JavaScript Object Notation (JSON) support and a long-awaited feature of SQL Server has been added to the 2016 version, which will allow you to exchange JSON data between applications and SQL Server, parse JSON formatted data so it can be stored in a relational format and convert relational data into JSON formatted data. 

Grouping Data with MoreLINQ Batch Extension Method

Being able to group data into batches can be quite useful and often done for reporting purposes, but I found it handy to group a series of multiple choice questions and answers for displaying a given tester. In this case, it was for a quiz that asked the capital of a given state with four possible answers provided for each question (see Figure 2). The data was in a SQL Server database table, but it could have been retrieved via a service or a text file.

SharePoint Server 2016 Update

SharePoint Server 2016 Update

Microsoft SharePoint Server 2016 Release Candidate (Beta 2) is in the process creating very positive impressions. Interestingly, with the release of Microsoft SharePoint Server 2016 comes a turn in the SharePoint offerings moving forward. SharePoint is clearly at a crossroads. A commitment to choose between On-Premise and Cloud is likely to soon to lean heavily towards SharePoint as a service. These signals are important to consider as your company determines its planning horizon to move important SharePoint-based applications to The Cloud.

Microsoft SQL Server AlwaysOn for your business

Posted in

Platform & Cloud Solutions

The Microsoft SQL Server AlwaysOn feature provides business continuity and workload distribution. It adds a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Hear from a Microsoft Dynamics customer on the benefits of SQL Server AlwaysOn. Come to this session to learn about configuring AlwaysOn for your business. We will also cover some of the basics to deployment and management of SQL Server AlwaysOn for Microsoft Dynamics.

Enabling/Using Package Configurations (SSIS)

If you can accomplish all of your tasks with one SSIS package, I'm happy for you - but sometimes more than one is necessary. If you ever find yourself with multiple packages with similar properties (variables, connection managers, executables, etc.) it may be in your best interest to use a Package Configuration. This will save you some time down the road if you decide to create another package, or update properties of the existing ones.

Query MS CRM XML Entity with XQuery and LINQ

In our company we have been working on a large MSCRM 2011 project. Last week, I was asked to create a report listing all the visible fields for each entity in the solution. During my search, I found a few different ways to do it, but the most fun way was querying the XML. The XML is created when the solution is exported. It's normally several levels deep and even when the structure would depend on the solution the XML listed below is an example of how it would looks like.