Viewing 15 posts - 751 through 765 (of 822 total)
Thanks for the info, Cindy. I'm forced to use GRID to monitor my SQL Server instances and this type of information is useful, as I've never tested that metric.
Side...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 12, 2010 at 9:26 am
Just giving this a bump, hard to believe that the community is not using this type of software. Would love to hear from y'all.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 12, 2010 at 8:23 am
Wish it meant something more, I'd love to see more intensity than just whatever pride generates. To see the best of the best go at it like it was...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 12, 2010 at 8:21 am
One reason I've set our named instances to specific ports is our firewall rules. We want control over over which machines connect to our databases, even if it means...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 9, 2010 at 3:12 pm
Just found this thread, fun stuff. Giants fan here, NL West is crazy insane. I'm not holding my breath, though.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 9, 2010 at 11:45 am
Can you use the NOCHECK option on the constraint?
I. Disabling and re-enabling a constraint
The following example disables a constraint that limits the salaries accepted in the data. NOCHECK CONSTRAINT is...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
July 1, 2010 at 5:15 pm
http://msdn.microsoft.com/en-us/library/ms143504.aspx
BoL has great info...on that page check out 'Viewing Windows permissions for SQL Server Services'.
There's a MS white paper also, google 'microsoft best practices sql server', you'll find a link...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
June 30, 2010 at 11:38 am
Google is an awesome tool:
http://msdn.microsoft.com/en-us/library/ms143269(SQL.90).aspx
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
June 8, 2010 at 7:30 am
Thanks again. I had done the same Googling considering the ramifications of the TRUSTWORTHY setting and saw similar results.
Interesting idea with a monitoring job. I'll look at my...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
May 27, 2010 at 12:16 pm
I've finally finished my version of the stored procedure, and indeed, as you stated, Lowell, I need to change the TRUSTWORTHY property of the 'master' database to ON for this...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
May 27, 2010 at 11:13 am
Try single user mode then:
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
May 4, 2010 at 3:27 pm
Do have the administrator password to the Windows server administrator account that the database instance resides on? If so, and if the former admin did not remove the BUILTIN/administrators...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
May 4, 2010 at 3:16 pm
I've just recently set up Oracle Enterprise Manager 10.2.0.5 GRID control and the SQL Server plugin needed to monitor the SQL Server instance, here's some of my experience:
If you're using...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
April 29, 2010 at 10:59 am
"This is not 'Nam, this is bowling....there are rules." - Walter Sobchak
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
April 26, 2010 at 2:36 pm
Sacramento, California. Yes, it's sunny here and we all like to surf. Oh yeah, and everyone smokes pot.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
April 26, 2010 at 2:20 pm
Viewing 15 posts - 751 through 765 (of 822 total)