Health Review
Health Review

High Availability

Capacity Planning

Capacity Planning

Capacity Planning
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

Read More »
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, cache efficiency, and improving overall system performance. Enabling force parameterization instructs SQL Server to attempt parameterization for all queries, even those

Read More »
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 mind to guarantee that their code remains efficient, maintainable, and secure.

Read More »
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 new query execution plan, and it can be necessary when the existing execution plan is no longer suitable.

Read More »