Select * from tab equivalent in SQL Server

 Oracle SQL:: Select * from tab;

MS SQL Server::  

select TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE
from INFORMATION_SCHEMA.TABLES order by TABLE_TYPE,TABLE_NAME

What is a Runbook?

 

A runbook is a step-by-step guide that describes all procedures and operations that must be considered or addressed during the cutover. 

A runbook contains all the required documentation for each member of the cutover team to complete their tasks, as well as timelines and detailed instructions so that everyone can work together effectively and efficiently. 

To guarantee that there are no problems throughout the cutover process, your deployment runbook will need to be more extensive the larger and more complicated your business' old systems are. Most IT networks today span several systems and include third-party applications, therefore they should all be included in the runbook to avoid or minimize downtime.

Back to data migration

  Hi All, I am once again back to data migration, which is my most desired technical activity.

Will start with some notes about challenges w.r.t bad data / dirty data in a wide perspective.

We can broadly classify dirty data into

Inaccurate

Incomplete

Duplicate

Siloed

Ungoverned

Stale

Unshared

Inconsistent

I will start posting my thoughts in different tech stuff here soon. From Telecom , SOA, BigData
BI etc and etc.

DBA Basics

Important Telecom terms and its descriptions.

Resilience