MySQL Master-Slave Replication on the Same Machine

Submitted by pIrina on

by Ivan Bojovic

MySQL replication is a process that enables data from one MySQL database server (the master) to be copied automatically to one or more MySQL database servers (the slaves). It is usually used to spread read access on multiple servers for scalability, although it can also be used for other purposes such as for failover, or analyzing data on the slave in order not to overload the master.

Planning SharePoint Data Storage for better Performance and Manageability

Submitted by Nizam on

If you are planning for setup of your SharePoint farm, as all the data that you access/put in SharePoint goes to the SQL Server database, it is very important to plan out your storage of your database files to achieve a better performance and manageability.

SQL Server 2016 - What you can benefit

Submitted by Nizam on

Enhanced in-memory performance provides up to 30x faster transactions, more than 100x faster queries than disk-based relational databases and real-time operational analytics

New Always Encrypted technology helps protect your data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without application changes

Stretch Database technology keeps more of your customer’s historical data at your fingertips by transparently stretching your warm and cold OLTP data to Microsoft Azure in a secure manner without application changes

SQL Server 2014 CTP1

Submitted by Nizam on

This is really exciting to see SQL Server roadmap towards improving the performance of the database and making it more robust for Business Intelligence processing. OLTP was really a problem in older version of the database, Microsoft SQL Server 2014 with the improvement of in-memory will make a lot of difference. Here are some brief outline from the datasheet about SQL Server 2014:-

How to check when index rebuild, update statistics last happened on SQL Server

Submitted by Nizam on

Question: I have executed the script given on below link to rebuilt all table indexes on SQL Server, but how do I know whether it is updated or not.

SQL Script for rebuilding all the tables’ indexes

Now the problem is that SQL Server does not store the information when all the indexes were rebuilt, however it stores the information on when was the last time statistics were updated.

What do you mean by a Functional Dependency in the process of Normalization ???

Submitted by Nizam on

A Function Dependency tells you the relation ship of two columns in the a table.Functional Dependencies are fundamental to the process of Normalization that describes the relationship between attributes(columns) in a table.

For example, if A and B are ..............

Tips: Sample SQL Script demonstrating moving row from one database table to another database table

Submitted by Nizam on

Many times such requirement comes wherein you need to copy data from one database to another database. Below is the sample sql script demonstrating the same.

You can use a three part qualifier like DatabaseName.Schema.TableName to address a table in a different database.

Use Database1

INSERT INTO Databas2.dbo.TableName
SELECT * FROM Database1.dbo.TableName

You just need to make sure the selected data matches the datatypes in the destination table.