2,032 reputation
719
bio website
location Wetherby, United Kingdom
age 44
visits member for 5 years, 2 months
seen Jun 4 at 12:23
Database manager and DBA for SQL Server and Oracle. IT Operational Support manager (a technincal boss). Occasional classic ASP and C# web programmer.

Sep
19
answered Certain SQL queries performing very poorly in ESXI hosted environment
Sep
17
comment How much RAM for a web server?
512GB for a webserver is fine. If there are no users! Please provide us with more details: How many concurrenty users do you want to support? How does the server perform in your dev and test environments?
Sep
15
answered Enabling xp_cmdshell in a production environment
Aug
11
comment Robocopy: How to move the content of a directory but KEEP the directory
That would be a.... copy? Sorry - don't get what you're trying to do. *If it is just a copy, then use /S
Aug
6
answered Robocopy: How to move the content of a directory but KEEP the directory
Jul
9
answered How to make SSRS 2005 run fast in general?
Jun
11
answered Concurrent backups in SQL Server?
Jun
7
comment SQL Clustering on Hyper V - is a cluster within a cluster a benefit
You do need to ensure that your storage infrastructure can cope with 20 or 30 SQL servers running at the same time. It's easy for a storage expert to say "yeah, it's fine" but you have to multiply everything by the PEAK of ALL the servers (How long is your backup window?) and still have enough left for growth. My storage and back-end requirements have 10x in the last 3 years!
Jun
7
comment SQL Clustering on Hyper V - is a cluster within a cluster a benefit
If you read my other posts, I'm a HUGE fan of virtualisation. I prefer vmware ESX (I still feel Hyper-V is playing catch up). Big wins for availability (HA, DRS), maintenance and flexiblity. But - you still need maintenance windows! Given MS publishes updates on "patch Tuesday", we have a "patch Sunday" each month that gives us enough time to test the patches on test servers, and than schedule reboots (if required) with the business.
Jun
7
answered SQL Clustering on Hyper V - is a cluster within a cluster a benefit
May
24
answered Windows Disk I/O Analysis
May
3
answered SQL Server instance shuts down
May
3
answered Backing Up Transaction Logs to Tape?
May
3
answered Run FTP session from bash script
May
1
awarded  Yearling
Apr
30
answered A different interface for the Sql Server Reporting Service?
Apr
30
answered The difference between desktop-series HDD drives and server-series
Apr
25
answered perf tuning for ESX vmfs3 on RAID
Apr
15
answered Oracle: how to find out storage space used by a table?
Mar
30
answered Can a SQL Server have a CPU bottleneck when Processor Time is under 30%