Viewing 12 posts - 1 through 12 (of 12 total)
Great article and discussion!
We've converted most of our SQL servers to VMware (NetApp back-end) for many reasons... Data center space, energy consumption, replace aging hardware, etc. I'm a...
June 17, 2011 at 9:59 am
Anyone figured out how to move systems dbs in SQL 2005 RTM? I just tried with the -T3608 startup parameter, and it bombed. Used to work like a...
November 30, 2005 at 2:04 pm
Not clear if you've checked this already... Make sure dbo maps to the same login (ideally, sa) in all databases. (All objects are owned by dbo, right?)
April 14, 2005 at 3:08 pm
Hmmm... I thought pooling was by default true. That's what my book says. But it's something to try. Thanks.
October 27, 2003 at 6:47 am
I agree--the question was misleading. I thought it meant a non-Server edition of Win2K. By the looks of the response chart, so did a lot of other people.
...
July 30, 2003 at 7:21 am
That looks about right for a package that's local to the SQL Server (if in the repository, add /R). Not sure what the .LOCAL is but I assume it...
June 17, 2003 at 6:09 am
Stored procedures, stored procedures, stored procedures. Simply don't let the apps access the server in any other way.
Use roles with execute permissions on the stored procs.
Always make dbo the...
June 16, 2003 at 11:42 am
It sounds like you should delete your old job and recreate it. Find the package under the DTS menu, then right-click on it and select Schedule Package...
You can also...
June 16, 2003 at 11:33 am
I'm also a DBA who comes from a development background. At my company, we've been using Visual Studio .NET database projects for our new systems. There are some...
April 25, 2003 at 8:27 am
Steve,that's my point--NT Authentication would be preferable for DBAs. (Sorry that was not clear.)
June 24, 2002 at 2:02 pm
Andy's arguments for using SQL accounts applies to *applications*... but what about controlling administrator access? In my organization, we have different levels of people who are in different...
June 24, 2002 at 12:23 pm
"Count the pennies and the dollars count themselves." A little bit of I/O, network traffic, memory, etc. saved whenever possible will make a difference in the long run.
April 18, 2002 at 6:46 am
Viewing 12 posts - 1 through 12 (of 12 total)