How to import large .sql file in MS SQL Server

1 1 1 1 1 How to import large .sql file in MS SQL Server5.00Rating 5.00 (1 Vote)

Sometimes you need to import large database into MS SQL Server, but when you use Microsoft SQL Server Management Studio, it doesn't do the job right, but shows the message "Insufficient memory". Or maybe you need to do a batch import of sql script to database instead of doing the import by hand. Here comes in handy the sqlcmd command line tool. It can import large .sql files, can be run from a batch script, installer, etc.

How to use sqlcmd command-line tool to import large .sql file?

Open a command prompt window.
In the Command Prompt window, type: sqlcmd -S yourServer\instanceName -i C:\yourScript.sql
Press ENTER.
The progress of operation is written to the command prompt window.

Source: Microsoft

How do I make a JSON object with multiple arrays?

1 1 1 1 1 How do I make a JSON object with multiple arrays?5.00Rating 3.00 (2 Votes)

{
"cars": {
"Nissan": [
{"model":"Sentra", "doors":4},
{"model":"Maxima", "doors":4}
],
"Ford": [
{"model":"Taurus", "doors":4},
{"model":"Escort", "doors":4}
]
}

 

Source: https://stackoverflow.com/questions/11197818/how-do-i-make-a-json-object-with-multiple-arrays/11197949

Arrays in JSON

1 1 1 1 1 Arrays in JSON5.00Rating 3.00 (2 Votes)

Example

[ "Ford", "BMW", "Fiat" ]


Arrays in JSON are almost the same as arrays in JavaScript.

In JSON, array values must be of type string, number, object, array, boolean or null.

In JavaScript, array values can be all of the above, plus any other valid JavaScript expression, including functions, dates, and undefined.

Arrays can be values of an object property:

Example
{
"name":"John",
"age":30,
"cars":[ "Ford", "BMW", "Fiat" ]
}

The objects returned from most Server APIs are highly nested:

{
"id": "0001",
"type": "donut",
"name": "Cake",
"ppu": 0.55,
"batters":
{
"batter":
[
{ "id": "1001", "type": "Regular" },
{ "id": "1002", "type": "Chocolate" },
{ "id": "1003", "type": "Blueberry" },
{ "id": "1004", "type": "Dog's Food" }
]
},
"topping":
[
{ "id": "5001", "type": "None" },
{ "id": "5002", "type": "Glazed" },
{ "id": "5005", "type": "Sugar" },
{ "id": "5007", "type": "Powdered Sugar" },
{ "id": "5006", "type": "Chocolate with Sprinkles" },
{ "id": "5003", "type": "Chocolate" },
{ "id": "5004", "type": "Maple" }
]
}

Sourceы: https://www.w3schools.com/js/js_json_arrays.asp  https://adobe.github.io/Spry/samples/data_region/JSONDataSetSample.html

Introduction to JSON

1 1 1 1 1 Introduction to JSON5.00Rating 3.00 (2 Votes)

JSON is a text format that facilitates structured data interchange between all programming languages. JSON
is syntax of braces, brackets, colons, and commas that is useful in many contexts, profiles, and applications.
JSON was inspired by the object literals of JavaScript aka ECMAScript as defined in the ECMAScript
Language Specification, third Edition [1]. It does not attempt to impose ECMAScript’s internal data
representations on other programming languages. Instead, it shares a small subset of ECMAScript’s textual
representations with all other programming languages.

Read more: Introduction to JSON

cJSON: Lightweight JSON parser

1 1 1 1 1 cJSON: Lightweight JSON parser5.00Rating 3.00 (2 Votes)

cJSON is one of the simplest possible parser that you can get your job done with. It's a single file of C, and a single header file.

JSON is described best here: http://www.json.org/ It's like XML, but fat-free. You use it to move data around, store things, or just generally represent your program's state.

As a library, cJSON exists to take away as much legwork as it can, but not get in your way. 

There are several ways to incorporate cJSON into your project, one of them is just copying the source.

Because the entire library is only one C file and one header file, you can just copy cJSON.h and cJSON.c to your projects source and start using it.

cJSON is written in ANSI C (C89) in order to support as many platforms and compilers as possible.

Read more: cJSON: Lightweight JSON parser

How to Install APK to Android Device via ADB in 6 simple steps

1 1 1 1 1 How to Install APK to Android Device via ADB in 6 simple steps5.00Rating 3.00 (2 Votes)

1. Download and install android platform tools: https://developer.android.com/studio/releases/platform-tools.html

2. Open command line and navigate to the folder where ADB is located, eg. cd /D d:\Android\sdk\platform-tools\

3. Type adb devices and press ENTER.

Read more: How to Install APK to Android Device via ADB in 6 simple steps

How To Upload Directory Tree To Remote FTP Server Recursively in Linux

1 1 1 1 1 How To Upload Directory Tree To Remote FTP Server Recursively in Linux5.00Rating 2.60 (10 Votes)

When you host your web site remotely and the ftp server is the only way to upload all files including subdirectroies. You need to use special file transfer program such as ncftpget or ncftpput for recursive remote ftp server uploading and downloading purpose. Ncftp is considered as an improved FTP client. Ncftp's improvements include support for command line editing, command histories, recursive gets/puts, automatic anonymous logins, and much more.

1. Install ncftp client

Type the following command under Debian/Ubuntu Linux to install ncftp client:
$ sudo apt-get install ncftp

Read more: How To Upload Directory Tree To Remote FTP Server Recursively in Linux

Android WebView transparent background for Android 2.3 and 4.x

1 1 1 1 1 Android WebView transparent background for Android 2.3 and 4.x5.00Rating 2.45 (11 Votes)

Many people face an issue with Android's WebView and transparent background. The problem is that if you need to make transparent background for the WebView, it is not easy to do at the first sight. If you try to use property android:background="@android:color/transparent", you will discover that it just don't work as expected. The background is still opaque. Using background color set explicitly as #ff000000 constant sometimes work and sometimes not. 

Read more: Android WebView transparent background for Android 2.3 and 4.x

Windows XP: How to Change Power Options When No User is Logged on

1 1 1 1 1 Windows XP: How to Change Power Options When No User is Logged on5.00Rating 3.00 (2 Votes)

HKEY_USERS\.Default stores the profile used when no users are logged on to the computer (such as when the CTRL+ALT+DELETE logon prompt is displayed).

HKEY_USERS\.DEFAULT\Control Panel\PowerCfg
Value Name: CurrentPowerPolicy
Data Type: REG_SZ
Value Data: 0 thru 5

Read more: Windows XP: How to Change Power Options When No User is Logged on

Fixing Magento error "[unknown object].fireEvent()"

1 1 1 1 1 Fixing Magento error "[unknown object].fireEvent()"5.00Rating 3.53 (19 Votes)

Recently I've encountered the following Javascript error in my Magento store:

error: error in [unknown object].fireEvent():
event name: address_country_changed
error message: zipElement.up(...).down(...) is undefined

This error pops out when creating the order from admin panel and entering customer shipping address. It pops out when editing every filed in the address, which is quite annoying.

Regarding to this forum post, this has something to do with defining the zip code as not required filed in the database. Specialists recommend to set zip code as required filed in the database and then setting it as not required on the country basis. But people report that setting so will still not make zip code as optional field.

So I decided to do my own fix. Here it is:

Read more: Fixing Magento error "[unknown object].fireEvent()"

Thursday the 23rd.