3 min read
0
Compatibility Level of the Master DB Remains Same After Upgrades
Scenario During an upgrade from SQL Server 2008 R2 to SQL Server 2016 SP2, we have noticed that all system…
Category: MSSQL
6 min read
0
Monitoring SQL Server Jobs & its Schedules
Introduction SQL Server jobs are essential for automating tasks and maintaining the stability and efficiency of a SQL Server system.…
2 min read
0
TSQL to find list of all index not used for last 30 days
This code is designed to provide information about the indexes in the database, including their creation dates, last usage dates,…
3 min read
1
Use ProcDump to capture sql server unexpected crash dump
To use ProcDump to capture a SQL Server unexpected crash dump, follow these steps: Download and extract ProcDump: Navigate to…
2 min read
0
SQL Server (MSSQLSERVER) service terminated unexpectedly
One day, we suddenly discovered that the SQL Server was not running and was in a stopped state. In a…
2 min read
1
TSQL to find index fragmentation in SQL Server
To determine index fragmentation in SQL Server, you can use the following steps: SELECT OBJECT_NAME(DMV.object_id) AS TABLE_NAME , SI.NAME AS…
3 min read
0
SQL Server DBA Daily Routine Tasks
As a SQL DBA, there are various essential tasks to perform every day to ensure the smooth operation and security…
13 min read
0
All About DBCC and DMV Interview Question
What is the use of DBCC commands? DBCC stands for Database Console Commands, a few of us also call it database consistency…
6 min read
0
List all Login, User & DB Role in SQL Server
Description This script generates a list of Logins, Users and the Database Roles that the user belongs to in all…
3 min read
0
How to check database encryption in sql server
Introduction Data security is a critical aspect of database management, and encrypting sensitive data is crucial to safeguarding it from…