Tutorial by Examples: at

Let use 'os_server' command from module 'Cloud' [http://docs.ansible.com/ansible/os_server_module.html]. Variables are defined in ./group_vars/all. $vi launch_compute.yml - name: launch a compute instance hosts: localhost gather_facts: False tasks: - name: Create and launch the VM ...

Use the 'os_server_facts' command from module 'Cloud' [http://docs.ansible.com/ansible/os_server_module.html]. Variables are defined in ./group_vars/all and the instance name is in server: "MyOwnPersonalInstance". $vi get_compute_info.yml - name: Get and print instance IP hosts: loca...

This guide is explicitly for PostgreSQL 9.1 or higher on linux machines. It uses the postgres extensions-feature that will greatly improve the import of extensions to an existing postgres-installation. If you have to work with an older version of postgres, please refer to the official documentations...

To create a new empty database, run as postgres-user: createdb [yourdatabase] Connect to the database with a psql-session: psql -d [yourdatabase] In the psql-session run: CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology; to create the neccesary geospatial extensions. Once thi...

Bullet This one particularly blew my mind. The bullet gem helps you kill all the N+1 queries, as well as unnecessarily eager loaded relations. Once you install it and start visiting various routes in development, alert boxes with warnings indicating database queries that need to be optimized will p...

In this example we will set up a geospatial database, import data from 2 different sources, and view the results in an application called QGIS. This guide is explicitly written for linux-machines, if you operate on another platform, some commands or paths might not work as expected. In order to vie...

Typically we represent an anary tree (one with potentially unlimited children per node) as a binary tree, (one with exactly two children per node). The "next" child is regarded as a sibling. Note that if a tree is binary, this representation creates extra nodes. We then iterate over the s...

TypeScript supports interfaces, but the compiler outputs JavaScript, which doesn't. Therefore, interfaces are effectively lost in the compile step. This is why type checking on interfaces relies on the shape of the object - meaning whether the object supports the fields and functions on the interfac...

Query to search last executed sp's in db SELECT execquery.last_execution_time AS [Date Time], execsql.text AS [Script] FROM sys.dm_exec_query_stats AS execquery CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql ORDER BY execquery.last_execution_time DESC Query to search thro...

//Using statement for ExcelTable and TableStyles using OfficeOpenXml.Table; //Defining the tables parameters int firstRow =1; int lastRow = worksheet.Dimension.End.Row; int firstColumn = 1; int lastColumn = worksheet.Dimension.End.Column; ExcelRange rg = worksheet.Cells[firstRow, firstCol...

Asterisk is an open source framework for building communications applications. You can use it for any of the following: IP PBX systems VoIP gateways ISDN/ 3G IVVR Here is a brief instruction for step by step installation of asterisk 1.8(or you can do for latest versions) on Redhat/centos (fo...

To use standard location services while the application is in the background you need first turn on Background Modes in the Capabilities tab of the Target settings, and select Location updates. Or, add it directly to the Info.plist. <key>NSLocationAlwaysUsageDescription</key> <st...

worksheet.Cells["A1:A25"].Style.Numberformat.Format = "@";

Detailed instructions on getting ssrs-2008 set up or installed.

This installation assumes hadoop to be pre-installed under hadoop user. Prerequisites: Hue depends on these following packages gcc g++ libxml2-dev libxlst-dev libsasl2-dev libsasl2-modules-gssapi-mit libmysqlclient-dev python-dev python-setuptools libsqlite3-dev ant libkrb5-dev libt...

Detailed instructions on getting installshield set up or installed.

[DscResource()] class File { } This example demonstrates how to build the outer section of a PowerShell class, that declares a DSC Resource. You still need to fill in the contents of the class definition.

[DscResource()] class Ticket { [DscProperty(Key)] [string] $TicketId [DscProperty(Mandatory)] [string] $Subject } When building a DSC Resource, you'll often find that not every single property should be mandatory. However, there are some core properties that you'll want to ensure ...

@{ RootModule = 'MyCoolModule.psm1' ModuleVersion = '1.0' CompatiblePSEditions = @('Core') GUID = '6b42c995-67da-4139-be79-597a328056cc' Author = 'Bob Schmob' CompanyName = 'My Company' Copyright = '(c) 2017 Administrator. All rights reserved.' Description = 'It does cool stu...

//Add a List validation to B column. Values should be in a list var val = worksheet.DataValidations.AddListValidation("B:B"); //Shows error message when the input doesn't match the accepted values val.ShowErrorMessage = true; //Style of warning. "information" and "warn...