Tutorial by Examples: i

This is a bare minimum setup for MySQL servers using InnoDB tables. Using InnoDB, query cache is not required. Reclaim disk space when a table or database is DROPed. If you're using SSDs, flushing is a redundant operation (SDDs are not sequential). default_storage_engine = InnoDB query_cache_type ...

The default encryption aes-128-ecb uses Electronic Codebook (ECB) mode, which is insecure and should never be used. Instead, add the following to your configuration file: block_encryption_mode = aes-256-cbc

Using PowerShell executed from a SharePoint Web Server: $wacoll = get-spwebapplication foreach($wa in $wacoll){ if($wa.IsAdministrationWebApplication -eq $false){ foreach($site in $wa.Sites){ foreach($web in $site.AllWebs){ # your code here ...

When using PowerShell, you can use setx.exe to set environment variables permanently. Start PowerShell Type one of the following: setx ASPNETCORE_ENVIRONMENT "development" setx ASPNETCORE_ENVIRONMENT "staging" Restart PowerShell

Make sure that you first have Node.js and npm installed. Then install sequelize.js with npm npm install --save sequelize You will also need to install supported database Node.js modules. You only need to install the one you are using For MYSQL and Mariadb npm install --save mysql For Postgr...

PS> console_app.exe PS> & console_app.exe PS> Start-Process console_app.exe

PS> gui_app.exe (1) PS> & gui_app.exe (2) PS> & gui_app.exe | Out-Null (3) PS> Start-Process gui_app.exe (4) PS> Start-Process gui_app.exe -Wait (5) GUI applications launch in a different process, and will immediately return control to the PowerShell host. Sometimes you...

PS> $LastExitCode PS> $? PS> $Error[0] These are built-in PowerShell variables that provide additional information about the most recent error. $LastExitCode is the final exit code of the last native application that was executed. $? and $Error[0] is the last error record that was gene...

Many of us start debugging with simple print(). Let's say we have such a class: class Abc { let a = "aa" let b = "bb" } and we have an instance of Abc as so: let abc = Abc() When we run the print() on the variable, the output is App.Abc while dump() output...

If you want to use connection object for query database you can use this sample code. var queryString = "SELECT name, age FROM students " ; var query = client.query(queryString); query.on("row", (row, result)=> { result.addRow(row); }); query.on("end", func...

The Lru Cache will store all the added resources (values) for fast access until it reaches a memory limit, in which case it will drop the less used resource (value) to store the new one. To initialise the Lru cache you need to provide a maximum memory value. This value depends on your application r...

To add a resource to the cache you must provide a key and the resource. First make sure that the value is not in the cache already public void addResourceToMemoryCache(String key, Bitmap resource) { if (memoryCache.get(key) == null) memoryCache.put(key, resource); }

To get a resource from the cache simply pass the key of your resource (String in this example) public Bitmap getResourceFromMemoryCache(String key) { memoryCache.get(key); }

Step 1: Create an empty project via File -> New Project. Step 2: Right click the project solution and select Build Dependencies->Build Customizations. Step 3: Check the checkbox ".masm". Step 4: Press the button "ok". Step 5: Create your assembly file and type in th...

Detailed instructions on getting prestashop-1.6 set up or installed. Start by downloading the zip-file from prestashop.com/download In the zip-folder you'll find a folder called prestashop and an html-file with an installation guide Put the contents of the folder prestashop into the location wh...

Some WMI Classes expose Methods that allow you to do something with that object. For example, the Win32_Printer class has 11 methods for interacting with a printer, one of which is the PrintTestPage method. The following code demonstrates how to select a specific printer and print a test page. 'Spe...

This tslint.json example contains a set of configuration to enforce more typings, catch common errors or otherwise confusing constructs that are prone to producing bugs and following more the Coding Guidelines for TypeScript Contributors. To enforce this rules, include tslint in your build process ...

Many, pure python, packages are not yet available on the Python Package Index as wheels but still install fine. However, some packages on Windows give the dreaded vcvarsall.bat not found error. The problem is that the package that you are trying to install contains a C or C++ extension and is not c...

There are changes in how we are setting the initial states. React.createClass We have a getInitialState function, which simply returns an Object of initial states. import React from 'react'; const MyComponent = React.createClass({ getInitialState () { return { activePage: 1 ...

Custom binding definition function regExReplace(element, valueAccessor, allBindingsAccessor, viewModel, bindingContext) { var observable = valueAccessor(); var textToReplace = allBindingsAccessor().textToReplace || ''; var pattern = allBindingsAccessor().pattern || ''; var flags = all...