1,739 reputation
29
bio website ashdar-partners.com
location Downingtown, PA
age 48
visits member for 2 years, 8 months
seen yesterday

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
5
comment How do you create a job in SQL server 2008 R2 that will clear transaction logs?
If all that you want to do is delete some old files, you could probably code up a job step in Powershell to do that in a couple of minutes.
Sep
3
answered How do you create a job in SQL server 2008 R2 that will clear transaction logs?
Jun
25
answered Using existing SQL Server credentials for log shipping reporting purposes
Feb
20
awarded  Yearling
Jun
10
answered Change server name for SQLLocalDB instance
Jun
7
answered Running a DELETE stored procedure but finding degradation in performance in WHILE loop as iterations increase
Jun
6
comment Query should yield result but doesn't
Try specifying a table schema. "SELECT * FROM dbo.Item", not "SELECT * FROM Item". Many devs get into trouble when they accidentally create, then query, tables in different schema without realizing that they actually have two copies of the table: one empty and one with data.
May
2
answered SSRS Deployment
May
2
answered DB comparer field by field for all tables
Apr
25
comment Running a Job from a Stored Procedure in another server?
Certainly does seem like a duplicate. to me, Rad's answer seems superior to Timbo's. Using osql and xp_cmdshell seems brittle and may lead to security problems (hardcoded, cleartext passwords).
Apr
17
comment How to take SQL Server database under this scenario?
How would the OP create those drive mappings? Mapping drive letters is a frequent source of confusion for people don't realize SQL is running as another user and drive mappings are not shared between users.
Apr
17
answered How to take SQL Server database under this scenario?
Apr
15
answered SQL Server stored procedure working when run manually, not running from SQL Server Agent
Mar
2
comment Can I run a Report Server and a Mirror server from a working Log Shipping secondary instance?
If you are going to go to the trouble of setting up mirroring between City A and City B (which is what I'm guessing that the OP means), what does the log shipping get you?
Feb
20
awarded  Yearling
Feb
14
answered SQL Server replication for off site copy
Feb
14
comment SQL Server 2012 SSIS\SharePoint Kerberos auth
It sounds dumb, but make sure that the clocks on the servers, workstations & domain are synchronized. kerberos becomes unhappy if the clocks are too far apart and connections will fall back to NTLM. +1 for self-registering SPNs. I had various problems, plus bugging domain admins to run setspn commands for me. We gave in, started granting the right to create SPNs to the service accounts (we did NOT make those accounts domain admins). Problems went away and our workload dropped. Also, +1 for getting SQL & SSMS working first. Good chance that if SSMS works, the other stuff will follow.
Feb
14
comment SQL Server connection failed for domain user from Mac OS machine
Are you passing the domain name as well? Is kerberos running in your environment? Can you use the tsql command to run queries, as discussed here->freetds.schemamania.org/userguide/domains.htm
Feb
12
answered Identify NON-ANSI joins in SQL Server 2008 R2 on a Database that's in 2000 (80) compatibility mode
Feb
11
comment 32-bit ODBC driver on 64-bit SQL Server
Yes, but I figured that simplification was easier than trying to describe how 32 bit drivers can't be loaded into 64 bit address spaces, or how SSMS is just calling procedures on the server to do stuff like list out available drivers (so it doesn't even matter what drivers are on your workstation) or even to bring SSIS packages (which I have personally seen a lot of developer confusion on) into the 32/64 bit driver discussion. I am a naturally wordy person but, from what I see on SE, it is the short and speedy answers that get rewarded.