Viewing 14 posts - 256 through 269 (of 269 total)
We don't allow access to SQL Server by specific user id's, only thorugh group membership. We also do not use SQL logins unless required by an application. If you use...
May 11, 2007 at 11:48 am
Save the trace as a SQL script and look for the INSERT statements in the resuling .sql file.
April 26, 2007 at 9:19 am
Here's some of the things we do to ensure SOX compliance:
Have an owner for each application who is responsible for approving any changes to the application.
Each database should have an...
April 18, 2007 at 1:37 pm
We had this problem when there was a SET IDENTITY INSERT ON statement inside the cursor. Apparently, there are some non-obvious actions that are considered schema changes.
April 4, 2007 at 7:43 am
If you have several large indexes on a table it is entirely possible the index file will grow faster than the data files. Take a look at the structure of...
March 20, 2007 at 2:15 am
This is why all changes to production servers should be tested in a non-production environment first. I don't think that putting email processes on a SQL Server is good practice. Our...
March 15, 2007 at 1:58 am
My company has formal documentation requirements for new databses, users, logins, etc. on production servers. Per the policy, all objects must have an owner, so a request for a new...
March 7, 2007 at 3:36 am
I'm on a two month trip overseas, so I had to make a similar, though not so limited, choice (I have a 1GB and a 2GB card for my mp3...
February 11, 2007 at 12:28 am
I don't think we will see tape go away any time soon. How do you take data offsite if you don't have tape? I do think disk can help improve...
November 29, 2006 at 7:54 am
ISNULL frequently causes this sort of problem. We've had to rewrite a number of queries to change ISNULL to an or statement to improve performance.
November 3, 2006 at 9:01 am
US Customs has had the ability forever to prevent just about anything from entering the country until they are convinced it is legal and not a danger. The Fourth Amendment...
November 1, 2006 at 9:14 am
Use Right Click->Open in New window to view the next page. This eliminates the need to use the Back arrow to return to the base page.
October 5, 2006 at 11:21 am
You might be able to get some info from the links at the wikipedia entry at http://en.wikipedia.org/wiki/Imdb. There's a link to IMDB interfaces in the article.
September 20, 2006 at 9:57 am
We can't use groups as the ID's are sa equivalents and we don't want users to have that kind of access. The app reads the encrypted SQL ID and password...
September 5, 2006 at 12:36 am
Viewing 14 posts - 256 through 269 (of 269 total)