James

Age: 36

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

1d
comment Memory Issue - SQL Server 2008r2
Can you post what sp_whoisactive output looks like when you see this amount of memory usage from MEMORYCLERK_SQLOPTIMIZER?
Aug
27
comment Recovering MySQL root password (XAMPP)
Glad to hear it. I think you could document the steps that worked for you and then self-answer if you want.
Aug
26
comment Recovering MySQL root password (XAMPP)
Does this work? learntech.imsu.ox.ac.uk/blog/?p=151
Aug
25
comment Huge differences of performance of MySQL in two servers
Sounds like you should upgrade the OS on the test server and make it prod : )
Aug
23
awarded Supporter
Aug
23
comment Infinite loop in MySQL when connecting to database
Yes, the log entries you pasted just show MySQL starting successfully.
Aug
22
comment how to resolve mssqlsystemresource.mdf corruption?
What happened to R:\aSQL\? Is that a mount point? If so, does it still exist?
Aug
22
comment What makes yum difficult with RAID
yum is a software package manager. It isn't aware of what RAID level you're using. I'd suggest asking the person who told you this for clarification, as it seems to make no sense. This is like saying 'it's difficult to use RAID5 with Windows Update'.
Aug
1
awarded Notable Question
Jul
22
awarded Commentator
Jul
22
accepted How can I verify whether a Windows cluster has previously been successfully validated?
Jul
22
comment How can I verify whether a Windows cluster has previously been successfully validated?
OK, fair point that mentioning the directory where the reports exist could be useful information. That said, the question is clearly about programmatic checking and the content you pasted from Technet is obviously about clicking in the GUI. We'll probably end up parsing the report for keywords like 'failure', since there doesn't seem to be another option. When I looked into this several years ago, the SQL installer appeared to function the same way, checking the directory for the existence of a report and (apparently) failing if no such report existed.
Jul
22
comment How can I verify whether a Windows cluster has previously been successfully validated?
The question is about programmatically checking, although parsing the report is one option. Unfortunately this answer only provides information anyone who knew enough to ask the question would already know.
Jul
22
asked How can I verify whether a Windows cluster has previously been successfully validated?
Jul
17
revised Security implications of restoring a backup from an unknown source?
added 26 characters in body
Jul
17
answered Security implications of restoring a backup from an unknown source?
Jul
8
comment Is it possible to have the transaction log file write to a disk on a remote machine?
I don't think this addresses the actual question. The OP appears to be asking about hosting the transaction log on a remote server, over a CIFS share or some other means.
Jul
4
comment Not all members in a Windows group have permissions
Was DMN\Group a security group or a distribution group?
Jul
2
awarded Curious
Jun
23
comment ibdata1 corrupted, recover from ib_logfile?
Or hire Percona to do the work for you. (I'm assuming there's no backup to restore from.)
1 2 3 4 5