Part 2:- Learning T SQL for beginners – Datatypes

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…

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

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…

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…

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…

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 would be some good syntax or code available on the Internet. On Googling I did find a couple of links but they all felt a bit cumbersome…

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 concept even if they don’t know the exact name of it. I think the best way to explain this will be with an example so let’s have…

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 trainings as well as consulting. The fact is the answer is very straight forward but at the same time not an easy one to hear. I’ve…

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 1024 MB (on purpose). The error message mentioned that memory could be an issue as shown below in bold. The client was unable to establish a connection…

Error IDX21323 – RequireNonce is ‘[PII is hidden by default. Set the ‘ShowPII’ flag in IdentityModelEventSource.cs to true to reveal it.]

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 implement authentication without the hassle of…

Adding a reusable block to the WordPress Site

  A great way to add content to a WordPress site is to use reusable blocks. A block as its name suggests is a unit of code representing a paragraph and image a widget or a video or any combination of the above. These blocks can be made reusable such that you could customise them…