The DB World

Re-Inventing Humanity

• by administrator

• The DB World

Wishing you all a very happy, prosperous and peaceful new year 2020! May new year make us Human who cares for all the living being and for our mother...

2020-01-11

12 reads

Re-Inventing Humanity

• by administrator

• The DB World

Are we Human or Robots ? AI & ML shall definitely change the world some day in future. One thing is also sure, very soon we’ll also become machines...

2020-01-07

Part 2 : Does storage architecture matters ?

• by administrator

• The DB World

This article is the part of Does it matter ? series.

2019-11-16

4 reads

Part 1 : Does database modelling matters ?

• by administrator

• The DB World

This article is the part of Does it matter ? series.

2019-11-06

Project Management and Advocacy

• by administrator

• The DB World

I’ve observed few similarities between the Project Managers and Advocates. Being Project Manager, law bachelor and little practical experienced as an Advocate, I noticed few similarities. I think it’s...

2019-11-04

Does it matter ?

• by administrator

• The DB World

A series of articles that will talk about most important but least focused areas in Database Design and Development.

2019-10-31

T-SQL query to get the latest available backup chain

• by administrator

• The DB World

T-SQL query to return the latest available database backup chain (Full, Differential and Log) of individual databases along with their backup size and compressed size.

2019-10-30

T-SQL script to purge all the tables including foreign key references

• by administrator

• The DB World

T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and...

2019-10-30

T-SQL query to copy data from one database to another database

• by administrator

• The DB World

T-SQL query to copy the rows of all the tables from one database to another database only if they have rows in Source DB and exact same Schema in...

2019-10-30

2 reads

Pseudo Code for batch processing using WHILE LOOP

• by administrator

• The DB World

  Leveraging WHILE LOOP

2019-10-10