Every once in a while, there is a need to profile columns in a table. typically as part of a redesign, the below query help quickly profile some important aspects of the column such as the name, datatype , min , max , count and count distinct values. The query generates the profile which can…
Category: Uncategorized
Outlook 2019 keeps asking for password multiple times
A few years back I had tried upgrading my version of Outlook from 2013 to 2019. During this time I faced a number of issues and the most irritating one was that Outlook constantly kept asking me to enter the password. I contacted Microsoft support and spent close about two hours and a number of emails trying to…
Query to find execution time of Jobs
Recently we have been facing couple of issues with regard to the way the jobs have been scheduled. To investigate this, we needed a query that can identify the execution time of jobs to see if they overlap. In addition, we needed to see which steps within the job are taking unusually long to complete as well as information about jobs…
A simple script to decapitalize Column names
The above script can take column names for all tables in the database and provide the rename script to only capitalize the first letter.
My personal side effects with Covishield
This is a comprehensive list of side effects I faced after taking the Covishield vaccine. I took the vaccine on Wednesday and fully recovered by Friday. If you Google common side effects Covishield vaccine you will find a list that includes the following. Most common: Pain or tenderness at the injection site Headache Tiredness Muscle…
Memory Configuration in MS SQL Server
Understanding Memory Usage Lock Pages in Memory Min and Max Memory Setting
Configuring Office 365 on Outlook 2013- when using MFA (Modern Authentication)
I recently formatted my laptop and this resulted in all the software being removed from the operating system. Normally this wouldn’t be that big a deal except I have outlook 2013 being used as my primary mail client. Admittedly outlook 2013 is pretty old and not compatible with Office 365. This is mainly because Office…
How to enable Hyper-V on Windows 10 Home edition OS
One the biggest issues I had with Windows 10 was when it said I had to uninstall VMware since it wasn’t compatible with the OS. Thus a perfectly good license was wasted. I figured I would just use Hyper-V going forward only to realize that Hyper V wasn’t supported on Windows 10 Home edition. For…
Script for Backup Encryption
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 the need to ensure you’re not being ripped off and so we standardized the rates. Initially this meant a fixed quantity of food or cattle gets exchanged….
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 to create measures and then using them in others. For example you use Var to store the result of a particular group and then use the var…
PowerBI DAX- USERNAME
This is a function that may not be used as frequently as it used to be but it is likely you will encounter it in older PowerBI Reports where RLS or row level security was implemented. The function returns the username of the user currently viewing the report. Using this information and mapping it against…
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 importing data it can make creating measures a hassle. An example of this scenario could be the use of calendar table for Order Date and Delivery Date….
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 the virtual table based on certain Input criteria. In such cases we can use the TREATAS function to apply filters to a Virtual or Actual Table as…
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 growing as the year goes by. Charts such as these provide a clear indication of the long term trajectory of the sales and clearly indicates Sales for…