Online Free Computer Tutorials.: 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, 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

Wednesday, January 9, 2013

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

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

Monday, September 17, 2012

Performing Bulk Copy Operations on Database

There can be situation when we need to copy large amount of data from one location to another. For example,  you have created a backup co...
Read More

Thursday, August 30, 2012

HOWTO: SQLite with Windows 8 apps

I've previously posted a few things about SQLite including a HOWTO on how to build from their source code. If you still want to build...
Read More

Thursday, July 26, 2012

CT in SQL server 2008 R2

This article explores one of the features (of SQL server 2008 and higher) of providing the change tracking abilities i.e. what data has c...
Read More