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)
190 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)
2,987 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
924 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,493 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)
716 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,002 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)
547 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
5 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)
746 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
16 reads
Blogs
Sabbatical le Troisième: A Recharge Week
By Steve Jones
It’s been a week since I flew home from London and Redgate to begin...
SQL Server Careers: Still a Goldmine, or a Dead End?
When you're searching about the future of a career in MS SQL Server, you're...
AI Destroying Creativity or Creative Industry
By Rohit Garg
In 2025, artificial intelligence is no longer a futuristic concept—it’s a central force in...
Forums
how to move all SP from one db to another db?
Hi everyone I have two db - one is test and other is archive. ...
The Long Weekend
Comments posted to this topic are about the item The Long Weekend
Need Help to implement the De Duplication
Dear All, Good Day. I have a requirement to implement de-duplication on customer data...
Question of the Day
Independence Day
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers