List of services started automatically by Windows that you could consider stopping

# DHCP Client: On most servers, IP addresses are fixed and DHCP is not needed.

#DNS Client: This caches DNS names locally.

#Network Location Awareness: This collects and stores the configuration information

for the network and notifies the programs when this information is modified. You can't

disable it unless you use the Windows 2008 Advanced Firewall.

#Print Spooler: This loads the files to the memory for printing later. It can be disabled

if you don't print from the server.

#Windows Error Reporting Service: This allows errors to be reported when programs

stop working or responding, and allows existing solutions to be delivered. It can safely

be disabled.

#Windows Firewall: You can disable this service, if you are using a network firewall.

#Shell Hardware Detection: This activates AutoPlay for removable devices.

On Windows Server 2008 R2, this service stops when nobody is logged in,

to minimize risks. You can disable it.

Reference: Microsoft SQL Server 2012 Security

Cookbook

Script to automatically create insert statements for table data in SQL Server

CREATE procedure  [dbo].[INS]                             

(                                                         

   @Query  Varchar(MAX)                                                         

)                             

AS                            

   Set nocount ON                 

DEclare @WithStrINdex as INT                           

DEclare @WhereStrINdex as INT                           

DEclare @INDExtouse as INT                            

Declare @SchemaAndTAble VArchar(270)                           

Declare @Schema_name  varchar(30)                           

Declare @Table_name  varchar(240)                           

declare @Condition  Varchar(MAX)                             

SET @WithStrINdex=0                           

SELECT @WithStrINdex=CHARINDEX('With',@Query )                           

, @WhereStrINdex=CHARINDEX('WHERE', @Query)                           

IF(@WithStrINdex!=0)                           

Select @INDExtouse=@WithStrINdex                           

ELSE                           

Select @INDExtouse=@WhereStrINdex                           

Select @SchemaAndTAble=Left (@Query,@INDExtouse-1)                                                     

select @SchemaAndTAble=Ltrim (Rtrim( @SchemaAndTAble))                           

Select @Schema_name= Left (@SchemaAndTAble, CharIndex('.',@SchemaAndTAble )-1)                           

,      @Table_name = SUBSTRING(  @SchemaAndTAble , CharIndex('.',@SchemaAndTAble )+1,LEN(@SchemaAndTAble) )                           

,      @CONDITION=SUBSTRING(@Query,@WhereStrINdex+6,LEN(@Query))--27+6                           

Declare   @COLUMNS  table (Row_number SmallINT , Column_Name VArchar(Max) )                             

Declare @CONDITIONS as varchar(MAX)                             

Declare @Total_Rows as SmallINT                             

Declare @Counter as SmallINT             

declare @ComaCol as varchar(max)           

select @ComaCol=''                  

Set @Counter=1                             

set @CONDITIONS=''                             

INsert INTO @COLUMNS                             

Select  Row_number()Over (Order by ORDINAL_POSITION ) [Count] ,Column_Name FRom INformation_schema.columns Where Table_schema=@Schema_name                             

And table_name=@Table_name        

and Column_Name not in ('SyncDestination','PendingSyncDestination' ,'SkuID','SaleCreditedto')                  

select @Total_Rows= Count(1) FRom  @COLUMNS                             

             Select @Table_name= '['+@Table_name+']'                     

             Select @Schema_name='['+@Schema_name+']'                     

While (@Counter<=@Total_Rows )                             

begin                              

--PRINT @Counter                             

    select @ComaCol= @ComaCol+'['+Column_Name+'],'           

    FROM @COLUMNS                             

Where [Row_number]=@Counter                         

select @CONDITIONS=@CONDITIONS+ ' +Case When ['+Column_Name+'] is null then ''Null'' Else ''''''''+                             

 Replace( Convert(varchar(Max),['+Column_Name+']  ) ,'''''''',''''  )                             

  +'''''''' end+'+''','''                             

FROM @COLUMNS                             

Where [Row_number]=@Counter                             

SET @Counter=@Counter+1                              

End                             

select @CONDITIONS=Right(@CONDITIONS,LEN(@CONDITIONS)-2)                             

select @CONDITIONS=LEFT(@CONDITIONS,LEN(@CONDITIONS)-4)             

select @ComaCol= substring (@ComaCol,0,  len(@ComaCol) )                           

select @CONDITIONS= '''INSERT INTO '+@Schema_name+'.'+@Table_name+ '('+@ComaCol+')' +' Values( '+'''' + '+'+@CONDITIONS                             

select @CONDITIONS=@CONDITIONS+'+'+ ''')'''                             

Select @CONDITIONS= 'Select  '+@CONDITIONS +'FRom  ' +@Schema_name+'.'+@Table_name+' With(NOLOCK) ' + ' Where '+@Condition                             

print(@CONDITIONS)                             

Exec(@CONDITIONS) 

Exec [dbo].[INS]  'Person.PersonPhone where 1=1'