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
705 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
391 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
275 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
209 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
291 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
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers