Reputation
2,172
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
1 9 21
Newest
 Nice Answer
Impact
~304k people reached

  • 0 posts edited
  • 0 helpful flags
  • 256 votes cast
Oct
2
answered Why does SQLServer 2008 R2 take hours and hours to uninstall?
Sep
27
accepted How can I find out how many updates are waiting to be installed on a remote server
Sep
23
answered How can I find out how many updates are waiting to be installed on a remote server
Sep
23
comment How can I find out how many updates are waiting to be installed on a remote server
Thanks - I looked at UpdateHf.vbs and worked out how to use CreateObject("Microsoft.Update.Session", strServer) in VBScript to create a small script to check a servers "not installed" status.
Sep
22
asked How can I find out how many updates are waiting to be installed on a remote server
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