Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
10
Impact
~4k people reached

  • 0 posts edited
  • 0 helpful flags
  • 12 votes cast
Apr
22
awarded  Popular Question
Mar
3
accepted SQL Server Replication :: Dedicated Distributor Hardware Requirements
Feb
23
comment What is Data Virtualisation?
The best resource I've found so far is: dantehranian.wordpress.com/2015/01/13/… - which sells it well, but again lacks the detail for me to think "ah, that would work for us!".
Feb
23
comment What is Data Virtualisation?
NB: This is not the same as server virtualisation (for that I can understand the benefit; particularly where servers peak use times complement one anothers). Rather this seems to be billed as automated data refresh (e.g. to data what puppet/chef are for platforms), but the word virtualisation seems inappropriate if it's more of an automation / workflow / script generator tool; and there's other parts which don't seem to fit with that concept making me assume I've missed something.
Feb
23
awarded  Commentator
Feb
23
comment What is Data Virtualisation?
At present we don't have a real problem; we have scripts to refresh data in our test environments which we're looking to improve, and we use replication (SQL Server with dedicated distributor) to feed BI with a copy of our production data for monitoring and reporting (via some ETL) which works but requires care when making schema-affecting changes, and can suffer poor performance at peak times. My manager had a sales call and asked if it could help with the above. My advice was to ignore this as we have bigger problems; but wanted to get a better understanding to confirm (or otherwise) this.
Feb
23
asked What is Data Virtualisation?
Nov
13
awarded  Curious
Nov
12
comment Correct way to stop SQL Server (through automation)
Thanks @firasathahmed. So if only stopping/starting services; not changing passwords; there's no issue to simply using standard windows service stop/start mechanisms.
Nov
12
accepted Correct way to stop SQL Server (through automation)
Nov
12
awarded  Custodian
Nov
12
reviewed Approve Correct way to stop SQL Server (through automation)
Nov
12
revised Correct way to stop SQL Server (through automation)
added 24 characters in body
Nov
12
asked Correct way to stop SQL Server (through automation)
Oct
10
accepted Performance of checking for data in related tables
Sep
22
asked Blocking SPID has Zero Disk IO and Zero CPU Time
Sep
11
comment Restore from SQL Server 2008 R2 to SQL Server 2014 fails
Only solution is to purchase SQL (developer edition's included with MSDN), or to decrease the size of the database you're recovering (i.e. by deleting stuff you don't care about and shrinking it before taking a backup; but deleting stuff may not be a viable option).
Sep
11
comment Restore from SQL Server 2008 R2 to SQL Server 2014 fails
Per the error message, SQL Express has a size limit of 10GB, so you can't put a 40GB database there. google.co.uk/webhp?q=sql%20express%20size%20limit%202014
Aug
4
awarded  Popular Question
Mar
3
awarded  Scholar