Blogs - Page 5 of 5 - Technology Cue – IT Consulting & Digital Transformation in Brisbane

SQL Queries SQL Tips

Finding the Start Position of a String Within Another String

Problem Statement : This article explains how to find the starting index of the first occurrence of a pattern in a string or a specified…

admin08/12/2022

Datawarehouse ETL SQL Queries SQL Tips

How to deal with Long running SQL Query?

Problem Statement: Long running queries have been found in the plan cache. These may be ETL, reports, or other queries that should run long. Or…

Yash Shah07/12/2022

Datawarehouse ETL SQL Queries SQL Tips

How to create a Running Total Function in SQL

Problem Statement: In SQL, a running total is the cumulative sum of the previous numbers in a column. Code Snippet: -- Create a view that…

Yash Shah28/11/2022

ETL SQL Queries

How to Subtract Days from DateTime in SQL Server?

We can use DATEADD() function to Subtract days from DateTime in Sql Server. DATEADD() functions first parameter value can be day or dd or d all will…

admin25/11/2022

Datawarehouse ETL SQL Queries

How to create a Volume Data for Database

Problem Statement: This article describes how to display the data and log space information for a database in SQL Server by using SQL Server Management…

Yash Shah24/11/2022

Datawarehouse ETL SQL Queries SQL Tips

How to create Columnstore Index using SQL

Problem Statement:-

Yash Shah24/11/2022

Python

Download YouTube Videos in Python

#1 Install and import PyTube library to download the video: pip install pytube import pytube   #2 Ask for the video URL: url =…

Yash Shah05/09/2022

ETL Power BI

How to Find a Value by searching Multiple Columns in Power BI

Problem: We were combining data from 2 source systems and transforming directly within Power BI and as a result, need to filter Contract Manager which…

admin26/09/2019

ETL

How to Troubleshoot Subscription issue in Reporting Services

Tips on troubleshooting Subscription issue in Reporting Services 1 – Look at the Reporting Services Log File Error Message from Log File: Email Provider…

admin26/09/2019

ETL

How To Extract data from Sharepoint Online using Power BI

If you want to extract data from Sharepoint online using Power BI then this code snippet might help to connect to Sharepoint online Code Snippet…

admin26/09/2019

Finding the Start Position of a String Within Another String

How to deal with Long running SQL Query?

How to create a Running Total Function in SQL

How to Subtract Days from DateTime in SQL Server?

How to create a Volume Data for Database

How to create Columnstore Index using SQL

Download YouTube Videos in Python

How to Find a Value by searching Multiple Columns in Power BI

How to Troubleshoot Subscription issue in Reporting Services

How To Extract data from Sharepoint Online using Power BI

Services

Get in touch

Subscribe Now