Roles (L1,L2,L3) in SQL Server DBA

Dear Readers, In this article, we will discuss Roles (L1,L2,L3) in SQL Server DBA. Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a SQL Server Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/roles L1 Roles: ➼Check to… Read More

Tools for Administering the SQL Server

Dear Readers, In this article, we will discuss Tools for Administering the SQL Server. Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a SQL Server Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/sqlserver SQL Server Supported Platforms… Read More

SQL SERVER Articles

SQL SERVER Articles Dear Readers, Please check below articles to get good knowledge on SQL SERVER. SNO DESCRIPTION ARTICLE LINK 1 SQL Server – Issue to view Alwayson Health Events https://www.ktexperts.com/sql-server-issue-to-view-alwayson-health-events/ 2 Script to copy one particular database role from one SQL server to another… Read More

SQL Auto-Caching with No Code Changes

Heimdall Data auto-caches and auto-invalidates, removing complex configuration. It requires zero changes to your application and database. Try it out.   There are only two hard things in Computer Science: cache invalidation and naming things.” -Phil Karlton     Caching is complex and engineering intensive.… Read More

To check the fragmentation of all indexes on the Database

SELECT OBJECT_NAME(ind.OBJECT_ID) AS TableName, ind.name AS IndexName, indexstats.index_type_desc AS IndexType, indexstats.avg_fragmentation_in_percent FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) indexstats INNER JOIN sys.indexes ind ON ind.object_id = indexstats.object_id AND ind.index_id = indexstats.index_id WHERE indexstats.avg_fragmentation_in_percent > 30 ORDER BY indexstats.avg_fragmentation_in_percent DESC