In this series we cover all the different ways you can protect your Microsoft SQL Server database from attacks. We cover the methodology being used to secure databases. […]
FREE PowerBI session – Batch 2
It’s time for the next batch of PowerBI Sessions. This is a 3 hour free PowerBI Session for those whose careers have been affected by #Covid or those […]
PowerBI Introduction – More info
As we wait for the session to start you can find a screenshot of the kind of report we will be creating. If you can’t wait to get […]
Introduction to PowerBI
The Covid 19 situation has been tough for pretty much everyone and a lot of careers have come to an abrupt stop. If you feel your career opportunities […]
Introduction to PowerBI
The Covid 19 situation has been tough for pretty much everyone and a lot of careers have come to an abrupt stop. If you feel your career opportunities […]
Opportunity =Money! = Worth
We have always had to measure the worth of things. Everybody has things they want and in order to get them they need to trade. With trade came […]
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 […]
29 DAX Functions you must know
PowerBI has been the preferred BI tool for a large number of companies in recent times. As the tools get adopted we have seen a number of reporting […]
PowerBI DAX – VAR
A very useful way to work with DAX functions is to use VAR. VAR is a form of variable in which results can be stored temporarily without having […]