Skip to content

Jayanth Kurup SQL Guy

Everything SQL and More

  • Home
  • PowerBI
  • Simply Better Business
  • Business Intelligence
  • Contact Us
  • Clients and Testimonials
administration / TSQL

Boolean Hell – Missed rows when grouping in SQL

Posted on: April 20, 2021June 25, 2025

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

administration / Misc

What is the role of the DBA in a Cloudy world?

Posted on: April 15, 2021June 25, 2025

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

administration

Memory Configuration in MS SQL Server

Posted on: April 15, 2021June 20, 2025

Understanding Memory Usage Lock Pages in Memory Min and Max Memory Setting

administration / Errors

No process is on the other end of the pipe

Posted on: April 9, 2021June 20, 2025

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

Errors

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

Posted on: April 1, 2021June 25, 2025

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

Wordpress

How to add a Next and Previous Post Button to the WordPress site

Posted on: March 24, 2021June 20, 2025

Adding a next and previous button to the post footer makes navigation much easier for the reader. Imagine a long post with a lot of content. The user […]

Wordpress

Adding a reusable block to the WordPress Site

Posted on: March 23, 2021June 25, 2025

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

Wordpress

Adding a subscribe button to your WordPress site

Posted on: March 23, 2021June 25, 2025

Recently in a move to improve the subscription rate and overall search ranking of my site I decided to add a subscribe button to all my posts. The […]

administration

Database in Suspect: – DBCC CHECKDB – It has been marked suspect by recovery

Posted on: March 22, 2021June 25, 2025

A database on the server was recently in suspect mode and the error message below was provided on running DBCC CHECKDB. This is a classic case of why […]

Wordpress

SEO – Expire Headers for WordPress site hosted on IIS

Posted on: March 18, 2021June 20, 2025

One of the most important things you can do to improve your Google search index ranking is to improve the load time of your website. What this means […]

Posts pagination

Previous page Page 1 … Page 5 Page 6 Page 7 … Page 51 Next page

Please consider following

Subscribe

Recent Posts

  • IntelliSense not working in latest version of SSMS
  • Converting times across time zones
  • SQL 2025 Optimized locking in SQL2025
  • You Can’t Be King till You’ve Killed Someone 
  • Fuzzy String matches in TSQL
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