search
Follow Topic
profile img

Mishel Vettukattil

Oct 19, 2019
bookmarks

linkgeekinsta.com

MySQL joins are used to fetch data from multiple tables. We can call it as a method for fetching records from one or more tables based on some common values in the table.

share
favorite_border0 visibility3
favorite_border0 visibility3 share
bookmarks
profile img

Bharat Dwarkani

Oct 11, 2019
bookmarks

linkibm.com

One of the highlights of PostgreSQL is its versatility, especially when you need a flexible data model. In this post, we’ll explore hstore, PostgreSQL’s simple key-value store, and take a look at how it works using a catalog of books.

share
favorite_border0 visibility0
favorite_border0 visibility0 share
bookmarks
profile img

Bharat Dwarkani

Oct 11, 2019
bookmarks

linkdev.to

Thinking about scaling beyond your Postgres cluster and adding another data store like Redis or Elasticsearch? Before adopting a more complex infrastructure, take a minute and think again. It’s quite possible to get more out of an existing Postgres database

share
favorite_border0 visibility1
favorite_border0 visibility1 share
bookmarks
profile img

Bharat Dwarkani

Sep 02, 2019
bookmarks

linkmssqltips.com

Transparent Data Encryption (TDE) performs real-time I/O encryption and decryption of the data and log files, thereby, protecting data at rest. You can use TDE with Availability Groups to provide security and high availability to your databases.

share
favorite_border0 visibility2
favorite_border0 visibility2 share
bookmarks
profile img

Bharat Dwarkani

Sep 02, 2019
bookmarks

linkmssqltips.com

An important option to be considered during restricting unauthorized access to data is to encrypt data so that even if somebody was able to reach to data it is not discernable by a simple query. Since critical information like credit card numbers are stored in column or two, it does not make sense to encrypt the complete database or database files.

share
favorite_border0 visibility2
favorite_border0 visibility2 share
bookmarks
profile img

Bharat Dwarkani

Sep 02, 2019
bookmarks

linklink.medium.com

Redis is an open source (BSD licensed), in-memory data structure store, used as a database, cache and message broker. It supports various data structures such as Strings, Hashes, Lists, Sets etc.

share
favorite_border0 visibility3
favorite_border0 visibility3 share
bookmarks
profile img

Bharat Dwarkani

Aug 27, 2019
bookmarks

linkdiscussions.syncfusion.com

Some times SQL DB_log.ldf takes up more server space in GBs to shrink and reduce the size of the log file to less than 15 MB from GB execute the below-mentioned script

share
favorite_border0 visibility14
favorite_border0 visibility14 share
bookmarks
profile img

Bharat Dwarkani

Aug 20, 2019
bookmarks

linkdocs.microsoft.com

Azure Cosmos DB is a fully-managed database service with turnkey global distribution and transparent multi-master replication. You can run globally distributed, low-latency operational and analytics workloads and AI on transactional data within your database.

share
favorite_border0 visibility8
favorite_border0 visibility8 share
bookmarks
profile img

Bharat Dwarkani

Aug 20, 2019
bookmarks

linkhackernoon.com

A brief post about what Firebase is all about, and it’s new NoSQL Database — Cloud Firestore. With a variety of server-side technologies that are on the market today, developers have a tough job of deciding what kind of backend is most suitable for their app.

share
favorite_border0 visibility3
favorite_border0 visibility3 share
bookmarks
profile img

Bharat Dwarkani

Aug 18, 2019
bookmarks

linkdigitalocean.com

There are many implementations of the SQL database language available on Linux and Unix-like systems. MySQL and MariaDB are two popular options for deploying relational databases in server environments. However, like most software, these tools can be security liabilities if they are configured incorrectly. This tutorial will guide you through some basic steps you can take to secure your MariaDB or MySQL databases, and ensure that they are not an open door into your VPS.

share
favorite_border0 visibility4
favorite_border0 visibility4 share
bookmarks
add