Tuesday, February 11, 2014

Enable SSH on HP Switch(es)

ProCurve Switch(config)# crypto key generate ssh
ProCurve Switch(config)# ip ssh
ProCurve Switch(config)# no telnet-server
Read more...

Disable Plain-Text HTTP server on HP Switch(s) HTTP-->HTTPS

Disable Plain-Text HTTP server on HP Switch(s) HTTP-->HTTPS


Switch(config)# no web-management plaintext
Switch(config)# crypto key generate cert 1024
Switch(config)# crypto host-cert generate self-signed
Validity start date [01/01/1970]: 08/06/2013
Validity end date   [08/09/2011]: 08/06/2023
Common name            [0.0.0.0]:
Organizational unit  [Dept Name]:
Organization      [Company Name]:
City or location          [City]:
State name               [State]:
Country code                [US]:
Switch(config)# web-management ssl
Switch(config)# wr mem
Read more...

Wednesday, February 5, 2014

View and Set Exchange 2010 Attachment Size

Check attachment limits

Get-TransportConfig

Set-TransportConfig -ExternalDsnMaxMessageAttachSize 50Mb
Set-TransportConfig -InternalDsnMaxMessageAttachSize 50Mb
Set-TransportConfig -MaxSendSize 50Mb
- See more at: http://www.ercanozkurt.com/?cat=4&paged=6#sthash.gkwFSjtf.dpuf
Set attachment Limits

Set-TransportConfig -ExternalDSNMaxMessageAttachSize 10MB
Set-TransportConfig -InternalDSNMaxMessageAttachSize 10MB
Set-TransportConfig -MaxSendSize 10MB
Set-TransportConfig -ExternalDsnMaxMessageAttachSize 50Mb
Set-TransportConfig -InternalDsnMaxMessageAttachSize 50Mb
Set-TransportConfig -MaxSendSize 50Mb
- See more at: http://www.ercanozkurt.com/?cat=4&paged=6#sthash.gkwFSjtf.dpuf
Get-TransportConfig
Get-TransportConfig
Get-TransportConfig
Get-TransportConfig

Read more...

Monday, February 3, 2014

Check Free Space on Exchange Server DB

Get-MailboxDatabase -Status | ft name,databasesize,availablenewmailboxspace -auto
Read more...

GRANT Permission to specific column in Table MS SQL Server

GRANT SELECT (Columnname) ON [DBNAME].[TableName] TO Username

Example;

GRANT SELECT (PerColumn) ON [YNS].[Table1] TO HRUser

Read more...

Grant Permission to View MS SQL Server

First you should create user and assign public server role for releated database.



GRANT SELECT ON [DBNAME].[SCHEMAName].[ViewName] TO Username

Example;

GRANT SELECT ON [YNS].[dbo].[V_Personnel] TO ViewUser1
Read more...
 
span.fullpost {display:none;}