SQL Server Blog quarterly review
This SQL Server blog roll talks about the few blog articles I have published in last couple of months. I am certain you would like reading
The post SQL...
2024-01-08 (first published: 2024-01-01)
227 reads
SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
Create failed for Availability Group
Ever since the release of Always On Availability Group (AG or HADR) in SQL Server 2012 the adoption ratio is increasing. A lots of my clients too are adopting...
2024-01-03 (first published: 2023-12-25)
4,013 reads
PostgreSQL Backup Failure
In this blog post I wrote a tip about fixing the PostgreSQL backup failure issue. The error was directing about the permission issue.
The post PostgreSQL Backup Failure appeared first...
2023-12-04
1,184 reads
Job Description of a DBA
I have curated the list of activities of a DBA or one can say Job Description of a DBA. DBA needs to adapt and keep learning new technologies
The...
2023-12-11 (first published: 2023-11-27)
1,766 reads
Force parameterization is powerful-feature
Force parameterization in Microsoft SQL Server is a feature designed to optimize query performance by converting literal values in Transact-SQL statements into parameters. This process helps in plan reuse,...
2023-11-27 (first published: 2023-11-13)
843 reads
How to write efficient TSQL
This is an article on How to write efficient TSQL. When it comes to composing T-SQL (Transact-SQL) code, there exist a multitude of vital considerations developers should bear in...
2023-11-20 (first published: 2023-11-06)
1,054 reads
Common Mistakes in SQL Server – Final
In this final and summary post on the blog series of Common Mistakes in SQL Server I have pen down about auto growth, use of null values, implicit conversion...
2023-11-15 (first published: 2023-10-30)
559 reads
Common Mistakes in SQL Server – Final
In this final and summary post on the blog series of Common Mistakes in SQL Server I have pen down about auto growth, use of null values, implicit conversion...
2023-10-30
9 reads
Common Mistakes in SQL Server – Part 6
In SQL Server, there are various scenarios in which you may want to consider recompiling a query or a stored procedure to ensure optimal query performance. Recompilation generates a...
2023-11-06 (first published: 2023-10-23)
755 reads
Common Mistakes in SQL Server – Part 6
In SQL Server, there are various scenarios in which you may want to consider recompiling a query or a stored procedure to ensure optimal query performance. Recompilation generates a...
2023-10-23
22 reads
Blogs
Why I stopped using MCP for AI coding stuff
By HeyMo0sh
Something has shifted quietly in 2026. The developers I know/respect—the ones actually shipping, not...
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers