Stevan Tosic

DotNetNuke® Claims Visual Studio Magazine Award

Wed, 15 Oct 2008 10:40:08 GMT

DotNetNuke® Corporation, producers of the highly acclaimed open source web application framework for the Microsoft platform, today announced that the product has been honored with the 2007 Editors Choice Award from Visual Studio Magazine as part of their annual Readers’ Choice Awards. The full list of winners, which appears in the June 2007 issue, is chosen by Visual Studio Magazine’s readers and honors excellent software in 22 development categories. The Editors Choice Award is a special designation given to products which show “special merit or innovation.”

proxy account information - xp_sqlagent_proxy_account

Wed, 15 Oct 2008 10:40:08 GMT

proxy account information - xp_sqlagent_proxy_account

check this

http://msdn2.microsoft.com/en-us/library/aa260700(SQL.80).aspx

to find out if any proxy account is used or not and how toset one.

and this one:

http://msdn2.microsoft.com/en-us/library/aa260289(SQL.80).aspx

to find out when and how to use a proxy account.

Permissions
Execute permissions default to the public role in the msdb database. A user who can execute this procedure and is a member of the sysadmin fixed role can start any job. A user who is not a member of the sysadmin role can use sp_start_job to start only the jobs he/she owns.

When sp_start_job is invoked by a user who is a member of the sysadmin fixed server role, sp_start_job will be executed under the security context in which the SQL Server service is running. When the user is not a member of the sysadmin fixed server role, sp_start_job will impersonate the SQL Server Agent proxy account, which is specified using xp_sqlagent_proxy_account. If the proxy account is not available, sp_start_job will fail. This is only true for Microsoft® Windows NT® 4.0 and Windows 2000. On Windows 9.x, there is no impersonation and sp_start_job is always executed under the security context of the Windows 9.x user who started SQL Server.

AND

Sets or retrieves the proxy account information used by SQL Server Agent and the xp_cmdshell extended stored procedure when executing jobs or commands for users who are not members of the sysadmin fixed server role. The proxy account is a Microsoft® Windows® account in whose security context the jobs or command prompt commands are run.

DB_CHAINING and TRUSTWORTHY

Wed, 15 Oct 2008 10:40:08 GMT

ALTER DATABASE MSDB
SET DB_CHAINING ON
GO

ALTER DATABASE MSDB
SET TRUSTWORTHY ON

Automatic Reindexing and Microsoft SQL Server 2000 Index Defragmentation Best Practices

Wed, 15 Oct 2008 10:40:08 GMT

Two great links for Microsoft SQL Server 2000 Index Defragmentation Best Practices and Automatic Reindexing.

These links provides information that you can use to determine whether you should defragment indexes to benefit the workload performance in your production environment. And how...

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

http://www.sqlmag.com/Articles/ArticleID/43783/pg/2/2.html

Find most frequently executed queries in SQL Server 2005 - sys.dm_exec_query_stats

Wed, 15 Oct 2008 10:40:08 GMT

Use dm_exec_query_stats to find data for all statements in the cache: number of times the query has been executed, the longest query to execute.

Use these tow objects:

sys.dm_exec_query_stats
sys.dm_exec_sql_text

Run this query to find most frequently executed queries in SQL Server 2005

select* from sys.dm_exec_query_stats as across apply sys.dm_exec_sql_text(a.sql_handle) as b order by execution_count desct

Run DBCC FREEPROCCACHE to to clear the procedure cache before start monitoring.

Monitor Microsoft SQL Server for higher performance and availability with WildMetrix

Wed, 15 Oct 2008 10:40:08 GMT

Great SQL Server Monitoring Tool.

WildMetrix says:

"Benefits of Monitoring Microsoft SQL Server with WildMetrix

Helps administrators detect problems in their SQL Server architecture
Quickly diagnose exactly where and what the problems are
Resolves the problems from a single easy-to-use interface
Gain understanding of entire SQL Server system inside and out"

Product

http://www.ascendview.com/wildmetrix/sol_mssqlserver.asp

Demo

http://www.ascendview.com/resources/request.asp?Activity=Eval