The below script can take column names for all tables in the database and provide the rename script to only capitalize the first letter. Sometimes we just want […]
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 […]
Setting up and Configuring CUDA, CUDNN and PYTorch for Python Machine Learning.
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 […]
keras.utils.generic_utils’ has no attribute ‘populate_dict_with_module_objects
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 […]
Simple Function to capitalize a string
Recently I was required to write a function that would capitalize the 1st letter in every word. This is a fairly common requirement and I felt that there […]
Boolean Hell – Missed rows when grouping in SQL
I was recently asked about the concept of Boolean hell and thought it would be a good post to discuss. Most database professionals should be familiar with the […]
What is the role of the DBA in a Cloudy world?
What is the role of the DBA in a world where Cloud is being adopted more and more each day? This is a question I’ve had to answer multiple times in various sessions and […]
Memory Configuration in MS SQL Server
Understanding Memory Usage Lock Pages in Memory Min and Max Memory Setting
No process is on the other end of the pipe
Recently I got the below error when trying to connect to SQL Server. There error was caused in this case because the max memory setting was set to […]
Error IDX21323 – RequireNonce is ‘[PII is hidden by default. Set the ‘ShowPII’ flag in IdentityModelEventSource.cs to true to reveal it.]
One of the best features of Azure is the ability to authenticate with Azure Active Directory. This is easy to implement and therefore a very nice way to […]