793 reputation
1719
bio website
location London, United Kingdom
age 36
visits member for 2 years, 5 months
seen 6 hours ago

SQL Server DBA/developer


9h
comment how to resolve mssqlsystemresource.mdf corruption?
What happened to R:\aSQL\? Is that a mount point? If so, does it still exist?
9h
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
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.)
Jun
3
revised How to troubleshoot “client driver has sent multiple requests while the session is in single-user mode”
deleted 25 characters in body
Jun
3
comment How to troubleshoot “client driver has sent multiple requests while the session is in single-user mode”
@stacylaray Thanks. Any insight into why the problem would keep occurring with async=true enabled?
May
29
revised How to troubleshoot “client driver has sent multiple requests while the session is in single-user mode”
added 3 characters in body
May
29
comment How to troubleshoot “client driver has sent multiple requests while the session is in single-user mode”
Yes, I think Ladislav's answer to that question highlights why the dev probably can't disable MARS easily. The app is probably coded to execute multiple queries on the same connection in parallel, and disabling MARS in the connection string may just make the error happen more often unless the dev rewrites the app. The only answer may be 'debug your app, or rewrite it and turn MARS off.'
May
29
comment How to troubleshoot “client driver has sent multiple requests while the session is in single-user mode”
Yes, I may just suggest they test turning off MARS. I don't know why they are using it and doubt the developer does either as this is a spaghetti code legacy app handed down through many generations of developers. That said, I'm not sure if that will stop this error or make it occur incessantly.
May
29
asked How to troubleshoot “client driver has sent multiple requests while the session is in single-user mode”
May
19
comment SQL Server 2012 Page Life Expectancy resets to 0 after about 50 days
@CRCerr0r You could configure a SQL Server Agent job to run something like this at startup: littlekendra.com/2011/02/01/whoisactive Then maybe run another job to clean data from the table older than a certain number of days. This has worked well for me in the past, but there are probably lots of ways to collect activity data, and AWS might already have something you could use for that as far as I know.
May
19
comment SQL Server 2012 Page Life Expectancy resets to 0 after about 50 days
@CRCerr0r Ah, OK, that rules that out then. Do you have any information about activity in SQL Server when this problem happens? In the past when I haven't had something like SQL Sentry available, I've had good luck doing something like dumping the output of sp_whoisactive to a table every n seconds.
May
17
comment SQL Server 2012 Page Life Expectancy resets to 0 after about 50 days
Is it possible that an int in the tool that's reporting this data (as opposed to the actual value of the counter in Windows and SQL Server) is reaching its maximum value and rolling over?
May
11
awarded  Nice Question
May
10
accepted How deterministic is execution plan creation in SQL Server?