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