PowerShell Script to restart SQL Services
This article gives PowerShell script to restart the SQL Server service, SQL Server Agent, Reporting Service (SSRS), and SQL Server...
Author: Callum
Callum is a news writer at DBBlogger, delivering timely updates and concise analysis across a range of global and digital topics.
233 articles
T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)
As per best practice, you must set SQL Server min and max server memory(MB) as post-installation steps. SQL Server 2019...
Identifying SQL Agent Job from the format – SQLAgent – TSQL JobStep (Job 0xC4A075BBC7D7FB4993E60371
This article helps you get the SQL Server agent job name from the hexadecimal Job ID format. Let’s say you...
SQL Server Queries to troubleshoot Memory pressure on SQL instance
SQL Server memory pressure can cause a lot of problems. This is a list of queries you can run to...
Why my SQL Server tempdb database Is Growing Fast?
Have you ever wondered why your tempdb database is growing so fast? This article explores how to find the culprit...
How to Suspend and Resume an Availability Database in SQL Server Always On Availability Group
One of the fantastic features of Always On Availability Groups is that you can take one of the replicas for...
Identify When your SQL Database Was Last Used – SQL Server
Database servers are used for storing vast amounts of data. It is essential to know when any user last used...
Convert Unix Timestamp in SQL Server (T-SQL)
Want to know how to convert a Unix timestamp to a SQL Server timestamp or vice-a-versa? This article shows you...
SQL Server Error VIEW SERVER STATE permission was denied on object ‘server’,databasE’Master’
Did you face the error – VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’ while executing the...
T-SQL query to change the job owners for all jobs owned by a specific login
Many SQL Server DBAs manage jobs through the SSMS GUI and do not know about the underlying T-SQL scripts being...