SanOraLife

 This query below gives you All Tables with Columns in All the database in SQL Server: SET NOCOUNT ON DECLARE @AllTables table ( DbName sysn...

Got annoyed with Teams taking forever to upload a simple file.  Found that clearing Teams Cache would help and here are the steps to do so i...

 At the time of this post, Snowflake did not have any dictionary view that gives the column names for constraints that are defined for a tab...

The below command gets the records that have a value "new" in the given position (in this case the file was fixed-width). All othe...

#below inserts a line at 1st row with the content  " Added new line using sed  " in all the files in the path for i in *; do sed -...