Microsoft Acquire GitHub after Linkedin
Microsoft acquires GitHub is a very big news after LinkedIn… that way now Microsoft will grow like anything as considering...
2018-07-06
383 reads
Vinay Thakur
Day 25 Optimization
Locking is depends upon Isolation level and Storage Engine. MySQL uses table level locking (instead of page, row, or column...
2018-05-25
270 reads
Day 24 Replication Setup
Today we will discuss how setup a replication: Master – Slave Replication: Requirement: 2 (Linux) System (MasterServer and SlaveServer) MySQL Installed...
2018-05-24
276 reads
Day 23 Replication
Replication means making copy of the objects and moving transaction from primary server to secondary/standby/Slave server. There are two type...
2018-05-23
267 reads
Day 20 Innodb Storage engine
InnoDB is the major Storage engine and is default Storage engine after MySQL 5.5 version. As standard RDBMS requires ACID...
2018-05-21
198 reads
Day 21 NDB Storage Engine (Cluster)
MySQL also support High Availability, NDB Storage engine provides high availability- shared-nothing system, NDB Cluster integrates the standard MySQL server...
2018-05-21
278 reads
Day 22 Other Storage Engines
So far we have discussed InnoDB, MyIASM and NDB Storage engine which are most standard/common and important storage engine MySQL...
2018-05-21
191 reads
Day 19 MyIASM Storage engine
MyIASM storage engine is available from the early stage of MySQL this engine is developed from IASM language and it...
2018-05-19
203 reads
Day 18 Storage engine
MySQL is special compare to all the other RDBMs System because of its special architecture, the STORAGE Engine. MySQL has...
2018-05-18
253 reads
Day 17 Backup and Recovery
There are there types of Backup: Full Backup Incremental Backup Bin-Log Backup Full Backup: is a complete backup of the...
2018-05-17
236 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers