1,717 reputation
76
bio website ashdar-partners.com
location Downingtown, PA
age 47
visits member for 5 years, 2 months
seen 16 hours ago

I have been a principal at Ashdar Partners since 2003, a SQL Server DBA since 1998, a developer since the 1980s and a nerdy computer enthusiast since the 1970s. I've probably used more obsolete computer systems than you have.


Sep
9
comment In place upgrade from SQL Server 2005 to 2008
Can he upgrade from 32 bit to 64 bit or does that absolutely require a re-install? I don't think that I've seen a Windows sysadmin do an 'in place' upgrade of a server OS for at least ten years.
Sep
7
answered In place upgrade from SQL Server 2005 to 2008
Aug
30
answered User mapping lost after manual failover
Aug
30
answered Simplest way to shrink transaction log files on a mirrored production database
Jul
5
comment Cannot login by using Server Name but together with instance
Server roles have nothing to do with connection information and requiring an admin-level login is a red flag for bad software. There is an old Dilbert cartoon with the punchline "Our target market is people who are too embarrassed to return the software." If you don't complain nothing ever gets fixed, no one (but you) realizes that there is a problem and the DBA always seems to shoulder the blame for other people's mistakes. Just a friendly warning to the new ("accidental" or not) DBAs out there.
Jul
4
answered SQL Express 2008 R2 on Amazon EC2 instance: tons of free memory, poor performance
Jul
3
answered Cannot login by using Server Name but together with instance
Jun
19
comment SQL Server OPENROWSET/OPENQUERY Issue with Access DB
I don't think I've ever had success using NTLM when trying to connect from a SQL Server to another SQL Server or a legacy file format like Access or Excel. The workaround would be to use a SQL account, but I would recommend configuring an SPN if you have the time. I think that the simplest thing is to get your AD admin to allow the SQL Server's domain account to create an SPN when SQL Starts up. There are guides on the internet for that and for setting one up manually. I don't want to provide too much detail on this here becuase I think that it would be outside the scope of this question.
Jun
19
awarded  Enthusiast
Jun
17
comment SQL Server OPENROWSET/OPENQUERY Issue with Access DB
Is there an SPN set up for SQL running on this server? Are you connecting via kerberos or ntlm?
Jun
14
comment SQL Server OPENROWSET/OPENQUERY Issue with Access DB
Are you connecting to the SQL Server with an AD login or a SQL login? If you are using AD, are you using kerberos?
Jun
12
answered Moving MS SQL Server installation files
Jun
11
answered Very slow SQL Server Agent history
Jun
6
answered Compressing and copying large files on Windows Server?
Jun
1
comment Can not create a linked server between SQL Server 2008 on a desktop and my laptop
Can you post the value for "state" that should be part of the 18456 error message? The state value can provide more detail about the exact cause of the problem.
May
31
comment Can not create a linked server between SQL Server 2008 on a desktop and my laptop
Are you using a Windows account or a SQL Server account?
May
31
comment Maintaining SQL Log Files
At this point, if the log hasn't grown and DBCC OPENTRAN() doesn't say that a transaction has been in-flight for days/weeks/months, I'd say that you are left with slowly shrinking the log down to something sane, watching for growth & thinking about backup/restore strategy.
May
31
comment Maintaining SQL Log Files
Isn't much point to running 1 tlog backup between full backups, ++ with those diffs. I'd switch to SIMPLE recovery, stop tlog backup and run a diff in it's place (1 full + 6 diffs a week) or leave db in FULL recovery mode, stop all the diffs and run tlog backups more often, anywhere from 1/day to 12/hour, depending on rate of data change & SLA.
May
31
awarded  Yearling
May
30
answered Moving database to new server