A fairly important aspect of retail software is inventory management. Often this requires some kind of counter that reduces the count of stock items based on the number […]
Securing SQL Server: – Data Classification and Vulnerability Assessment
A big challenge with implementing security is just being able to keep track of the different tables and columns where the data is located. This features in […]
Securing Azure AD using the free stuff
One of the first things I did in 2021 was to log into Azure portal and check my Active Directory. You can imagine how much of a shock […]
How to analyze a Presidential debate?
During the last US presidential election we extracted some important critical information from the presidential debate to help profile the candidates. This year we are performing the same […]
Azure Data Sync Issues
Azure data sync is a great tool for those people looking for a quick and easy way to move data from on premise systems to the cloud. It […]
When does SQL Server Cache an execution plan?
Ever wondered under what circumstances SQL Server cache an execution plan. What is the difference between simple and forced parametrization. What are the disadvantages of plans being cached? […]
Visual Studio – The process cannot access the file because it is being used by another process
Cannot delete the file “C:\……t\LoadExcelFiles.ispac”: The process cannot access the file ‘C:\…..LoadExcelFiles.ispac’ because it is being used by another process The above error common message that we encounter […]
PowerBI DAX – USERELATIONSHIP
A common issue faced when working with PowerBI is the limitation of having only one Active relationship between two tables. While this is a not an issues when […]
PowerBI DAX- TREATAS
Once we are able to create virtual tables within PowerBI using Functions such as EVALUATE , CALCULATE TABLE etc it might be required to filter the contents of […]
PowerBI DAX- TOTALYTD
A very useful kind of report is called a cumulative report. Which is based on summarizing data cumulatively. This means we can see the area chart as progressively […]