Tutorial by Examples: e

CREATE VIEW view_EmployeeInfo WITH ENCRYPTION AS SELECT EmployeeID, FirstName, LastName, HireDate FROM Employee GO

CREATE VIEW view_PersonEmployee AS SELECT P.LastName, P.FirstName, E.JobTitle FROM Employee AS E INNER JOIN Person AS P ON P.BusinessEntityID = E.BusinessEntityID GO Views can use joins to select data from numerous sources like tables, table functio...

UPDATE HelloWorlds SET HelloWorld = 'HELLO WORLD!!!' WHERE Id = 5 The above code updates the value of the field "HelloWorld" with "HELLO WORLD!!!" for the record where "Id = 5" in HelloWorlds table. Note: In an update statement, It is advised to use a "where&...

A simple form of updating is incrementing all the values in a given field of the table. In order to do so, we need to define the field and the increment value The following is an example that increments the Score field by 1 (in all rows): UPDATE Scores SET score = score + 1 This can be dang...

The obvious way to zero a register is to MOV in a 0—for example: B8 00 00 00 00 MOV eax, 0 Notice that this is a 5-byte instruction. If you are willing to clobber the flags (MOV never affects the flags), you can use the XOR instruction to bitwise-XOR the register with itself: 33 C0 ...

Background If the Carry (C) flag holds a value that you want to put into a register, the naïve way is to do something like this: mov al, 1 jc NotZero mov al, 0 NotZero: Use 'sbb' A more direct way, avoiding the jump, is to use "Subtract with Borrow": sbb al,a...

Background To find out if a register holds a zero, the naïve technique is to do this: cmp eax, 0 But if you look at the opcode for this, you get this: 83 F8 00 cmp eax, 0 Use test test eax, eax ; Equal to zero? Examine the opcode you get: 85 c0 test ea...

We will use the built in tooth growth dataset. We are interested in whether there is a statistically significant difference in tooth growth when the guinea pigs are given vitamin C vs orange juice. Here's the full example: teethVC = ToothGrowth[ToothGrowth$supp == 'VC',] teethOJ = ToothGrowth[To...

The rep function can be used to repeat a vector in a fairly flexible manner. # repeat counting numbers, 1 through 5 twice rep(1:5, 2) [1] 1 2 3 4 5 1 2 3 4 5 # repeat vector with incomplete recycling rep(1:5, 2, length.out=7) [1] 1 2 3 4 5 1 2 The each argument is especially useful for ex...

var multiplexer = ConnectionMultiplexer.Connect("localhost"); IDatabase db = multiplexer.GetDatabase(); // intialize key with empty string await db.StringSetAsync("key", ""); // create transaction that utilize multiplexing and pipelining ITransaction transacton...

When the Pentium was being developed, memory sizes, and the programs that ran in them, were getting larger. The OS had to do more and more work to maintain the Paging Subsystem just in the sheer number of Page Indexes that needed to be updated when large programs or data sets were being used. So th...

class Program { private static Lazy<ConnectionMultiplexer> _multiplexer = new Lazy<ConnectionMultiplexer>( () => ConnectionMultiplexer.Connect("localhost"), LazyThreadSafetyMode.ExecutionAndPublication); static void Main(string[] args...

This example will show you how to create a Windows Forms Application project in Visual Studio. Create Windows Forms Project Start Visual Studio. On the File menu, point to New, and then select Project. The New Project dialog box appears. In the Installed Templates pane, select "...

Open a text editor (like Notepad), and type the code below: using System; using System.ComponentModel; using System.Drawing; using System.Windows.Forms; namespace SampleApp { public class MainForm : Form { private Button btnHello; // The form's con...

In pointer arithmetic, the integer to be added or subtracted to pointer is interpreted not as change of address but as number of elements to move. #include <stdio.h> int main(void) { int array[] = {1, 2, 3, 4, 5}; int *ptr = &array[0]; int *ptr2 = ptr + sizeof(int) * 2; ...

Mesos is a cluster manager aiming for improved resource utilization by dynamically sharing resources among multiple frameworks. It was started at the University of California, Berkeley in 2009 and is in production use in many companies, including Twitter and Airbnb. It became an Apache top-level ...

docker network create app-backend This command will create a simple bridged network called appBackend. No containers are attached to this network by default.

docker network ls This command lists all networks that have been created on the local Docker host. It includes the default bridge bridge network, the host host network, and the null null network. All containers by default are attached to the default bridge bridge network.

docker network connect app-backend myAwesomeApp-1 This command attaches the myAwesomeApp-1 container to the app-backend network. When you add a container to a user-defined network, the embedded DNS resolver (which is not a full-featured DNS server, and is not exportable) allows each container on ...

docker network disconnect app-backend myAwesomeApp-1 This command detaches the myAwesomeApp-1 container from the app-backend network. The container will no longer be able to communicate with other containers on the network it has been disconnected from, nor use the embedded DNS resolver to look u...