1,827 reputation
1115
bio website
location Rochester, NY
age 52
visits member for 5 years, 2 months
seen Jul 4 at 1:47

Feb
24
comment SQL Server Offsite Backups
Or take a look at Quest LiteSpeed; it can easily cut backup size in half, but will run your CPU up a bit.
Feb
23
answered SQL 2008 and SQL 2008 R2 Server hangs on 'Welcome' screen while connecting using RDP
Feb
22
revised Diagnosing Microsoft SQL Server error 9001: The log for the database is not available
deleted 89 characters in body
Feb
22
comment Diagnosing Microsoft SQL Server error 9001: The log for the database is not available
I'll rephrase..maybe not corruption of the database, but certainly a cause for log files being unavailable as the op stated.
Feb
22
answered Diagnosing Microsoft SQL Server error 9001: The log for the database is not available
Feb
21
answered SQL Server 2005 question about procedure cache
Feb
18
answered SQL 2008. What permissions needed to see log file free space?
Feb
16
answered Database mirroring login failure attempts on mirror server
Feb
10
awarded  Citizen Patrol
Feb
6
comment Where to start fixing an IO Bottle neck in SQL Server?
+1 but would add: Zero-ith : add indexes as needed to support the existing queries; make sure index rebuilds jobs are in place, and that your statistics are up-to-date. Make sure log files are on different physical disks than data; make sure the RAID levels are capable of handling the workload, i.e. no RAID 5.
Jan
24
comment Could not connect with Instance of SQL SERVER from LIVE server to server in office
Are you specifying the instance name when you are connecting, i.e. 111.111.111.111\sql2005,1445?
Jan
21
comment Estimate daily network IO between 2 servers
Should be under Performance Object: Network Interface, then make sure you select the right instance, there will be one for each nic.
Jan
20
answered Estimate daily network IO between 2 servers
Jan
19
comment Nice tool that will backup databases & logs and truncate logs?
don't truncate your logs either; might as well go simple recovery mode if you're going to do that.
Jan
15
answered Can you upgrade SQL Server 2008 SP2 Standard Edition to 2008 R2 Developer Edition?
Jan
7
comment What should I do about someone trying to brute force attempt to login to our SQL Server 'sa' account?
1433; if it has to be open to the outside, change it to just about anything else; that will involve changing connection strings on clients however.
Jan
1
comment Does running the sql server profiler affect performance on the server?
i would add "as long as you know what you are doing" after the "..."; it's very easy to consume enough network bandwidth with profile data if you're sending it over the wire, or eat up RAM to hold the trace data if you're running profiler on the server...seen it..had to clean it up..
Jan
1
answered SQL Server 2008 Reporting Services on Windows 2003
Dec
24
comment Does resizing a column lock the table?
and which part of that section says that copying the table is how it is done?
Dec
23
revised SQL Server account per-table privileges
edited tags