PinnedData Migration 101: Generate a SQL Script with Table Data in SQL ServerRecently, I found myself in a situation where I needed to migrate data from one table to another on different servers. The tables were…Nov 8Nov 8
PinnedHow to delete duplicate rows from a table using the ROW_NUMBER function in SQL?ROW_NUMBER()is one of the SQL’s most useful functions which can be leveraged for many advanced scenarios and use cases. Some of those…Sep 13, 2022Sep 13, 2022
EASY WAY TO CREATE A VIEW FROM THE TABLE IN SQLI came across a challenge that required creating a view from a very complex table with 30+ columns. The goal was to create a view almost…Jan 26Jan 26
SQL COLLATION ISSUESIf you’ve ever encountered the ‘Cannot resolve the collation conflict’ error message while working in SQL Server Management Studio (SSMS)…May 9, 20231May 9, 20231
SQL function we could use more often — ASCII () function with examplesASCII is an abbreviation for American Standard Code for Information Interchange, and to make things a bit more clear it is a character…Apr 8, 2021Apr 8, 2021
How to create a batch script and a task scheduler on Windows server 2012A batch file is a script file which contains series of commands that get executed one after the other, in sequence. A batch file is…Feb 11, 2020Feb 11, 2020
Oracle APEX — Basic authorization for REST servicesRoles, privileges and privilege mappingOct 10, 20191Oct 10, 20191