removing public permission from master and msdb databases in sql server 2000

Today I was runing a Squirral scan on a sql server 2000 instance found many security isssues so I bolg out the fixes done to that setting..

EXEC sp_MSforeachdb 'USE [?];
SELECT * FROM sysusers;'
GO

USE <Database Name>
GO
EXEC sp_revokedbaccess 'guest'
GO



use master revoke execute on xp_regread to public
use master revoke execute on xp_instance_regread to public

use msdb; revoke execute on sp_add_job to public; use master

use msdb; revoke execute on sp_add_jobserver to public; use master

use msdb; revoke execute on sp_add_jobstep to public; use master

use msdb; revoke execute on sp_start_job to public; use master

use msdb
revoke execute on sp_purge_jobhistory to public
revoke execute on sp_help_jobhistory to public
revoke execute on sp_delete_jobserver to public
revoke execute on sp_help_jobserver to public
revoke execute on sp_get_jobstep_db_username to public
revoke execute on sp_update_jobstep to public
revoke execute on sp_delete_jobstep to public
revoke execute on sp_help_jobstep to public
revoke execute on sp_add_jobschedule to public
revoke execute on sp_update_jobschedule to public
revoke execute on sp_delete_jobschedule to public
revoke execute on sp_help_jobschedule to public
revoke execute on sp_add_job to public
revoke execute on sp_update_job to public
revoke execute on sp_delete_job to public
revoke execute on sp_help_job to public
revoke execute on sp_get_job_alerts to public
revoke execute on sp_stop_job to public
revoke execute on sp_check_for_owned_jobs to public
revoke execute on sp_check_for_owned_jobsteps to public
use master
use master revoke execute on sp_readwebtask to public

use master revoke execute on sp_runwebtask to public
 use master
 exec sp_dropextendedproc 'sp_OACreate'
 exec sp_dropextendedproc 'sp_OADestroy'
 exec sp_dropextendedproc 'sp_OAGetErrorInfo'
 exec sp_dropextendedproc 'sp_OAGetProperty'
 exec sp_dropextendedproc 'sp_OAMethod'
 exec sp_dropextendedproc 'sp_OASetProperty'
 exec sp_dropextendedproc 'sp_OAStop'

SQL Mail Configuration

I plan to post the thing where I faced some kind of problem.. As I am working as a DBA and trying to learn new things everyday and like to share the same with you and hoping this might help someone some way.
I am configuring a SQL Mail on SQL Server 2008 R2 .
Steps to be followed.
1.SSMS-->Management-->Database Mail
2. Right Click configure Database Mail-->

Database Core Concept

Three-Schema Architecture

Internal Schema

·         Description of Physical Storage structure of the database.

·         It has an internal Schema

·         It descried the details of the store records and access method used to achieve efficiency to data.

Conceptual level                                        

·         This hides the details of physical storage structure

·         This level is both independent of software and hardware

External Level or  view level

·         This the outer most layer

·         This layer is closet to the users

·         Data can be view by individual users

Dbms must have a programming language

Dbms Language
DDL---Data Defination Language
DML—Data Manupulation language

Data Manupulation Language:

Basic SQL Querry

           Microsoft SQL Server is a RDMS software ppackage developed by Microsoft. Its a database, so its primary function is to store and retrieve data as requested by other applications.

           A DBMS package is a complex set of Software Programs that Controls the organization, storage and modifying and retrieval of data in a database:

·         It contains collection of data.

·         Set of programs to access those data.

·         A complete definition of the database structure and constrain.

Overview of Microsoft SQL Server and Version Details.

9.0	2005	SQL Server 2005	Yukon
10.0	2008	SQL Server 2008	Katmai
10.25	2010	SQL Azure DB	CloudDB
10.5	2010	SQL Server 2008 R2	Kilimanjaro (aka KJ)
11.0	2012	SQL Server 2012	Denali

Database users:

1.Database Administrator:

·         Database is one of the many primary resources that are used by many people in an organization.

·         DBMS and related software are the secondary resources. Administrating this secondary resources is the primary responsibility of a Database administrator.

·         He has the complete authority to access and monitoring a database .

·         He is responsible for for creating modifying and maintain the database

·         He grant permission to the users of the database .

·         He defines procedure to recover database

Other users

2.Database designer

3.End Users

Ok Now Lets work on everyday work of a DBA.  As in current world role of DBA is evolving very fast. 
you can be taking care of Application and then will be called as application DBA. Your databases can be hosted in cloud in various cloud technologies for microsoft its Azure . Then you will be called as Cloud DBA  and many more but if I drill down we all DB administrator gets few common issues which i will discuss as those comes under everyday tasks for most dba's.

Please let us know did it help....

To have more understanding of SQL server below links can help:

<a href="http://www.quackit.com/sql_server/tutorial/%22%3ESQL Server Tutorial</a> from Quackit.com