James

Age: 36

Sysadmin (Windows, Linux) and DBA (SQL Server, MySQL).

Dec
6
awarded Curious
Dec
5
awarded Nice Question
Dec
5
accepted Avoid truncating error message in Powershell error
Dec
5
asked Avoid truncating error message in Powershell error
Dec
4
awarded Popular Question
Nov
24
awarded Caucus
Oct
30
awarded Autobiographer
Oct
27
awarded Supporter
Oct
27
awarded Autobiographer
Oct
25
comment What are the dangers of non-IT managers using improper database terminology
It's a good question, just not a good question for this site.
Oct
12
comment How do I kill a rollback process when I want to drop the database?
I did something like that once and it turned out to be a Really Bad Idea. I'd rather just restart the instance than stomp on file handles and get potentially undefined behavior.
Oct
9
awarded Autobiographer
Oct
4
comment MySQL uses more than 500% of the CPU
The error message is about corrupt temporary tables due to filling up the MySQL tmpdir. I can't see any point in running a repair here.
Oct
1
awarded Civic Duty
Sep
30
comment Will increased network latency cause table locks in MS SQL Server?
Interesting results. What client program/library is this with?
Sep
30
awarded Supporter
Sep
30
awarded Explainer
Sep
29
comment why I can't delete old transaction log backup files with an existing scheduled job?
I'm not sure if I understand, but I think you need two maintenance plan cleanup tasks, 1 to delete transaction log backups (trn) and one to delete database backups (bak).
Sep
29
comment why I can't delete old transaction log backup files with an existing scheduled job?
In the maintenance plan, do you by any chance have the file extension to delete set to ".trn" instead of "trn"? If you include the period, it won't find any files to delete. This was a common annoyance with maintenance plans. Ola Hallengren's maintenance scripts are much easier to work with and generally more reliable.
Sep
28
revised Create failed for Availability Group 'AGN'
added 140 characters in body
1 2 3 4 5