Tutorial by Topics: q

SQL Server Management Studio (SSMS) is a tool to manage and administer SQL Server and SQL Database. SSMS is offered free of charge by Microsoft. SSMS Documentation is available.

This section provides an overview of what sqlite3 is, and why a developer might want to use it. It should also mention any large subjects within sqlite3, and link out to the related topics. Since the Documentation for sqlite3 is new, you may need to create initial versions of those related topi...

If we have a Hive meta-store associated with our HDFS cluster, Sqoop can import the data into Hive by generating and executing a CREATE TABLE statement to define the data’s layout in Hive. Importing data into Hive is as simple as adding the --hive-import option to your Sqoop command line. Impo...

This script is designed to handle reporting devices (IoT), when a device is not previously authorized (in the devices table in the database), I add the new device to a new_devices table. I run an update query, and if affected_rows returns < 1, I insert. When I have a new device report, the first...

This documentation focuses on explaining the uses and of the require() statement that NodeJS includes in their language. Require is an import of certain files or packages used with NodeJS's modules. It is used to improve code structure and uses. require() is used on files that are installed locally...

This topic covers how to do a dynamic pivot in SQL Server.

RequireJS is a JavaScript file and module loader. It is optimized for in-browser use, but it can be used in other JavaScript environments, like Rhino and Node. Using a modular script loader like RequireJS will improve the speed and quality of your code. Using TypeScript with RequireJS requires conf...

Here is some of different ways to provide alias names to columns in Sql Server

Get data directly into an R session. One of the nice features of R is the ease of data acquisition. There are several ways data dissemination using R packages.

Take, Skip, TakeWhile and SkipWhile are all called Partitioning Operators since they obtain a section of an input sequence as determined by a given condition. Let us discuss these operators

This technique divides input data into data classes to reduce test cases amount to validate a rule. The idea is that given a set of possible equivalent values, using just one of those values will be enough to design a test case. An advantage of this approach is reduction in the time required for...

This technique should be used whenever you have boundaries defined into a spec. It is a great idea to apply it to any rule based on time, values, any kind of counting or scale to be triggered. It also ensure and helps finding n + 1 errors. And yes, it is an expansion from Equivalence Partition c...

This technique should be used when you have any workflow in place, and should consider positive test cases (transitions that can happen), as well as negative test cases (transitions that are not allowed). Any rule that can be described, thinked, scratched as a state transition diagram, workflow,...

A frequent desire is to convert monthly data into quarterly data format. One simple method is to 1) sum the appropriate months into quarterly sums, then 2) identify those months as quarters, and finally 3) filter the quarterly data out of your monthly data. Here's a relatively quick and easy method ...

There are scenarios when dealing with service layer in liferay, when we need to query database with too many clauses or dealing with multiple tables.In such cases,we use either of: 1)Dynamic query(wrapper on Hibernate criteria API) 2)Custom SQL queries References: Custom SQL Dynamic quer...

Dynamic SQL allows you to assemble an SQL query code in the runtime. This technique has some disadvantages and have to be used very carefully. At the same time, it allows you to implement more complex logic. PL/SQL requires that all objects, used in the code, have to exist and to be valid at compila...

How use ansible to install mysql binary file

SQL Database Recovery SQL Database Recovery And Everything You Need To Know About It: When someone is collecting data in its raw form, you will need to organize it for it to make sense to the company. All the figures and facts are information but not necessarily important for the business. Data in i...