Developer Support

Advocacy and Innovation

SSRS and the Case of the Out-of-Order Report Tables

April 5, 2017 Apr 5, 2017 04/5/17

Developer Support

In this post, Senior Application Development Manager, Patrick King shares a SSRS tip to help control report item order when it differs from what you may see in VS designer. (image) I recently worked with a customer developing a SQL Server Reporting Services (SSRS) report that was rendering in a different order than what appeared in the ...

Entity Framework Query Caching

March 23, 2017 Mar 23, 2017 03/23/17

Developer Support

Senior Application Development Manager, Deepak Malik, explains the Query caching behavior, performance implications, and extensibility provided in the latest release of Entity Framework Caching entities or query results has been a recommended practice for application development to improve an application's performance especially in data ...

Factoring impact of SQL Secure Login Certificate Key Length on SQL Performance

March 7, 2017 Mar 7, 2017 03/7/17

Developer Support

In this post, Application Development Managers, Lou Sawyer and Everett Yang spotlight the performance impact of certificate key length for login operations with SQL Server. The effect of RSA Key Length on CPU utilization during decryption is well documented. With a larger key size, we expect higher CPU utilization during decryption. ...

The High Availability Conversation Part 1: Introduction

February 3, 2017 Feb 3, 2017 02/3/17

Monu Bambroo

In this post, Senior Consultant, Bradley Ball discusses High Availability for SQL Server. In this latest blog post PSfD Consultant Bradley Ball begins the High Availability Conversation based off of a question on Twitter. He answers the questions what do the Three Bears have to do with HA planning and the business users and IT management...

Migrating SQL Workloads? Check out Database Experimentation Assistant

November 30, 2016 Nov 30, 2016 11/30/16

Developer Support

Considering the impact of a SQL upgrade? In this post, Application Development Manager Omer Amin spotlights Database Experimentation Assistant (DEA). Customers who are upgrading from previous SQL server versions (starting 2005 and above) to any new version of the SQL server will be able to use analysis metrics to help them build higher ...

SQL Server 2016: It Just Runs Faster

October 20, 2016 Oct 20, 2016 10/20/16

Developer Support

Does the marketing live up to the hype? Senior ADM, Paul King shares some perspective from the field. (image) Upgrading between major versions of a product can sometimes be a painful and time consuming task. Development organizations often have to spend time going over depreciated feature lists to make sure that their applications will ...

Random SQL Workload Generator

May 26, 2016 May 26, 2016 05/26/16

Monu Bambroo

In a recent post from his blog, Premier Developer Consultant Bradley Ball gives us a step-by-step overview of how to use SQL Server Random Workload Generator Many developers develop their own T-SQL, many DBA’s have to maintain that SQL. If you are looking for a way to generate a workload against a SQL Server to practice performance ...

US Developer Ramp-up Series

August 30, 2015 Aug 30, 2015 08/30/15

Developer Support

The Developer Ramp-Up Series, offered through Premier Support for Developers, is a collection of webcasts created with the goal of teaching developers basic development skills. No prior knowledge is necessary. The current offering includes a collection of webcasts and hands on lab guides/exercises in the areas of PowerShell, Object Oriented ...

Developer Support

Data - Developer Support