1,768 reputation
313
bio website stuart-moore.com
location Nottingham
age
visits member for 1 year, 7 months
seen Apr 2 at 8:21

Nottingham based DBA, mainly SQL Server but turns hand to anything else. Currently getting excited about cloudy stuff.


Nov
8
comment SQL Server Mirror failover on failing storage
Is this the blog you're following? - sqlserverperformance.wordpress.com/2012/03/27/… - I'm wondering if it's because all the DBs are on the same 'failed' drive so the ALTER DATABASE in the sp is failing?
Nov
8
comment SQL Server Mirror failover on failing storage
Can you failover manually? When you disable the storage of sql-01 are the databases 'failing' and are you seeing anything in the SQL logs?
Nov
8
comment SQL Server Mirror failover on failing storage
Do you have a witness server? And are you running in High-Safety mode? Both are required for automatic failover ( msdn.microsoft.com/en-us/library/ms189590(v=sql.105).aspx )
Nov
8
answered Finding delete or update records
Nov
5
revised Database Indexing - Maintenance Jobs
edited tags
Nov
2
revised “Zero” downtime and minimal space requirements for upgrade to PostgreSQL 9.2
Clarified which RDBMS the question is about
Nov
2
suggested suggested edit on “Zero” downtime and minimal space requirements for upgrade to PostgreSQL 9.2
Nov
1
comment Powershell script executing within SQL Server Agent
Unfortunately that won't work unless you've already accepted the host key, as acknowledging the host key is seen as part of the secure connection method, as you're confirming that the host you've connected to is the one you expected (prevents man in the middle style exploits).
Nov
1
answered Powershell script executing within SQL Server Agent
Nov
1
answered How do I enable READ-only (passive) mode in a particular RDBMS?
Oct
31
answered Mysql database connector table or keys
Oct
30
comment How can I change the timezone in MySQL?
What format are the current date strings in? dd/mm/YY/, mm/dd/YYYY, dd-mm-YYYY or something else?
Oct
30
answered sp_dboption is not available in SQL Server 2012
Oct
29
comment Same query taking 0.2 sec in Oracle database but 4 mins in SQL Server
Are both databases running on comparable hardware and disk systems? Is the data identical in each db?
Oct
29
answered How to summarize Bridge results?
Oct
29
comment Getting max values from MySQL tables
Do you want just the ranking points awarded to an athlete in the latest competition, or a total of all an athlete's ranking points up to the competition date? Could you provide some example data, and examples of the output you'd like?
Oct
28
comment Finding violations of the symmetry constraint
All good points. Thank you.
Oct
28
awarded  Commentator
Oct
28
comment Finding violations of the symmetry constraint
That makes 2 of us. I'm fine with being told I'm wrong, but it would be nice to know what I was wrong about so I can learn from it.
Oct
28
answered Finding violations of the symmetry constraint