Tutorial by Examples: l

Detailed instructions on getting audio set up or installed.

Query store can be enabled on database by using the following command: ALTER DATABASE tpch SET QUERY_STORE = ON SQL Server/Azure SQL Database will collect information about executed queries and provide information in sys.query_store views: sys.query_store_query sys.query_store_query_text sy...

The following query will return informationa about qeries, their plans and average statistics regarding their duration, CPU time, physical and logical io reads. SELECT Txt.query_text_id, Txt.query_sql_text, Pl.plan_id, avg_duration, avg_cpu_time, avg_physical_io_reads, avg_logica...

SQL Query optimizer will choose the baes possible plan that he can find for some query. If you can find some plan that works optimally for some query, you can force QO to always use that plan using the following stored procedure: EXEC sp_query_store_unforce_plan @query_id, @plan_id From this poi...

ObservableCollection is a collection of type T like List<T> which means that it holds objects of type T. From documentation we read that : ObservableCollectionrepresents a dynamic data collection that provides notifications when items get added, removed, or when the entire list is refres...

files = list.files(pattern="*.csv") data_list = lapply(files, read.table, header = TRUE) This read every file and adds it to a list. Afterwards, if all data.frame have the same structure they can be combined into one big data.frame: df <- do.call(rbind, data_list)

LINQ extension methods on IEnumerable<T> take actual methods1, whether anonymous methods: //C# Func<int,bool> fn = x => x > 3; var list = new List<int>() {1,2,3,4,5,6}; var query = list.Where(fn); 'VB.NET Dim fn = Function(x As Integer) x > 3 Dim list = New List F...

Add the readonly attribute to prevent user input. A readonly field can't be edited <input class="form-control" type="text" placeholder="Readonly input here…" readonly> Add the disabled attribute to disable an input field. A disbled field can't be edited either...

$scheme = 'https' $url_format = '{0}://example.vertigion.com/foos?{1}' $qs_data = @{ 'foo1'='bar1'; 'foo2'= 'complex;/?:@&=+$, bar''"'; 'complex;/?:@&=+$, foo''"'='bar2'; } [System.Collections.ArrayList] $qs_array = @() foreach ($qs in $qs_data.GetEnumerator()...

Encoded with [uri]::EscapeDataString() First, we'll decode the URL and Query String encoded with [uri]::EscapeDataString() in the above example: https://example.vertigion.com/foos? foo2=complex%3B%2F%3F%3A%40%26%3D%2B%24%2C%20bar'%22& complex%3B%2F%3F%3A%40%26%3D%2B%24%2C%20foo'%22=bar2&am...

Encoded with [uri]::EscapeDataString() First, we'll decode the URL and Query String encoded with [uri]::EscapeDataString() in the above example: https://example.vertigion.com/foos? foo2=complex%3B%2F%3F%3A%40%26%3D%2B%24%2C%20bar'%22& complex%3B%2F%3F%3A%40%26%3D%2B%24%2C%20foo'%22=bar2&am...

List all the node versions installed nvm ls v4.5.0 v6.7.0 Run command using any node installed version nvm run 4.5.0 --version or nvm exec 4.5.0 node --version Running node v4.5.0 (npm v2.15.9) v4.5.0 nvm run 6.7.0 --version or nvm exec 6.7.0 node --version Running node v6.7.0...

This is the Cypher, Neo4j's query language. In many ways, Cypher is similar to SQL if you are familiar with it, except SQL refers to items stored in a table while Cypher refers to items stored in a graph. First, we should start out by learning how to create a graph and add relationships, since tha...

public class AmazonRootobject { public Itemsearchresponse ItemSearchResponse { get; set; } } public class Itemsearchresponse { public string xmlns { get; set; } public Operationrequest OperationRequest { get; set; } public Items Items { g...

using System; using System.Collections.Generic; using System.Linq; using System.Reflection; using System.Text; using System.Threading.Tasks; using System.Xml; using System.Xml.Linq; using ApplicationDataServices.SBEntityBox; namespace ApplicationManagementLayer.Affiliate { public cl...

Objective-C and Xib Add a target to an existing XCode project In the Add Target select Custom KeyBoard Add the target like this: Your project file directory should look something like this Here myKeyBoard is the name of the added Target Add new Cocoatouch file of type of type UIView and ...

To use the IMAP functions in PHP you'll need to install the IMAP extension: Debian/Ubuntu with PHP5 sudo apt-get install php5-imap sudo php5enmod imap Debian/Ubuntu with PHP7 sudo apt-get install php7.0-imap YUM based distro sudo yum install php-imap Mac OS X with php5.6 brew reinsta...

To do anything with an IMAP account you need to connect to it first. To do this you need to specify some required parameters: The server name or IP address of the mail server The port you wish to connect on IMAP is 143 or 993 (secure) POP is 110 or 995 (secure) SMTP is 25 or 465 (secure) N...

Once you've connected to your mailbox, you'll want to take a look inside. The first useful command is imap_list. The first parameter is the resource you acquired from imap_open, the second is your mailbox string and the third is a fuzzy search string (* is used to match any pattern). $folders = ima...

You can return a list of all the messages in a mailbox using imap_headers. <?php $headers = imap_headers($mailbox); The result is an array of strings with the following pattern: [FLAG] [MESSAGE-ID])[DD-MM-YYY] [FROM ADDRESS] [SUBJECT TRUNCATED TO 25 CHAR] ([SIZE] chars) Here's a sample o...