Editorials

More in this category »

SQL Server

More in this category »

From the Community

More in this category »

Other News

Community

New XSLT Policy

(Matt Farmer) In our latest release we have added a new policy that allows you to run XSLT transformations on the body of a request or response. Those of you using XML or SOAP with your Azure API Management instance may find this useful to give you a great deal of control of how XML is served up to

Community

More General and Less SQL

(Thomas LaRock) Last week I received an email from my friend Mike Walsh (blog | @mike_walsh), who commented on the look and feel of this blog as well as the general content. Mike and I have been friends for more than 10 years now so it’s safe to say “he knew me when”.

Editorials

The Power of Coalesce

Cascading Style Sheets (CSS) are an HTML technique for formatting the display of html documents in a standard fashion. They are called Cascading because there is a hierarchy to how the styles are defined and implemented. Styles implemented in the HTML document itself override other styles. The concept I want to communicate here is that the same HTML tag may […]

SQL Server

Some tips for using User-Defined Functions in SQL Server 2016

Some tips for using User-Defined Functions in SQL Server 2016 Use scalar user-defined functions when you need to do the same mathematical calculations at multiple places in code. For example, if you need to calculate the factorial for the given number, you can write appropriate scalar user-defined function to encapsulate code for reuse. Consider using CLR user-defined functions. The CLR […]