SQLZealots
400 FOLLOWERS
My SQL Server Ramblings.
SQLZealots
1y ago
Definition of Data Cleaning Data cleaning is a process of preparing data for analysis by removing or modifying data that ..read more
SQLZealots
1y ago
Its a very frequent requirement to transform data in your excel sheet to meet some of your requirement or understanding ..read more
SQLZealots
1y ago
Why Data Warehouse? Datawarehouse is important in modern technology world for several reasons as below: Transactional Versus Reporting Transactional Database ..read more
SQLZealots
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
SQLZealots
1y ago
ANY is a SQL operator that used to compare a scalar value with a set of single column resultset from ..read more
SQLZealots
2y ago
Problem Statement: One of the view creation scripts in our deployment failed continuously with the below exception: Invalid parameter 1 ..read more
SQLZealots
2y ago
In some genuine cases, we may experience a failure even when there are no issues with SQL Script or SQL ..read more
SQLZealots
2y ago
Here is a short program in Python to identify the count of duplicate lines in a text file. Output: If ..read more
SQLZealots
2y ago
We are going to see the SQL Behaviour while assigning value to variable, we thought of writing this post since ..read more
SQLZealots
2y ago
Recently one of my colleague reached out to me with an error message as : “Server is not configured for ..read more