PinnedBiljana JelićData 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
PinnedBiljana JelićHow 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
Biljana Jelić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
Biljana Jelić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
Biljana Jelić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
Biljana Jelić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
Biljana JelićOracle APEX — Basic authorization for REST servicesRoles, privileges and privilege mappingOct 10, 20191Oct 10, 20191