Tutorial by Examples

Security policy is a group of predicates associated to tables that can be managed together. You can add, or remove predicates or turn on/off entire policy. You can add more predicates on tables in the existing security policy. ALTER SECURITY POLICY dbo.CompanyAccessPolicy ADD FILTER PREDICATE...

Row-level security enables you to define some predicates that will control who could update rows in the table. First you need to define some table-value function that represents predicate that wll control access policy. CREATE FUNCTION dbo.pUserCanAccessProduct(@CompanyID int) RETURNS TABLE WIT...

The point about temporary tables is that they're limited to the scope of the connection. Dapper will automatically open and close a connection if it's not already opened. That means that any temp table will be lost directly after creating it, if the connection passed to Dapper has not been opened. ...

Every good IDE provides a GUI for interactively debugging Ruby (and thus Rails) applications where you can add breakpoints, watches, auto pausing on exception and allows you to follow the code execution even step by step, line by line. For example, take a look at one of the best Ruby IDE's, RubyMin...

Automatic calculation of low and high thresholds for the Canny operation in opencv

In this example, we will log into the GitHub website by using the FormElement class. // # Constants used in this example final String USER_AGENT = "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36"; final String LOGIN_FORM_U...

Access the RecyclerView in the NavigationView and add ItemDecoration to it. NavigationView navigationView = (NavigationView) findViewById(R.id.nav_view); NavigationMenuView navMenuView = (NavigationMenuView) navigationView.getChildAt(0); navMenuView.addItemDecoration(new DividerItemDecoration(thi...

You can configure the database settings in config/connections.js. Example: someMongoDb: { adapter: 'sails-mongo', host: 'localhost', // defaults to `localhost` if omitted port: 27017, // defaults to 27017 if omitted user: 'username_here', // or omit if not relevant password: 'passwo...

Install from NPM. npm install sails-mongo --save

Create a new SSDT project Import 3rd party DB Build project to create a dacpac Reference dacpac in other projects

C++ provides only 4 anchors: ^ which asserts the start of the string $ which asserts the end of the string \b which asserts a \W character or the beginning or end of the string \B which asserts a \w character Let's say for example we want to capture a number with it's sign: auto input = &q...

Google Apps Script is a JavaScript based platform-as-a-service primarily used to automate and extend Google Apps. Apps Script runs exclusively on Google's infrastructure requiring no server provisioning or configuration. An online IDE serves as the interface to the entire platform connecting all the...

Detailed instructions on getting mips set up or installed.

Step one We need to create a service called jwToken. Go to api/services directory and create jwToken.js. 'use strict'; const jwt = require('jsonwebtoken'), tokenSecret = "secretissecret"; module.exports = { // Generates a token from supplied payload issue(payload) { ...

We need two dependencies: bcrypt for encryption npm install bcrypt --save JSON Web token npm install jsonwebtoken --save

Laravel allows you to use multiple Authentication types with specific guards. In laravel 5.3 multiple authentication is little different from Laravel 5.2 I will explain how to implement multiauthentication feature in 5.3 First you need two different user Model cp App/User.php App/Admin.php ch...

Go to the repository you want to clone (something like: https://github.com/username/repo) On the right, click on the green button named clone or download A small window will appear, copy the url (something like: https://github.com/username/repo.git) Open a terminal window on...

If you have email column you can mask it with email() mask: ALTER TABLE Company ALTER COLUMN Email ADD MASKED WITH (FUNCTION = 'email()') When user tries to select emails from Company table, he will get something like the following values: [email protected] [email protected] [email protected]

You can add partial mask on the column that will show few characters from te beginning and the end of the string and show mask instead of the characters in the middle: ALTER TABLE Company ALTER COLUMN Phone ADD MASKED WITH (FUNCTION = 'partial(5,"XXXXXXX",2)') In the parameters of th...

Random mask will show a rundom number from the specified range instead of the actual value: ALTER TABLE Product ALTER COLUMN Price ADD MASKED WITH (FUNCTION = 'random(100,200)') Note that is some cases displayed value might match actual value in column (if randomly selected number matches valu...