Skip to content

Jayanth Kurup SQL Guy

Everything SQL and More

  • Home
  • PowerBI
  • Simply Better Business
  • Business Intelligence
  • Contact Us
  • Clients and Testimonials
Database / Misc / MSSQL / TSQL

Monty Hall Simulation using T-SQL

Posted on: April 5, 2022December 30, 2023

  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 […]

Database / MSSQL / TSQL

Query to quickly profile a column

Posted on: February 7, 2022January 15, 2025

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 […]

Database

Outlook 2019 keeps asking for password multiple times

Posted on: December 9, 2021December 26, 2022

  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 […]

TSQL

Part 2:- Learning T SQL for beginners – Datatypes

Posted on: September 28, 2021December 30, 2023

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 […]

TSQL

Part 1:- Learning T SQL for beginners- SQL, Tables and Nulls

Posted on: September 27, 2021December 30, 2023

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 […]

administration

Query to find execution time of Jobs

Posted on: July 28, 2021December 30, 2023

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 […]

TSQL

A simple script to decapitalize Column names

Posted on: July 19, 2021December 30, 2023

The above script can take column names for all tables in the database and provide the rename script to only capitalize the first letter.

Misc

My personal side effects with Covishield

Posted on: June 27, 2021December 30, 2023

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 […]

AI-ML

Setting up and Configuring CUDA, CUDNN and PYTorch for Python Machine Learning.

Posted on: June 3, 2021December 30, 2023

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 […]

AI-ML

keras.utils.generic_utils’ has no attribute ‘populate_dict_with_module_objects

Posted on: May 30, 2021December 30, 2023

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 […]

Posts pagination

Page 1 Page 2 … Page 33 Next page

Please consider following

Subscribe

Recent Posts

  • You Can’t Be King till You’ve Killed Someone 
  • Fuzzy String matches in TSQL
  • Executing Python Code in TSQL using SQL 2022
  • When is a date not a date in MS SQL SERVER?
  • The certificate received from the remote server was issued by an untrusted certificate authority
Log in

Categories

  • administration
  • AI-ML
  • AWS
  • Azure
  • Database
  • Errors
  • Misc
  • MSBI
  • MSSQL
  • MYSQL
  • NOSQL
  • PowerBi
  • Security
  • TSQL
  • Uncategorized
  • Wordpress
Log in
Theme Shaft Blog Powered by Kantipur Themes