PinnedPower BI x Smartsheet: How to Build Dynamic Issue Tracking ReportsThe goal of this article is to inspire you to take your Smartsheet data and transform it into a dynamic, interactive report. Smartsheet is…Dec 9, 2024Dec 9, 2024
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 8, 2024Nov 8, 2024
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
Why 1 Beats * in Certain SQL Queries (And When to Use it)“1” might seem like just a simple number, but as we know in any programming language or the computing world, 1 plays a significant role…Feb 24Feb 24
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 26, 2024Jan 26, 2024
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
