Prakash K

I am a MS SQL DBA, born and brought up in Mumbai, India. Done my engineering in Electronics And Telecommunications and have been working in this industry as a DBA since 2011

Blog Post

Intelligent Query Processing (IQP)

In SQL Server 2022, a new feature called Intelligent Query Processing (IQP) makes use of machine learning to enhance query performance. Because of the automatic workload adjustment provided by...

2023-03-20 (first published: )

591 reads

Blog Post

In Memory OLTP – 1

In-Memory OLTP  (A.K.A. Hekaton) is a specialized, memory-optimized relational data management engine and native stored procedure compiler, integrated into SQL...

2016-12-06

626 reads

Blogs

Stack Overflow & AI

By

I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow...

Checking Myself with GenAI

By

I had a suggestion from somone on a place where AI helps them and...

Redgate SQL Prompt in SSMS 21

By

Disclaimer: this post is not sponsored by Redgate 🙂 For those who’ve missed it,...

Read the latest Blogs

Forums

Deadlocks and Backups - Need help

By Mike-342950

Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...

Does Version Control Scare You

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Does Version Control Scare You

Unlimited Text

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Unlimited Text

Visit the forum

Question of the Day

Unlimited Text

If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?

See possible answers