Articles tagged functions

15 February 2021
15 February 2021

Custom Binding for Azure Functions

0
4
Azure Functions are a great development tool, allowing us to create serverless software. However, one detail was bothering me when I create a function: The HTTP Trigger receives a HTTPRequest object and we need to extract the parameters from the request. This becomes kind of a low-level code mixed with our business code. It’s like going … Read more
13 April 2019
13 April 2019

Extract the Path from Filename in SQL

0
10
While I was preparing an article, I faced the challenge to extract the path from a filename in SQL Server. It’s an interesting challenge with many possible uses, so I decided to create a function to solve this problem. The Main Expression First, let’s understand the main expression to solve the problem. The path is everything … Read more
20 November 2015
20 November 2015

About functions, records and result cache

0
1
This article is about functions and how to get more out of them if you combine them with record structures. Functions are the instrument in the Oracle Database to execute code and return a value.┬áNothing new here, everybody who develops in PL/SQL on the database knows that. In case you’re just starting with Oracle and want to know more about… Read more
12 March 2007
12 March 2007

PowerSMO at Work Part 2

In part 3 of Dan Sullivan's in-depth exploration of PowerSMO, the versatile command line utility for managing SQL Server databases, he describes how to control the identity that SMO uses to login to SQL Server, how to set up Server activity monitoring, and how to create standalone PowerSMO scripts, suitable for use in a production environment.… Read more