New – News on Database System
This month i will try to write whats new going on in the market, as i could see many new...
2018-09-02
231 reads
Vinay Thakur
Apache Hadoop Ozone+HDDs and Kubernetes
As Hadoop is already a great on BIG Data, now as you know hadoop has addition stuff in it with...
2018-07-09
704 reads
Kubernetes
Have you heard the name Kubernetes, it is another open source in the market by Google and works one Containers,...
2018-07-06
320 reads
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
390 reads
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
274 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
290 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
273 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
208 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
289 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
203 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers