Data Cleaning – A detailed view for Data Analysts
SQLZealots
by Latheesh NK
1y ago
Definition of Data Cleaning Data cleaning is a process of preparing data for analysis by removing or modifying data that ..read more
Visit website
UnPivot data in Excel using Power Query
SQLZealots
by Latheesh NK
1y ago
Its a very frequent requirement to transform data in your excel sheet to meet some of your requirement or understanding ..read more
Visit website
A glimpse of Dimensional Modelling
SQLZealots
by Latheesh NK
1y ago
Why Data Warehouse? Datawarehouse is important in modern technology world for several reasons as below: Transactional Versus Reporting Transactional Database ..read more
Visit website
Azure Data Studio
SQLZealots
by Latheesh NK
1y ago
Introduction Azure Data Studio (ADS) is a cross-platform database tool for those who work in On-Premise or Cloud platforms on ..read more
Visit website
ANY, ALL & SOME Operators in SQL Server
SQLZealots
by Latheesh NK
1y ago
ANY is a SQL operator that used to compare a scalar value with a set of single column resultset from ..read more
Visit website
Exception: “Invalid parameter 1 specified for datediff.” in SQL Server
SQLZealots
by Latheesh NK
2y ago
Problem Statement: One of the view creation scripts in our deployment failed continuously with the below exception: Invalid parameter 1 ..read more
Visit website
Retry SQL Code for X times within SQL Script
SQLZealots
by Vigneshwaran A
2y ago
In some genuine cases, we may experience a failure even when there are no issues with SQL Script or SQL ..read more
Visit website
How to identify duplicate lines in a text file using Python
SQLZealots
by Latheesh NK
2y ago
Here is a short program in Python to identify the count of duplicate lines in a text file. Output: If ..read more
Visit website
SQL Behaviour – Assignment of value to Variable
SQLZealots
by Vigneshwaran A
2y ago
We are going to see the SQL Behaviour while assigning value to variable, we thought of writing this post since ..read more
Visit website
Error Message: Server is not configured for RPC in SQL Server
SQLZealots
by Latheesh NK
2y ago
Recently one of my colleague reached out to me with an error message as : “Server is not configured for ..read more
Visit website

Follow SQLZealots on FeedSpot

Continue with Google
Continue with Apple
OR