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 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

Saturday, November 10, 2012

Adding Email, Details field in UserProfile DB Table in MVC

Adding Email, Details field in UserProfile DB Table in MVC In this post you will learn how to add Email and Details columns in existing D...
Read More

Monday, October 22, 2012

Inner Join using LINQ for Multiple Tables (3 Tables Now) with Lambda

Inner Join using LINQ for Multiple Tables (3 Tables Now) with Lambda Inner Join using LINQ for Multiple Tables (3 Tables Now) with ...
Read More

Inner Join using LINQ

Inner Join using LINQ Inner Join using LINQ   Introduction Today, in this article let's play around with one of the interesting...
Read More

Inner Join using LINQ with Lambda

Inner Join using LINQ with Lambda Inner Join using LINQ with Lambda   Introduction Today, in this article let's play around wit...
Read More

Inner Join using LINQ for Multiple Tables (3 Tables Now)

Inner Join using LINQ for Multiple Tables (3 Tables Now) Inner Join using LINQ for Multiple Tables (3 Tables Now)   Introduction To...
Read More