MrBool Search
Google Search

Search results
09/27/2016 Article
Reference Guide: NoSQL Databases
NoSQL is an alternative to relational databases that is optimized to work with non-structured data and large data volume, while maintaining high availability and performance. In this guide you will find more informations about NoSQL databases.
10/29/2015 Article
Working with Triggers in PostgreSQL
In this article we will learn in practice the use of triggers in PostgreSQL 9.4 database, and learn how to use the rules.
09/26/2015 Article
Working with Stored Procedures in PostgreSQL
In this article we will see a brief overview around working with stored procedures with PostgreSQL.
08/31/2015 Article
Using Functions in PostgreSQL
In this article we will see how to create a custom audio player for the web environment using only jQuery and audio plugins.
08/27/2015 Article
NoSQL vs NewSQL: BigData in Details
In this article we will see a complete discussion regarding these two new BigData methodologies: NoSQL and NewSQL, their main features and principles.
04/30/2015 Article
Saving Geolocation data with Google Maps API and MongoDB
See in this article how to develop an application based on geographic data using Google Maps API and MongoDB. The application consists of a page on which we will enter the location of taxi passengers and another where we will see a map.
03/31/2015 Article
NoSQL: An Overview to the Non-Relational Database
In this article we are going to see a complete overview regarding the development with NoSQL and its references to Non-relational Databases.
03/30/2015 Article
Stored Procedures and Functions in MySQL with PhpMyAdmin
See this article how to use Stored Procedures and Functions in MySQL using PhpMyAdmin tool, with some real scenarios.
01/28/2015 Article
SQL Server: How to Perform Data Encryption
This article, through contextualization and simple examples, discusses best practices regarding encryption for sensitive data protection inside and outside the organization.
03/27/2014 Article
Database Management System: Overview of DBMS
This article briefs you about Database Management System often called as DBMS and give you an overview about it.
03/17/2014 Article
What is Disaster Recovery Planning in SQL Server
In this article we will talk about the recovery planning in SQL Server. We will learn what is this and how to use it.
03/14/2014 Article
What is Disaster Recovery Planning in SQL Server
In this article we will talk about the recovery planning in SQL Server. We will learn what is this and how to use it.
02/17/2014 Article
SQL server Pivot Table Construction
A pivot table is a series instrument that allows us to restructure and abridge chosen columns and rows of information in a spreadsheet or database tuple to get a chosen statement. In this article we will discuss about the pivot table.
01/30/2014 Article
SQL Server Control Flow Elements
The organize flow in a SSIS wrap up is constructed by using dissimilar types of manages flow elements, just like Pot, Job and Priority constraints. In this article we will discuss about the details of control flow.
01/29/2014 Article
SQL Server Data Source View
In this article we will discuss about the data source views in details in SQL Server.
01/15/2014 Article
Connection Manager in SQL Server
In this article we will discuss about the connection manager in SQL server.
01/02/2014 Article
MS SQL Server Replication
Replication is one of the important aspects in SQL server. In this article, we will discuss the replication in details.
12/18/2013 Article
Stored Procedures in SQL
Stored procedures are one of the important areas in database programming. In this article we will discuss about different areas of stored procedure in details.
12/13/2013 Article
SQL Custom Data Types
In this article we will discuss about the data persistence for custom data types in SQL databases. We will see how to persist custom data types.
12/10/2013 Article
How to Audit SQL Server with the Default Trace
In this article we will talk about the auditing feature of SQL Server’s evasion outline, how the outline is implemented and what it contains. After that, we will see how to use information as of the outline sleeve for auditing and problem searching
12/03/2013 Article
How to Scale large Databases
In database scaling is an important aspect. As the data volume increases, scaling factor plays a major role to support it. In this article we will discuss the scalability of database system.
12/02/2013 Article
Understanding Non-functional testing
Non functional testing is a special type of testing performed to test the non functional requirements like response time, portability, stability etc. In this article we will discuss non functional testing in details.
11/30/2013 Article
OVER Clause for SQL Server
In this article we will elucidate what collective and position transom functions are underneath. The escapade mechanism example database for SQL Server 2008 R2 will be worn for all instances.
11/29/2013 Article
SQL Set Operators
The SET operators unite the outcome of two or additional ingredient queries into one outcome. Queries Containing SET operators are called composite queries. In this article we will discuss the details about Set operators in SQL
11/22/2013 Article
SQL Data Generator
In this article, we can take a general idea of how we can prepare SQL Server Data Generator to produce information.
11/11/2013 Article
Uses of SQL Desc
In this article we will discuss one of the most important functions in the SQL world. The DESC is known as the description in database system. It is used to know the description of database components.
11/06/2013 Article
Running Data Pump SQL DB
In this article I will discuss the details of data pump. Data pump is a technology which enables high speed data movement from one database to another.
11/04/2013 Article
How to capture and execute queries in SQL Server
In this article we will see how to capture and execute queries by means of sys.dm_exec_requests in SQL Server
10/25/2013 Article
Aggregating and Pivoting Data in SQL Server
In this article we will talk about a new class of aggregations that have similar behavior to SQL standard aggregations, but which produce tuples with a flat outline.
10/08/2013 Article
Identifing deadlocks in SQL Server
In this article we will describe the details about dead locks in SQL server DB. Dead lock is one of the important areas where every data base developer should pay more attention.