Tutorial by Examples: l

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...

Switch to the new opened tab. Close the current windows(In this case the new Tab). Switch back to first window. PROTRACTOR: browser.getAllWindowHandles().then(function (handles) { browser.driver.switchTo().window(handles[1]); browser.driver.close(); browser.driver.switchTo().window(...

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...

url |> IO.inspect |> HTTPoison.get! |> IO.inspect |> Map.get(:body) |> IO.inspect |> Poison.decode! |> IO.inspect This will result in a lot of output with no context: "https://jsonplaceholder.typicode.com/posts/1" %HTTPoison.Response{body: &qu...

using the label option to add context can help a lot: url |> IO.inspect(label: "url") |> HTTPoison.get! |> IO.inspect(label: "raw http resonse") |> Map.get(:body) |> IO.inspect(label: "raw body") |> Poison.decode! |> IO.inspect...

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...

//myLogger.js export default { install(Vue, options) { function log(type, title, text) { console.log(`[${type}] ${title} - ${text}`); } Vue.prototype.$log = { error(title, text) { log('danger', title, text) }, success(title, text) { log('success', ti...

While the basic invocation above is easy enough, the curses package provides the wrapper(func, ...) helper function. The example below contains the equivalent of above: main(scr, *args): # -- Perform an action with Screen -- scr.border(0) scr.addstr(5, 5, 'Hello from Curses!', curses...

//By range address worksheet.Cells["A1:B5"].Merge = true; //By indexes worksheet.Cells[1,1,5,2].Merge = true;

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 } A DSC Resource must declare at least one key property. The key property is what uniquely identifies the resource from other resources. For example, let's say that you're building a DSC Resource that represents a ticket...

@{ 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...

function Add { [CmdletBinding()] param ( [int] $x , [int] $y ) return $x + $y } Export-ModuleMember -Function Add This is a simple example of what a PowerShell script module file might look like. This file would be called MyCoolModule.psm1, and is referenced from the mod...

$FirstName = 'Bob' Export-ModuleMember -Variable FirstName To export a variable from a module, you use the Export-ModuleMember command, with the -Variable parameter. Remember, however, that if the variable is also not explicitly exported in the module manifest (.psd1) file, then the variable wil...

Rather than defining all of your functions in a single .psm1 PowerShell script module file, you might want to break apart your function into individual files. You can then dot-source these files from your script module file, which in essence, treats them as if they were part of the .psm1 file itself...

In order to install an extension as a normal add-on into Release or Beta versions of Firefox greater than, or equal to, version 48, the extension must be signed by Mozilla. An extension is signed by submitting it to AMO. Once it is signed, the extension can be installed on any version of Firefox whi...