Tutorial by Examples: al

Append a scalar value into a JSON array

JSON_MODIFY has 'append' mode that appends value into array. declare @json nvarchar(4000) = N'{"Id":1,"Name":"Toy Car","Tags":["toy","game"]}' set @json = JSON_MODIFY(@json, 'append $.Tags', 'sales') print @json -- Output: {"Id&quot...

Microsoft SQL Server • Modify JSON text

The Eval Monad

Parallelism in Haskell can be expressed using the Eval Monad from Control.Parallel.Strategies, using the rpar and rseq functions (among others). f1 :: [Int] f1 = [1..100000000] f2 :: [Int] f2 = [1..200000000] main = runEval $ do a <- rpar (f1) -- this'll take a while... b <- rpa...

Haskell Language • Parallelism

Displaying all elements in the index

To view all elements in the index change the print options that “sparsifies” the display of the MultiIndex. pd.set_option('display.multi_sparse', False) df.groupby(['A','B']).mean() # Output: # C # A B # a 1 107 # a 2 102 # a 3 115 # b 5 92 # b 8 98 # c 2 87 # c 4 104 #...

pandas • MultiIndex

Count Unique values in Range

Function countUnique(r As range) As Long 'Application.Volatile False ' optional Set r = Intersect(r, r.Worksheet.UsedRange) ' optional if you pass entire rows or columns to the function Dim c As New Collection, v On Error Resume Next ' to ignore the Run-time error 457: "Th...

excel-vba • User Defined Functions (UDFs)

The generated HTML with automaticaly loaded assets

<!DOCTYPE html> <html lang="en-EN"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="csrf-param" content="_csrf"> <me...

yii2 • Asset management

Create your own collection and use it to collect all your losses.

Here we will create collection for losses of Neural Network's computational graph. First create a computational graph like so: with tf.variable_scope("Layer"): W = tf.get_variable("weights", [m, k], initializer=tf.zeros_initializer([m, k], dtype=tf.float32)) ...

tensorflow • How to use TensorFlow Graph Collections?

Installation or Setup

Detailed instructions on getting logstash set up or installed.

logstash • Getting started with logstash

Enroll contact in the engagement plan programmatically

AutomationMetadataProvider automationMetadataProvider = Assert.ResultNotNull(Factory.CreateObject("automation/metadataProvider", true) as AutomationMetadataProvider); var context = AutomationManager.Provider.GetAutomationContext(ID.Parse(contact.ContactId)); co...

sitecore • Engagement Automation

Google Analytics in cordova without any plugin.

Insert the analytics function within index.js function analytics(){ (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a...

Cordova • Google Analytics in Cordova

Form validation using NSPredicate

NSString *emailRegex = @"[A-Z0-9a-z]([A-Z0-9a-z._-]{0,64})+[A-Z0-9a-z]+@[A-Z0-9a-z]+([A-Za-z0-9.-]{0,64})+([A-Z0-9a-z])+\\.[A-Za-z]{2,4}"; NSString *firstNameRegex = @"[0-9A-Za-z\"'-]{2,32}$"; NSString *firstNameRegex = @"[ 0-9A-Za-z]{2,32}$"; NSString *lastNa...

iOS • NSPredicate

Installation or Setup

PowerBI reports can be created using PowerBI Desktop application. Download link: https://powerbi.microsoft.com/en-us/desktop/ Requirements (as of 5 April 2017): Windows 7 / Windows Server 2008 R2, or later .NET 4.5 Internet Explorer 9 or later Memory (RAM): At least 1 GB available, 1.5 GB...

powerbi • Getting started with powerbi

Type of value - package "reflect"

reflect.TypeOf can be used to check the type of variables when comparing package main import ( "fmt" "reflect" ) type Data struct { a int } func main() { s:="hey dude" fmt.Println(reflect.TypeOf(...

Go • Reflection

Alter default search_path of user

With the below commands, user's default search_path can be set. Check search path before set default schema. postgres=# \c postgres user1 You are now connected to database "postgres" as user "user1". postgres=> show search_path; search_path ---------------- &q...

postgresql • Role Management

Binding multiple values with a MultiBinding

The MultiBinding allows binding multiple values to the same property. In the following example multiple values are bound to the Text property of a Textbox and formatted using the StringFormat property. <TextBlock> <TextBlock.Text> <MultiBinding StringFormat="{}{0}...

wpf • Introduction to WPF Data Binding

Installation or Setup

Detailed instructions on getting jax-rs set up or installed.

jax-rs • Getting started with jax-rs

Installation or Setup

primary requirement is that java should be installed in your system.there is two option for setting the jersey in the Eclipse IDE is first manually download the jersey jars from this link.and the in the project->add external jars you can add these libraries there.[https://jersey.java.net/download...

jersey • Getting started with jersey

Addition of two vectors using OpenMP parallel for construct

void parallelAddition (unsigned N, const double *A, const double *B, double *C) { unsigned i; #pragma omp parallel for shared (A,B,C,N) private(i) schedule(static) for (i = 0; i < N; ++i) { C[i] = A[i] + B[i]; } } This example adds two vector (A and B into...

openmp • Loop parallelism in OpenMP

Conditional clauses in OpenMP parallel regions

#include <omp.h> #include <stdio.h> int main (void) { int t = (0 == 0); // true value int f = (1 == 0); // false value #pragma omp parallel if (f) { printf ("FALSE: I am thread %d\n", omp_get_thread_num()); } #pragma omp parallel if (t) { printf (&quo...

openmp • Conditional parallel execution

Parallel processing of a c++ list container using OpenMP tasks

#include <omp.h> #include <unistd.h> #include <iostream> #include <list> static void processElement (unsigned n) { // Tell who am I. The #pragma omp critical ensures that // only one thread sends data to std::cout #pragma omp critical std::cout <...

openmp • Irregular OpenMP parallelism

Localize Variables with @at-root directive

@at-root directive can be used to localize variables. $color: blue; @at-root { $color: red; .a { color: $color; } .b { color: $color; } } .c { color: $color; } is compiled to: .a { color: red; } .b { color: red; } .c { color: blue; }

sass • Variables