1. To get the location of SQLServer Agent log file, the log file is called SQLAGENT.out
DECLARE @AGENT_ERRORLOG NVARCHAR(255)
EXECUTE MASTER.DBO.XP_INSTANCE_REGREAD N’HKEY_LOCAL_MACHINE’,
N’SOFTWAREMICROSOFTMSSQLSERVERSQLSERVERAGENT’,
N’ERRORLOGFILE’,
@AGENT_ERRORLOG...
2013-01-31
7,761 reads
Welcome to day 24 of my 31 Days of Disaster Recovery series. Previously, I’ve talked about several different forms of...
2013-01-31
1,858 reads
I’m going to Nottingham, England, fabled home of Robin Hood, where I’m going to eat fish and chips and talk...
2013-01-30
1,538 reads
We got a call last week about an application that was running slowly. The server was showing about 80% CPU...
2013-01-30
1,264 reads
This weekend of SQL Saturday #183 in Albuquerque, NM. It’s the first SQL Saturday in that state, and it’s a...
2013-01-30
1,498 reads
Recently I was brought in to help troubleshoot performance issues on a database server. Going through my typical check list...
2013-01-30
1,966 reads
I’ve been exploring execution plans in Azure SQL Databases a lot lately. I’m getting a presentation together for some upcoming...
2013-01-30
1,904 reads
First of all I would like to thank Koen Verbeeck and Joost van Rossum for great suggestions that helped to...
2013-01-30
1,773 reads
Earlier on my blog I posted about how you can attach a database using T-SQL when no log file is...
2013-01-30
2,750 reads
by Steve Bolton
Anyone who has been following this series of self-tutorials has probably grown accustomed to me adding some...
2013-01-30
2,984 reads
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Comments posted to this topic are about the item Absolute and Relative References
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Comments posted to this topic are about the item Reserved Words I