Reputation
1,007
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
7 17
Newest
 Yearling
Impact
~77k people reached

Feb
24
comment IIS Manager - Connect to Another Server (Win7 to Win2008 server)
Check this link out - it'll help you enable your tools for remote admin via IIS Manager. learn.iis.net/page.aspx/159/…
Feb
24
comment MS Access gets Disconnected
This would be set on the server.
Feb
24
comment How do I shrink the size of a SQL Server log file
I agree that its the absolute last thing to do, shrink the file. Correct maintenance obviates the need for this. But once its big and you want it smaller, you have to shrink it. However, when shrinking, it's better to shrink the file as small as possible, then grow the file to the correct size in 8GB increments. This will optimize the number of VLFs in the file. See - sqlskills.com/BLOGS/KIMBERLY/post/….
Feb
22
comment SQL Default Instance Name
Spot on Ed - you are entirely correct! :)
Feb
22
comment Replication sync failing; Publisher out of Identity ranges
I've not seen any. I've upgraded systems using all three types of replication from SP2 to SP3 and have had no issues at all. Of course, I always recommend testing in a QA environment first ;). Here's the link to the KB article for that fix: support.microsoft.com/default.aspx/kb/941989
Feb
18
comment SQL Server Database Backups using VSS versus native SQL Server
Thanks for your answer. I think your approach sounds like a good one.
Feb
18
comment SQL Server Database Backups using VSS versus native SQL Server
Thank you! That is an excellent document and helped clear up a lot for me.