Archive for April, 2016

Microsoft SQL Server Developer Edition is now free

April 19, 2016

Exciting news! Starting today, SQL Server 2014 Developer Edition is now a free download for Visual Studio Dev Essentials members (you will be prompted to sign in to Visual Studio Dev Essentials before you can download SQL Server 2014 Developer Edition). We are making this change so that all developers can leverage the capabilities that SQL Server 2014 has to offer for their data solution, and this is another step in making SQL Server more accessible. SQL Server Developer Edition is for development and testing only, and not for production environments or for use with production data.

Visual Studio Dev Essentials is Microsoft’s most comprehensive free developer program ever, with everything you need to build and deploy your app on any platform, including state-of-the-art tools, the power of the cloud, training, and support.

SQL Server 2014 Developer Edition offers the full feature set of SQL Server 2014 Enterprise Edition, and allows you to build almost any kind of data solution on top of SQL Server. SQL Server 2014 delivers mission critical performance across all workloads with in-memory with in-memory built-in, faster insights from any data with familiar tools, and a platform for hybrid cloud enabling organizations to easily build, deploy, and manage solutions that span on-premises and cloud. It also delivers peace of mind with the fewest security vulnerabilities of any enterprise database six years in a row. [1] To learn more about the value proposition of SQL Server 2014, read the datasheet.

SQL Server 2016 Developer Edition, when released later this year, will also be free. To learn more about the exciting new features in SQL Server 2016, read the datasheet.

SQL Server Developer Edition does not include a licensed OS, such as a license for Windows 10 included on a new laptop. 90 to 180 day free trials of Windows and Windows Server are available on the TechNet Eval Center.

For customers needing a comprehensive database development solution, we also offer Visual Studio Professional and Visual Studio Enterprise subscriptions. Visual Studio subscriptions provide additional benefits, including:

  • Past and current versions of SQL Server (including Enterprise edition)
  • Past and current versions of Windows and Windows Server for dev/test
  • A monthly Azure credit of $50 to $150 to use for running dev/test workloads, including Azure SQL Database, SQL Server running in Azure Virtual Machines, and much more
  • 2 or 4 incidents with Microsoft Technical Support
  • Visual Studio Professional or Visual Studio Enterprise, for state-of-the-art database development
  • Source code management/version control, work item management, builds, and more using Team Foundation Server and Visual Studio Team Services
  • And much more…

Click here to download SQL Server 2014 Developer Edition from Dev Essentials. You will be prompted to sign in to Visual Studio Dev Essentials before you can download SQL Server 2014 Developer Edition.

Click here for the original article


Microsoft Dynamics CRM Personal Views Manager Utility

April 14, 2016

With Microsoft Dynamics CRM 2016, even under the System Administrator Security Role, you can’t view (nor edit, share, assign or delete) other users’ Personal Views. Via the application UI, only the view owner can manage it.

This project implements a utility which allows you to manage other users Personal Views, as long as you have the prvActOnBehalfOfAnotherUser privilege, which is granted by default by the built-in Delegate and System Administrator Security Roles.

Personal Views Manager.gif

This utility can be especially useful in the following scenarios:

  • A user who shared his Personal Views with other users or teams has left the organization and now no one can edit or delete these views which are irrelevant or just annoying
  • A user has defined and shared a resources hungry Personal View which execution make the application grind to a halt

To use this utility, import the downloaded Solution to Microsoft Dynamics CRM 2016 Organization, open it and navigate to the Configuration tab.

Note: this solution will not work with Microsoft Dynamics CRM versions 2015 and below.

You can find additional details in the following post:


,Microsoft Office SharePoint 2013 Improved List View Paging

April 1, 2016

Full trust solution to replace the basic back/next pagination on SharePoint 2013 List Views with a proper paging pattern using JSLink on a page by page basis.

Quite simple really, the default pagination on SharePoint List View webparts is quite poor, only providing for back/next style controls. There is no means of seeing the total number of records or pages, nor being able to jump to the start or end without using sorting tricks.

Default Paging Controls

This solution takes advantage of the JSLink functionality in SP 2013 to override the standard footer template and replace the basic paging controls with more classic search style page controls.

New Paging Controls:

To use the solution:

  • Download the WSP package and deploy to your SharePoint 2013 farm.
  • Test the solution is successfully deployed and available by manually calling both the .js and .aspx files to ensure you can hit the pages successfully:
  • If all looks good, then go to your list view web part, edit the page, edit the web part properties for the List View.
  • Under the Miscellaneous section, add the path to the javascript file in the JSLink field:
    • ~site/_layouts/15/ImprovedListView/JSLink.js
  • Click OK and Stop editing the page, you should now see the replaced paging controls

Additional Important Notes

  • This solution assumes you are using jQuery already on your SharePoint site. If you’re not, then you will need to grab the source code and update the “updatePagingControls” function to use basic javascript to modify the DOM instead of jQuery. But seriously, why are you not using jQuery?!
  • The solution affects ALL list view web parts on the same page, you do not need to add the JSLink reference to each webpart.
  • If you need it to not affect some of the list views on a page, sorry you will need to download the source and customize the solution by specifying the BaseViewID and/or ListTemplateType. You could also do this with a custom version of the JS file however, and deploy the solution as is. Put a copy of the JSLink.js file into /_catalogs/masterpage using SharePoint Designer, then customize the variant file and use that in your JSLink field instead of the one I have provided (google: “SharePoint 2013 JSLink” for more details on this).
  • This solution is a full trust solution which makes use of an application page, which is deployed to the _layouts folder in the 15 hive. It is therefore not suitable for sandbox style environments where full trust deployments are not allowed. However, you could retrofit the solution to make it purely javascript based by using CSOM calls in order to replicate the server side code on the client instead. I did this to start with, but found the additional AJAX calls made the load times significantly slower (particularly for large lists), and so I chose to go with a server side solution for building the page URLs instead.