1,717 reputation
76
bio website ashdar-partners.com
location Downingtown, PA
age 47
visits member for 5 years, 3 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.


May
30
answered SQL Server architecture - they want to move my database to new instance…Why?
May
26
answered Data transfer between servers extremely slow
May
25
comment Maintaining SQL Log Files
Maybe it's been that way for a while & was noticed lately? At this point, especially if the log file is larger than the data file(s),I'd leave the recovery set to FULL, monitor the used portion of the log file and use shrinkfile to lop off a couple of GB of log file at a time, over several days or a week or two. Also, it seems odd to backup the log once a week and do differentials several times a week. Normally, log backups are run very frequently, perhaps one an hour or once every few minutes. I don't know that this is necessarily a cause of your problem, but I wanted to mention it.
May
24
answered MS SQL server port questions
May
24
answered Possible to regularly export MS-SQL tables to another DB format on Linux without complete dumps?
May
24
comment Maintaining SQL Log Files
"You should also be aware that taking a log backup will truncate the log, but taking a FULL database backup will not truncate the log." sqlblog.com/blogs/kalen_delaney/archive/2008/11/30/…
May
24
answered Maintaining SQL Log Files
May
19
answered Generate sql script of a table schema in SQL 2000 through script
May
17
awarded  Organizer
May
17
revised Adding SQL Server 2008 R2 (sqlexpress) datasource in CF Administrator
edited tags
May
17
answered Adding SQL Server 2008 R2 (sqlexpress) datasource in CF Administrator
May
9
answered Can a Sql Server standard edition backup be restored to web edition
May
3
answered AlwaysOn SQL Server 2012 - any option for true active/active?
May
2
comment Is SQL Server 2012 Express Edition a Production Release? The download still has RC on the end
I believe that Tony meant RTM, not RTW.
May
2
answered Is SQL Server 2012 Express Edition a Production Release? The download still has RC on the end
Apr
30
answered unresponsivene sql server
Apr
25
comment C#/SQL Server: Login failed when connecting from remote machine
The default roles should work. Note that these roles exist in each database and you need to add the user to those roles in each database. Just doing it in the master database won't get the desired result. You want to avoid granting permissions to each user because it's easy for them to get out of sync with each other and it's time consuming to do that for everyone. If you need to, create role, make the users a member of the role and then assign rights to that role.
Apr
24
comment C#/SQL Server: Login failed when connecting from remote machine
Nothing jumps to mind; I'd have to google something up. If you don't have a complicated security situation (some users need read and write on some tables but not others, and other users need read access on different tables, etc. etc.) (and since most web apps connect with just one user, you probably don't have a complicated situation), you can just add your user to the pre-existing db_datareader and db_datawriter roles. This will allow the user to read & write any table in the database. This can be done with SSMS or by using the sp_addrolemember system stored procedure.
Apr
23
comment C#/SQL Server: Login failed when connecting from remote machine
When troubleshooting this sort of thing, the first command I try is 'SELECT @@SERVERNAME'. There are two sorts of roles, server and database. The server roles are aimed more at admin functions, the database roles are aimed more at restricting read/write of data for 'regular' users. You can create your own db roles and grant whatever security you like to them, then add users. Or you can just add users to the predefined roles.
Apr
21
answered C#/SQL Server: Login failed when connecting from remote machine