Everything SQL related and then some
The first time I heard about the Monty Hall problem was while watching TV. The host of the TV show had presented the problem as you typically see. I am recapping it for your benefit now. The TV show has three doors. Behind one of which there is a prize. The guest is…
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…
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…
In the previous post I talked about what Microsoft SQL Server programming language (T-SQL) is about. I also explained what a table is and what basic information is requires. In this post we’re going to continue the discussion on tables a bit further. Now we try to understand some more features that we need to provide the table in order…
Learning SQL is easy when you have a good understanding of the basics. Everything else is based on the basics and it’s been the same since RDBMS (relational database management systems) have been launched. In this series of posts I hope to provide you with a good understanding of the basics and help you start…
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…
The above script can take column names for all tables in the database and provide the rename script to only capitalize the first letter.
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…
To perform image classification its best to have a GPU to improve the speed of operations. To have everything working on a GPU you need to have Pytorch installed with the support for appropriate version of CUDA. Keep in mind all versions of CUDA are not supported at the moment. In order to have CUDA…
This is an issue that arises as a result of the version incompatibility of the modules in Keras and tensor flow. The solution you find on google recommends downgrading the version of Tensor flow to 2.1 but this is no longer an option. You can create a virtual environment in Python but that still won’t…