wiky apps: Database

Software Development, Games Development, Mobile Development, iOS Development, Android Development, Window Phone Development. Dot Net, Window Services,WCF Services, Web Services, MVC, MySQL, SQL Server and Oracle Tutorials, Articles and their Resources

Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts

Saturday, October 20, 2018

UUIDs With MongoDB and Node.js

My team uses MongoDB quite heavily in a variety of our service backends. Some of these services interface with one another. For example, ...
Read More

Query Databases Using Java Streams

Query Databases Using Java Streams In this article, you will learn how you can write pure Java applications that are able to work with da...
Read More

Provisioning SQL Databases With Initial Sets of Data Using Java and MockNeat

MockNeat is a "faker"-like Java library that is used to mock complex Java objects or to generate arbitrary data for a wide rang...
Read More

Containerizing a Spring Data Cassandra Application

I'm continuing my journey of learning Docker. I am still keeping it simple at this point. This time around, I am going to tackle conv...
Read More

Breaking the Monolithic Database in Your Microservices Architecture

When you are decomposing your application to adopt microservices architecture, it is important to focus on the monolithic database. You w...
Read More

Saturday, October 13, 2018

CRUD With Blazor Using MongoDB

Introduction In this article, we will create a Blazor application using MongoDB as our database provider. We will create a Single Page Ap...
Read More

Tuesday, October 9, 2018

MySQL 8: Load Fine Tuning With Resource Groups

MySQL Resource Groups, introduced in MySQL 8, provide the ability to manipulate the assignment of running threads to specific resources, ...
Read More

Sunday, September 30, 2018

Execute PL/SQL Calls With Python and cx_Oracle

After you've got the hang of performing Basic CRUD operations with cx_Oracle, you're ready to start tapping into some of the real...
Read More

Tuesday, September 25, 2018

SQL Database Corruption: Causes, Prevention, and Fixing Techniques

"I had a Database File and I want to attach this MDF file to SQL Server 2014. However, whenever I try to attach the file, I am recei...
Read More

Saturday, August 18, 2018

Database Migration for .Net Core Projects

You can find all my .Net core posts here. I am adding a new post after a long break because I recently joined a new company called Attach...
Read More

Creating Multiple Masked Databases with SQL Provision

Sometimes developer teams need access to a copy of the database containing live data. However, if that database contains sensitive or per...
Read More

Tuning InnoDB Primary Keys

The choice of good InnoDB primary keys is a critical performance tuning decision. This post will guide you through the steps of choosing ...
Read More

Monday, July 9, 2018

Best Practices for Cassandra Data Modeling

People new to NoSQL databases tend to relate NoSql as a relational database, but there is quite a difference between those. For people fr...
Read More

Sunday, July 8, 2018

What To Do When MySQL Runs Out of Memory: Troubleshooting Guide

Troubleshooting crashes is never a fun task, especially if MySQL does not report the cause of the crash. For example, when MySQL runs out...
Read More

Thursday, October 24, 2013

10 Easy Steps to a Complete Understanding of SQL

Too many programmers think SQL is a bit of a beast. It is one of the few declarative languages out there, and as such, behaves in an enti...
Read More

Friday, October 18, 2013

C# - Add/Copy Rows from One Datatable to Another Datatable

Introduction: Here I will explain simple code snippet in c# to add rows from one table to another table in vb.net, asp.net or copy rows f...
Read More

Monday, March 18, 2013

Wednesday, January 9, 2013

Understanding SQL Injection and Creating SQL Injection Proof ASP.NET Applications

As ASP.NET developers, we often write dynamic SQL to perform some database operations. These dynamic SQL is some cases might be created by...
Read More

Sunday, November 11, 2012

LinQ Extended Joins

The very first time that I was interested by LinQ, there in 2007, apart from the great admiration for the product and the whole range o...
Read More

What are SQL Joins and How to use thses..

The first thing we learn to do with SQL is writing a SELECT statement to get data from one table. This kind of statement seems to be str...
Read More