• Data Cleaning – A detailed view for Data Analysts - Definition of Data Cleaning Data cleaning is a process of preparing data for analysis by removing or modifying data that…
• UnPivot data in Excel using Power Query - Its a very frequent requirement to transform data in your excel sheet to meet some of your requirement or understanding.…
• A glimpse of Dimensional Modelling - Why Data Warehouse? Datawarehouse is important in modern technology world for several reasons as below: Transactional Versus Reporting Transactional Database…
• Data Modelling & Key Concepts - Definition of Data Modelling Data Modelling is a process of identifying the business requirements of an organization and modelling the…
• Power BI Dashboard Report - Overview:- Power BI is a dashboard reporting tool, also an user friendly tool which can get inputs from various data…
• Power BI Desktop Installation Guide - Overview:- Power BI is a dashboard reporting tool which uses the various data sources (SQL Server, excel, csv, analysis services…
• How to Automatically Post to Facebook From WordPress - I was wondering if there are any automatic way of posting my blog post to Facebook directly from WordPress as…
• Some thoughts on working from home and remote work - “Work from Home” – A new IT norm in India. Before I jot down my views here, let me clarify,…
• Zoomit – A tool to boost your presentation skills - If you are community player or even you want to present something to someone, you may need to zoom in…
• Windows Power Shell Script to run SQL Files in Folder against SQL Server Database - Problem Statement:- At times, we may need to run SQL files present in a folder against SQL Server Database. Since…
• Amazon RDS for SQL Server versus SQL Server On Amazon EC2 - Its an era of Cloud computing and anywhere you go, people talk about cloud computing and its usages, migration and…
• On-Demand Performance Test Rig with JMeter - These days it has become necessary to execute the performance test at low cost. This blog details about the how…
• Windows Power Shell Script to Find Full File Path Length for all files in Directory - In some cases, we may need to identify the maximum length of full file path in a directory such that…
• Windows Power Shell script to Purge/Cleanup Backup & Transaction files - At times, we need to purge backup files (.bak, *.trn) which are older than some x days from the server…
• How to get list of filenames in a folder – Command Shell Script - There may be some situation where you want to find the list of all filenames whose patterns are like “*.txt”,…
• Using Windows Power Shell to get the Server Disk Space Information - To find Drive Names, Total Space, Free Space and Free Space Percentage for the list of Servers specified in computers.txt…
• Toulouse Chapter - This post has nothing to do with SQL Server, but sharing my experiences at Toulouse in France. I stayed near…
• How to identify NetBIOS Name of a computer? - Its not a SQL Server related, but I found it difficult to identify a way to get the NetBIOS name…
• Microsoft Free E-Books - Today evening, While I was going through MSDN blog sites, I happen to see such a great collection of Free…
• SQL Formatters – Beautify your code and coding experience - Today, I am going to introduce some of tools available for SQL Server formatting. The list is not in order…
• How to search a word in all files in a Folder – Powershell Script - To search a word in all files in a Folder using Powershell Script $i=0 foreach ($filename in Get-ChildItem -Path FOLDERNAME\…
• My First blog post – SQLZealot - Hi Everyone, Hope all are doing good. I finally decided to blog my experiences in SQL Server here. During MVP…